Q. What does the ACID acronym stand for in database transactions?
-
A.
Atomicity, Consistency, Isolation, Durability
-
B.
Atomicity, Consistency, Integrity, Durability
-
C.
Atomicity, Concurrency, Isolation, Durability
-
D.
Atomicity, Consistency, Isolation, Data
Solution
ACID stands for Atomicity, Consistency, Isolation, and Durability, which are the properties that guarantee reliable transaction processing.
Correct Answer:
A
— Atomicity, Consistency, Isolation, Durability
Learn More →
Q. What does the ACID property in transactions stand for?
-
A.
Atomicity, Consistency, Isolation, Durability
-
B.
Atomicity, Consistency, Integrity, Durability
-
C.
Atomicity, Concurrency, Isolation, Durability
-
D.
Atomicity, Consistency, Isolation, Data
Solution
ACID stands for Atomicity, Consistency, Isolation, and Durability, which are key properties that guarantee reliable transaction processing.
Correct Answer:
A
— Atomicity, Consistency, Isolation, Durability
Learn More →
Q. Which of the following is a type of JOIN in SQL?
-
A.
INNER JOIN
-
B.
OUTER JOIN
-
C.
CROSS JOIN
-
D.
All of the above
Solution
All of the above options are types of JOINs in SQL, used to combine rows from two or more tables.
Correct Answer:
D
— All of the above
Learn More →
Q. Which of the following is NOT a type of index in SQL?
-
A.
Unique index
-
B.
Composite index
-
C.
Full-text index
-
D.
Dynamic index
Solution
Dynamic index is not a recognized type of index in SQL; the other options are valid types of indexes.
Correct Answer:
D
— Dynamic index
Learn More →
Q. Which of the following is NOT a type of indexing?
-
A.
B-tree indexing
-
B.
Hash indexing
-
C.
Bitmap indexing
-
D.
Sequential indexing
Solution
Sequential indexing is not a recognized type of indexing in databases; the other options are valid indexing methods.
Correct Answer:
D
— Sequential indexing
Learn More →
Showing 1 to 5 of 5 (1 Pages)
