Which of the following commands is a part of Transaction Control Language (TCL) in SQL? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following commands is a part of Transaction Control Language (TCL) in SQL?

A. ALTER

B. DELETE

C. GRANT

D. COMMIT

Answer: Option D

Solution (By JKExamLibrary)

COMMIT is a TCL command used to permanently save all modifications made during the current transaction into the database.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

Which type of JOIN combines all rows from the left table and all rows from the right table, filling in NULLs wherever a match is missing on either side?

A. Cross Join

B. Natural Join

C. Inner Join

D. Full Outer Join

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Full Outer Join combines the behavior of both Left and Right Outer Joins, returning all rows from both tables and applying NULL values where matches do not exist.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Share Report

A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency?

A. Transitive Dependency

B. Join Dependency

C. Trivial Dependency

D. Partial Dependency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Third Normal Form (3NF) requires a relation to be in 2NF with no transitive dependencies, meaning non-prime attributes cannot be determined by other non-prime attributes.

This question belongs to: Computer Database Management System (DBMS)