SQL MCQs - Structured Query Language Interview Questions and Answers

(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]