Free 1Z0-062 Exam Dumps

No Installation Required, Instantly Prepare for the 1Z0-062 exam and please click the below link to start the 1Z0-062 Exam Simulator with a real 1Z0-062 practice exam questions.
Use directly our on-line 1Z0-062 exam dumps materials and try our Testing Engine to pass the 1Z0-062 which is always updated.

Exam Code: 1Z0-062
Exam Title: Oracle Database 12c: Installation and Administration
Vendor: Oracle
Exam Questions: 379
Last Updated: November 15th,2024

Question 1

Examine the command to perform a data pump export operation on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept On the target database, you execute the data pump import command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept Which three statements are true? (Choose three.)

A. The expdp operation exports data that satisfies the condition of the defining query used to create the EMP_DEPT view.
B. The impdp operation creates the view and dependent objects.
C. All rows from the dependent objects, along with the metadata required to create the EMP_DEPT view, are exported.
D. Objects dependent on the EMP_DEPT view are exported.
E. The impdp operation creates EMP_DEPT as table and populates it with the data from the export dump fil

Correct Answer:ADE

Question 2

Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)

A. It can be used to create a database template from an existing database.
B. It can be used to add a new tablespace.
C. It can generate SQL database creation scripts.
D. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
E. It can configure Automatic Storage Management (ASM) diskgroups.

Correct Answer:AC
References: https://docs.oracle.com/cd/E17559_01/em.111/e16599/appdx_creating_db_templates.htm#CJACEDCD

Question 3

A redaction policy was added to the SAL column of the SCOTT.EMP table:
1Z0-062 dumps exhibit
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

A. SYS sessions, regardless of the roles that are set in the session
B. SYSTEM sessions, regardless of the roles that are set in the session
C. SCOTT sessions, only if the MGR role is set in the session
D. SCOTT sessions, only if the MGR role is granted to SCOTT
E. SCOTT sessions, because he is the owner of the table
F. SYSTEM session, only if the MGR role is set in the session

Correct Answer:ABD

Question 4

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

A. An SPFILE can be created from a PFILE or from memory.
B. A PFILE can be used to start up a database instance even if an SPFILE exists.
C. An SPFILE must reside in the ORACLE_HOME/dbs directory.
D. An SPFILE can be created only before a database instance is started.
E. An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance.

Correct Answer:AB

Question 5

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

A. The PDB must be open in read only mode.
B. The PDB must be dosed.
C. The unplugged PDB becomes a non-CDB.
D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
E. The unplugged PDB can be plugged into another CDB.
F. The PDB data files are automatically removed from disk.

Correct Answer:BDE
B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB’s datafiles can remain in place.
References: