Current Affairs Quiz 2024GKCourses AptitudeADRE 2.0English

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

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

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]

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!

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

Chapters

LEAVE A COMMENT