sql Interview Questions and Answers
Ques:- The SQL keywords _____ is used with wildcards.
A. NOT in only
B. IN and NOT IN
C. IN only
D. LIKE only
Ques:- Which of the following is the original purpose of SQL?
A. To define the data structures
B. To specify the syntax and semantics of SQL data definition language
C. To specify the syntax and semantics of SQL manipulation language
D. All of the above
Ques:- In the _____ normal form, a composite attribute is converted to individual attributes.
A. 1st
B. 2nd
C. 3rd
D. 4th
Ques:- You can add a row using SQL in a database with which of the following?
A. INSERT
B. CREATE
C. ADD
D. MAKE
Ques:- Which normal form is considered adequate for relational database design?
A. 1 NF
B. 2 NF
C. 3 NF
D. 4 NF
Ques:- The primary key is selected from the
A. Determinants
B. Candidate keys
C. Composite keys
D. Foreign keys
Ques:- A relation is in this form if it is in BCNF and has no multivalued dependencies.
A. Second normal form
B. Third normal form
C. Fourth normal form
D. Domain/key normal form
Ques:- SQL can be used to
A. Create database structures only
B. Query database data only
C. Modify database data only
D. All of the above can be done by SQL
Ques:- The SQL statement that queries or reads data from a table is
A. READ
B. SELECT
C. ORDER
D. QUERY
Ques:- The command to eliminate a table from a database is
A. DELETE TABLE CUSTOMER
B. UPDATE TABLE CUSTOMER
C. DROP TABLE CUSTOMER
D. REMOVE TABLE CUSTOMER