Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 81:

  Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to tape drive fast enough.

  What could be a solution to make streaming happen during the backup?

  A. Configure backup optimization

  B. Configure the channel to increase MAXOPENFILES

  C. Configure the channel to increase the capacity with the RATE parameter

  D. Configure the channel to adjust the tape buffer size with the BLKSIZE option

  Correct Answer: D

• Question 82:

  Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the

  TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.)

  A. Taking the MASTERTBS tablespace offline

  B. Dropping the relationship between the tables

  C. Adding the MASTERTBS tablespace to the recovery set

  D. Putting the MASTERTBS tablespace in read-only mode

  Correct Answer: BC

  If constraints for the tables in tablespace tbs1 are contained in the tablespace tbs2, then you cannot

  recover tbs1 without also recovering tbs2.

  Reference:

  http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtspit.htm#BRADV99978

• Question 83:

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

  A. Oracle Data Pump export and import operations can be performed to move data across different database releases.

  B. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.

  C. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object.

  D. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

  E. Oracle Data Pump export operations invoked from the clients that are connected remotely by using a connection string, create Data Pump files on the client file system.

  Correct Answer: ABC

• Question 84:

  In your database, archive logging and control file autobackup are enabled.

  The data files and redo log files are intact but control files are impacted due to media failure.

  In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)

  A. One control file copy is intact so the spfile is changed to refer to only one copy.

  B. One control file copy is intact and damaged control file copies have to be restored to the default location.

  C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually.

  D. All copies of the control file are damaged and the auto backed up control file is used for recovery.

  E. One control file copy is intact and damaged control file copies have to be restored to a non-default location.

  Correct Answer: CD

• Question 85:

  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 file.

  Correct Answer: ADE

• Question 86:

  Examine the details of the uncompressed, non-partitioned heap table CITIES.

  

  Examine the command:

  SQL> ALTER TABLE cities SHRINK SPACE COMPACT;

  What must you do before executing it?

  A. Ensure free space that is approximately equal to the space used by the table should be available.

  B. Ensure there are no pending transactions on the table.

  C. Enable row movement is enabled.

  D. Disable all indexes on the table.

  Correct Answer: C

• Question 87:

  Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged.

  Which command must you execute before starting the recovery of this tablespace?

  A. ALTER TABLESPACE users OFFLINE

  B. STARTUP FORCE NOMOUNT

  C. STARTUP FORCE

  D. SWITCH DATAFILE ALL

  Correct Answer: A

• Question 88:

  Which statement is true regarding the DEFAULT profile?

  A. The values assigned to the resource limits and password parameters in the default profile can be altered.

  B. A different DEFAULT profile can be created before each user in a database.

  C. It can be dropped and recreated.

  D. it must be explicitly assigned to the user.

  Correct Answer: A

• Question 89:

  Your database is running in ARCHIVELOG mode.

  You want to take a consistent whole database backup.

  Which two statements are true in this scenario? (Choose two.)

  A. RMAN backups contain only data files.

  B. The database instance must be shut down to take a user-managed consistent backup.

  C. Consistent RMAN backups can be taken while the database is open.

  D. User-managed backups only contain formatted data blocks.

  E. The database must be in MOUNT state to take consistent RMAN backups.

  Correct Answer: CD

• Question 90:

  Which two services may you see on the My Service Dashboard page? (Choose two.)

  A. Network Cloud Service

  B. User Cloud Service

  C. Compute Cloud Service

  D. Database Cloud Service

  Correct Answer: CD