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

Question
Which of the following commands is a part of Transaction Control Language (TCL) in SQL?
A. COMMIT
B. DELETE
C. GRANT
D. ALTER
Answer: Option A
Solution (By JKSSB Mock Tests)
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
Which SQL operator returns only the rows that are common and present in the outputs of both executing SELECT queries?
A. INTERSECT
B. UNION
C. EXCEPT / MINUS
D. JOIN
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The INTERSECT operator returns only the distinct rows that appear in the result sets of both SELECT statements.
This question belongs to: Computer Database Management System (DBMS)
Question #2
In SQL, which statement is used to create a new database?
A. CREATE SCHEMA
B. CREATE TABLE
C. NEW DATABASE
D. CREATE DATABASE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
CREATE DATABASE is used to create a new database in SQL.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which key establishes a logical relationship between two tables by referencing the primary key of another table?
A. Super Key
B. Candidate Key
C. Foreign Key
D. Alternate Key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Foreign Key is an attribute or collection of attributes in one table that references the primary key of another table to maintain referential integrity.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Abbreviations 369 Computer Networking 325 Programming Languages 0 Microsoft Office 1199 Database Management System (DBMS) 278
Explore Subjects
Geography GK 6121 Current Affairs 575 Economy GK 2220 English 15164 Science 4430
Practice Mix
Simple interest on Rs. 1224000 for 3 years at 32% per annum is
Spot the error: 'These kind of mistakes are common.'
What is 'Edge Computing'?
If a:b = 4:10 and b:c = 10:12, then a:b:c = ?
The administrative position of 'Waqil' in the early Mughal hierarchy under Akbar was essentially equivalent to which role?