Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

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

Computer Science Books

Chapters

Please Like Us
Brand