1Z0-082 - Oracle Database Administration I Managing Database Instances Questions and Answers

Question 1

A database administrator needs to enable Automatic Memory Management (AMM) for an Oracle instance. Which two initialization parameters must be set to achieve this?

Accepted Answer

MEMORY_TARGET and MEMORY_MAX_TARGET

Answer

SGA_TARGET and PGA_AGGREGATE_TARGET

Answer

DB_CACHE_SIZE and SHARED_POOL_SIZE

Answer

SGA_MAX_SIZE and PGA_AGGREGATE_LIMIT

Question 2

A DBA issues the `SHUTDOWN IMMEDIATE` command. Which of the following best describes the actions the Oracle instance will take?

Accepted Answer

Terminates all active sessions, rolls back uncommitted transactions, and then shuts down.

Answer

Waits for all active user sessions to disconnect before shutting down.

Answer

Immediately stops all database processes without rolling back transactions, requiring instance recovery on the next startup.

Answer

Waits for all active transactions to complete, prevents new transactions, and then shuts down.

Question 3

During the startup sequence of an Oracle database, in which stage are the control files read to identify the location of data files and online redo log files?

Accepted Answer

MOUNT

Answer

NOMOUNT

Answer

OPEN

Answer

QUIESCE

Question 4

You are managing an Oracle database that uses a Server Parameter File (SPFILE). You need to change a dynamic initialization parameter and ensure the change persists across instance restarts. Which `SCOPE` option should you use with the `ALTER SYSTEM` command?

Accepted Answer

SCOPE=BOTH

Answer

SCOPE=MEMORY

Answer

SCOPE=PFILE

Answer

SCOPE=SPFILE

Question 5

A DBA needs to perform a critical administrative task that requires no active non-DBA transactions to be running. However, they want to avoid shutting down the database and disconnecting all users. Which command can be used to achieve this state?

Accepted Answer

ALTER SYSTEM QUIESCE RESTRICTED

Answer

STARTUP RESTRICT

Answer

ALTER SYSTEM ENABLE RESTRICTED SESSION

Answer

SHUTDOWN TRANSACTIONAL

Question 6

What is the primary difference between an Oracle SPFILE and a PFILE?

Accepted Answer

An SPFILE is a binary file whose parameters can be changed dynamically, while a PFILE is a text file that requires an instance restart for changes to take effect.

Answer

A PFILE is a binary file, while an SPFILE is a text file.

Answer

Changes to a PFILE can be made dynamically, while SPFILE changes require a restart.

Answer

An SPFILE is only used in Real Application Clusters (RAC) environments, while a PFILE is for single-instance databases.