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]

Article and Schedule Quiz	Start Test!

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]

Take Mock Tests

Missiles Mock Test	Start Test!
SSC MTS Mock Test	Start Test
IBPS CLERK MOCK TEST	Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH)	Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi)	Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH)	Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH)	Start Test!
IB Security Assistant Mock test 1 (english)	Start Test!
UP POLICE CONSTABLE MOCK TEST 1	Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI)	Start Test!