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: 2 / 5
Total 286 questions

Which two statements are true when row archival management is enabled?

A.

The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

B.

The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

C.

The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

D.

The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

E.

The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

A.

FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

B.

FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

C.

FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

D.

FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

E.

FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.

F.

FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

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 an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.

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 the PDB1 application PDB and synchronize it with PDB$SEED.

E.

Create an application seed, and install HR_APP in it.

Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?

A.

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

B.

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

C.

If an RMAN BACKUP VALIDATE command takes noticeably less time than 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 both read and write I/O are likely bottlenecks.

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.

Choose three. Which three are true about corrupted data blocks and their recovery in an Oracle Database?

A.

If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.

B.

DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.

C.

A media corrupt block is one where the block is not formatted correctly.

D.

The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.

E.

If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.

F.

DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.

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.)

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?

A.

DBUA must be launched from the target Oracle Home.

B.

Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

C.

A whole database backup must exist before upgrade.

D.

The Pre-Upgrade Information Tool script is executed by DBUA.

E.

All pluggable databases are automatically upgraded as part of a container database upgrade.

F.

The database must be opened in read-only mode.

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?

A.

Enable Memory Access Mode, which reads performance data from SGA.

B.

Use emergency monitoring to fetch data directly from SGA for analysis.

C.

Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

D.

Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

E.

Run ADDM in diagnostic mode.

Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

A.

redo logs

B.

control files

C.

all data dictionary metadata

D.

user-defined PL/SQL packages

E.

temporary tablespaces

F.

mandatory Oracle-supplied PL/SQL packages

G.

undo tablespaces

Which three are true about using Database Resource Manager in an Oracle multitenant environment?

A.

PDB-level resource plans can limit uncommitted UNDO per consumer group.

B.

A PDB-level resource plan can limit session PGA memory.

C.

A CDB-level resource plan can limit PDB UNDO use.

D.

A CDB-level resource plan can limit session CPU utilization.

E.

A CDB-level resource plan is mandatory when using PDB-level resource plans.

F.

A CDB-level resource plan can limit PDB CPU utilization

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.

COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

A.

It will return an error because creation of a local role is not allowed in CDB$ROOT.

B.

ROLE1 will be created only in CDB$ROOT.

C.

It will return an error because common roles must start with C##.

D.

ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

E.

ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1: CREATE PLUGGABLE DATABASE pdb1 USING ‘/u01/app/oracle/oradata/pdb1.xml’ SOURCE_FILE_NAME_CONVERT = (‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);

Which two are true? (Choose two.)

A.

PDB1 data files already exist in the correct location.

B.

DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

C.

PDB_FILE_NAME_CONVERT must be set before executing the command.

D.

/u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

E.

PDB1 must be dropped from CDB1.

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?

A.

CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

B.

CDB1_TAB and APP_PDB1_TAB

C.

CDB1_TAB and APP_ROOT_TAB

D.

CDB1_TAB only

E.

none of the tables, because all three tables will be dropped

Choose three. Which three are true about backing up the control file?

A.

It cannot be backed up manually as a binary copy.

B.

It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re¬creation when a database backup occurs.

C.

It can be backed up manually as a binary copy.

D.

It can get backed up automatically as a binary copy.

E.

It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.

F.

It can be backed up manually as a trace file containing SQL statements for control file recreation.

Which three are true about an application container?

A.

It can contain a single application

B.

Two application containers can share an application seed PDB.

C.

It must have an application root PDB.

D.

An application PDB can belong to multiple application containers.

E.

It must have an application seed PDB.

F.

It can contain multiple applications.

Choose three. Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A.

It requires Oracle ASMLib to manage Automatic Storage Management (ASM) disks.

B.

It creates one disk group during installation.

C.

It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

D.

Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.

E.

It requires Oracle ASM Fitter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks.

F.

It requires the operating system ORACLE_BASE environment variable to be predefined before installation.

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

A.

A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

B.

The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

C.

An existing Oracle base can be used.

D.

The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

E.

Existing Oracle Database instances must be shut down before starting the upgrade.

F.

Only the grid user can perform the upgrade.

Which three are true about the SQL Tuning Advisor? (Choose three.)

A.

It checks each query being analyzed for stale statistics.

B.

It checks each query being analyzed for missing statistics.

C.

It only recommends syntactic changes to SQL statements.

D.

It can recommend semantic changes to SQL statements.

E.

It considers all SQL statements being analyzed by the advisor task as a group.

F.

It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Choose three. Which three are true in Oracle 19c and later releases?

A.

Tablespaces always remain in read/write mode during transportable tablespace operations.

B.

Tablespaces never remain in read/write mode during transportable tablespace operations.

C.

A transportable data pump import can leave a plugged-in tablespace in read-only mode.

D.

Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

E.

A transportable data pump import can leave a plugged-in tablespace in read/write mode.

F.

An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Choose two. Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?

A.

RESYNC CATALOG

B.

CROSSCHECK BACKUP OF ARCHIVELOG ALL

C.

LIST ARCHIVELOG ALL

D.

LIST EXPIRED

E.

LIST ARCHIVELOG

F.

REPORT OBSOLETE

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