NEW QUESTION 1
Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.)

• A. consistent whole database backup
• B. backup of noncritical tablespaces without shutting down the instance
• C. backup of the database without shutting down the instance
• D. backup of only those blocks that have changed since the last backup while database is mounted
• E. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database isopen

Answer: ACD

NEW QUESTION 2
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:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3. Perform a full transportable export on the source database with the parameters VERSI0N=12, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters. Identify the required steps in the correct order.

• 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

Answer: A

NEW QUESTION 3
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?

• A. image copy backup by using RMAN
• B. multisection image copy backup by using RMAN
• C. multisection parallel backup by using RMAN
• D. cold backup after taking the tablespace offline
• E. cold backup after placing the tablespace in backup mode

Answer: C

NEW QUESTION 4
Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? (Choose two.)

• A. online redo log files while the database is open
• B. data files while the database is open
• C. PFILE and password file in MOUNT state
• D. data blocks in data files that have changed since the previous backup
• E. data files while the database is in NOMOUNT state

Answer: BD

NEW QUESTION 5
Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database? (Choose two.)

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

Answer: BE

NEW QUESTION 6
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.
What is the easiest way to perform capacity planning for consolidation?

• 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

Answer: C

NEW QUESTION 7
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.
Which three storage options support the use of HCC? (Choose three.)

• A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D. Database files stored in ZFS and accessed using conventional NFS mounts.
• E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

Explanation: HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).
Note:
* Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition
11.2.1.3 and above
* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.

NEW QUESTION 8
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:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcll; SQL> GRANT CREATE SESSION TO c##scott user?
Which statement is true about the C##SCOTT user?

• A. It is created in all the PDBs with the CREATE SESSION privilege.
• B. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.
• C. It is created and has the CREATE SESSION privilege only in a PDB that is open.
• D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.

Answer: B

NEW QUESTION 9
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.
You execute the RMAN commands:

Which two tasks are performed as part of the import? (Choose two.)

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

Answer: AD

NEW QUESTION 10
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

• A. Use PDB$SEED for creating a PDB.
• B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
• C. Clone the existing PDB.
• D. Use Enterprise Manager Database Express to create a PDB in an existing CDB.
• E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.

Answer: BCD

NEW QUESTION 11
Which three statements are true about Oracle Restart? (Choose three.)

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

Answer: ABE

NEW QUESTION 12
Identify two scenarios in which the RMAN CROSSCHECK command can be used. (Choose two.)

• 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

Answer: BE

NEW QUESTION 13
Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? (Choose three.)

• A. The COMPATIBLE initialization parameter is set to 10.2 or higher.
• B. There are no guaranteed restore points defined for the database.
• C. The default device for the backup must be set to disk.
• D. The tablespaces are locally managed.
• E. The fast recovery area is less than 50 percent free.

Answer: ABD

NEW QUESTION 14
Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup? (Choose three.)

• A. when one or more disks in an ASM disk group are lost
• B. when the data file on an ASM disk group gets corrupted
• C. when one of the disks in a disk group is accidentally unplugged
• D. when one or more file directory paths are accidentally deleted from an ASM disk group
• E. when all the ASM disk groups for the ASM instance are lost

Answer: ADE

NEW QUESTION 15
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.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?

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

Answer: B

NEW QUESTION 16
Examine the command and its output: SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type
FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;
Which two statements are true? (Choose two.)

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

Answer: AC

NEW QUESTION 17
Which two are prerequisites for creating a backup-based duplicate database? (Choose two.)

• 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

Answer: AB

NEW QUESTION 18
Which two statements are true about unified auditing? (Choose two.)

• A. A unified audit trail captures audit information from unified audit policies and audit settings.
• B. Unified auditing is enabled by executing make –f ins_rdbms.mk uniaud_on ioracle 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.

Answer: AB

NEW QUESTION 19
Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)

• A. loss of a non-critical data file
• B. loss of a control file
• C. physical data block corruption
• D. logical data block corruption
• E. loss of an archived redo log file

Answer: BCE