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

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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]

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics