NEW QUESTION 1
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? (Choose two.)

• A. Table Point-in-Time Recovery
• B. Database Point-in-Time Recovery
• C. Tablespace Point-in-Time Recovery
• D. Flashback Database
• E. Flashback Transaction Backout

Answer: BD

NEW QUESTION 2
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? (Choose two.)

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

Answer: BE

Explanation: B: Oracle Database retrieves all indexes defined on the table except for bitmap join indexes, and all triggers and constraints defined on the table except for referential integrity constraints that reference other tables.

NEW QUESTION 3
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;
Which statement is true about the execution of the command?

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

Answer: D

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

• A. All the read-only tablespaces should be taken offline.
• B. All the read-only tablespaces should be restored separately.
• C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
• D. All the read-only tablespaces should be made online with logging disabled.

Answer: A

NEW QUESTION 5
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.
Examine the steps to recover the database:
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.
Identify the required steps in the correct order.

• 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

Answer: D

NEW QUESTION 6
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 cact1.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.

Answer: B

NEW QUESTION 7
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.
How can you detect the cause of the degraded performance?

• 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

Answer: A

NEW QUESTION 8
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

• A. Compare Period ADDM report
• B. AWR Compare Period report
• C. Active Session History (ASH) report
• D. Taking a new snapshot and comparing it with a preserved snapshot

Answer: B

Explanation: The awrddrpt.sql report is the Automated Workload Repository Compare Period Report. The awrddrpt.sql script is located in the $ORACLE_HOME/rdbms/admin directory.

NEW QUESTION 9
Which two statements are true about RMAN duplexed backups? (Choose two.)

• A. It is only supported for backups to tape via media management interface.
• B. It is not supported for image copies.
• C. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.
• D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
• E. Duplex backups can contain only data files and control files.

Answer: BD

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

• A. from the last complete checkpoint position
• B. from the beginning of the current redo log file until the instance failure
• C. from the last committed transaction
• D. from the beginning of the current redo log file to the checkpoint position
• E. from the most recent incremental checkpoint

Answer: E

NEW QUESTION 11
You want to create a guaranteed restore point for your database by executing the command: SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command. (Choose two.)

• A. The database must be running in ARCHIVELOG mode.
• B. Flashback Database must be enabled.
• C. Fast Recovery Area must be enabled.
• D. The recyclebin must be enabled for the database.
• E. Undo retention guarantee must be enabled.
• F. A database backup must be taken.

Answer: AC

NEW QUESTION 12
Consider the following scenario for your database: Backup optimization is enabled in RMAN.
The recovery window is set to seven days in RMAN.
The most recent backup to disk for the tools tablespace was taken on March 1, 2013. The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk. Which statement is true about the backup of the tools tablespace?

• A. The RMAN backup fails because the tools tablespace is read-only.
• B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
• C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
• D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Answer: D

NEW QUESTION 13
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;

Answer: D

NEW QUESTION 14
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.
Examine the steps to recover this table from an RMAN backup:
1. Determine which backup contains the table that needs to be recovered.
2. Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.
3. Import the Data Pump export dump file into the auxiliary instance.
4. Create a Data Pump export dump file that contains the recovered table on a target database. Identify the required steps in the correct order.

• A. 1, 4, 3
• B. 1, 2
• C. 1, 4, 3, 2
• D. 1, 2, 4

Answer: B

NEW QUESTION 15
You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?

• A. A custom database template
• B. AData Warehouse database template
• C. Automatic Storage Management (ASM) for storage of data files
• D. A file system for storage of data files

Answer: A

NEW QUESTION 16
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

Which two statements are true? (Choose two.)

• A. The root and seed databases are included in the duplication.
• B. Only the SALES PDB is duplicated as the non-CDBCDBDUP.
• C. A backup of the SALES PDB must exist before the execution of the command.
• D. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
• E. RMAN must be connected to a recovery catalog for the execution of the command.

Answer: AD

Explanation: D: When duplicating a whole CDB or one more PDBs:
You must create the auxiliary instance as a CDB. To do so, start the instance with the following declaration in the initialization parameter file:
enable_pluggable_database=TRUE
A: To duplicate PDBs, you must create the auxiliary instance as a CDB. To do so, start the instance with the declaration enable_pluggable_database=TRUE in the initialization parameter file. When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the seed database, and the duplicated PDBs.
References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm

NEW QUESTION 17
A user issues a query on the sales table and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace? (Choose two.)

• A. Drop the tenp01.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.

Answer: BE

NEW QUESTION 18
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
------------------------- 0
SQL> EXECDBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full; NUMBER VALUE
------------------------
-1
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?

• A. Re-enable redaction policies that use FULL data redaction.
• B. Re-create redaction policies that use FULL data redaction.
• C. Re-connect the sessions that access objects with redaction policies defined on them.
• D. Flush the shared pool.
• E. Restart the database instance.

Answer: E

Explanation: About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.

NEW QUESTION 19
In which three scenarios is media recovery required? (Choose three.)

• A. when a tablespace is accidentally dropped from a database
• B. when archived redo log files are lost
• C. when data files are lost
• D. when one of the online redo log members is corrupted
• E. when all control files are lost

Answer: ACE