Free 1Z0-062 Exam Dumps

Question 21

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.
In which three scenarios do you need media recovery? (Choose three.)

A. loss of all the copies of the control file
B. loss of all the inactive online redo log group members
C. loss of a data file that belongs to the active undo tablespace
D. loss of data files that belong to the SYSTEM tablespace
E. logical corruption of data that is caused by a wrong transaction
F. abnormal termination of the database instance

Correct Answer:ACD

Question 22

You install “Oracle Grid Infrastructure for a standalone server” on a host on which the ORCL1 and ORCL2 databases both have their instances running.
Which two statements are true? (Choose two.)

A. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
B. The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.
C. Both ORCL1 and ORCL2 are automatically added to the Oracle Restart configuration.
D. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
E. The crsctl start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the “Oracle Grid Infrastructure for a standalone server” installation is complete.

Correct Answer:AB

Question 23

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? (Choose two.)

A. ALTER TABLE SPLIT PARTITION
B. ALTER TABLE MERGE PARTITION
C. ALTER TABLE TRUNCATE PARTITION
D. ALTER TABLE ADD PARTITION
E. ALTER TABLE DROP PARTITION
F. ALTER TABLE MOVE PARTITION

Correct Answer:CE
Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION
This feature enables global index maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index unusable. Enhancements include faster DROP and TRUNCATE partition operations and the ability to delay index maintenance to off-peak time.
References:

Question 24

You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor? (Choose three.)

A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.
B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
C. It may advise the use of online table redefinition for tables in locally managed tablespaces
D. It will detect and advise about chained rows.
E. It may advise the use of segment shrink for free list managed tables.

Correct Answer:ACD

Question 25

You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file? (Choose two.)

A. It records the usernames and passwords of users when granted the DBA role.
B. It contains the usernames and passwords of users for whom auditing is enabled.
C. Is used by Oracle to authenticate users for remote database administration.
D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
E. It supports the SYSBACKUP, SYSDG, and SYSKM system privilege

Correct Answer:CE