SQL MCQs - Structured Query Language Interview Questions and Answers

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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]
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
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]

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics