Online Access Free 1z1-063 Exam Questions

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ' /dev/f lash_device_1',' /dev/f lash_device_2'
How should the D3_flash_cache_size be configured to use both devices?

• A.db_flash_cache_SI2E is automatically configured by the instance at startup.
• B.Set DB_FLASH_CACHE_SIZE=64G.
• C.Set D3_FLASK_CACKE_SI2E=128G.
• D.Set D3_FLASH_CACHE_SIZE=64G, 64G.

You are administering a database that supports data warehousing workload and is running in NOARCHIVELOG mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in NOMOUNT state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the RESETLOGS option.
10. Recover the database with the NOREDO option.
11. Recover the data file with the NOREDO option.
Identify the required steps in the correct order.

• A.1, 2, 6, 3, 7, 10, 9
• B.1, 3, 7, 10, 9
• C.1, 2, 6, 3, 8, 11, 9
• D.1, 3, 8, 11, 9
• E.4, 8, 11, 5

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1. Determine which backup contains the table that needs to be recovered.
2. Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.
3. Import the Data Pump export dump file into the auxiliary instance.
4. Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.

• A.1, 4, 3, 2
• B.1, 2, 4
• C.1, 4, 3
• D.1, 2

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

• A.It enables separation of duties between the database administrator and the security administrator.
• B.It facilitates and helps to enforce keystore backup requirements.
• C.It enables a keystore to be stored only in a file on a file system.
• D.It handles encrypted data without modifying applications.
• 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.

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

• A.OSB encryption for data in transport and on tape
• B.scheduling of the RMAN backup to occur automatically at user-defined intervals
• C.matching the OS user identity of the Oracle instance associated with the database username
• D.assigned to a class with rights to browse all directories and catalogs
• E.RMAN preauthorization on the host
• F.assigned to a class with rights to back up or restore Oracle database