1z0-083 sample questions

Question 1

Which three are true about monitoring waits for sessions and services? (Choose three.)

Accepted Answer

V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service

Accepted Answer

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

Accepted Answer

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

Answer

V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

Answer

V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting session

Answer

V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a sessio

Question 2

Which two are true about Oracle Flashback features? (Choose two.)

Accepted Answer

FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

Accepted Answer

FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files

Answer

FLASHBACK TABLE can undrop a column.

Answer

FLASHBACK DROP can undrop an index when undropping a table.

Answer

After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Question 3

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?

Accepted Answer

Run the Memory Advisor for the shared pool.

Answer

Run the SQL Access Advisor.

Answer

Run the SQL Tuning Advisor.

Answer

Run the Memory Advisor for the Program Global Area.

Answer

Run the Memory Advisor for the System Global Area.

Question 4

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

Accepted Answer

it recompiles all stored PL/SQL code by using utlrp.sq

Accepted Answer

It performs prerequisite checks to verify if the Oracle database is ready for upgrade

Accepted Answer

It increases tablespace size, if required, to meet upgrade requirements.

Answer

It empties the RECYCLE BIN

Answer

It sets all user tablespaces to “read-only” before starting the upgrade.

Answer

It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

Question 5

A global company is migrating its 12cR2 non-CDB database located in a US data center to a 19c CDB in a European data center. The source and destination platforms have different endian formats. The total database size is 8TB, and the allowed downtime is minimal. Which method is most efficient for this upgrade and migration? ```mermaid graph LR subgraph US_DC [US Data Center] A[12cR2 Non-CDB on Linux x86-64] -- RMAN --> B(Backup Files) end subgraph EU_DC [EU Data Center] C(19c CDB on Solaris SPARC) --> D{Plug-in as PDB} end B -- Network Transfer --> E(Staging Area in EU) E -- RMAN CONVERT --> F(Converted Datafiles) F --> D ```

Accepted Answer

Use RMAN's `CONVERT DATABASE` on the source, transfer files, and then execute the upgrade scripts on the destination after plugging in the non-CDB as a PDB.

Answer

Perform a full Data Pump export on the 12cR2 source and a full import into a new 19c PDB on the destination.

Answer

Upgrade the database in-place to 19c in the US data center, and then use RMAN Active Database Duplication to clone it to the EU data center.

Answer

Create a physical standby database in the EU data center, upgrade the standby to 19c, and then perform a switchover.

Question 6

Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)

Accepted Answer

Data file 24 must be recovered while the CDB is opened.

Accepted Answer

Data file 24 cannot be recovered while the CDB is opened.

Answer

Data file 24 can be recovered while PDB2 is opened.

Answer

Data file 24 can be recovered while CDBSROOT and PDB$SEED are opened.

Answer

Data file 24 must be recovered while PDB2 is closed.

Question 7

Examine this configuration:

While CDB1 is open, 7u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’ is accidentally deleted.

To recover from this critical failure, you execute these commands:

What will be the outcome?

Accepted Answer

It will re-create 7u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’

Answer

It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’

Answer

It will create 7u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.

Answer

|t will create 7u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.

Answer

It will fail because there is no autobackup of the controlfiles.

Question 8

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

Accepted Answer

relocating a remote pluggable database in interactive mode

Accepted Answer

cloning a remote container database in silent mod

Accepted Answer

relocating a remote pluggable database in silent mode

Answer

cloning a remote container database in interactive mode

Answer

cloning a remote pluggable database in silent mod

Answer

relocating a remote container database in silent mode

Answer

relocating a remote container database in interactive mod

Question 9

Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

Accepted Answer

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

Answer

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

Answer

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

Answer

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

Answer

This cannot be done due to the lack of a clean restore point.

Question 10

A user complains about poor database performance.

You want to verify if the user’s session has waited for certain types of I/O activity.

Which view displays all waits waited on by a session at least once?

Accepted Answer

V$SESSION_WAIT_CLASS

Answer

V$SESSION_EVENT

Answer

V$SESSTAT

Answer

V$SESSION_WAIT

Answer

V$SESSION

1z0-083 Oracle Database Administration II Practice Questions

Create an account to continue.

Create an account to continue.

Related exams