Which SQL keyword is used to give users permission to access database objects? MCQ with Answer and Explanation

Question Report Error

Which SQL keyword is used to give users permission to access database objects?

A. REVOKE

B. PERMIT

C. GRANT

D. ASSIGN

Answer: Option C

Solution (By JKExamLibrary)

GRANT is a DCL command used to assign privileges to users.

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

What is the result of the SQL query: SELECT * FROM employees;?

A. Only the first row

B. All rows and all columns from the employees table

C. An empty result

D. Only the primary key column

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
SELECT * retrieves all columns and rows from the specified table.

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

Question #2 Report Error

What is the purpose of a trigger in a database?

A. To create a backup

B. To join tables

C. To automatically execute a set of actions in response to certain events on a table

D. To index a column

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
A trigger is a stored program that automatically runs when a specified event (INSERT, UPDATE, DELETE) occurs on a table.

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

Question #3 Report Error

What type of key uniquely identifies each record in a table and cannot contain NULL values?

A. Candidate Key

B. Primary Key

C. Secondary Key

D. Foreign Key

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
A Primary Key is a unique identifier for each tuple in a relation. It enforces entity integrity and strictly cannot accept NULL values.

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

Explore All Database Management System (DBMS) MCQs