SQL MCQs - Structured Query Language Interview Questions and Answers

Questions

26 Which of the following is not an SQL command ?

A CREATE

B DROP

C ALTER

D All are SQL commands

Answer: Option [D]

27 Which of the following is correct ?

A A SQL query automatically eliminates duplicates.

B SQL permits attribute names to be repeated in the same relation

C A SQL query will not work if there are no indexes on the relations.

D None of these

Answer: Option [D]

28 The DMLs which require user to specify what data is needed and how to get it, is called :

A DDL DMLs

B Procedural DMLs

C Non-procedural DMLs

D None of the above

Answer: Option [B]

29 Which of the following clauses is used in the CREATE TRIGGER command to create a row level trigger ?

A FOR ROW

B ROW LEVEL

C ROW LEVEL TRIGGER

D None of the above.

Answer: Option [D]

30 Which of the following is used to evaluate a query execution strategy ?

A Query tree

B Access plan

C Database catalog

D None of the above

Answer: Option [A]