Oracle Database Administration

These flashcards cover key concepts related to user management, privileges, and data backup in Oracle Database administration.

What SQL statement is used to create a new user in Oracle?

CREATE USER

Which clause in the CREATE USER statement is used for password authentication?

IDENTIFIED BY clause

What is the default tablespace for a new user if not specified?

users

What does the Quota clause specify for a user?

The maximum amount of space that the user can allocate in the tablespace.

What is the purpose of the Profile clause in user creation?

To limit the amount of database resources the user can use.

What happens to a user account set to the status 'LOCK'?

The account is created but access is disabled.

What keyword is used to permanently remove a database user?

DROP USER

What is the consequence of using the CASCADE keyword when dropping a user?

All objects owned by the user are automatically dropped.

What are the two types of privileges in Oracle Database?

System Privilege and Object Privilege.

Who can grant or revoke system privileges in Oracle?

The SYS user, a user with GRANT ANY PRIVILEGE, and any user granted with ADMIN OPTION.

What is the difference between SYSTEM privileges and OBJECT privileges?

SYSTEM privileges allow actions on any schema objects, while OBJECT privileges are specific access rights to database objects.

What does the GRANT OPTION allow a user to do?

It allows the user to grant an object privilege to another user.

Which clause indicates that a role must be authorized by a password?

IDENTIFIED BY clause.

What is the purpose of using roles in Oracle?

To simplify the management and control of privileges.

What command is used to assign a system privilege to a role?

GRANT TO .

What is the export utility in Oracle used for?

To create a copy of the database or specific database components.

What are logical backups in Oracle?

Backups that export database objects and data in a format that can be imported back into the database.

In the export utility, what does the option 'Specify Objects' allow you to do?

Limit the scope of the export process by selecting types of objects to include.

What does the IMPORT utility do in Oracle?

It imports data from an export SQL file into the database.

What must be done before running a script in the IMPORT utility?

Open the export SQL file.

What is the default temporary tablespace for a new user if not specified?

temp