Oracle Database 12c: Advanced Administration - 1z0-063 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

When is the UNDO_RETENTION parameter value ignored by a transaction?

A. when there are multiple undotablespaces available in a database B. when the undo tablespace is of a fixed size and retention guarantee is not enabled C. when Flashback Database is enabled D. when the data file of the undo tablespace is autoextensible

Discussion 0

Correct Answer: B Vote an answer

Question 2

Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open? (Choose two.)

A. creating a control file for the duplicate database B. generating a new, unique database identifier (DBID) for the duplicate database C. copying online redo log files from the target database to the duplicate database D. performing complete recovery by using all available backups E. restoring target data files to the duplicate database

Discussion 0

Correct Answer: C,D Vote an answer

Question 3

You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION ('ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp')
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_items
WHERE o.orderid = i.order_id and i.product_id = p.product_id;
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. DEFAULT DIRECTORY B. PARALLEL C. TYPE D. ORGANIZATION EXTERNAL E. LOCATION

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which two statements describe the relationship between a window, a resource plan, and a job class? (Choose two.)

A. A window specifies a resource plan that will be activated when that window becomes active. B. A window in association with a job class controls a resource allocation. C. A window in association with a resource plan controls a job class allocation. D. A window specifies a job class that will be activated when that window becomes active. E. A job class specifies a window that will be open when that job class becomes active.

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used? (Choose two.)

A. RMAN Media Management Library B. Oracle Secure Backup C. Enterprise Manager Cloud Control D. Enterprise Manager Database Express E. RMAN recovery catalog

Discussion 0

Correct Answer: C,E Vote an answer

Question 6

RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)

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.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

One of your databases supports a data warehousing workload and is in NOARCHIVELOG mode. You perform RMAN level 0 backup on Sundays and level 1 incremental backups on other days.
One data file is corrupt and the current online redo log is missing due to media failure.
Which four actions must you take for recovery? (Choose four.)

A. Recover the database by using RECOVER DATABASE; B. Recover the database by using RECOVER DATABASE NOREDO; C. Recover the corrupt file by using RECOVER DATAFILE. D. Restore the missing data file. E. Open the database by using the RESETLOGS option. F. Restore all data files. G. Restore the control file.

Discussion 0

Correct Answer: B,E,F,G Vote an answer

Question 8

Which two methods can be used to create a PDB from a non-CDB Oracle 12c Database? (Choose two.)

A. Use Data Pump to export the non-CDB and import it into a newly created, empty PDB. B. Use only the DBMS_PDB package. C. Use only the DUPLICATE DATABASE command. D. use the CREATE PLUGGABLE DATABASE command across a database link from CDB$ROOT to the non-CDB. E. Use the CREATE DATABASE command with an XML file created by executing DBMS_PDB in the non-CDB.

Discussion 0

Correct Answer: B,D Vote an answer

Question 9

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

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 10

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 and only the used blocks are backed up with a maximum backup piece size of
1024 MB. C. The backup succeeds only if the RMAN default device for backup is set to disk. D. The backup fails because you cannot specify section size for a compressed backup.

Discussion 0

Correct Answer: B Vote an answer

Question 11

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.
What is the effect of this setting on the database?

A. Automatic checkpoint tuning is disabled. B. The frequency of log switches is increased. C. The overhead on database performance is increased because of frequent writes to disk. D. The MTTR advisor is disabled.

Discussion 0

Correct Answer: C Vote an answer