PRG REVISION Quiz

What is a system privilege?

• The ability to change rows of data in a table

• A group of privileges assigned to users

• The right to perform a task in the database

• A command to create a new user

Answer explanation

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.

Which command is used to create a new user in the database?

• DROP USER

• ALTER USER

• CREATE USER

• GRANT USER

Answer explanation

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.

What does the CASCADE option do when dropping a user?

• Removes the user and all objects they own

• Changes the user's password

• Only removes the user account

• Grants privileges to the user

Answer explanation

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.

What is the purpose of the GRANT command?

• To provide privileges to database objects

• To remove privileges from users

• To create new database objects

• To log in to the database

Answer explanation

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.

What does the REVOKE command do?

• Grants new privileges to a user

• Creates a new role

• Changes a user's password

• Withdraws user privileges on database objects

Answer explanation

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

What is a role in the context of database privileges?

• A group of privileges

• A command to create users

• A single privilege

• A type of database object

Answer explanation

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.

How can you grant privileges to multiple users at once?

• By using the GRANT command for each user

• By creating multiple user accounts

• By using the REVOKE command

• By creating a role and assigning it to users

Answer explanation

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.

What is the first step to grant privileges to a role?

• Drop the role

• Revoke existing privileges

• Assign users to the role

• Create the role

Answer explanation

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.

Which statement is true about object privileges?

• They are rights to perform actions on specific database objects

• They can only be granted to one user at a time

• They allow users to create new database objects

• They are the same as system privileges

Answer explanation

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

What happens when you revoke a privilege from a role?

• The privilege is granted to another role

• The user retains the privilege

• Only the role is deleted

• All users assigned to that role lose the privilege

Answer explanation

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.