PRG REVISION Quiz

A system privilege refers to the right to perform a specific task in the database, such as creating users or managing data. This distinguishes it from other options, which describe actions or groups of privileges.

The command 'CREATE USER' is specifically designed to add a new user to the database. In contrast, 'DROP USER' removes a user, 'ALTER USER' modifies an existing user, and 'GRANT USER' is not a valid command.

The CASCADE option when dropping a user removes not only the user account but also all objects they own, ensuring that no orphaned objects remain in the database.

The GRANT command is used to provide privileges to users on database objects, allowing them to perform specific actions. This makes the first choice the correct answer, as it directly relates to granting access rights.

The REVOKE command is used to withdraw user privileges on database objects, effectively removing access rights that were previously granted.

In database management, a role is defined as a group of privileges that can be assigned to users. This allows for easier management of permissions, as multiple privileges can be bundled together under a single role.

The correct way to grant privileges to multiple users at once is by creating a role and assigning it to those users. This method simplifies privilege management compared to granting privileges individually.

The first step to grant privileges to a role is to create the role itself. Without creating the role, you cannot assign privileges or users to it.

The correct statement is that object privileges are rights to perform actions on specific database objects, allowing users to interact with those objects directly.

Revoking a privilege from a role means that all users assigned to that role will lose the privilege. This is because privileges are tied to roles, and removing them affects all users associated with that role.