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

Choose two. In which two situations can you use Database Upgrade Assistant?

A.

when a character set conversion is required during the upgrade

B.

when multiple pluggable databases in a container database have to be upgraded in a specific sequence

C.

when the target and source database are on the same platform

D.

when the hardware platform needs to be changed as part of the upgrade

E.

when the operating system (OS) needs to be changed as part of the upgrade

Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?

A.

Tune individual SQL statements using the SQL Tuning Advisor.

B.

Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.

C.

Test the application as a whole using tuned SQL statements.

D.

Test tuned SQL statements one at a time for all statements in the application.

E.

Identify poorly tuned SQL statements using the SQL Tuning Advisor.

F.

Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

A.

It creates a binary backup of the control file.

B.

It updates the alert log with the location and contents of the control file

C.

It creates a file that contains SQL statements to re-create the control file.

D.

It creates a file that contains RMAN scripts to create a duplicate database.

E.

It creates a copy of the control file in the fast recovery area (FRA).

1.Which two are prerequisites for creating a backup-based duplicate database?

A.

connecting to the target database and a recovery catalog to execute the duplicate command

B.

creating a password file for an auxiliary instance

C.

connecting to an auxiliary instance

D.

matching the database identifier (DBID) of the source database and the duplicate database

E.

creating an SPFILE for the target database

Choose two. In performance management, which two factors might reduce the ability of an application to scale to a larger number of users?

A.

poorly trained users who do not commit transactions

B.

the number of tablespaces containing tables updated by a transaction

C.

issuing multiple savepoints during a transaction

D.

the number of data files containing extents belonging to tables updated by a transaction

E.

poorly written SQL

Which two arc true about Optimizer Statistics ?

A.

They can be gathered by the DBMS_STATE package.

B.

They are ignored by Optimizer if they are state.

C.

They are gathered by the SQL Tuning Advisor.

D.

By default, they are automatically gathered by a maintenance job.

E.

They provide real-time data about schema objects.

Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

A.

A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.

B.

A PDB Lockdown profile can be created in an application root.

C.

A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.

D.

A PDB Lockdown profile can be created in a regular PDB.

E.

A PDB Lockdown profile can be created in CDB$ROOT .

Which three are true about opatch auto? (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 applied via 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 to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

A.

Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

B.

A connection to an auxiliary instance is always required.

C.

A subset of the target database can be duplicated.

D.

A new DBID is always created for the duplicated database.

E.

A connection to the recovery catalog instance is always required.

F.

A backup of the target database is always required.

G.

Duplication can be done by having the target database instance push copies to the auxiliary database instance.

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

A.

Control file backups can be created while connected to the root container.

B.

Archived Redo Log backups can be created while connected to an application root CDB.

C.

Control file backups can be created while connected to a nonroot container.

D.

Online Redo Log backups can be created while connected to the root container.

E.

The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

A.

The number of table rows is considered when evaluating the cost of accessing a table using an index.

B.

Index balanced B*Tree height is considered when evaluating the cost of using an index.

C.

The Statistics Advisor can help recommend the best way to gather statistics.

D.

Statistics collected using DBMS_STATS always yield the best optimizer result.

E.

The Statistics Advisor generates actions for all recommendations.

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

A.

It is integrated with the SQL Access Advisor.

B.

It predicts the impact of system changes on SQL workload response time.

C.

It provides before and after execution statistics for each SQL statement in the analysis task

D.

It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

E.

SQL statements that were originally run concurrently are run concurrently by SPA.

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

A.

Schema Only accounts can be granted administrator privileges.

B.

If the password file location changes, then the instance must be restarted.

C.

Unified Auditing can be configured to audit only events that are issued directly by an audited user.

D.

All the Oracle-supplied accounts are Schema Only accounts.

E.

Unified Auditing can be configured to audit only events that are issued indirectly by all users

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

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Which three are true about Optimizer Statistics Advisor? (Choose three.)

A.

It can be run only manually.

B.

It is part of the DBMS_ADVISOR package.

C.

It can recommend changes to improve the statistics gathering process.

D.

It always analyzes all schemas in the database.

E.

It runs automatically every night by default.

F.

It is part of the DBMS_STATS package.

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

A.

It is automatically synchronized with its application root PDB when an application is upgraded. B)It cannot be added to an application container after the application container has already been created.

B.

A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

C.

It is automatically synchronized with its application root PDB when an application is installed.

D.

It cannot be dropped from its application container.

E.

A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

F.

It is not required in an application container.

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

A.

PDB1 and PDB2 are in MOUNT state.

B.

Redo logs are opened.

C.

PDB1 and PDB2 are in READ ONLY state.

D.

CDB$ROOT is in MOUNT state.

E.

PDB$SEED is in READ ONLY state.

Choose two. Examine this command: $ rhpctl move database -sourcehome Oracle_home_path ¬destinationhome Oracle_home_path For which two purposes can you use this command?

A.

to switch to a patched Oracle Database home

B.

to upgrade an Oracle Database on the centralized Rapid Home Provisioning server

C.

to move an Oracle Database to the centralized Rapid Home Provisioning server

D.

to switch back to the previous Oracle home as part of a rollback operation

E.

to switch to a read-only Oracle home

Choose three. Which three activities are possible for PDBs?

A.

converting an application seed to an application PDB

B.

converting a regular PDB to an application PDB

C.

converting an application PDB to an application root

D.

copying an application container into another application container in the same CDB

E.

copying an application container into another application container in a different CDB

F.

converting an application PDB to an application seed G) converting an application PDB to a regular PDB

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

A.

Database Replay

B.

Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C.

Active Session History (ASH) report

D.

SQL Performance Analyzer

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