Which three statements are true about RMAN compressed backups?
A. Media manager compression should not be enabled if compressed backups are being written to tape.
B. Compressed backups can be written to media only if using proxy copies.
C. File system compression should be enabled if compressed backups are being written to disk.
D. Compression creates some performance overhead during backups to tape.
E. Compression creates some performance overhead during backups to disk.
You notice that the elapsed time for an important database scheduler job is unacceptably long.
The job belongs to a scheduler job class and runs in a scheduler window.
Which two actions could reduce the job's elapsed time?
A. Increasing the job's relative priority within the Job class to which it belongs
B. Increasing the priority of the scheduler window to which the job belongs
C. increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window
D. Moving the job to an existing higher priority scheduler window with the same schedule and duration
E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
Which three statements are true about tablespaces in a multitenant container database (CDB)?
A. All PDBs and CDBs have their own UNDO tablespaces.
B. All PDBs and CDBs have their own SYSTEM and SYSAUX tablespaces.
C. Each pluggable database (PDB) can have a temporary tablespace or a tablespace group.
D. CDBs and PDBs may share the same temporary tablespace that is present in the root container.
E. There can be only one temporary tablespace group in a CDB.
On your Oracle 12c database, you issue the following commands to create indexes:
SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id);
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which statement is correct?
A. Only the ORD_CUSTOMER_IX1 index is created and it is visible.
B. Both the indexes are created and both of them are visible.
C. Both the indexes are created; however, only the ORD_CUSTOMER_IX1 index is visible.
D. Both the indexes are created; however, only the ORD_CUSTOMER_IX2 index is visible.
You use RMAN to back up a database which uses Automatic Storage Management (ASM) and you use
the MD_BACKUP command to back up the ASM metadata regularly.
You lose an ASM disk group DG1 due to a hardware failure.
In which two ways can you re-create the lost disk group and restore the data? (Choose two.)
A. Use RMAN to restore both the metadata and the data.
B. Use the MKDG command to add a new disk group DG1 with the same or different specifications as those from the lost disk group and use RMAN to restore the data.
C. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
D. Use the MD_RESTORE command to restore the disk group metadata and use RMAN to restore the data.
You connect to the root container of a multitenant container database (CDB) with SYSDBA privileges by
using SQL*Plus.
The CDB has several pluggable databases (PDBs) open in read/write mode.
There are ongoing transactions in both the CDB and the PDBs.
What happens after issuing the SHUTDOWN TRANSACTIONAL statement?
A. the statement results in an error because there are open PDBs
B. the shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled back.
C. the shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
D. the shutdown proceeds immediately
Which two statements are true concerning Information Lifecycle Management (ILM) policies?
A. Multiple ILM policies may exist for the same segment and any compression levels may be specified for any policy.
B. Segment-level policies override row-level policies.
C. Multiple ILM policies may exist for the same table, if the action is compression and the scope is at the
row level.
D. Multiple ILM policies may exist for the same segment but greater compression levels must be specified at greater elapsed times.
E. ILM policy functions return a Boolean value.
Which three are amongst the categories into which column definitions are classifies by the Database Migration Assistant for Unicode (DMU)?
A. alphanumeric columns that will have invalid binary representation after converting to the chosen Unicode character set
B. alphanumeric columns that need conversion to a different binary representation before converging to the chosen Unicode character set
C. date columns that will have invalid binary representation after converting to the chosen Unicode character set
D. numeric columns that will have invalid binary representation after converting to the chosen Unicode character set
E. numeric columns that will exceed the column size limit after converting to the chosen Unicode character set
F. alphanumeric columns that need no conversion
You plan to drop the column of a table that has Flashback Archiving enabled.
You want to ensure minimal service disruption.
How would you do this in your Oracle 12c Database?
A. Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.
B. Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.
C. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.
D. Drop the column using the ALTER TABLE statement.
E. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.
You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN:
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION `+RECO';
Which five steps are performed by RMAN?
A. truncating the SCOTT.EMP table in the original database
B. exporting the SCOTT.EMP table from the auxiliary database
C. flashing back the original database to the desired point in time
D. recovering the auxiliary database to the desired point in time
E. creating an auxiliary instance
F. importing the SCOTT.EMP table into the original database
G. restoring the tablespaces required for point-in-time recovery
H. dropping the SCOTT.EMP table in the original database
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-060 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.