Exit demo 1Z0-182 Oracle Database 23ai Administration Associate PDF format · free preview

Oracle 1Z0-182 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/1z0-182.html

Question 1
Multiple choice

Which three statements are true about Oracle Managed Files (OMF)?

A.

If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo
logs and control files are placed in DB_RECOVERY_FILE_DEST by default.

B.

If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.

C.

If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data
files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default.

D.

If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo
logs and control files are stored in DB_CREATE_FILE_DEST by default.

E.

If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.

F.

If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

Question 2
Multiple choice

Which two statements are true about trace files produced by the Oracle Database server?

A.

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

B.

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

C.

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

D.

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

E.

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

Question 3
Multiple choice

You have connected to the CDB root as a common user with the CREATE PLUGGABLE DATABASE
system privilege and issued the following command: SQL> CREATE PLUGGABLE DATABASE pdb1
ADMIN USER admin1 IDENTIFIED BY p1 ROLES = (CONNECT) FILE_NAME_CONVERT = ('PDB$SEEDdir', 'PDB1dir');

Which three are results of the CREATE command?

A.

It creates new default schemas for the PDB.

B.

It creates tablespaces to store metadata.

C.

It creates a new local user ADMIN with SYSDBA privileges.

D.

The PDB must be opened Read Only to complete the integration of the PDB into the CDB.

E.

After the PDB is created, it is automatically opened Read/Write.

F.

It creates a new local user ADMIN with restricted privileges.

Question 4
Multiple choice

Which two statements are true about views used for viewing tablespace and datafile information?

A.

Tablespace free space can be viewed in V$TABLESPACE.

B.

V$TABLESPACE displays information about tablespaces contained in the data dictionary.

C.

A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened.

D.

Tablespace free space can be viewed in DBA_TABLESPACES.

E.

V$TABLESPACE displays information that is contained in the control file about tablespaces.

Question 5
Multiple choice

Which three relationships between instances and Oracle databases are possible without using Multi-tenant?

A.

One instance on one server mounting multiple databases.

B.

Two or more instances on separate servers all mounting and opening the same database.

C.

One instance on one server mounting and opening multiple databases.

D.

One instance on one server that has no database mounted.

E.

One instance on one server mounting and opening one database.

Question 6
Single choice

You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; 

Which statement is true prior to plugging the PDB into the other CDB?

A.

The PDB archive file must be copied to the target CDB.

B.

The PDB manifest and all the datafiles must be copied to the target CDB.

C.

PDB archive file and only the user-defined tablespaces must be copied to the target CDB.

D.

The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.

Question 7
Multiple choice

Which four statements are true about the Oracle Server architecture?

A.

A person or program can have more than one session with an instance by logging in with different users.

B.

The buffer cache and the redo log buffer are held in the large pool.

C.

A session represents the state of a user's login to an instance.

D.

Each server process or background process has their own Program Global Area (PGA).

E.

A connection represents the state of a user's login to an instance.

F.

A person or program can have more than one session with an instance by logging in with the same user.

Question 8
Single choice

You have connected to a PDB to perform the administration operations of changing and verifying a system parameter that is PDB_MODIFIABLE.

What is the appropriate mode to open the PDB to achieve this?

A.

READ WRITE

B.

RESTRICTED READ ONLY

C.

READ ONLY

D.

RESTRICTED WRITE ONLY

Question 9
Multiple choice

One of your database instances was shut down normally and then started in NOMOUNT state. You then
executed this command: ALTER DATABASE MOUNT;

Which two of these actions are performed?

A.

Online data files are opened.

B.

Online redo logs are opened.

C.

The initialization parameter file is read.

D.

Oracle shared memory structures are allocated.

E.

The alert log has instance startup details written to it.

F.

Control files are read.

Question 10
Multiple choice

What are the three components of Oracle Database Automatic Maintenance Tasks?

A.

A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.

B.

Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.

C.

The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.

D.

A packaging system that allows you to combine all error and failure logs to share with Oracle Support.

E.

A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.

F.

A set of tasks that are started automatically at regular intervals to perform maintenance operations on

the database.

Showing 10 of 151 questions · Unlock the full set