1z0-083 Oracle Exam Questions and Free Practice Test

Question 7

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

A. A PDB snapshot is always a full copy of the source PDB.

B. A PDB snapshot is always a sparse copy of the source PDB.

C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.

E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

G. A snapshot copy PDB can be created from a stand-alone clone PDB.

Correct Answer:AE

Question 8

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 commontables, 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 the SALES_APP1 and SALES_APP2 application PDBs with the application root.
* 7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
* 8. Sync the application seed withthe application root.
Which are the minimum required steps in the correct sequence?

A. 3,4,1,6,8

B. 1,5,6

C. 1,3,5,6,7

D. 1,3,5,7

E. 2,5,6

Correct Answer:B

Question 9

Which three are true about opatchauto? (Choose three.)

A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

B. It must be invoked by a user with root user privileges.

C. Patches are appliedvia opatchauto.

D. Users must always input patch plans to opatchauto.

E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

F. It applies patches in nonrolling mode by default.

G. It is used toapply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Correct Answer:ABC

Question 10

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

A. cloning a remote container database in interactive mode

B. cloning a remote pluggable database in silent mode

C. relocating a remote pluggable database in interactive mode

D. relocating a remote container database in silent mode

E. cloning a remote container database in silent mode

F. relocating a remote pluggable database in silent mode

G. relocating aremote container database in interactive mode

Correct Answer:BEF

Question 11

Examine this configuration:
* 1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. * 2.ORCL uses disk group +FRAfor the Fast Recovery Area.
* 3. LISTENER is the listener for ORCL.
* 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5.All components are currently shut down.
You execute this command:
1Z0-083 dumps exhibit
What is the outcome?

A. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENERare started.

B. Only the ORCL database instance is started.

C. Only the ORCL database and the ASM instances are started.

D. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

E. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

Correct Answer:D

Question 12

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)

A. Increase the size of tape I/O buffers.

B. Disable FORCE LOGGING for the database.

C. Increase the size of the database buffer cache.

D. Enable asynchronous disk I/O.

E. Increase the level of RMAN multiplexing.

Correct Answer:DE

START 1z0-083 EXAM