1Z0-006 Database Administration & Security

Question 1

Which privilege allows a user to create tables in their own schema?

Accepted Answer

CREATE TABLE

Answer

ALTER ANY TABLE

Answer

CREATE SESSION

Answer

GRANT ANY PRIVILEGE

Question 2

A backup strategy that captures only data blocks changed since the last backup is called:

Accepted Answer

Incremental backup

Answer

Cold backup

Answer

Full backup

Answer

Logical export

Question 3

The process of applying archived redo logs to a standby database to keep it synchronized is known as:

Accepted Answer

Managed recovery

Answer

Clustering

Answer

Snapshot refresh

Answer

Checkpointing

Question 4

Which authentication method relies on the operating system to verify database users?

Accepted Answer

OS authentication

Answer

Password file

Answer

Kerberos external authentication

Answer

LDAP directory

Question 5

The principle of least privilege suggests that users should:

Accepted Answer

Receive only necessary privileges

Answer

Have DBA role by default

Answer

Share accounts

Answer

Use SYSDBA connections

Question 6

Transparent Data Encryption (TDE) primarily protects data:

Accepted Answer

At rest in data files

Answer

In transit over networks

Answer

During memory processing

Answer

Inside redo logs only

Question 7

A database alert log records:

Accepted Answer

Critical messages and errors from background processes

Answer

Only user queries

Answer

All DML statements

Answer

Operating system patches

Question 8

To revoke a role from a user, which statement is used?

Accepted Answer

REVOKE

Answer

DENY

Answer

REMOVE

Answer

DROP

Question 9

Which automatic feature in Oracle attempts to protect against SQL injection by verifying input types?

Accepted Answer

DBMS_ASSERT

Answer

VPD

Answer

Audit Vault

Answer

Fine-Grained Auditing