1Z0-006 Database Administration and Security 5

Question 1

Which initialization parameter file stores the database configuration parameters and can be modified without restarting the instance?

Accepted Answer

SPFILE (server parameter file)

Answer

The SPFILE (Server Parameter File) is a binary file that allows parameters to be changed dynamically using ALTER SYSTEM and persist across instance restarts.

Question 2

What is the role of the Oracle SMON background process?

Accepted Answer

Performing instance recovery at startup and coalescing free space in tablespaces

Answer

SMON (System Monitor) performs automatic instance recovery at database startup and reclaims unused temporary space in tablespaces.

Question 3

A user receives ORA-01950: no privileges on tablespace error when trying to insert data. What is the most likely fix?

Accepted Answer

Grant a quota on the tablespace to the user using ALTER USER

Answer

ORA-01950 occurs when a user has no quota assigned to a tablespace; the fix is ALTER USER username QUOTA amount ON tablespace_name.

Question 4

What is the purpose of Oracle's UNDO tablespace?

Accepted Answer

Storing before-images of data to support transaction rollback and read consistency

Answer

The UNDO tablespace stores before-images (undo records) of changed data, enabling transaction rollback, read consistency, and Flashback features.

Question 5

Which Oracle feature automatically manages the sizes of various SGA components like the buffer cache and shared pool?

Accepted Answer

Automatic Memory Management (AMM) / Automatic Shared Memory Management (ASMM)

Answer

Automatic Memory Management (AMM) or Automatic Shared Memory Management (ASMM) dynamically redistributes memory between SGA components based on workload needs.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 Database Administration and Security 5