AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


DOWNLOAD & READ Free Dumps For Oracle- 1z0-060



You are reading online questions and answers for Oracle Exam 1z0-060 (Upgrade to Oracle Database 12c ) 100% free... Please share this site which will help this community to grow...

Question ID 2101

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’ ORA-27037: unable to obtain file status
Identify two ways to rectify the error.
 

Option A

A.    Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
 

Option B

B.    Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
 

Option C

C.    Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
 

Option D

D.    Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.

 

Option E

E.    Shut down the database instance and then restart the CDB and PDBs.

Correct Answer A,E
Description Update Date and Time 2015-12-14 15:06:38

============================================================================

Question ID 2102

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Option A

A.    All the triggers for the table are disabled without changing any of the column names or column types in the table.
 

Option B

B.    The primary key constraint on the EMPLOYEES table is disabled during redefinition.
 

Option C

C.    VPD policies are copied from the original table to the new table during online redefinition.

 

Option D

D.    You must copy the VPD policies manually from the original table to the new table during online redefinition.

Correct Answer A,C
Description Update Date and Time 2015-12-14 15:10:00

============================================================================