GkSeries.com

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

Download PDF

DBMS objective interview questions and answers for Database administrator job page contain 5 questions from chapter Structured query language. Each SQL MCQ has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(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

Comment

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

Comment

Answer: Option [B]

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

Comment

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.

Comment

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

Comment

Answer: Option [C]

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test