Free 1Z0-063 Exam Dumps

Question 31

- (Exam Topic 2)
Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.

A. 1, 3, 6, 7, 4
B. 2, 1, 6, 4, 7
C. 1, 3, 5, 7, 4
D. 1, 3, 6, 4, 7

Correct Answer:A
The storage selector act as a layer between RMAN, which accesses the database, and the Oracle Secure Backup software, which manages the backup media.
For backups, Oracle Secure Backup stores metadata about RMAN backup pieces in the Oracle Secure Backup catalog.
The Oracle Secure Backup catalog is stored and managed completely separately from the RMAN recovery catalog. Oracle Secure Backup stores each backup piece and corresponding metadata about the piece.
References: https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm

Question 32

- (Exam Topic 2)
You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command: SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?

A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.
C. It executes successfully and continues to store metadata related to the EMPLOYEES table.
D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Correct Answer:C

Question 33

- (Exam Topic 1)
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID). SSL has been configured for the database and OID and the password file has been configured for the database. User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name. Which authentication method will be attempted first?

A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server

Correct Answer:A

Question 34

- (Exam Topic 1)
Which three statements are true about the keystore storage framework for transparent data encryption? (Choose three.)

A. It facilitates and helps to enforce keystore backup requirements.
B. It handles encrypted data without modifying applications.
C. It enables a keystore to be stored only in a file on a file system.
D. It enables separation of duties between the database administrator and the security administrator.
E. It transparently decrypts data for the database users and applications that access this data.
F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Correct Answer:ADF

Question 35

- (Exam Topic 2)
Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

A. Transparent encryption of backups uses an encryption wallet.
B. A database uses the same encryption key for every encrypted backup.
C. A password encryption of backups uses the password while creating and restoring backups.
D. Image copy backups can be created by using password encryption.
E. Encrypted backups can only be written to disk.

Correct Answer:AC