Objective Type Interview Questions and Answers for SQL DBA Jobs

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]

Article and Schedule Quiz	Start Test!

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]

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!