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]

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
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]

Chapters

ADRE 3.0 Complete Study Material