Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
NO.1 Which three actions are performed by the Oracle Preinstallation RPM, oracle-database- server
-xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose
three.)
A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure
are met
B. creating the oracle OS user
C. creating the OSDBA (dba) group
D. creating thte oraInventory (oinstall) group
E. creating the grid OS user
F. configuring the OS for Oracle Automatic Storage Management shared storage access
Answer: BCD
Explanation:
When installed, the Oracle Preinstallation RPM does the following:
Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid
Infrastructure and Oracle Database, and resolves any dependencies Creates an oracle user, and
creates the oraInventory (oinstall) and OSDBA (dba) groups for that user As needed, sets sysctl.conf
settings, system startup parameters, and driver parameters to values based on recommendations
from the Oracle Preinstallation RPM program Sets hard and soft resource limits Sets other
recommended parameters, depending on your kernel version Sets numa=off in the kernel for Linux
x86_64 machines.
https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN172
NO.2 Which two are true about the Program Global Area (PGA) and its management in an Oracle
database instance? (Choose two.)
A. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated
servers.
B. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
C. The entire PGA is located in the System Global Area (SGA) when using shared servers.
D. Sorts and Hash Joins use PGA memory.
E. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
Answer: DE
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-
architecture.html#GUID-913335DF-050A-479A-A653-68A064DCCA41
NO.3 Which two are true about automatic block repair? (Choose two.)
A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING =
TRUE.
B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be
done on that physical standby database.
C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on
any of its physical standby databases.
D. It is not possible for media corrupt blocks.
E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be
2 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 1
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
done on its primary database.
Answer: BE
Explanation:
You can use an Oracle Active Data Guard standby database for automatic repair of data corruptions
detected by the primary database. Additionally if the corruption is discovered on an Active Data
Guard physical standby database the corruption will be automatically repaired with a good block
from the Primary.
NO.4 To 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.
Answer: DE
NO.5 Which three are true about backup, restore, and recovery operations done without using
Recovery Manager (RMAN)? (Choose three.)
A. Backing up a database in NOARCHIVELOGmode using O/S utilities requires that the database
instance be started and the dataabse be in the MOUNT state.
B. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance
be started and the database be in MOUNT state.
C. An Oracle database can be restored from backup files copied using O/S utilities.
D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE
COPIES.
E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database
instance be shut down.
F. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a
backup set.
G. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database
instance be started and the database be in OPEN state.
Answer: CDE
Explanation:
A,B,G are not right because the question is telling us 'without RMAN'. To put it in mount/open or so,
are necessary only in case of using RMAN. Otherwise, using OS Utils, DB must be closed or maximum
in NOMOUNT state.
F is incorrect as according to the following note only archivelog, backuppiece, controlfilecopy or
3 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 2
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
datafilecopy can be cataloged
https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta011.htm
NO.6 Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome
Oracle_home_path
For which two purposes can you use this command? (Choose two.)
A. to switch an existing Oracle Database home to a newer release of Oracle software on the same
server
B. to switch to a read-only Oracle home
C. to switch back to the previous Oracle home as part of a rollback operation
D. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
E. to switch to a patched Oracle Database home
Answer: CE
Explanation:
You can use rhpctl move gihome command with the same syntax to switch from the current Oracle
Grid Infrastructure home to a patched home.
The rhpctl command enables you to switch from your current Oracle Grid Infrastructure or Oracle
Database home to patched Oracle home so that you can provision the new Oracle home as gold
image.
You can also use the rhpctl command to switch back to the old Oracle home, if you want to roll back
the operation.
NO.7 Which three tasks can be automatically performed by the Automatic Data Optimization feature
of Information lifecycle Management (ILM)?
A. Tracking the most recent read time for a table segment in a user tablespace
B. Tracking the most recent write time for a table segment in a user tablespace
C. Tracking insert time by row for table rows
D. Tracking the most recent write time for a table block
E. Tracking the most recent read time for a table segment in the SYSTEM tablespace
F. Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct
Answer: ABC
NO.8 You plan to perform cross-platform PDB transport using XTTS. Which two are true?
A. Automatic conversion of endianess occurs.
B. The source and target platforms must have the same endianess.
C. The source PDB can be in MOUNT or OPEN state.
D. The source PDB must not be an application root.
E. The source PDB must be in MOUNT state.
F. A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.
Answer: BC
NO.9 Which two statements are true about the Database Configuration Assistant (DBCA)?
A. It can configure Automatic Storage Management (ASM) diskgroups.
4 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 3
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
B. It can be used to copy an existing Oracle database to a new host and apply any patches necessary
in the new host.
C. It can be used to add a new tablespace.
D. It can be used to create a database template from an existing database.
E. It can generate SQL database creation scripts.
Answer: DE
NO.10 Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose
three.)
A. All archive logs are retained after an archival backup is taken, until the next archival backup is
taken of the same database.
B. The SPFILE is included in the archival backup.
C. They are never considered obsolete by RMAN.
D. Archive logs are retained if they are necessary to allow the database to be recovered to a
consistent state when an archival backup is restored.
E. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
F. They can optionally be written to a fast recovery area (FRA).
G. Use of a recovery catalog is always required to support the creation and use of archival backups.
Answer: BDE
NO.11 You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)
A. All Oracle recovery files not in the current FRA that have not been backed up already, are backed
up.
B. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
C. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
D. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
E. These backups can be written to disk or SBT.
Answer: AC
Explanation:
The Backup recovery files command backs up all recovery files even if they are not in the FRA,Which
would back up foe example any copies of control files or data files that are not in the FRA. by default
backup optimization is in effect for backup recovery area and backup recovery files i.e the only
recovery files that this command backs up are those that are not already backed up.
NO.12 Examine this configuration:
17.CDB1is an Oracle Database 12c Release 2 container database (CDB).
18.PDB1and PDB2are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle
Database 18c environment:
5 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 4
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
What is the outcome?
A. It fails because PDB$SEED is in MIGRATE state.
B. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
C. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
D. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
E. Only CDB$ROOT and PDB$SEED are upgraded.
F. It fails because PDB2 is not in UPGRADE state.
Answer: C
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/21/upgrd/upgrading-parallel- upgrade
-utility-catctl-pl.html#GUID-C667B51C-058F-48B6-86FE-12E9D82FDDBD
NO.13 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? (Choose two.)
A. Create an application seed, and install HR_APP in it.
B. Create the PDB1 application PDB and install HR_APP in it.
C. Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application
PDB.
6 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 5
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
D. Create the PBD1 application PDB and synchronize it with HR_ROOT.
E. Create the PBD1 application PDB and synchronize it with PDB$SEED.
Answer: CD
NO.14 Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose
two.)
A. It analyzes a period of time corresponding to the 12 hours of activity.
B. It runs automatically after each AWR snapshot.
C. A DBA can run it manually.
D. Results are written to the alert log.
E. It analyzes a period of time corresponding to the last day of activity.
Answer: BC
Explanation:
An ADDM analysis task is performed and its findings and recommendations stored in the database
every time an AWR snapshot is taken provided the STATISTICS_LEVEL parameter is set to TYPICAL or
ALL.
The time period analyzed by ADDM is defined by the last two snapshots (the last hour by default).
NO.15 Which three are true about Database Point-in-Time Recovery? (Choose three.)
A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
B. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
D. The Database must be in ARCHIVELOG mode.
E. The target point for the recovery must be specified as a stime or System Change Number (SCN).
F. The database must be open RESETLOGS after Database Point-in-Time Recovery.
Answer: BDF
Explanation:
Archivelog mode and mount state are needed (B, and D)
After the restore you need to open with reset logs (F)
E is discarted because sequence number also is valid
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%2
0point%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20t
arget%20time.
NO.16 Examine this configuration:
1. CDB1is a container database.
2. COMMON_USER_PREFIXis C##.
3. PDB1is a pluggable database contained in CDB1.
4. APP1_ROOTis an application container contained in CDB1.
5. APP1_PDB1is an application PDB contained in APP1_ROOT.
You execute these commands successfully:
7 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 6
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
Which two are true? (Choose two.)
A. APP1_USER1 can be created in PDB1.
B. APP1_USER1 can be created in CDB1.
C. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
D. C##_APP_USER1 can be created in CDB1.
E. P1_USER1 can be created in CDB1.
F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.
Answer: AD
Explanation:
For the common user:
The username must be unique across all containers. So D is correct because APP_USER1 is different
from APP1_USER1 in APP1_ROOT B,E are wrong because you can only create local user in specific
PDB.
A is true because APP1_USER1 is unique in PDB1
F is false because common user will not have the same privileges and role unless you grant it with
option CONTAINER=ALL;
NO.17 Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
A. A base recovery catalog should exist.
B. The owner of VPC cannot own recovery catalog.
C. At least one target database should be registered in the recovery catalog.
D. The register database privilege should be granted to the virtual catalog owner.
E. The recovery_catalog_owner role should be granted to the virtual catalog owner.
Answer: ABD
NO.18 Identify three benefits of Unified Auditing.
8 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 7
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
A. Decreased use ofstorage to store audit trail rowsin the database.
B. It improves overall auditing performance.
C. It guarantees zero-loss auditing.
D. The audit trail cannot be easily modified because it is read-only.
E. It automatically audits Recovery Manager (RMAN) events.
Answer: BDE
NO.19 Which three statements are true about Flashback Database?
A. Flashback logs are written sequentially, and are archived.
B. Flashback Database uses a restored control file to recover a database.
C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery
Area.
D. Flashback Database can recover a database to the state that it was in before a reset logs
operation.
E. Flashback Database can recover a data file that was dropped during the span of time of the
flashback.
F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be
used to roll forward to the desired flashback time.
Answer: ACF
NO.20 Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
5. Each PDB has several tables with referential integrity constraints.
6. FLASHBACK DATABASE is ON.
7. UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs.
Which method can be used to undo the changes using a single command?
A. restore and recover database
B. flashback transaction
C. flashback database
D. flashback table and transaction
E. flashback table
Answer: C
NO.21 Oracle Data Redaction is active on the SCOTT.EMPtable.
You queried the table twice.
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;
9 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 8
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
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.
Answer: C
NO.22 Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and
are granted system privileges. You execute the command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES
hr_admin,oe_admin; Which statement is true?
A. It succeeds and needs to be enabled to capture all SQL statements that require either the
specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.
B. It fails because the command does notspecify when the unified audit policy should be enforced.
C. It succeeds and starts capturing only successful SQL statements for all users who have either the
specified privileges or roles granted to them.
D. It fails because system privileges cannot be granted with roles in the same audit policy.
Answer: A
NO.23 Which two statements are true about the Oracle Database server architecture?
A. An Oracle Database server process represents the state of a user's login to an instance.
B. An Oracle Database server process is always associated with a session.
C. Each server process has its own User Global Area (UGA).
D. A connection represents the state of a user's login to an instance.
E. The entire data dictionary is always cached in the large pool.
Answer: CD
10 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 9
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
NO.24 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).
Answer: C
NO.25 Which three are true about recovering tables using RMAN?
A. RMAN can recover tables owned by the SYSTEM user.
B. RMAN can recover tables owned by the SYS user.
C. RMAN can recover tables in the SYSTEM tablespace.
D. RMAN always uses an auxiliary instance.
E. RMAN can recover a table after a DDL operation has altered the table structure.
F. RMAN can recover tables in the SYSAUX tablespace.
G. RMAN can recover tables in a standby database.
Answer: ADE
NO.26 Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)
A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
C. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
D. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
E. CDB$ROOT and PDB$SEED are automatically duplicated.
Answer: AE
Explanation:
"Duplicates the specified PDBs in the CDB. Use a comma-delimited list to duplicate multiple PDBs."
"When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed
database (PDB$SEED)." The reasons why the other answers are wrong are also found here:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV760
NO.27 Which three are true about actions that can or cannot be performed by users with the
SYSBACKUP privilege? (Choose three.)
A. They can view data from any data dictionary view or dynamic performance view.
B. They cannot create restore points.
C. They cannot drop tablespaces.
D. They can create any table.
E. They can drop any tablespace.
F. They can view data from any user-defined tables.
Answer: ADE
Explanation:
11 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 10
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
Free Exam/Cram Practice Materials - Best Exam Practice Materials
IT Certification Guaranteed, The Easy Way!
https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-privilege-and-
role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7
NO.28 Which three are true about using an RMAN Recovery Catalog with a pluggable database
(PDB) target connection in Oracle Database 19c and later releases? (Choose three.)
A. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more
PDBs.
B. The base catalog must be enabled for Virtual Private Catalog use.
C. The target PDB must be registered in a base catalog.
D. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB
registered in the Virtual Private Catalog.
E. The target PDB must be registered in a Virtual Private Catalog.
F. The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
Answer: ADE
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-
catalog.html#GUID-A7502D0D-5840-4B13-869D-7259F2D73119 A base recovery catalog is a database
schema that contains RMAN metadata for a set of target databases.
A virtual private catalog is a set of security policies that restrict user access to a subset of a base
recovery catalog.
12 from Freecram.net.
Get Latest & Valid 1Z0-083 Exam's Question and Answers 11
https://www.freecram.net/exam/1Z0-083-oracle-database-administration-ii-e10509.html
