JOIN ADRE 2.0 Telegram Group

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

ADRE 2.0 FULL LENGTH MOCK TEST

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!

Chapters

Advertisement