Free Oracle 1z0-083 Practice Exam with Questions & Answers | Set: 4

Name: How to Pass 1z0-083 Exams
Brand: Examstrack
SKU: 1z0-083
Price: 42 USD
Availability: InStock

Questions 31

Choose two. Which two are true about monitoring waits for sessions and services?

Options:

V$SERVICE_EVENT displays wait counts for every wait event for each service even including counts of zero for waits that never occurred.

V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

V$SESSION_WAIT and V$SESSION both contain details of the event on which a waiting session is currently waiting.

V$SESSION_EVENT displays all waits events for those events that have occurred at least once for sessions that have now terminated.

V$SESSION_WAIT_CLASS displays waits broken down by wait class only for terminated sessions.

Oracle 1z0-083 Premium Access

Keyon

13-May-2025

examstrack.com's real exams content is the ultimate 1z0-083_V2.0 preparation tool.

Questions 32

Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

Options:

The control file is backed up whenever a new tablespace is created.

The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

The control file is backed up whenever a new table is created.

The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

It requires the use of fast recovery area (FRA).

The control file is backed up automatically each time the SPFILE is backed up manually.

Questions 33

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

Options:

Run the SQL Access Advisor.

Run the Memory Advisor for the shared pool.

Run the SQL Tunning Advisor.

Run the Memory Advisor for the Program Global Area.

Run the Memory Advisor for the System Global Area.

Questions 34

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

Options:

Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

SPFILE backups can be created while connected to an application root PDB.

The BACKUP DATABASE PLUS ARCHIVE LOG command will back up archive logs when RMAN is connected to a PDB.

The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Questions 35

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

Options:

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

The UNDO TABLESPACE clause is never required.

RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

Questions 36

Choose two. Which two are true about Rapid Home Provisioning of Oracle software?

Options:

It can be used for applications and middleware.

It can be used only for Oracle Grid Infrastructure, including Oracle Restart.

It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.

It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

Questions 37

Which three are true about an application container?

Options:

It can contain a single application

Two application containers can share an application seed PDB.

It must have an application root PDB.

An application PDB can belong to multiple application containers.

It must have an application seed PDB.

It can contain multiple applications.

Questions 38

Choose the best answer. Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1. Install the SALES_APP application, including the common tables, in the application root. 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. 3. Create an application seed.; 4. Install the SALES_APP application in the application seed. 5. Create the SALES_APP1 and SALES_APP2 application PDBs. 6. Sync root. 7. Sync seed. 8. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application the SALES_APP1 and SALES_APP2 application PDBs with the application the application seed with the application root.

Which are the minimum required steps in the correct sequence?

Options:

1,3,5,7

3,4,1,6,8

1,3,5,6,7

1,5,6

2,5,6

Questions 39

You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: Which three are true? (Choose three.)

Options:

The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

All archive logs created after this backup are kept for two years.

The SPFILE is included in the self-contaied archival backup.

The control file is included in the self-contained archival backup.

The restore point is a label for the system change number (SCN) before the archival backup was taken.

Questions 40

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

Options:

It fails because Data Pump cannot be container.

It creates a full export of the root

It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.