Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 17 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

How many storage engines among the following are transaction-safe?

A. 1
B. 2
C. 3
D. 4View Answer
Answer» E.
Discussion
2.

What is the durability property of transactions?

A. statements form a logic unit
B. database remains consistent
C. one transaction does not affect the other
D. transaction effects are recorded permanently
Answer» C. one transaction does not affect the other
Discussion
3.

Transactional processing requires lesser overhead due to CPU cycles and memory.

A. True
B. False
Answer» B. False
Discussion
4.

Transactional processing provides strong guarantees about the outcome of operations.

A. True
B. False
Answer» C.
Discussion
5.

What does ‘C’ stand for in the ACID property of transactions?

A. Compound
B. Concrete
C. Collision
D. Consistency
Answer» E.
Discussion
6.

What does ‘A’ stand for in the ACID property of transactions?

A. Availability
B. Accuracy
C. Adjustability
D. Atomicity
Answer» E.
Discussion
7.

What is known as the set of SQL statements that either executes successfully or none of them have an effect?

A. joins
B. transactions
C. filters
D. deletions
Answer» C. filters
Discussion
8.

WHAT_IS_THE_DURABILITY_PROPERTY_OF_TRANSACTIONS??$

A. statements form a logic unit
B. database remains consistent
C. one transaction does not affect the other
D. transaction effects are recorded permanently
Answer» E.
Discussion
9.

TRANSACTIONAL_PROCESSING_REQUIRES_LESSER_OVERHEAD_DUE_TO_CPU_CYCLES_AND_MEMORY.?$

A. True
B. False
Answer» C.
Discussion
10.

How many storage engines among the following are transaction-safe?$

A.
B. 1
C. 2
Answer» C. 2
Discussion
11.

Transactional processing provides strong guarantees about the outcome of operations?

A. True
B. False
Answer» B. False
Discussion
12.

What is the command to disable autocommit and launch a transaction?

A. INITIATE TRANSACTION
B. START TRANSACTION
C. DISABLE AUTOCOMMIT
D. TRANSACTION
Answer» C. DISABLE AUTOCOMMIT
Discussion
13.

What is the isolation property of transactions?

A. statements form a logic unit
B. database remains consistent
C. one transaction does not affect the other
D. transaction effects are recorded permanently
Answer» D. transaction effects are recorded permanently
Discussion
14.

What does ‘A’ stand for in the ACID property of transactions?$

A. Availability
B. Accuracy
C. Adjustability
D. Atomicity
Answer» E.
Discussion
15.

What is generally done if an error occurs during the transaction?

A. delete
B. rollback
C. commit
D. update
Answer» C. commit
Discussion
16.

What is generally done after the transactions are executed successfully?

A. delete
B. rollback
C. commit
D. update
Answer» D. update
Discussion
17.

What is known as the set of SQL statements that either execute successfully or none of them have an effect.

A. joins
B. transactions
C. filters
D. deletions
Answer» C. filters
Discussion