Oracle Database 23ai Administration Associate - 1Z1-182 Exam Practice Test

A. All trace files contain error information that requires contacting Oracle Support.

B. They can be written by server processes to the Fast Recovery Area (FRA).

C. They can be written by background processes to a file system.

D. They can be written by server processes to a file system.

E. Trace file names are based on the database name concatenated with a sequential number.

A. Undo segments can be stored in the SYSTEM tablespace.

B. A single transaction may use multiple undo segments simultaneously.

C. Undo segments can be stored in the SYSAUX tablespace.

D. Undo segments can extend when a transaction fills the last extent of the undo segment.

E. Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment.

A. Tables with one or more extents in this data file may be queried during the execution of this command.

B. It overwrites any existing file with the name sales02.dbf in /u02 by default.

C. DML may be performed on tables with one or more extents in this data file during the execution of this command.

D. Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.

E. The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

A. It has its own commands that are separate from any SQL statements.

B. It has both command-line and graphical user interfaces (GUI).

C. It can run scripts passed to it by a shell script.

D. It must be downloaded from the Oracle Technology Network (OTN).

E. It can run scripts entered at the SQL prompt.

F. It can run Recovery Manager (RMAN) commands.

A. It is supported for SYS-owned tables contained in locally managed tablespaces.

B. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

C. Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.

D. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.

E. It is the default behavior for tables and indexes.

A. Connect Time Failover requires the use of Transparent Application Failover (TAF).

B. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration.

C. Connect Time Failover requires the connect string to have two or more listener addresses configured.

D. Source Routing requires the use of encrypted connections.

E. Load Balancing requires the use of a name server.

A. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.

B. The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.

C. The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.

D. The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.

A. Password File authentication must be used for system-privileged administrative users.

B. REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.

C. Password authentication must be used for system-privileged administrative users.

D. Password File authentication is supported for any type of database user.

E. Operating System authentication may be used for system-privileged administrative users.

A. A RAC database can have instances on separate servers.

B. A RAC database must have two or more instances.

C. A RAC database must have three or more instances.

D. Two RAC databases can share their instances.

E. A RAC database can have one instance.

A. Analysis of privileges that a user has on other schemas' objects.

B. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

C. Analysis of privileges that a user has on their own schema objects.

D. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.

E. Analysis of all privileges used by the SYS user.