Home / Programming MCQs / MySQL MCQs / Question

V

Vishal Gupta • 7.73K Points
Tutor III 

Q. Difference between GRAND & REVOKE command is/are?

(A) The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
(B) The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
(C) A transaction can be rolled back to its last saved state.
(D) None of the above

Correct answer: Option(A)

in MySQL Share
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

Explanation: 

The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Login to discuss.

Related MCQs on MySQL

Number of operands used by Unary Operator is?

Which of these commands will delete a table called XXX if you have appropriate authority:

What is ghi in the following statement?

What is the default format for the data type “Date”?

The option used to specify the socket file pathname is ______________.

MySQL comes with as standard with client libraries for

Which Operator Returns TRUE if a subquery returns at least one row?

What can be the maximum size of char(n) in SQL Server String Data Type?

Which of the following query is correct to get Current Date from Query?A. SELECT DATE ( NOW() ) as today;B. SELECT DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) as today;

SQL has the advantage of?

Learn All MySQL MCQs