1Z0-082 - Oracle Database Administration I Administering User Security Questions and Answers

Question 1

A database administrator needs to create a new user named 'APP_USER' who will own application objects.
Which SQL statement correctly creates the user, assigns a default tablespace for their objects, and allows them to use 100M of space in that tablespace?

Accepted Answer

CREATE USER app_user IDENTIFIED BY a_password DEFAULT TABLESPACE app_data QUOTA 100M ON app_data;

Answer

CREATE NEW USER app_user WITH PASSWORD a_password TABLESPACE app_data QUOTA 100M;

Answer

ADD USER app_user IDENTIFIED BY a_password DEFAULT TABLESPACE app_data;

Answer

CREATE USER app_user WITH a_password ON app_data QUOTA 100M;

Question 2

A new developer, 'John', has been created with the `CREATE USER john IDENTIFIED BY ...` command. When John tries to connect to the database, he receives an `ORA-01045: user JOHN lacks CREATE SESSION privilege; logon denied` error. What is the most likely cause of this error?

Accepted Answer

The user 'john' was not granted the necessary privilege to connect to the database.

Answer

The user 'john' has an expired password.

Answer

The user 'john' does not have a quota on any tablespace.

Answer

The database listener is not running.

Question 3

Which of the following is a key benefit of using roles to manage database security?

Accepted Answer

Roles simplify privilege management by grouping multiple privileges that can be granted to users or other roles collectively.

Answer

Roles can be assigned their own storage quotas on tablespaces.

Answer

Roles allow for password-protected access to specific schemas.

Answer

Roles automatically audit all activities performed by users who are granted the role.

Question 4

A database administrator is tasked with enforcing a stricter password policy. They need to ensure that user accounts are locked after 3 failed login attempts. Which database security mechanism should be used to configure this setting?

Accepted Answer

Profiles

Answer

System Privileges

Answer

Object Privileges

Answer

Database Triggers

Question 5

Which of the following is an example of a system privilege?

Accepted Answer

CREATE TABLE

Answer

SELECT on the EMPLOYEES table

Answer

UPDATE on the ORDERS table

Answer

EXECUTE on the CALC_BONUS procedure

Question 6

A database administrator wants to create a role named `APP_DEVELOPER` and grant it the ability to create tables and views. Additionally, any user granted this role should be able to grant the role to other users. Which set of SQL statements accomplishes this?

Accepted Answer

CREATE ROLE app_developer; GRANT CREATE TABLE, CREATE VIEW TO app_developer WITH ADMIN OPTION;

Answer

CREATE ROLE app_developer; GRANT CREATE TABLE, CREATE VIEW ON app_developer;

Answer

NEW ROLE app_developer; GRANT CREATE TABLE, CREATE VIEW TO app_developer WITH GRANT;

Answer

CREATE ROLE app_developer WITH ADMIN OPTION; GRANT CREATE TABLE, CREATE VIEW TO app_developer;