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]

Random GK Questions

Q. Which one of the following mountain ranges lies in India ?
Q. Indian accounts for_________ percent of the total world’s wildlife.
Q. Which Bank was merged in the Punjab National Bank in February, 2003?
Q. When does the problem of unfavourable balance of payment arise ?
Q. Locked jaw disorder is the other name of the disease
Q. Liquidity Preference means

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics