1Z0-006 Database Administration and Security Questions and Answers

Question 1

A new user account, 'DEV01', has been successfully created using the `CREATE USER` statement.
However, when the user attempts to connect to the database, they receive an 'ORA-01045: user DEV01 lacks CREATE SESSION privilege; logon denied' error.
What is the most likely cause of this issue?

Accepted Answer

The user has not been granted the CREATE SESSION system privilege.

Answer

The user account is locked.

Answer

The user's default tablespace quota is set to zero.

Answer

The user entered an incorrect password.

Question 2

A database administrator needs to manage permissions for a team of 20 analysts who all require the same 15 `SELECT` privileges on various tables. What is the most efficient and scalable method for managing these permissions?

Accepted Answer

Create a role, grant the 15 `SELECT` privileges to the role, and then grant the role to each of the 20 analysts.

Answer

Create a script to grant each of the 15 privileges to each of the 20 analysts individually.

Answer

Grant the `SELECT ANY TABLE` privilege to all 20 analysts.

Answer

Have each analyst request privileges from the table owners directly.

Question 3

Which of the following is an example of an object privilege, as opposed to a system privilege?

Accepted Answer

INSERT on the `sales.orders` table

Answer

CREATE USER

Answer

DROP ANY TABLE

Answer

CREATE TABLE

Question 4

A database administrator implements a backup strategy that involves a full backup (Level 0) on Sunday. On Monday, a backup is run that captures only the blocks changed since Sunday. On Tuesday, another backup is run that captures only the blocks changed since Monday. What type of incremental backup was performed on Monday and Tuesday?

Accepted Answer

Differential incremental backup

Answer

Cumulative incremental backup

Answer

Logical backup

Answer

Full backup

Question 5

A new accounting clerk needs to run a pre-written application that only reads data from the `invoices` and `payments` tables. According to the principle of least privilege, which of the following is the MOST appropriate set of privileges to grant?

Accepted Answer

`SELECT` privilege on the `invoices` and `payments` tables.

Answer

The `DBA` role.

Answer

The `SELECT ANY TABLE` system privilege.

Answer

`SELECT`, `INSERT`, `UPDATE`, and `DELETE` privileges on the `invoices` and `payments` tables.

Question 6

The user `BSMITH` was previously granted the ability to add new records to the `hr.departments` table. Due to a change in job roles, this permission is no longer necessary. Which SQL statement should the DBA execute to remove this specific privilege?

Accepted Answer

REVOKE INSERT ON hr.departments FROM BSMITH;

Answer

ALTER USER BSMITH REMOVE INSERT ON hr.departments;

Answer

DROP PRIVILEGE INSERT ON hr.departments FROM BSMITH;

Answer

DELETE PRIVILEGE INSERT ON hr.departments FOR BSMITH;

A new user account, 'DEV01', has been successfully created using the `CREATE USER` statement.However, when the user attempts to connect to the database, they receive an 'ORA-01045: user DEV01 lacks CREATE SESSION privilege; logon denied' error.What is the most likely cause of this issue?

A new user account, 'DEV01', has been successfully created using the `CREATE USER` statement.
However, when the user attempts to connect to the database, they receive an 'ORA-01045: user DEV01 lacks CREATE SESSION privilege; logon denied' error.
What is the most likely cause of this issue?