MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 3 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In authorization graph, if DBA provides authorization to u1 which inturn gives to u2 which of the following is correct? |
| A. | If DBA revokes authorization from u1 then u2 authorization is also revoked |
| B. | If u1 revokes authorization from u2 then u2 authorization is revoked |
| C. | If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked |
| D. | If u2 revokes authorization then u1 authorization is revoked |
| Answer» D. If u2 revokes authorization then u1 authorization is revoked | |
| 2. |
If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command. |
| A. | With grant |
| B. | Grant user |
| C. | Grant pass privelege |
| D. | With grant option |
| Answer» E. | |
| 3. |
Which of the following statement is used to remove the privilege from the user Amir? |
| A. | Remove update on department from Amir |
| B. | Revoke update on employee from Amir |
| C. | Delete select on department from Raj |
| D. | Grant update on employee from Amir |
| Answer» C. Delete select on department from Raj | |