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

Which SQL keyword is used to give users permission to access database objects?
A. GRANT
B. ASSIGN
C. PERMIT
D. REVOKE
Answer: Option A
Solution (By JKSSB Mock Tests)
GRANT is a DCL command used to assign privileges to users.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which type of integrity constraint ensures that a foreign key value must either match an existing primary key value in the parent table or be NULL?
A. Domain Integrity
B. Key Integrity
C. Entity Integrity
D. Referential Integrity

Correct Answer: Option D


Explanation:
Referential Integrity ensures that relationships between tables remain consistent, requiring a foreign key to point to a valid existing row in the referenced table.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a subquery in database terminology?
A. A nested SQL query placed completely inside another outer query statement.
B. A query that executes after the main query terminates.
C. A query that runs on a backup server.
D. An error log file.

Correct Answer: Option A


Explanation:
A subquery (or nested query) is an inner SQL SELECT statement embedded within an outer statement (such as a WHERE, FROM, or SELECT clause).

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a feature of SQL?
A. It is used to define, manipulate, and control data
B. It is a declarative language
C. It is the standard language for relational databases
D. All of the above

Correct Answer: Option D


Explanation:
SQL is a declarative language used for defining, manipulating, and controlling data in relational databases.

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