Free 1Z0-063 Exam Dumps

Question 51

- (Exam Topic 1)
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command? (Choose two.)

A. It succeeds with default settings if the employees table exists in the hr schema.
B. It fails because no SQL*Loader data file location is specified.
C. It fails if the hr user does not have the create any directory privilege.
D. It fails because no SQL*Loader control file location is specified.
E. It succeeds and creates the employees table in the HR schema.

Correct Answer:AD

Question 52

- (Exam Topic 1)
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. TYPE
B. LOCATION
C. PARALLEL
D. DEFAULT DIRECTORY
E. ORGANIZATION EXTERNAL

Correct Answer:C

Question 53

- (Exam Topic 1)
Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL> STARTUP
Which two statements are true about the successful execution of the command? (Choose two.)

A. All redo log files are opened.
B. The root, the seed, and all the PDBs are opened in read-write mode.
C. All the PDBs are opened in read-write mode.
D. All the PDBs are in closed state.
E. Only the root database is opened in read-write mode.

Correct Answer:AE

Question 54

- (Exam Topic 2)
Which three statements are true about Flashback Data Archive? (Choose three.)

A. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.
B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
C. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.
D. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

Correct Answer:BCD

Question 55

- (Exam Topic 1)
Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2. RMAN is connected to the target database PDB2_1.
Examine the command executed to back up PDB2_1: RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?

A. It fails because archive log files cannot be backed up using a connection to a PDB.
B. It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.
C. It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.
D. It fails because the PLUGGABLE clause is missing.

Correct Answer:B