Free 1Z0-062 Exam Dumps

Question 11

Which three statements are true about Oracle Data Pump? (Choose three.)

A. IMPDP can be used to change target data file names, schemas, and tablespaces during import.
B. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations.
C. EXPDP and IMPDP are the client components of Oracle Data Pump.
D. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
E. IMPDP always use the conventional path insert method to import data.

Correct Answer:ABC
References: https://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL2880

Question 12

Which two tools can be used to configure static service information in the listener.ora file? (Choose two.)

A. Oracle Net Manager
B. Oracle Enterprise Manager Cloud Control
C. Oracle Net Configuration Assistant
D. Listener Control Utility (LSNRCTL)
E. Oracle Enterprise Manager Database Express

Correct Answer:AB

Question 13

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

A. recommending creation of indexes based on SQL workload
B. recommending restructuring of SQL statements that have suboptimal plans
C. checking schema objects for missing and state statistics
D. recommending optimization of materialized views
E. generating SQL profiles

Correct Answer:BCE

Question 14

A database is open READ WRITE and the instance has multiple sessions some of which have active transactions.
You execute this command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
Which three are true about the active transactions? (Choose three.)

A. They may issue COMMIT OR ROLLBACK statements
B. They are suspended and unable to issue any statements
C. They may continue to issue DML statements
D. They are rolled back automatically
E. They may continue to issue queries
F. They are terminated immediately

Correct Answer:BDF

Question 15

Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
C. Use the DBMS_PDB package to clone an existing PDB.
D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.

Correct Answer:ACD
Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). This statement enables you to perform the following tasks:
* (A) Create a PDB by using the seed as a template
Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB.
* (C) Create a PDB by cloning an existing PDB
Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB.
The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files.
* Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB
Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.