Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmaspas7

Easiest Solution 2 Pass Your Certification Exams

1z0-083 Oracle Database Administration II Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Oracle 1z0-083 Oracle Database Administration II certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Oracle 1z0-083 Premium Access     Download Demo    
Page: 3 / 5
Total 286 questions

choose one .Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command?

A.

It succeeds and creates multisection backup sets that are used for active database duplication.

B.

It fails because there is no connection to a recovery catalog.

C.

It succeeds only if the target database is in MOUNT state.

D.

It fails because no parallel channels are allocated for the auxiliary database.

A database is configured in ARCHIVE LOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)

A.

when any archived log from, before, or after the most recent backup is corrupt.

B.

after losing all copies of the control file

C.

after losing an archived log from after the most recent backup

D.

after losing an archived log from before the most recent backup

E.

after losing the SYSTEM tablespace

Which two are true about gathering optimizer statistics? (Choose two.)

A.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

B.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.

C.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

D.

System statistics can be gathered only while connected to CDB$ROOT.

E.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

A.

2,4,5,6

B.

1,2,3,4,5,6

C.

1,2,4,5

D.

2,4,5

E.

1,3,4,5

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup istaking too long and suspect a performance bottleneck. Which three are true about diagnosing and tuning these problems? (Choose three.)

A.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

B.

Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.

C.

If an RMAN BACKUP VALIDATE command takes noticeably lessthan an actual backup, then write I/O is a likely bottleneck.

D.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.

E.

Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

F.

Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/

G.

Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

A.

the data dictionary in CDB$ROOT

B.

the log writer process (LGWR)

C.

SYSAUX tablespaces

D.

temporary tablespaces

E.

the Process Monitor Process (PMON)

F.

undo tablespaces

Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?

A.

FULL redaction is active on the SAL column

B.

RANDOM redaction is active on the MGR column

C.

RANDOM redaction is active on the HIREDATE column

D.

PARTIAL redaction is active on the MGR column.

E.

PARTIAL redaction is active of the HIREDATE column.

Which two are true about instance recovery? (Choose two.)

A.

It is not possible if an archived log is missing.

B.

It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

C.

Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

D.

It is performed by the Recovery Writer (RVWR) background process.

E.

Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing The log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

F.

It is performed automatically while the database remains in MOUNT state. Then the database is opened.

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?

A.

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

B.

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

C.

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

D.

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

E.

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

Choose two. Which two are true about Oracle Database Configuration Assistant (DBCA)?

A.

It can only be launched from the command line interface.

B.

It can be launched from both the command line and the Universal Installer (OUI) interfaces.

C.

It can be used to create container databases and non-container databases.

D.

It can be used to change the character set of an existing database.

E.

It can be used to convert a non-container database to a container database.

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed: Which three are true? (Choose three.)

A.

Application PDBsthat are subsequently created in the APP1 application container will be cloned from APP1$SEED.

B.

An application seed PDB is created for APP1.

C.

An application root PDB is created for APP1.

D.

A default service is created for the application root APP1.

E.

Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

F.

APP1 can never be unplugged.

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

A.

AWR snapshots can be created in CDB$ROOT.

B.

ADDM can run in a nonroot container.

C.

AWR reports can be generated while connected to any container.

D.

All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E.

AWR snapshots can be created in a PDB.

F.

No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Choose three. You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use?

A.

Data Pump full database export and import

B.

cloning the non-CDB as a PDB

C.

replication using GoldenGate

D.

Data Pump transportable tablespaces

E.

Data Pump full transportable database

F.

the DBMS_PDB package

Choose three. Which three are true about recovery operations done without using Recovery Manager (RMAN)?

A.

A lost PFILE can be re-created from alert.log using SQL*PLUS.

B.

A lost index tablespace can be re-created without performing any recovery.

C.

A lost password file can be manually re-created with the orapwd utility.

D.

A lost password file can be re-created with SQL*PLUS.

E.

A lost SPFILE can be recovered from memory using SQL*PLUS.

F.

A lost TEMPFILE must always be re-created manually.

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

A.

Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

B.

A failure can be closed only when it has been repaired.

C.

Data Recovery Advisor can be used if a database is closed.

D.

The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

E.

Data Recovery Advisor can proactively check for failures.

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

A.

It is an Oracle Database service

B.

It cannot be used to upgrade Oracle Database homes.

C.

It can be used to provision applications.

D.

It can be used to patch Grid Infrastructure homes containing Oracle Restart.

E.

It can be used to provision middleware.

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

A.

Create the PDB1 application PDB and synchronize it with poB$SEED.

B.

Create the PDB1 application PDB and synchronize it with HR_ROOT.

C.

Create the PDB1 application PDB and install HR_APP in it.

D.

Create an application seed, and install HR_APP in it.

E.

Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

A.

Create SQL plan directives for each of the regressed statements.

B.

Use The SQL Tuning Advisor for each of the regressed statements.

C.

Create an adaptive execution plan for each of the regressed statements

D.

Use the SQL Access Advisor for each of the regressed statements.

Choose three. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?

A.

automatically dropping the database link to the remote database if it already exists

B.

opening the cloned PDB

C.

creating a new empty PDB in the local database from PDB$SEED

D.

creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned

E.

creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database

F.

creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned

G.

creating a database link from CDB$ROOT in the remote database to the PDB in the local database

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

A.

Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

B.

Recovery catalog is resynchronized with the control files of the registered databases.

C.

Imported databases are unregistered from the RC11 catalog.

D.

Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

E.

All databases registered in the RC11 catalog are registered in the RC12C catalog.

Oracle 1z0-083 Premium Access     Download Demo    
Page: 3 / 5
Total 286 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved