Which of the following is a DCL (Data Control Language) command? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a DCL (Data Control Language) command?

A. COMMIT

B. GRANT

C. CREATE

D. SELECT

Answer: Option B

Solution (By JKSSB Mock Tests)

GRANT and REVOKE are DCL commands. COMMIT is TCL, SELECT is DML, CREATE is DDL.

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

What is a synonym in database terms?

A. A type of index

B. An alias for a table or view

C. A foreign key

D. A data type

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A synonym is an alternative name for a database object, allowing simpler references.

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

Question #2

What is the difference between an inner join and an outer join?

A. Inner join returns only matching rows; outer join returns matching plus non-matching rows from one or both tables

B. Outer join is used for more than two tables

C. Inner join returns all rows; outer join returns matching only

D. They are the same

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Inner join returns rows where the join condition matches. Outer join (left, right, full) returns unmatched rows as well with NULLs.

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

Question #3

Which type of subquery executes once for each row evaluated by the outer query, depending on values provided by the outer statement?

A. Scalar Subquery

B. Independent Subquery

C. Correlated Subquery

D. Static Subquery

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.

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

Explore All Database Management System (DBMS) MCQs