Q1. Identify two scenarios in which the RMAN crosscheck command canbe 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
Answer: C,E
Q2. 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: A
Q3. 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.
Which three are prerequisites to fulfill this requirement?
A. Minimal supplemental logging must be enabled.
B. The database must be running in archivelog mode.
C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
D. The flashback any table privilegemust be granted to the user.
E. The select any transaction privilege must be granted to the user.
F. The recycle bin parameter must be set to on.
Answer: C,D,E
Q4. Which statement is true aboutthe 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 PDBlevel.
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 CD
Answer: A
Q5. Which two statements are true abouta 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.
Answer: C,D
Q6. 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 T3Spercent 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
Answer: B,C
Q7. 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.
Answer: B,C,D
Q8. Your database has a table customers that contains the columns cust_name, amt_due, and old_status.
Examine the commands executed and their output:
SQL>UPDATEcustomersSETamt_due=amt_due+amt_due*l. 1WHEREcust_name='JAMES'
1row updated.
SQL> ALTER TABLE customers DROP COLUMN old_status;
Table Altered
SQL> UPDATE customers SET amt_due=amt_due+amt_due*1.5 WHERE cust_r.ame='JAMES'
1 row updated.
SQL> COMMIT;
SQL> SELECT versions_xid AS XID, versior.s_startscr. AS START_SCN,
versions_er.cscn AS END_SCN, versior.s_operatior. AS OPERATION', amt_due
FROM customers VERSIONS BETWEEN SCN MINVALULEAND MAXVALUE WHERE custname='JAMES'.
XIDSTART_SCNEND_SCNOPERATIONAMT_DUE
07002f00cl03000017063371706337 U3300
Why is it that only one update is listed by the Flashback Version Query?
A. Supplemental logging is not enabled for the database.
B. The undo data that existed for versions of rows before the change to the table structure is invalidated.
C. The db_flash3ACK_reteni:on_target parameter is set toa lower value and the undo data pertaining to the first transaction is flushed out.
D. Undo retention guarantee is not enabled.
E. Flashback Data Archive is full after the first update statement.
Answer: C
Q9. When is the UNDO_RETENTION parameter value ignored by a transaction?
A. when the data file of the undo tablespace is autoextensible
B. when there are multiple undotablespaces available in a database
C. when the undo tablespace is of a fixed size and retention guarantee is not enabled
D. when Flashback Database is enabled
Answer: C
Reference:http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm(undo retention, see the bullets)
Q10. Which two statements are true regarding SecureFile lobs?
A. The amount of undo retained is user controlled.
B. They can be used only for nonpartitioned tables.
C. Fragmentation is minimized by using variable-sized chunks.
D. They support random reads and writes of encrypted LOB data.
Answer: C,D
Reference:http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#AD LOB46113