JOIN ADRE 2.0 Telegram Group

Objective Type Interview Questions and Answers for SQL DBA Jobs | Structured Query Language MCQs

Questions
21 Transactions are initiated by BEGIN TRANSACTION and terminated :
A by COMMIT TRANSACTION
B by ROLL BACK TRANSACTION
C either by COMMIT TRANSACTION or by ROLL BACK TRANSACTION
D none of these

Answer: Option [C]
22 Statement that uses a condition to control iterative execution of a statement block :
A IF statement
B WHILE statement
C BREAK statement
D None of the above

Answer: Option [B]
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

23 Complex calculations can be performed using the following operation :
A Union
B Aggregation
C Nested IF
D None of these

Answer: Option [B]
24 An alias is :
A An alternate name given to a relation.
B An alternate name given to an inner query.
C An alternate name given to a user.
D None of the above.

Answer: Option [B]
25 One of the main heuristic rule for query optimization :
A Applying a join first.
B Applying any binary operation first.
C Applying a select and a Project first.
D None of these

Answer: Option [C]

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