Oracle Exam. 1z0-063.by - Me.249q v.10
Oracle Exam. 1z0-063.by - Me.249q v.10
Oracle Exam. 1z0-063.by - Me.249q v.10
10
Number: 1z0-063
Passing Score: 800
Time Limit: 120 min
File Version: 10
1z0-063
Version 3.10
Exam A
QUESTION 1
Which two statements are true about scheduling operations in a pluggable database (PDB)?
A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
B. A job defined in a PDB runs only if that PDB is open.
C. Scheduler attribute setting is performed only at the CDB level.
D. Scheduler objects created by users can be exported or imported using Data Pump.
E. Scheduler jobs for a PDB can be created only by common users.
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/schedadmin.htm#ADMIN12052
QUESTION 2
A complete database backup to media is taken for your database every day. Which three actions would you
take to improve backup performance?
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmtunin.htm#BRADV011
QUESTION 3
For which three pieces of information can you use the RMAN list command?
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmreprt.htm#BRADV89585
QUESTION 4
You notice performance degradation in your production Oracle 12c database. You want to know what
caused this performance difference.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT525
QUESTION 5
Which three statements are true about a job chain?
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN033
QUESTION 6
Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a
specified point in time.
A. 1, 4, 3
B. 1, 2
C. 1, 4, 3, 2
D. 1, 2, 4
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689
QUESTION 7
Examine the command:
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/osadvsce.htm#BRADV018
QUESTION 8
Which two are prerequisites for setting up Flashback Data Archive?
Correct Answer: DF
Section: (none)
Explanation
Explanation/Reference:
D:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS01002
F:
https://docs.oracle.com/database/121/ERRMG/ORA-54500.htm#ERRMG-GUID-23CDF896-45E7-46D5-
988C-16516FA0008F
ORA-55627: Flashback Archive tablespace must be ASSM tablespace
Cause: An attempt was made to add a tablespace that was not an ASSM tablespace.
Action: Add tablespace that is created with segment space management auto.
QUESTION 9
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/
oracle/product/12.1.0/db_1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR).
Examine the initialization parameters set in your database.
A. It is set to/u01/app/oracle/product/12.1.0/db_1/log.
B. It is set to /u01/app/oracle/admin/eml2rep/adump.
C. It is set to /u01/app/oracle.
D. It is set to /u01/app/oracle/flash_recovery_area.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/diag.htm#ADMIN11008
QUESTION 10
You want to export the pluggable database (PDB) hr_pdb1 from the multitenant container database (CDB)
CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.
A. 2, 1, 3, 7, 6, and 8
B. 2, 1, 4, 5, 3, 7, 6, 9, and 8
C. 2, 1, 3, 7, 6, 9, and 8
D. 2, 1, 3, 5, 7, 6, and 8
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SUTIL/GUID-49A847B1-3193-4C45-B7F3-
B7F514B75C71.htm#SUTIL4335
https://docs.oracle.com/database/121/SUTIL/GUID-C1578FB6-216F-473E-A6D5-
18453D4F9021.htm#SUTIL4336
QUESTION 11
You wish to create jobs to satisfy these requirements:
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/scheduse.htm#ADMIN12393
QUESTION 12
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In
the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges.
You then execute the commands:
A. C##admin can create and select any table, and grant the c##role1 role to users only in the root
container.
B. B_admin can create and select any table in both the root container and hr_pdb.
C. c##admin can create and select any table in the root container and all the PDBs.
D. B_admin can create and select any table only in hr_pdb.
E. The grant c##role1 to b_admin command returns an error because container should be set to ALL.
Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89257
https://docs.oracle.com/database/121/SQLRF/statements_9014.htm#SQLRF01603
QUESTION 13
Examine the commands executed in the root container of your multitenant container database (CDB) that
has multiple pluggable databases (PDBs):
A. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root
container.
B. It fails and reports an error because the container=all clause is not used.
C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database
and all the PDBs.
D. It fails and reports an error because the comtainer=current clause is not used.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_9022.htm#BGEDBIHI
https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89257
This clause does not revoke privileges granted with CONTAINER = ALL.
ORA-01951: ROLE 'C##ROLE1' not granted to 'C##A_ADMIN'
QUESTION 14
Examine the RMAN command:
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#GUID-00CCDDB4-E999-4956-AF30-
15E7D622908B
QUESTION 15
A database is running in archivelog mode. The database contains locally managed tablespaces. Examine
the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
DATABASE;
A. The backup succeeds only if all the tablespaces are locally managed.
B. The backup succeeds only if the RMAN default device for backup is set to disk.
C. The backup fails because you cannot specify section size for a compressed backup.
D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of
1024 MB.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#RCMRF107
QUESTION 16
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to
20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM)
to automate data movement?
A. The movement of all segments to a target tablespace with a higher degree of compression, on a
different storage tier, when the source tablespace exceeds tbs percent used
B. Setting the target tablespace to read-only after the segments are moved
C. The movement of some segments to a target tablespace with a higher degree of compression, on a
different storage tier, when the source tablespace exceeds tbs percent used
D. Taking the target tablespace offline after the segments are moved
E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different
storage tier, when the source tablespace exceeds tbs percent used
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_3001.htm#CJAJGGED
QUESTION 17
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple
databases running in your organization.
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
QUESTION 18
You want RMAN to make duplicate copies of data files when using the backup command.
What must you set using the RMAN configure command to achieve this?
A. MAXSETSIZE TO 2;
B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta009.htm#RCMRF113
QUESTION 19
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle
Database 12c.
Which three statements are true concerning the use of the Valid Time Temporal feature for the
EMPLOYEES table?
A. The valid time columns employee_time_start and employee_time_end are automatically created.
B. The same statement may filter on both transaction time and valid temporal time by using the AS OF
TIMESTAMP and PERIOD FOR clauses.
C. The valid time columns are not populated by the Oracle Server automatically.
D. The valid time columns are visible by default when the table is described.
E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets
the visibility for data manipulation language (DML), data definition language (DDL), and queries
performed by the session.
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#CJADHJHB
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/ilm/temporal/temporal.html
https://docs.oracle.com/database/121/VLDBG/GUID-AF78C832-516A-4686-9DDF-
CE12597F7723.htm#VLDBG14127
QUESTION 20
Which two statements are true when row-archival management is enabled?
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/VLDBG/GUID-5A76B6CE-C96D-49EE-9A89-
0A2CB993A933.htm#VLDBG14154
https://docs.oracle.com/database/121/SQLRF/statements_2015.htm#SQLRF53046
https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#CJADBDCA
QUESTION 21
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a
multitenant container database (CDB) plan using Oracle Database Resource Manager?
Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13777
QUESTION 22
Which three types of failures are detected by the Data Recovery Advisor (DRA)?
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmrepai.htm#GUID-8990058E-4CF3-4165-92DF-
F75706D8F310
QUESTION 23
You want to capture column group usage and gather extended statistics for better cardinality estimates for
the customers table in the SH schema.
A. 3, 2, 1, 4
B. 2, 3, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 4, 1
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/TGSQL/tgsql_astat.htm#GUID-858E0BDA-06C6-471F-B9E8-
888C3AD29673
QUESTION 24
Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create the CDB1. container database (CDB):
A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are
opened in read-write and read-only modes, respectively.
B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
C. It creates a multitenant container database with the root and seed databases opened and one PDB
mounted.
D. It sets the users tablespace as the default for both the root and seed databases.
E. undotbs1 is used as the undo tablespace for both the root and seed databases.
F. It creates a multitenant container database with the root database opened and the seed database
mounted.
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_5005.htm#CACIGAJD
QUESTION 25
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
1.Create media families for data files and archived redo log files.
2.Configure database backup storage selectors or RMAN media management parameters.
3.Create an OSB user preauthorized for RMAN operations.
4.Configure RMAN Access to the OSB SBT.
5.Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0.
A. 1, 4, 3, 2, 5
B. 1, 3, 4, 5, 2
C. 4, 3, 1, 2, 5
D. 4, 3, 5, 1, 2
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#GUID-7D738FAA-B1C8-
49D0-B1DF-13B97F54D067
QUESTION 26
Examine the RMAN command:
Which type of encryption is used for the backup performed by using this command?
A. password-mode encryption
B. dual-mode encryption
C. transparent encryption
D. default encryption
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#GUID-8D85E7DF-53FE-4AF8-811B-
CA836B737B36
QUESTION 27
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
A. 2, 4, 5
B. 2, 1, 4, 3, 5
C. 1, 2, 3, 4, 5
D. 1, 2, 4, 5
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL94653
QUESTION 28
You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
A. USERS
B. SYSTEM
C. SYSAUX
D. EXAMPLE
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
In DBCA templates
QUESTION 29
Your database is running in archivelog mode. Examine the parameters for your database instance:
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not
available. All redo log groups have been used.
A. The database instance hangs and the redo log files are not overwritten.
B. The archived redo log files are written to the fast recovery area until the mandatory destination is made
available.
C. The database instance is shutdown immediately.
D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are
created in the next two available locations to guarantee archive log success.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-009C36AE-8DA3-450A-8988-
8C03CB0D82F5.htm#REFRN10091
https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11347
QUESTION 30
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
A. when the duplicate ... from active database command contains the section size clause
B. when you perform active database duplication on a database with flashback disabled
C. when you specify set encryption before the duplicate ... from active database command
D. when the number of auxiliary channels allocated is equal to or greater than the number of target
channels
E. when you perform active database duplication on a database that has read-only tablespaces
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV89928
QUESTION 31
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN
backup?
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695
(Limitations of Recovering Tables and Table Partitions from RMAN Backups)
QUESTION 32
Your database is running in archivelog mode and a nightly backup of the database, along with an
autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the
control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
A. 1, 2, 5, 3, 6, 4
B. 1, 2, 3, 5, 6, 4
C. 2, 1, 5, 7, 3, 4
D. 2, 1, 5, 6, 7, 4, 3
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89840
QUESTION 33
After implementing full Oracle Data Redaction, you change the default value for the number data type as
follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?
Correct Answer: E
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ASOAG/configuring-oracle-data-redaction-policies.htm#GUID-
58FD64FD-71C5-429A-9A4F-14D63AE2E02A
QUESTION 34
You want to create a guaranteed restore point for your database by executing the command:
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_6013.htm#SQLRF20001
QUESTION 35
Your database has a table customer that contains the columns cust_name, amt_due, and old_status.
Why is it that only one update is listed by the Flashback Version Query?
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS01012
16.10 General Guidelines for Oracle Flashback Technology
QUESTION 36
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB)
as a pluggable database (PDB)?
A. Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB. B. Use
the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying
data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly
created PDB.
B. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the
Oracle 11g database into the newly created PDB.
C. Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump
import to import data from the Oracle 11g database to the newly created PDB.
D. Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to
plug the database as a new PDB into the CDB.
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf
https://docs.oracle.com/database/121/UPGRD/expimp.htm#UPGRD12565
QUESTION 37
In which three scenarios is media recovery required?
Explanation/Reference:
https://docs.oracle.com/database/121/ADMQS/GUID-CBC5870F-2C9A-4F67-B5E9-
D65049AD1E8E.htm#ADMQS09112
QUESTION 38
In the SPFILE, UNDO_TABLESPACE is Set to UNDOTBS.
A. The tablespace will be renamed but the data file headers will not be updated.
B. The statement will fail because you cannot rename an undo tablespace.
C. The tablespace will be renamed and all the changes will be logged in the alert log.
D. The tablespace will be renamed and a message written to the alert log indicating that you should change
the corresponding initialization parameter.
E. You must set the undo_tablespace parameter to some other tablespace name before renaming
undotbs.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://oracledbadmins.blogspot.com/2016/08/change-or-switch-undo-tablespace-in.html
QUESTION 39
Which two statements are true about dropping a pluggable database (PDB)?
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#GUID-6EEAC62B-E7DD-47BA-A62B-
1F34B3D9D02E
QUESTION 40
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr
schema by issuing the command:
A. It succeeds with default settings if the employees table exists in the hr schema.
B. It fails because no SQL*Loader data file location is specified.
C. It fails if the hr user does not have the create any directory privilege.
D. It fails because no SQL*Loader control file location is specified.
E. It succeeds and creates the employees table in the HR schema.
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SUTIL/GUID-8C235861-2A8B-4196-9705-
E6FFED0C0C99.htm#SUTIL3948
https://docs.oracle.com/database/121/ERRMG/SQL-Loader-00100.htm#ERRMG-GUID-538A8B3F-0E15-
4092-82FD-DEB70FDF9A6D
SQL*Loader-00816: error creating temporary directory object string for file string
SQL*Loader-00149: Control file cannot be specified with the TABLE parameter.
QUESTION 41
Which three RMAN persistent settings can be set for a database?
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#BRADV99961
QUESTION 42
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up
your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to
remain open during the duplicate process. You restore the database backups to a new host with the same
directory structure as the production database and want to use the recovery catalog for future backups after
the database is successfully restored to the new host.
How would you achieve this?
A. by using the RMAN switch command to set the new location for the data files
B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
C. by using the RMAN duplicate command with dbid and set newname for tablespace to recover the
database to the new host
D. by creating a new database in the new host, and then using the RMAN recover command
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV168
QUESTION 43
Identify two scenarios in which the RMAN crosscheck command can be used.
A. when checking for backups that are not required as per the retention policy
B. when updating the RMAN repository if any of the archived redo log files have been deleted without using
RMAN to do the deletes
C. when updating outdated information about backups that disappeared from disk or media or became
corrupted and inaccessible
D. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository
E. when listing backups that are required for recovery operations
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta014.htm#RCMRF119
QUESTION 44
A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users
tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 45
Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and
historical data for a given transaction or for transactions in a given time interval.
Explanation/Reference:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS610
QUESTION 46
Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdp system/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
A. expdp will fail because no path has been defined for the dumpfile.
B. expdp will succeed but impdp will fail because the users do not exist.
C. impdp will create two users called hr1 and oe1 and import all objects to the new schemas.
D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas
to ht1 and oe1 schemas, respectively.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SUTIL/GUID-619809A6-1966-42D6-9ACC-
A3E0ADC36523.htm#SUTIL927
https://docs.oracle.com/database/121/SUTIL/GUID-8B512637-E259-4F20-B7C9-
DCD0BB501D09.htm#SUTIL864
https://docs.oracle.com/database/121/SUTIL/GUID-6FEDE3AF-0ED5-46D6-BE91-
C3F840291735.htm#SUTIL931
QUESTION 47
Which two statements are true about a multitenant architecture?
A. Each pluggable database (PDB) has its own initialization parameter file.
B. A PDB can have a private undo tablespace.
C. Log switches occur only at the container database level.
D. A PDB can have a private temporary tablespace.
E. Each PDB has a private control file.
Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
QUESTION 48
Examine the command to create a pluggable database (PDB):
A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/'
directory.
C. The tablespace specifications of pdb2 are the same as pdb1.
D. All database objects belonging to common users in PDB1 are cloned in PDB2.
E. pdb2 is created with its own private undo and temp tablespaces.
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13583
QUESTION 49
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 each block in a table segment
E. tracking the most recent read time for a table segment in the sysaux tablespace
F. tracking the most recent write time for a table segment in the sysaux tablespace
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-F0F60587-56A5-4727-B9D4-
FA44ADD7774E.htm#REFRN10342
QUESTION 50
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when
it is enabled?
Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/glossary.htm#GUID-A0106836-D69F-4157-A3D9-
04842A99FDC8
https://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT1245
QUESTION 51
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure
Backup (OSB):
A. 1, 4, 6, 5, 8, 3, 9
B. 1, 6, 4, 5, 8, 3, 9
C. 2, 4, 6, 5, 8, 3, 7
D. 2, 4, 5, 8, 3, 7, 9
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 52
You want to back up a database such that only formatted blocks are backed up. Which statement is true
about this backup operation?
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV194
QUESTION 53
You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the
following statements:
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_4008.htm#SQLRF56110
QUESTION 54
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:
Which two statements are true about the statistics level parameter?
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_admin.htm#ADMIN13650
https://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14017
QUESTION 55
You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.
A. by using the connect statement as a local user having only the set container privilege
B. by using easy connect
C. by using external authentication
D. as a common user with the set container privilege
E. by executing the alter session set container command as a local user
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN13861
https://docs.oracle.com/database/121/SQLRF/statements_9014.htm#SQLRF01603
QUESTION 56
In which situation can you use Flashback Database?
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_9012.htm#SQLRF01801
https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV286
QUESTION 57
For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup
is performed, you add a new tablespace.
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
A. It returns an error because there is no level 0 backup available for new data files.
B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data
files.
C. It performs a level-0 backup of all data files including those that belong to the new tablespace.
D. It performs an image copy backup of all data files including those that belong to the new tablespace.
E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#GUID-73642FF2-43C5-48B2-9969-
99001C52EB50__I1015480
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV8186
QUESTION 58
Which three conditions must be true for unused block compression to be used automatically while
performing backups by using RMAN?
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV194
QUESTION 59
Your database supports a Decision Support System (DSS) workload that involves the execution of complex
queries. Currently, the database is running with peak workload. You want to analyze some of the most
resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to
improve query performance?
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/TGSQL/tgsql_sqlaccess.htm#TGSQL591
QUESTION 60
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2
databases both have their instances running.
A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
B. All database listeners running from the database home are automatically added to the Oracle Restart
configuration.
C. The srvctl add database command must be used to add orcl1 and orcl2 to the Oracle Restart
configuration.
D. The crsctl start has command must be used to start software services for Oracle Automatic Storage
Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is
complete.
E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are
automatically added to the Oracle Restart configuration.
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/restart.htm#ADMIN12712
QUESTION 61
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user
executes the following commands to create and grant privileges on a procedure:
CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHAR2,
v_SALARYNUMBER,v_dept_idNUMBER)
BEGIN
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure from inserting
values into tables on which they do not have any privileges?
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG1038
QUESTION 62
You must unload data from the orders, order_items, and products database tables to four files using the
External Tables.
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be
changed so that four files are created?
A. TYPE
B. LOCATION
C. PARALLEL
D. DEFAULT DIRECTORY
E. ORGANIZATION EXTERNAL
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SUTIL/GUID-0B2EC1B2-701D-42ED-874C-
47F22F21D847.htm#SUTIL1457
https://docs.oracle.com/database/121/SUTIL/GUID-55E6AC71-5CDE-410E-AB02-
798AEC54F411.htm#SUTIL858
QUESTION 63
Users report this error message when inserting rows into the orders table:
ERROR at line1:
You determine that the indexes tablespace is out of space and there is no free space on the filesystem
used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries?
Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_1012.htm#SQLRF00805
QUESTION 64
Evaluate these statements:
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/VLDBG/GUID-54D18B18-6838-4115-9389-E1FB0D20A8CA.htm
QUESTION 65
Which four actions are possible during an Online Datafile Move operation?
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/dfiles.htm#ADMIN13837
QUESTION 66
Examine the command used to perform an incremental level-0 backup:
To enable block change tracking, after the incremental level 0 backup, you issue the command:
A. The block change tracking data is used only from the next incremental backup.
B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0
backup.
C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the
level 0 backup.
E. The block change tracking data is used for the next incremental level 1 backup only after the next level
0 backup.
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#GUID-4E1F605A-76A7-48D0-9D9B-
7343B4327E2A
QUESTION 67
You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%,
respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning
threshold value, but no alerts have been generated.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-16B23F95-8644-407A-A6C8-
E85CADFA61FF.htm#REFRN10214
QUESTION 68
You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG
mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the
following as the first command:
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmrepai.htm#GUID-1B27227C-84B1-41E1-98EC-
53A89A337FF5
https://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199
RMAN-06954: REPAIR command must be preceded by ADVISE command in same session
Cause: The ADVISE command was not issued in the same session as the REPAIR command.
Action: Submit ADVISE command and then submit the REPAIR command in same session.
QUESTION 69
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated
Maintenance Task?
A. statistics recommendations
B. SQL profile recommendations
C. SQL statement restructure recommendations
D. creation of materialized views to improve query performance
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL542
QUESTION 70
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log
files are backed up to media daily. Because of a media failure, the entire database along with the recovery
catalog database is lost.
A. 1, 8, 3, 2, 4, 5, 7, 6
B. 8, 1, 3, 2, 4, 5, 7, 6
C. 1, 3, 2, 4, 8, 5, 6, 7
D. 8, 3, 2, 4, 5, 7, 6
E. 8, 1, 3, 2, 4, 5, 6
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89839
QUESTION 71
Which three statements are true about the startup and shutdown of multitenant container databases
(CDBs) and pluggable databases (PDBs)?
Explanation/Reference:
https://docs.oracle.com/database/121/SQPUG/ch_twelve045.htm#SQPUG128
QUESTION 72
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of
time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?
A. a hash cluster
B. an index cluster
C. a partitioned table
D. a sorted hash cluster
E. a heap table with a rowid column
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/tablecls.htm#CNCPT608
QUESTION 73
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges
granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3.Start analyzing the data captured by the policy.
4.Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
A. 1, 3, 5, 6, 2, 4
B. 1, 3, 6, 2, 5, 4
C. 1, 3, 2, 5, 6, 4
D. 1, 3, 5, 2, 6, 4
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
1. Create a policy to capture the privilege used by a user for privilege analysis.
3. Start analyzing the data captured by the policy.
6. Stop analyzing the data.
2. Generate a report with the data captured for a specified privilege capture.
5. Compare the used and unused privileges’ lists.
4. Revoke the unused privileges.
https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM682
QUESTION 74
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable
databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target
pluggable database pdb2_1.
Which statement is true about the execution of this command to back up the database?
A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.
B. All data files belonging to pdb2_1 are backed up along with the archive log files.
C. Only the data files belonging to pdb2_ are backed up.
D. This command gives an error because archive log files can be backed up only when RMAN is
connected to the root database.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV835
QUESTION 75
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.
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.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://oracle-base.com/articles/12c/emergency-monitoring-em12c
QUESTION 76
You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based
Oracle 12c database:
CONNECT / AS SYSDBA
ALTER SYSTEM SET THREADED-EXECUTION=TRUE SCOPE=SPFILE;
SHUTDOWN IMMEDIATE
STARTUP
ORA-01031:insufficient privileges
A. because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as
sysdba before issuing a startup command
B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus
before issuing a startup command
C. because the threaded architecture requires authentication using a password file before issuing a startup
command
D. because the threaded architecture requires connecting to the instance via a listener before issuing a
startup command
E. because the threaded architecture requires restarting the listener before issuing a startup command
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT1245
https://docs.oracle.com/database/121/REFRN/GUID-7A668A49-9FC5-4245-AD27-
10D90E5AE8A8.htm#REFRN10335
QUESTION 77
Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple
pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQPUG/ch_twelve045.htm#SQPUG128
QUESTION 78
Examine the resources consumed by a database instance whose current Resource Manager plan is
displayed.
A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
B. An attempt to start a new session by a user belonging to OTHER_GROUPS fails with an error.
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management.
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to I/O waits and latch or enqueue contention.
E. A user belonging to the DSS_QUERIES resource consumer group can create a new session but the
session will be queued.
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-78EEDB39-2F56-4D6B-8878-
5840E95EAFB5.htm#REFRN30214
QUESTION 79
Examine the commands executed to monitor database operations:
A. Database operations will be monitored only when they consume a significant amount of resource.
B. Database operations for all sessions will be monitored.
C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL
and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
D. Only DML and DDL statements will be monitored for the session.
E. All subsequent statements in the session will be treated as one database operation and will be
monitored.
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ARPLS/d_sql_monitor.htm#ARPLS74779
https://docs.oracle.com/database/121/TDPPT/tdppt_realtime_dbops.htm#TDPPT555
https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL790
QUESTION 80
Examine the command:
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SUTIL/GUID-A6300021-419F-4C1D-AFF1-
38FE1123326B.htm#SUTIL841
https://docs.oracle.com/database/121/SUTIL/GUID-3536160E-68D8-4455-8A64-
F1A44032EABD.htm#SUTIL855
https://docs.oracle.com/database/121/SUTIL/GUID-D7F1C0E8-E3CF-495E-9596-
E08AEE36BB6B.htm#SUTIL840
QUESTION 81
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded.
Sometimes, you are not able to connect to the database instance because it hangs.
A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM)
to fetch data directly from SGA for analysis
B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
C. by using Active Session History (ASH) data and performing hang analysis
D. by running ADDM in diagnostic mode
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/TGDBA/pfgrf_diag.htm#GUID-C8ACD778-60CF-4E9E-A644-
45533E93C34A
QUESTION 82
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for
the managed components are not defined.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-68F83472-D74F-4C1D-B515-
FC80C40CC61B.htm#REFRN10033
QUESTION 83
You created a tablespace with this statement:
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_3002.htm#SQLRF01002
QUESTION 84
Which two statements are true regarding the Oracle Data Pump export and import operations?
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SUTIL/GUID-23E58D59-A477-4A87-BD0E-
C82447581D0A.htm#SUTIL856
https://docs.oracle.com/database/121/SUTIL/GUID-55EA54B5-BC13-48F1-AF14-
485C16170274.htm#SUTIL928
https://docs.oracle.com/database/121/SUTIL/GUID-65DCC12E-E370-46E0-86C0-
4EDFDD78DF25.htm#SUTIL862
https://docs.oracle.com/database/121/SUTIL/GUID-C0122FE3-71EE-4E10-8F2A-
03687227292C.htm#SUTIL201
QUESTION 85
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your
database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1','/dev/flash_device_2'
A. Set DB_FLASH_CACHE_SIZE=64G.
B. Set DB_FLASH_CACHE_SIZE=64G, 64G.
C. Set DB_FLASH_CACHE_SIZE=128G.
D. db_flash_cache_SIZE is automatically configured by the instance at startup.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-9B2E54F0-F2C0-4C3A-88B7-
C2F64F32376F.htm#REFRN10316
QUESTION 86
You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
A. 1, 3, 5, 4, 2, and 6(7)
B. 1, 2, 4, 6, 5, 3, and 7
C. 1, 2,4, and 7
D. 2, 4, 5, 6, and 7
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf
https://docs.oracle.com/database/121/SUTIL/GUID-49A847B1-3193-4C45-B7F3-
B7F514B75C71.htm#SUTIL4335
QUESTION 87
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable
databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.
A. It fails because archive log files cannot be backed up using a connection to a PDB.
B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.
C. It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.
D. It fails because the pluggable clause is missing.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV835
QUESTION 88
View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager.create_consumergroup
(consumer_group=>’OLTP',comment=>'onlineuser’)
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager.create_plan
(plan=>’PRIU3ER3',comment=>'dssprio’);
SQL>exec Dbms_resource_manager.create_plan_directive
(plan=>’PRIU3ER3’,group_or_subplan=>'OLTP’,commment=>'onlinegrp',CPU_Pl=>60);
PL/SQL procedure successfully completed.
After execting the steps in the exhibit you execute this procedure, which
results in an error:
SQL> EXECUTE dbms_resource_manager.validate_pending_area ();
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ARPLS/d_resmgr.htm#ARPLS67606
QUESTION 89
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is
corrupted. You notice that all online redo logs have been overwritten since the last backup.
A. Shut down the instance if not already shut down, restore all data files belonging to the system
tablespace from the last backup, and restart the instance.
B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system
tablespace from the last backup, and restart the instance.
C. Shut down the instance if not already shut down, restore all data files for the entire database from the
last backup, and restart the instance.
D. Mount the database, restore all data files belonging to the system tablespace from the last backup, and
open the database.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 90
You execute the RMAN commands:
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#RCMRF107
https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#RCMRF140
QUESTION 91
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is
open and you issue the shutdown immediate command.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14097
QUESTION 92
Which three statements are true about the SQL*Loader utility?
A. It can be used to load data from multiple external files into multiple tables.
B. It can be used to extract and reorganize data from external files, and then load it into a table.
C. It can be used to load data from external files using direct path only.
D. It can be used to create tables using data that is stored in external files.
E. It can be used to generate unique sequential values in specified columns while loading data.
Explanation/Reference:
https://docs.oracle.com/database/121/SUTIL/GUID-A07484AF-4EE8-432F-A587-
5E158FF0B4C1.htm#SUTIL978
QUESTION 93
While performing database backup to tape via the media manager interface, you notice that tape streaming
is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup?
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmtunin.htm#BRADV90072
QUESTION 94
You are administering a multitenant container database (CDB) cdb1.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_6010.htm#SQLRF55686
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13583
QUESTION 95
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container
database (CDB).
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using
the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the
DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_PDB function.
A. 2, 1, 3, 4, 5, 6
B. 1, 3, 4, 5, 6, 7
C. 1, 4, 3, 5, 6, 7
D. 2, 1, 3, 4, 5, 6, 7
E. 1, 5, 6, 4, 3, 2
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf
QUESTION 96
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to
pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container
database (CDB) that has multiple PDBs.
A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system
and using the SQL Performance Analyzer on the test system
B. capturing the workload on the production system and replaying the workload for one PDB at a time on
the test system
C. capturing the workload on the production system and using Consolidated Database Replay to replay the
workload of all production systems simultaneously for all PDBs
D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system
and using the SQL Tuning Advisor on the test system
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RATUG/GUID-62AAF505-1DD4-414A-9F1D-
4386B59B7138.htm#RATUG4080
QUESTION 97
Identify three benefits of unified auditing.
Explanation/Reference:
https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG1024
QUESTION 98
Examine the backup requirement for your company:
A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential
incremental level 1 backup on all the other days
B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative
incremental level 1 backup on all the other days
C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental
level 1 backup on all the other days
D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental
level 1 backup on all the other days
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV89528
QUESTION 99
Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your
database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of
the log_archive_dest_.n destinations.
B. Optional destinations cannot use the fast recovery area.
C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the
location specified for log_archive_dest_4.
D. These settings work only if log__archive_min_succeed_dest is set to a value of 4.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-009C36AE-8DA3-450A-8988-
8C03CB0D82F5.htm#REFRN10091
https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11347
QUESTION 100
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within
the Oracle Job Scheduler?
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN13371
https://docs.oracle.com/database/121/ARPLS/d_sched.htm#ARPLS72306
QUESTION 101
Which two statements describe the relationship between a window, a resource plan, and a job class?
A. A window specifies a resource plan that will be activated when that window becomes active.
B. A window specifies a job class that will be activated when that window becomes active.
C. A job class specifies a window that will be open when that job class becomes active.
D. A window in association with a resource plan controls a job class allocation.
E. A window in association with a job class controls a resource allocation.
Correct Answer: AE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12365
QUESTION 102
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
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV010
QUESTION 103
Which three statements are true about Oracle Secure Backup (OSB)?
Explanation/Reference:
https://docs.oracle.com/cd/E16926_01/doc.121/e16564/intro.htm#OBADM102
https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#OBADM192
https://docs.oracle.com/cd/E16926_01/doc.121/e16564/encryption.htm#OBADM501
QUESTION 104
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory
(OID).
SSL has been configure for the database and OLD and the password file has been configured for the
database.
User scott with sysdba privilege tries to connect remotely using this command:
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/DBSEG/authentication.htm#DBSEG003
QUESTION 105
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure,
the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
A. 1, 3, 4, 5
B. 6, 3, 4, 5
C. 2, 3, 4, 5
D. 6, 4, 3, 5
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 106
You are administering a multitenant container database (COB) that contains two pluggable databases
(PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.
A. The statistics_level parameter is set to all when any of the PDBs is reopened.
B. The statistics_level parameter is set to all only for PDB2 when it is reopened.
C. The statistics_level parameter is set to all when the root database is restarted.
D. The statement is ignored because there is no SPFILE for a PDB.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14017
QUESTION 107
Examine the command to back up the ASM metadata:
ASMCMD>md_backup /backup/ASM_backup
Explanation/Reference:
https://docs.oracle.com/database/121/OSTMG/GUID-FEA13FA9-4FB3-4C4B-B728-
99AD2452888A.htm#OSTMG94584
https://docs.oracle.com/database/121/OSTMG/GUID-D23C36FA-D1C8-4F82-A82A-
5F3EA6E01623.htm#OSTMG94578
QUESTION 108
You are administering a database that supports data warehousing workload and is running in noarchivelog
mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the
other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
A. 4, 8, 11, 5
B. 1, 3, 8, 11, 9
C. 1, 2, 6, 3, 7, 10, 9
D. 1, 3, 7, 10, 9
E. 1, 2, 6, 3, 8, 11, 9
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 109
Examine the commands:
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:
A. It recovers the structure, data, and indexes of the first emp table.
B. It recovers only the structure of the second emp table.
C. It returns an error because two tables with the same name exist in the recycle bin.
D. It recovers the structure, data, and indexes of the second emp table.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_9013.htm#SQLRF01802
QUESTION 110
Which three statements are true about the keystore storage framework for transparent data encryption?
A. It facilitates and helps to enforce keystore backup requirements.
B. It handles encrypted data without modifying applications.
C. It enables a keystore to be stored only in a file on a file system.
D. It enables separation of duties between the database administrator and the security administrator.
E. It transparently decrypts data for the database users and applications that access this data.
F. It helps to track encryption keys and implement requirements such as keystore password rotation and
master encryption key reset or re-key operations.
Explanation/Reference:
https://docs.oracle.com/database/121/ASOAG/introduction-to-transparent-data-
encryption.htm#ASOAG9578
QUESTION 111
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent
objects. During this operation, you want to ensure the following:
A. DEALLOCATE UNUSED
B. SHRINK SPACE CASCADE
C. SHRINK SPACE COMPACT
D. ROW STORE COMPRESS BASIC
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_3001.htm#i2192484
QUESTION 112
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle
database software installed. You also want the new databases to have the same directory structure and
components as your existing 12c database.
1.Create directory structures similar to the production database on all new machines.
2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production
database.
3.Create a database clone template for the database.
4.Run the Database Configuration Assistant (DBCA) to create the database.
5.Run OUI in graphical mode on each machine.
6.Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human
intervention.
A. 2, 1, 6, and 4
B. 2, 3, and 6
C. 3, 1, 5, and 6
D. 2, 3, 1, and 6
E. 1, 5, and 4
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
QUESTION 113
For which two requirements would you use the Database Resource Manager?
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ARPLS/d_resmgr.htm#ARPLS67609
QUESTION 114
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the
command to create a common user:
A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of
the CDB to store schema objects.
B. The command succeeds only if all the PDBs have the users and temp tablespaces.
C. The command gives an error because the container=all clause is missing.
D. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace
for the c##a_admin user if the users tablespace does not exist in that PDB.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG754
QUESTION 115
Which two statements are true about the Automatic Diagnostic Repository (ADR)?
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/diag.htm#ADMIN11007
QUESTION 116
user_data is a nonencryptedtablespace containing tables with data.
Explanation/Reference:
Move to another encrypted tablespace by those ways
Not D,E - https://docs.oracle.com/database/121/SQLRF/statements_3002.htm#SQLRF01002
QUESTION 117
Which two statements are true about a common user?
A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
B. A common user with the create user privilege can create other common users, as well as local users.
C. A common user can be granted only a common role.
D. A common user can have a local schema in a PDB.
E. A common user always uses the global temporary tablespace that is defined at the CDB level as the
default temporary tablespace.
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_8003.htm#SQLRF01503
https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89257
QUESTION 118
You are administering a database that supports a data warehousing workload and is running in
noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental
backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs
option to open the database.
B. Restore the control file and all the data files, recover them by using the recover database noredo
command, and use the resetlogs option to open the database.
C. Restore all the data files, recover them by using the recover database command, and open the
database.
D. Restore all the data files, recover them by using the recover database noredo command, and use the
resetlogs option to open the database.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#GUID-CA98040F-9865-4F4F-BAF2-
91C518612E95__CHDHFBFI
QUESTION 119
Which three statements are true about Oracle Restart?
A. It can be configured to automatically attempt to restart various components after a hardware or software
failure.
B. While starting any components, it automatically attempts to start all dependencies first and in proper
order.
C. It can be configured to automatically restart a database in case of normal shutdown of the database
instance.
D. It can be used to only start Oracle components.
E. It runs periodic check operations to monitor the health of Oracle components.
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/restart.htm#ADMIN12712
QUESTION 120
Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using statistics feedback?
A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is
a huge difference in optimizer estimates and execution statistics.
B. The optimizer can re optimize a query only once using cardinality feedback.
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are
enabled.
E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors
are submitted to the optimizer.
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-43655FC3-3C32-486B-8B11-
8C20C152618D.htm#REFRN10140
QUESTION 121
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the
command to create a duplicate database:
Which two statements are true about the execution of the duplicate command?
A. All archive redo log files are automatically copied to the duplicate database.
B. The duplicate database has the same directory structure as the source database.
C. The duplicate database is created by using the backups created during the execution of The duplicate
command.
D. The password file and SPFILE for the duplicate database dup1 are created in their respective default
locations.
E. The duplicate database is created without using RMAN backups and prod1 is allowed to remain open
during duplication.
Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#GUID-C890DBA3-A58B-4FA5-A4B1-
8FE8DFF8E600
QUESTION 122
A user issues a query on the sales table and receives the following error:
ERROR at line 1:
Which two actions would you take to recover the temporary tablespace?
A. Drop the temp01.dbf file, and then re-create the temp file.
B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
C. Shut down the database instance, start up the database instance in mount state, create a new
temporary tablespace, and then open the database.
D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary
tablespace online.
E. Create a new temporary tablespace and assign it as the default to the user.
Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
https://mybasicknowledge.blogspot.com/2012/06/losing-oracle-tempfile.html
https://www.techonthenet.com/oracle/tablespaces/set_default.php
QUESTION 123
Your database supports an online transaction processing (OLTP) workload in which one of the applications
creates a temporary table for a session and performs transactions on it. This consumes a lot of undo
tablespace and is affecting undo retention.
Correct Answer: AE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN13741
QUESTION 124
Which two statements are true about service creation for pluggable databases (PDBs)?
A. When a PDB is created, a service is automatically started in the instance with the same name as the
PDB.
B. The default service that is automatically created by a database at the time of PDB creation can be
dropped, provided a new additional service is created.
C. A database managed by Oracle Restart can have additional services created or existing services
modified by using the srvctl utility for each PDB.
D. Only a common user can create additional services for a PDB.
E. When a PDB is created, a service with the same name as the PDB is created in the PDB.
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
http://www.oracle.com/technetwork/articles/database/multitenant-part1-pdbs-2193987.html
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13556
QUESTION 125
You want to move your existing recovery catalog to another database.
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the create catalog command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target
database.
5) Import the source recovery catalog schema by using the import catalog command.
6) Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.
A. 1, 6, 4
B. 2, 3, 7, 5
C. 1, 2, 6, 4
D. 1, 2, 3, 6, 5
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm#BRADV189
QUESTION 126
Examine the command and its output:
A. It flashes back the employee table and all the constraints associated with the table.
B. It automatically flashes back all the indexes on the employees table.
C. It automatically flashes back any triggers defined on the table.
D. It flashes back only the structure of the table and not the data.
E. It flashes back the data from the recycle bin and the existing data in the original table is permanently
lost.
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_9013.htm#SQLRF01802
QUESTION 127
You want the execution of large database operations to suspend, and then resume, in the event of space
allocation failures.
A. A resumable statement can be suspended and resumed only once during execution.
B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in
a PL/SQL block.
C. A suspended statement will report an error if no corrective action has taken place during a timeout
period.
D. Before a statement executes in resumable mode, the alter session enable resumable statement must
be issued in its session.
E. Suspending a statement automatically results in suspending a transaction and releasing all the
resources held by the transaction.
Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SUTIL/GUID-E0A63ADD-A446-400A-8277-
7567BD2BC279.htm#SUTIL2694
https://docs.oracle.com/database/121/SQLRF/statements_2015.htm#SQLRF00901
QUESTION 128
Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?
A. Enable minimal supplemental logging.
B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which
the database can be flashed back.
C. Enable the recyclebin.
D. Enable undo retention guarantee.
E. Enable Fast Recovery Area.
Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMQS/GUID-2598AA28-DBBB-4B40-AABC-B28FB5C5F4BE.htm
QUESTION 129
Consider the following scenario for your database:
The most recent backup to disk for the tools tablespace was taken on March 1, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmbckad.htm#GUID-BC32C333-F0EB-4F17-AD79-
8882E224D2F4
QUESTION 130
You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-186DE5CB-8104-4C8B-B673-
6B831DFB42DB.htm#REFRN10285
QUESTION 131
Your database supports an OLTP workload. Examine the output of the query:
To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/TGDBA/pfgrf_instance_tune.htm#TGDBA13014
QUESTION 132
Which three statements are true about persistent lightweight jobs?
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN033
QUESTION 133
You restore and recover your database to a new host by using an existing RMAN open database backup.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89831
QUESTION 134
Which two statements are true about unified auditing?
A. A unified audit trail captures audit information from unified audit policies and audit settings.
B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle
ORACLE_HOME=$ORACLE_HOME.
C. Audit records are created for all users except sys.
D. Audit records are created only for the DML and DDL operations performed on database objects.
E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.
Correct Answer: AB
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG1024
QUESTION 135
Your database is running in archivelog mode. You are taking a backup of your database by using RMAN
with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
1.Restore the control files by using the RMAN restore controlfile command.
2.Mount the database.
3.Restore the data files by using the RMAN restore database command.
4.Open the database with the resetlogs option.
5.Recover the data files by using the RMAN recover using backup controlfile command.
6.Start the database instance in nomount state.
7.Connect to the target database by using a recovery catalog.
8.Open the database.
9.Restore the data file.
10.Recover the data file.
A. 7, 6, 1, 2, 3, 5, 4
B. 7, 2, 1, 3, 5, 8
C. 7, 6, 1, 2, 9, 10, 8
D. 7, 6, 1, 2, 9, 10, 4
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89840
QUESTION 136
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive
for over three months, in Hybrid Columnar Compressed (HCC) format.
Explanation/Reference:
https://docs.oracle.com/database/121/DBLIC/editions.htm#DBLIC-GUID-B6113390-9586-46D7-9008-
DCC9EDA45AB4
QUESTION 137
You notice a performance change in your production Oracle 12c database. You want to know which change
caused this performance difference.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT525
QUESTION 138
Which parameter must be set to which value to implement automatic PGA memory management?
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-DEBBD3F7-9F6D-4AC8-952C-
0E0B2E62312D.htm#REFRN10165
QUESTION 139
Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ;
RMAN> RUN
{
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN run block execution?
A. The script is executed and both DC1 and ch1 channels are used for script execution.
B. The execution of the script fails because multiple channels cannot exist simultaneously.
C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the
RMAN run block.
D. The new channel, ch1, is ignored because a channel has been configured already.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta004.htm#RCMRF102
QUESTION 140
You create two Resource Manager plans, one for night time workloads, the other for day time.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/scheduse.htm#GUID-4F377D3E-55EC-4552-B291-
0061709340CA
https://docs.oracle.com/database/121/ARPLS/d_sched.htm#ARPLS72310
QUESTION 141
Which three statements are true about Consolidated Database Replay?
A. The workload capture and replay systems must have the same operating system (OS).
B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable
databases (PDBs) in a multitenant container database (CDB).
C. A subset of the captured workload can be replayed.
D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you
can select from any of the existing replay schedules.
Explanation/Reference:
https://docs.oracle.com/database/121/RATUG/GUID-62AAF505-1DD4-414A-9F1D-
4386B59B7138.htm#RATUG4080
QUESTION 142
Which two statements are true about Flashback Version Query?
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS01004
QUESTION 143
Which three statements are true about unplugging a pluggable database (PDB)?
Explanation/Reference:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_unplug_plug/
pdb_unplug_plug.html
QUESTION 144
You are administering a multitenant container database (CDB) that contains multiple pluggable databases
(PDBs). You are connected to cdb$root as the sys user. You execute the commands:
A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
B. It is granted to the c##admin user only in the CDB.
C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a
PDB.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89261
https://docs.oracle.com/database/121/SQLRF/statements_9014.htm#SQLRF01603
QUESTION 145
Examine the RMAN command:
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#RCMRF107
QUESTION 146
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta012.htm#RCMRF117
QUESTION 147
Which two statements are true regarding SecureFile lobs?
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADLOB/adlob_smart.htm#ADLOB4444
https://docs.oracle.com/database/121/ADLOB/adlob_tables.htm#ADLOB45281
QUESTION 148
Which three statements are true about compression of backup sets?
QUESTION 149
Examine the RMAN command:
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#GUID-73642FF2-43C5-48B2-9969-
99001C52EB50__CHDCJHFH
QUESTION 150
You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases
(PDBs). As the sys user on cdb$root, you execute the commands:
Which two statements are true about the c##admin user that is created in all PDBs?
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG002
QUESTION 151
View the SPFILE parameter settings in the Exhibit.
SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal
settings, see alert log for more information
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-16B23F95-8644-407A-A6C8-
E85CADFA61FF.htm#REFRN10214
QUESTION 152
Which three requirements must be met before a tablespace can be transported across different platforms?
A. Both the source and target databases must use the same character set.
B. The platforms of both the source and target databases must have the same endian format.
C. The compatible parameter value must be the same in the source and target databases.
D. The minimum compatibility level for both the source and target databases must be 10.0.0.
E. The tablespace to be transported must be in read-only mode.
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/transport.htm#ADMIN13721
https://docs.oracle.com/database/121/RCMRF/rcmsynta2022.htm#RCMRF1919
QUESTION 153
Examine the output:
Which three types of files are automatically placed in the fast recovery area?
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/glossary.htm#GUID-6E3CDD76-A573-4E5C-B12D-
59C232C96C19
QUESTION 154
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB
plans) in a multitenant container database (CDB)?
A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an
equal degree of the resource share of that PDB.
B. In a PDB plan, subplans may be used with up to eight consumer groups.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups
across all PDBs in the CDB.
D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically
calculated.
E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups
based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer
groups in the PDB plan.
Correct Answer: AE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13775
QUESTION 155
In a database supporting an OLTP workload, tables are frequently updated on both key and non-
keycolumns.
Which table organization or type would provide the best performance for this hybrid workload?
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/tablecls.htm#CNCPT608
QUESTION 156
In your database, there are tablespaces that were read-only when the last backup was taken. These
tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the
database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/osadvsce.htm#BRADV227
QUESTION 157
Examine the RMAN commands executed in your database:
Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
C:
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#GUID-73642FF2-43C5-48B2-9969-
99001C52EB50__CHDBGAJI
D:
https://docs.oracle.com/database/121/RCMRF/rcmsynta009.htm#GUID-B5094E73-C26C-4FED-AE39-
8C2E9540050A__I1017491
QUESTION 158
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of
a pluggable database (PDB)?
A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
B. The PDB is closed and requires media recovery at the PDB level.
C. The PDB does not close and the temp file is re-created automatically whenever the container database
(CDB) is opened.
D. The PDB does not close and starts by using the default temporary tablespace defined for the CDB.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 159
You execute the commands on a multitenant container database CDB1 that has multiple pluggable
databases:
A. It succeeds and displays all the tablespaces that belong to the root database.
B. It fails and returns an error because a connection is not made by using the sysdba privilege.
C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-E6BF227D-CFAA-43EB-A7C9-
F0AF293FDEC0.htm#REFRN30277
QUESTION 160
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG355
QUESTION 161
Which two statements are true about tablespaces in multitenant container databases (CDBs)?
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb-12cr1#temporary-
tablespaces
QUESTION 162
When is the UNDO_RETENTION parameter value ignored by a transaction?
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN-GUID-28EA4133-BC73-4036-87F2-
656FC1A6D9A2
QUESTION 163
Which two options can be configured for an existing database by using the Database Configuration
Assistant (DBCA)?
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 164
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default
format of which two data types would be affected by this setting?
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/NLSPG/ch3globenv.htm#GUID-A00DF2B2-2A01-4517-B8DA-
D595788F16B5
QUESTION 165
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMQS/GUID-BA75AD46-D22E-4914-A31E-
C395CD6A2BBA.htm#ADMQS031
QUESTION 166
You issue the RMAN commands:
QUESTION 167
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing
the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?
A. Start up the database instance by using the new location of the server parameter file and run the
catuppst.sqi script to generate informational messages and log files during the upgrade.
B. Start up the database instance by using the new location of the server parameter file and run the
catctl.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object
statistics to minimize the time needed for recompilation.
D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing
database, and then performs additional upgrade operations.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/UPGRD/upgrade.htm#CHDBHAHE
QUESTION 168
Examine the command to duplicate a database:
A. The SPFILE is copied along with the data files of the pluggable databases (PDBs). The root and the
seed database in the container database (CDB) are also duplicated.
B. A backup of pdb1 and pdb5 must exist before executing the command.
C. The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.
D. The root and the seed database in the container database (CDB) are also duplicated
E. An auxiliary instance must be started with the initialization parameter
ENABLE_PLUGGABLE_DATABASE set to TRUE.
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#GUID-F8A5EEA9-F32E-4CB0-8C97-
C9D0A5F942F1
QUESTION 169
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
A. A DBA can check specific tables with the DMU
B. The database to be migrated must be opened read-only.
C. The release of the database to be converted can be any release since 9.2.0.8.
D. The DMU can report columns that are too long in the converted characterset
E. The DMU can report columns that are not represented in the converted characterset
Explanation/Reference:
Explanation:
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion
steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different
than the representation in the current character set, but neither length limit issues nor invalid representation
issues have been found.
QUESTION 170
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm#BRADV89644
https://docs.oracle.com/database/121/RCMRF/rcmsubcl013.htm#RCMRF131
QUESTION 171
Which two statements are true regarding Oracle Data Pump?
A. EXPDP and IMPDP are the client components of Oracle Data Pump.
B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA
privilege.
D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import
commands.
Correct Answer: AB
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SUTIL/GUID-47B26B0B-3C95-4182-ACDF-
2EEDD577FC9E.htm#SUTIL801
https://docs.oracle.com/database/121/SUTIL/GUID-8B6975D3-3BEC-4584-B416-
280125EEC57E.htm#SUTIL807
https://docs.oracle.com/database/121/SUTIL/GUID-B4A887AD-1E1D-4305-A6D8-
DC16D3B28BA9.htm#SUTIL959
QUESTION 172
Which two statements are true about making RMAN image copies of a database?
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
A:
https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#GUID-BC37B3E4-3338-4452-A363-
DB882F2E9415
D:
https://docs.oracle.com/database/121/BRADV/glossary.htm#GUID-397CB99E-3F07-4980-96B3-
9D0D0ABBABEA
QUESTION 173
The CATDB12c database contains an Oracle Database 12c catalog schema owned by the rc12c user.
The CATDB11 database contains an Oracle Database 11g catalog schema owned by the RC11 user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases
are open.
A. It fails because the target database and recovery catalog database are of different versions.
B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global
scripts in the RC12C catalog are automatically renamed.
C. It succeeds but the database is not automatically registered in the RC12c catalog.
D. It fails because RMAN is not connected to the target database with DBID=1423241.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198
QUESTION 174
You issue the command:
A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest
initialization parameter.
B. It creates a file that contains the SQL statement, which is required to re-create the control file.
C. It updates the alert log file with the location and contents of the control file.
D. It creates a binary backup of the control file.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_1006.htm#i2155843
QUESTION 175
You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR
schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:
A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback
Data Archive.
B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table
definition is purged from Flashback Data Archive.
C. It executes successfully and continues to store metadata related to the EMPLOYEES table.
D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS640
QUESTION 176
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has
multiple pluggable databases (PDB):
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?
A. The command fails and gives an error because object privileges cannot be granted to a common user.
B. The command fails because container is not set to current.
C. The command succeeds and the common user c##admin can create a session and query the
DBA_users view in cdb$root and all the PDBs.
D. The command succeeds and the common user c##admin can create a session in cdb$root and all the
PDBs, but can only query the dba_users view in cdb$root.
E. The command succeeds and the common user c##admin can create a session and query the
DBA_users view only in cdb$root.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89261
QUESTION 177
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database
(PDB) SALES:
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#GUID-F8A5EEA9-F32E-4CB0-8C97-
C9D0A5F942F1
https://docs.oracle.com/database/121/RCMRF/rcmsynta020.htm#RCMRF126
QUESTION 178
You create a new database by using the CREATE DATABASE command in SQL *Plus, with the ENABLE
PLUGGABLE DATABASE clause specified.
A. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database
(PDB).
B. It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.
C. It is created as a PDB that must be plugged into an existing CDB.
D. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_5005.htm#CACIGAJD
QUESTION 179
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the
backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to
another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89831
QUESTION 180
Examine the list of possible steps to transport a tablespace across platforms that have the same
compatibility level, character sets, and endian format:
A. 2, 4, and 3
B. 2, 4, 3, and 5
C. 1, 5, 2, 4, 3, and 6
D. 1, 2, 4, 3, and 6
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/transport.htm#ADMIN13726
QUESTION 181
In which three situations must you use a recovery catalog?
A. when you want to store RMAN global scripts that can be used across multiple databases
B. when you want to restrict the amount of space used by backups
C. when you want to perform incremental backups by using a block change tracking file
D. when you want to list data files that were in a target database at a given time by using the AT clause with
the REPORT SCHEMA command
E. when you want to maintain backup metadata longer than the period specified by the
CONTROL_FILE_RECORD_KEEP_TIME parameter
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm#BRADV89644
https://docs.oracle.com/database/121/BRADV/rcmreprt.htm#BRADV90911
QUESTION 182
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that
OSB performs RMAN backup or restore requests?
Explanation/Reference:
https://docs.oracle.com/cd/E16926_01/doc.121/e16563/osb_interfaces.htm#GUID-A2DC8B91-ADE2-4594-
8959-08E8DCBCA245
https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#GUID-BF56E3BD-247D-
40BB-A84F-3B2C2C402168
Oracle 12c: Backup and Restore Workshop
QUESTION 183
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero
value?
A. The MTTR advisor is enabled only if the value is greater than the default value.
B. Automatic checkpoint tuning is enabled.
C. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the
FAST_START_MTTR_TARGET parameter.
D. The time taken to recover an instance after a crash is always exactly the same as the value set for the
FAST_START_MTTR_TARGET parameter.
Correct Answer: AB
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/TGDBA/pfgrf_instance_tune.htm#TGDBA13009
QUESTION 184
You execute the commands to configure settings in RMAN:
A. The backup terminates because the backup destination for disk is not specified in the BACKUP
command.
B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to
media.
C. It backup up the data files and archived logs, making one copy of each data file and archived log on disk
and media.
D. It backs up the data files and archived logs to media, making two copies of each data file and archived
logs.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
QUESTION 185
You are administering a multitenant container database (CDB) that contains multiple pluggable databases
(PDBs). RMAN is connected to CDB$ROOT.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmrepai.htm#GUID-1B27227C-84B1-41E1-98EC-
53A89A337FF5
QUESTION 186
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant
container database (CDB)?
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13551
QUESTION 187
You are connected to a recovery catalog and target database. You execute the command:
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm#GUID-C2DE2E5D-DCDA-4A85-BA4D-
A783180C4F51
QUESTION 188
A database instance uses an SPFILE. Examine the parameter:
Identify the required steps in the correct order to accomplish the task.
A. 3, 4
B. 2, 1, 4, 6
C. 3, 1, 4, 6
D. 1, 5, 2, 4, 6
E. 2, 6
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
You can create an additional control file copy for multiplexing by copying an existing control file to a new
location and adding the file name to the list of control files.
Similarly, you rename an existing control file by copying the file to its new name or location, and changing
the file name in the control file list. In both cases, to guarantee that control files do not change during the
procedure, shut down the database before copying the control file.
To add a multiplexed copy of the current control file or to rename a control file:
1. Shut down the database.
2. Copy an existing control file to a new location, using operating system commands.
3. Edit the CONTROL_FILES parameter in the database initialization parameter file to add the new control
file name, or to change the existing control filename.
4. Restart the database.
QUESTION 189
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE
command.
Which two statements are true about the dependent objects of the CUSTOMERS table?
A. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be
retrieved separately.
B. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
C. All the triggers associated with the table are flashed back but are disabled.
D. Materialized views that use the CUSTOMERS table are flashed back.
E. LOB segments associated with the CUSTOMERS table are flashed back.
Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_9013.htm#SQLRF01802
QUESTION 190
Which three statements are true about the database instance startup after an instance failure?
A. The RECO process recovers the uncommitted transactions at the next instance startup.
B. Online redo log files and archived redo log files are required to complete the rollback stage of instance
recovery.
C. Uncommitted changes are rolled back to ensure transactional consistency.
D. The SMON process coordinates the database recovery.
E. Media recovery is required to complete the database recovery.
F. Changes committed before the failure, which were not written to the data files, are re-applied.
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/startup.htm#CNCPT89047
QUESTION 191
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container
database (CDB).
1. Use Data Pump export to perform a full transportable export on the source database with the export
parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
A. 1, 5, 4, 7, and 6
B. 3, 2, 5, 1, 4, and 7
C. 2, 5, 1, 4, 7, and 6
D. 2, 1, 3, 5, 7, and 6
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf
QUESTION 192
RMAN is connected to a target database instance and an auxiliary instance. You execute the command:
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#GUID-C890DBA3-A58B-4FA5-A4B1-
8FE8DFF8E600
https://docs.oracle.com/database/121/RCMRF/rcmsynta020.htm#RCMRF126
QUESTION 193
Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode?
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV002
QUESTION 194
You regularly take backups of your database using RMAN with a recovery catalog. Your database is
currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability.
A. Drop the TEMP tablespace, and then re-create it with new temp files.
B. Restart the database instance to create the temp file automatically.
C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is
corrupted.
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/dfiles.htm
https://docs.oracle.com/database/121/BRADV/rcmcomre.htm
QUESTION 195
You are administering a multitenant container database (CDB) that has no startup triggers and contains
three pluggable databases (PDBs).
SQL> STARTUP
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQPUG/ch_twelve045.htm#SQPUG128
QUESTION 196
Which three statements are true about unplugging a pluggable database (PDB)?
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_2008.htm
QUESTION 197
You want to create a duplicate database DUP_DB from your production database PROD on the same host.
The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken
using RMAN connected to a recovery catalog.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#GUID-C890DBA3-A58B-4FA5-A4B1-
8FE8DFF8E600
QUESTION 198
You execute the command to recover your database:
A. It restores all data files from the specified time, and then applies the redo logs.
B. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified
time.
C. It restores all data files and control files from the most recent backup taken before the “until time”. and
then recovers up to the “until time” using any restored archive logs that are needed to complete the task.
D. It restores the control file and all data files from the most recent backups, and then applies the redo logs
up to the “until time”.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsubcl022.htm#GUID-6A6C502A-6E21-4673-9FC9-
C075D1E2F97A__BABEDABD
QUESTION 199
You need to perform a block media recovery on the tools01.dbf data file in your database by using
Recovery Manager (RMAN).
Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmblock.htm#BRADV89785
QUESTION 200
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 databases are open.
A. All databases registered in the RC11 catalog are registered in the RC12C catalog.
B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered
databases with same name.
C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are
automatically renamed.
D. Imported databases are unregistered from the RC11 catalog.
E. Recovery catalog is resynchronized with the control files of the registered databases.
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm
QUESTION 201
In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN. and
then execute the command:
A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in
the root database.
B. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root
database, as well as in the pluggable databases (PDBs).
C. The command fails because the CONTAINER clause is not used.
D. The command fails because system privileges cannot be granted to a common user.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_9014.htm#SQLRF01603
QUESTION 202
Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup
(OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
A. 1, 3, 6, 7, 4
B. 2, 1, 6, 4, 7
C. 1, 3, 5, 7, 4
D. 1, 3, 6, 4, 7
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#OBADM190
QUESTION 203
Which three statements are true about common roles?
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89257
QUESTION 204
Which statement is true about the ALTER SESSION SET CONTAINER command to switch between
containers?
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_admin.htm#ADMIN13616
QUESTION 205
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB
plans) in a multitenant container database (CDB)?
A. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal
share of resources.
B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
C. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at
the PDB level and ignores the limits set at the CDB level.
D. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based
on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in
the PDB plan.
Correct Answer: AE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13775
QUESTION 206
RMAN is configured to create backupset backups for your database. You issue the command to back up
the database:
Which two statements are true about the backup performed by the command?
A. Only the used blocks in the data files are backed up.
B. It backs up all the data files and deletes obsolete backups after the backup is complete.
C. It backs up only those archived log files that are not backed up at least once.
D. It backs up all the archived log files and deletes the ones that were just backed up.
E. It backs up all archived redo log files and online log files and deletes the archived log files after the
backup is complete.
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#GUID-73642FF2-43C5-48B2-9969-
99001C52EB50__CHDIEAIE
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#GUID-73642FF2-43C5-48B2-9969-
99001C52EB50__CHDIEAIE
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#GUID-73642FF2-43C5-48B2-9969-
99001C52EB50__CHDCFGEI
QUESTION 207
Your database instance is abnormally terminated because of a power outage. At the next startup, from
which point in the redo log does the recovery start?
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/startup.htm#CNCPT89046
QUESTION 208
Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update
these copies incrementally every six hours. After a regular maintenance task, when you attempt to restart
the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the
EXAMPLE tablespace is lost.
You want to recover the data file as quickly as possible while maximizing availability for the database.
A. 2, 6, 4, 5, 3
B. 2, 4, 5, 3, 6
C. 1, 2, 4, 6, 3
D. 1, 2, 7, 5, 3, 6
E. 2, 7, 5, 3
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta2021.htm#RCMRF159
https://docs.oracle.com/database/121/BRADV/rcmcomre.htm#GUID-27F3EB09-3608-4E0E-A7F0-
1F0DF1D5C572
QUESTION 209
Examine the statements that use flashback technologies:
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
A. 1,2,5
B. 1,3,6
C. 2,3,5,6
D. 3,4,5
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm
QUESTION 210
Which two statements are true about RMAN duplexed backups?
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmbckad.htm#BRADV145
QUESTION 211
You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
A. 1, 3, 5, 4, 2, and 7
B. 1, 2, 4, 6, 5, 3, and 7
C. 1, 2,4, and 7
D. 2, 4, 5, 6, and 7
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf
QUESTION 212
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four
years. After some time, the requirement changes for keeping transactions from four to two years.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_1010.htm#SQLRF20009
QUESTION 213
Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7.
You want to perform a complete database backup by using RMAN.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV89528
QUESTION 214
You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs),
PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_8003.htm#SQLRF01503
https://docs.oracle.com/database/121/SQLRF/statements_9014.htm#SQLRF01603
QUESTION 215
Which two statements are true about roles in multitenant container databases (CDBs)?
Correct Answer: AF
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89257
https://docs.oracle.com/database/121/SQLRF/statements_9014.htm#SQLRF01603
QUESTION 216
Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by
an Administrator?
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta012.htm#RCMRF117
https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm#BRADV89643
QUESTION 217
Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at
midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few
important transactions are performed on the database.
Which two best methods for recovering the truncated table data?
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
Point-in-time
QUESTION 218
You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
A. The resulting backupset has backup pieces that cannot exceed 300 MB.
B. RMAN uses multiplexing to perform the backup.
C. RMAN always performs this type of backup in parallel.
D. The backup succeeds only if the USERS tablespace is locally managed.
E. The backup set size is limited to 300 MB.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#RCMRF107
https://docs.oracle.com/database/121/BRADV/glossary.htm#GUID-FDECFF77-1833-4BD3-A23C-
AA4806E28241
QUESTION 219
Which two statements are true about encrypted backups performed by using RMAN?
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#GUID-8D85E7DF-53FE-4AF8-811B-
CA836B737B36
https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#GUID-6ED708C7-1092-45FC-80C6-
236F062D0DAC
QUESTION 220
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The
local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2
connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14017
QUESTION 221
You execute the RMAN commands:
Which statement is true about the backup set created by the BACKUP command?
A. The default channel is allocated and the backup set is created in only one destination.
B. Two channels are allocated and backup pieces for the backup set are created in both the specified
destinations.
C. Two channels are allocated and two copies of the backup set are taken in parallel in both locations.
D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL
2.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#GUID-C6D6E615-892F-4586-B14D-
1BA42CB0C457
https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#GUID-42F31F53-07AF-4A81-9387-
849D17F90C9A
QUESTION 222
Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a
database that is open?
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#GUID-C890DBA3-A58B-4FA5-A4B1-
8FE8DFF8E600
QUESTION 223
Your database is running in archivelog mode. Examine the parameters for your database instance:
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not
available. All redo log groups have been used.
A. The database instance hangs and the redo log files are not overwritten.
B. The archived redo log files are written to the fast recovery area until the mandatory destination is made
available.
C. The database instance is shutdown immediately.
D. The destination set by the log_archive_dest_1 parameter is ignored and the archived redo log files are
created in the next two available locations to guarantee archive log success.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/REFRN/GUID-009C36AE-8DA3-450A-8988-
8C03CB0D82F5.htm#REFRN10091
https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11347
QUESTION 224
You are performing regular backups of your production database by using a recovery catalog.
You add two new tablespaces to your production database after performing a backup. They must be
included in future backups.
A. Synchronize the recovery catalog with the target database control file.
B. Create a new database incarnation record.
C. Add the tablespaces in the recovery catalog by using the CATALOG command.
D. Synchronize all the physical data files with the logical records in the recovery catalog by using the
CROSSCHECK command.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta2009.htm#RCMRF150
QUESTION 225
You use RMAN to take regular backups for your database.
A. All backups and archived redo log files that are not required for the recovery are deleted and the
repository is updated.
B. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist
on disk or media, is deleted.
C. All backups that have exceeded the age set by the RMAN retention policy are deleted.
D. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the
RMAN retention policy are deleted from the repository.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta014.htm#RCMRF119
https://docs.oracle.com/database/121/RCMRF/rcmsynta015.htm#RCMRF121
QUESTION 226
Which two are prerequisites for performing Flashback Transaction?
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS1008
QUESTION 227
In your database, the user SCOTT wants to retrieve the dropped HR. EMPLOYEES table by using the
command:
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_9013.htm#SQLRF01802
QUESTION 228
Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions?
Explanation/Reference:
B,C,D,E use RecycleBin
QUESTION 229
Examine the RMAN commands:
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta020.htm#GUID-E13D8A02-80F9-49A2-9C31-
92DD3A795CE4__I1011578
QUESTION 230
Which three statements are true about Flashback Data Archive?
A. Flashback Data Archive prevents flashback queries from getting a snapshot too-old error.
B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is
disabled or disassociated first.
C. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive
for a database.
D. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it
is enabled using the default Flashback Data Archive.
E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive
tablespace.
Explanation/Reference:
A:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS621
B:
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS641
D:
https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#BABGIIIA
QUESTION 231
Which three types of backups can be performed for a database running in NOARCHIVELOG mode?
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV89526
QUESTION 232
Which two statements are true regarding an Automatic Storage Management (ASM) instance?
(Choose two.)
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/OSTMG/GUID-33538342-DEC8-450C-83A8-
1B693D76529B.htm#OSTMG94074
QUESTION 233
Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_9013.htm#SQLRF01802
https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#i2159748
QUESTION 234
Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT '/u02/backup/%U';
RMAN>RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
EXECUTE SCRIPT full_backup;
}
Which statement is true when the RMAN run block is executed?
A. The execution of the script fails because multiple channels cannot coexist.
B. The script is executed and both the channels are used for the script execution.
C. The new channel, CH1, is ignored because a channel has been configured already.
D. The persistent configuration parameter DC1 is overridden because a new channel is allocated in the
RMAN run block.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta004.htm#RCMRF102
QUESTION 235
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the
users on the database use the default temporary tablespace.
A user issues a query on the orders table and receives the following error:
ERROR at line I:
ORA-0I565: error in identifying file
'/u01/app/oracle/oradata/TEST/temp01.tmp'
ORA-27037: unable to obtain file status
A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the
database.
C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with
new tempfiles.
D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then
bring the temporary tablespace online.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://mybasicknowledge.blogspot.com/2012/06/losing-oracle-tempfile.html
https://www.techonthenet.com/oracle/tablespaces/set_default.php
QUESTION 236
What two are the prerequisites for enabling Flashback Database?
Correct Answer: AB
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMQS/GUID-2598AA28-DBBB-4B40-AABC-B28FB5C5F4BE.htm
And B from 10g
QUESTION 237
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#SQLRF01402
https://docs.oracle.com/database/121/ADDCI/dom_idx.htm#ADDCI4489
QUESTION 238
Tablespaces of certain types or in certain states can be renamed.
Which four of these situations permit renaming a tablespace?
Explanation/Reference:
https://docs.oracle.com/database/121/SQLRF/statements_3002.htm#SQLRF01002
QUESTION 239
ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements
on the encrypted data in the tables?
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://www.oracle.com/technetwork/database/security/tde-faq-093689.html
https://www.oracle.com/technetwork/testcontent/o19tte-086996.html
https://docs.oracle.com/database/121/ASOAG/introduction-to-transparent-data-
encryption.htm#ASOAG10139
QUESTION 240
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?
(Choose all that apply.)
A. It can be used to allow the access privilege settings for users but not roles.
B. It can be used to allow the access privilege settings for users as well as roles.
C. It can be used to control the time interval for which the access privilege is available to a user.
D. It can be used to selectively restrict the access for each user in a database to different host computers.
E. It can be used to selectively restrict a user's access to different applications in a specific host computer
Explanation/Reference:
https://docs.oracle.com/database/121/ARPLS/d_networkacl_adm.htm#ARPLS148
QUESTION 241
You perform an RMAN block media recovery on the tools01.dbf data file in the SALES database.
Which two statements are true?
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmblock.htm#BRADV856
D from 10g
QUESTION 242
Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?
Correct Answer: E
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN027
QUESTION 243
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while
performing the backup operation?
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#GUID-BC37B3E4-3338-4452-A363-
DB882F2E9415
https://docs.oracle.com/database/121/BRADV/glossary.htm#GUID-397CB99E-3F07-4980-96B3-
9D0D0ABBABEA
QUESTION 244
Your database is running in ARCHIVELOG mode. You backup your database regularly. If certain files are
lost, an incomplete recovery is required.
In which two cases is this true? (Choose two.)
A. flashback logs
B. inactive online redo log
C. current online redo log member
D. all control files
E. archived log files required to perform recovery
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/osadvsce.htm#BRADV018
QUESTION 245
ENCRYPT_TS an encrypted tablespace that contains tables with data.
Which statement is true about queries and data manipulation language statements on these tables?
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
https://www.oracle.com/technetwork/database/security/tde-faq-093689.html
https://www.oracle.com/technetwork/testcontent/o19tte-086996.html
https://docs.oracle.com/database/121/ASOAG/introduction-to-transparent-data-
encryption.htm#ASOAG10139
QUESTION 246
Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have
enough free space and there is no scope to add more space to it.
Identify two events that can occur at the time of a log switch. (Choose two.)
A. All active transactions are rolled back and the database instance shuts down.
B. The database instance status is automatically changed to RESTRICTED mode and file creation in the
fast recovery area is prevented.
C. The Oracle Database server deletes a file that is on the obsolete file list to create free space in the fast
recovery area.
D. An entry is written in the alert log and the database instance is automatically placed in MOUNT state.
E. The log switch hangs until free space is available in the fast recovery area.
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#BRADV8183
QUESTION 247
As part of a manual update process, you install Oracle Database 12c software, prepare a new
ORACLE_HOME, you shut down an existing single-instance database that runs from that ORACLE_HOME.
What should you do next to start the upgrade of this database?
A. Start up the database instance by using the STARTUP UPGRADE command by using the server
parameter file.
B. Start up the database instance by using the new location of the server parameter file and run the
catupgrd.sql script from the new ORACLE_HOME to use parallel upgrade options that reduce down
time
C. Start up the database instance by using the new location of the server parameter file and run the
catctl.pl script from the new ORACLE_HOME to use parallel upgrade options that reduce down time
D. Start up the database instance by using the new location of the server parameter file and run the
catuppst.sql script to generate informational messages and log files during the upgrade.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
https://docs.oracle.com/database/121/UPGRD/upgrade.htm#CHDBHAHE
QUESTION 248
Which three statements are true about Scheduler Windows? (Choose three.)
Explanation/Reference:
https://docs.oracle.com/database/121/ADMIN/scheduse.htm#GUID-4F377D3E-55EC-4552-B291-
0061709340CA
https://docs.oracle.com/database/121/ARPLS/d_sched.htm#ARPLS72310
QUESTION 249
You plan to migrate a production database to Real Application Clusters (RAC). You created a test RAC
database by cloning the production database and plan to replay a workload, captured from the production
database. Examine these steps:
1. Preprocess the captured workload.
2. Restart the database instance in RESTRICTED mode.
3. Set up Replay Clients.
4. Restore the test database to the point when the capture started on the production database.
5. Remap connections.
Which is the correct sequence of required steps?
A. 1, 4, 3, 5
B. 1, 4, 5, 3
C. 2, 1, 5, 3, 4
D. 1, 2, 4, 5, 3
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference: