1Z0-514 Exam Questions

Which two statements are true regarding the Undo Retention Settings? (Choose two.)

View the exhibit above. Which two statements ore true regarding the status of data file backups after31 days? (Choose two)

You are a Database Administrator in Dolliver Inc. Oracle 11g is installed as the database server in the company. You want to protect data from privileged users through some prevent...

You have a system installed with Oracle 11g. You are concerned about the security of the database instances in your system. You plan to use Oracle Database Vault to create several...

Which of the following components of Oracle Database Vault is a Java application that is built on top of the Oracle Database Vault PL/SQL application programming interfaces (API)?

Which of the following are the advantages of Oracle Database Vault? Each correct answer represents a complete solution. Choose all that apply.

Which method should be adopted to retrieve all those rows whose sensitive columns have a null value and which are restricted by Virtual Private Database security?

Which three statements are true about database storage structures? (Choose three.)

Your database is down. You log in as the user SYS and issue the following command: SQL>STARTUP Which stops occur and in what order as a result of executing this command?

Which two statements ate true regarding the sever parameter file? (Choose two)

Which three options correctly match environment variables with their specific functionalities? (Choose three.)

Which mode of database shutdown requires an instance recovery at the time of the database startup?

You want to use the automatic management of backup and recovery operations feature for your database.Which configuration must you set?

Listed below are the database resident program units and their descriptions in random order. 1. Package 2. Procedure 3. Function 4. Trigger

You create an index, EMP_IDX, on the ENAME column in the EMP table. Identify the three operations in which FMP_IDX would be used? (Choose three.)

Which two statements are true regarding the usage of integrity constraints? (Choose two.)

Which method can you use to receive a notification when the free disk space in the recovery area falls below 10%?

Which two statements arc true regarding object privileges? (Choose two.)

Which two statements are true regarding SQL*Plus? (Choose two.)

Which two statements are true regarding views? (Choose two)

In your database, the SQL Tuning Advisor is running automatically during the system maintenancewindow as a maintenance task. Which of its recommendations would be implemented autom...

Your test database is currently running in the ARCHIVELOG mode and you plan to switch to the NOARCHIVELOG mode temporarily. Which type of backup should you perform before switching...

Which statement is true regarding undo tablespace?

Which statement is true regarding Automatic Memory Management?

Which two options describe the features of simple views? (Choose two.)

View the Exhibit. Which actions would be performed and in what sequence by clicking the Startup button? 1) Control file is read. 2) Memory is allocated. 3) Background processes are...