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

Automatic Memory Management (AMM) allows Oracle to automatically manage and tune the total memory allocated to the System Global Area (SGA) and the Program Global Area (PGA). To enable AMM, you must set MEMORY_TARGET to define the total memory for the instance, and it is best practice to also set MEMORY_MAX_TARGET, which specifies the maximum value to which MEMORY_TARGET can be dynamically increased.

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

The `SHUTDOWN IMMEDIATE` command does not wait for current user sessions to disconnect. It proceeds to terminate all active sessions, roll back any uncommitted transactions, and then performs a clean shutdown. No instance recovery is needed upon the next startup.

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

The Oracle startup sequence proceeds through three main stages: NOMOUNT, MOUNT, and OPEN. During the MOUNT stage, the instance reads the control files to get the names and locations of the data files and online redo log files, thereby associating the database with the instance.

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

When using an SPFILE, the `SCOPE=BOTH` option applies the change to the currently running instance (memory) and also writes the change to the SPFILE. This ensures the new parameter value is used immediately and also persists after the next shutdown and startup.

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

The `ALTER SYSTEM QUIESCE RESTRICTED` command puts the database into a quiesced state. In this state, all active non-DBA sessions are allowed to complete their current transaction or query, but no new non-DBA activity is permitted. This allows DBAs to perform tasks that require a stable state without shutting down the instance.

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 - Oracle Database Administration I Practice Test

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