Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

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 [C]
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]

Computer Science Books

Chapters

Please Like Us
Brand