Q1. Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

A. Failure when no standby database is configured

B. Failure because a data file is renamed accidentally

C. Failure that requires no archive logs to be applied for recovery

D. Failure due to loss of connectivity-for example, an unplugged disk cable

View Answer

Q2. View the Exhibit to examine the details for an incident.

Which statement is true regarding the status of the incident?

A. The DBA is working on the incident and prefers that the incident be kept in the ADR

B. The incident is now in the Done state and the ADR can select the incident to be purged

C. The incident has been newly created and is in the process of collecting diagnostic information

D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

View Answer

Q3. Note the following points describing various utilities in Oracle Database 11g:

Which point describes the Oracle Data Pump utility?

1. It enables the transfer of data from one database to another

2. It provides a complete solution for the backup, restoration and recovery needs of the entire database

3. It enables the loading of data from an external file into tables of an Oracle Database

4. It provides a tape backup management for the Oracle ecosystem

A. 1

B. 2

C. 3

D. 4

E. 1 and 3

F. 1, 2, 3 and 4

View Answer

Q4. You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

A. Lock statistics for the tables.

B. Change STALE_PERCENT to zero for the tables.

C. Set the TIMED_STATISTICS parameter to TRUE.

D. Set the STATISTICS_LEVEL parameter to BASIC.

E. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

View Answer

Q5. View the Exhibit to examine the output for the CROSSCHECK BACKUP command.

Which statement is true about the output of the command?

A. The backup piece is expired as the new backup is available

B. The backup piece is expired because the operating-system file was not found

C. The backup piece is expired because the retention period for the backup has expired

D. The backup piece is expired because the backup set to which it belongs is not complete

View Answer

Q6. You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.

Which action would help to use the previous set of statistics on the objects?

A. Restore statistics from statistics history.

B. Reduce the optimizer statistics retention period by 2 days.

C. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.

D. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.

View Answer

Q7. You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode.

Which two options do you have for performing user-managed backups? (Choose two.)

A. You can perform consistent backups only.

B. You can perform a complete database backup without shutting down the database instance.

C. You can back up data files only when all data files have the same SCN recorded in the control file.

D. You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.

View Answer

Q8. You have executed this command to change the size of the database buffer cache:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;

System altered.

To verify the change in size, you executed this command:

Why is the value set to 4194304 and not to 2516582?

A. Because 4194304 is the granule size

B. Because 4194304 is the standard block size

C. Because 4194304 is the largest nonstandard block size defined in the database

D. Because 4194304 is the total size of data already available in the database buffer cache

View Answer

Q9. A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?

A. Set REMOTE_OS_ROLES to FALSE

B. Set OS_ROLES parameter to FALSE

C. Set the REMOTE_OS_AUTHENT parameter to FALSE

D. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE

View Answer

Q10. You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information. The employees submit the expense reports to the accounts payable department. A user of the accounts payable database wants to extract the employee information from the database in the SEMP server for crossverification.

Which schema object enables the user to access the information from the remote database?

A. Cluster

B. Database link

C. Mapping table

D. Materialized view

View Answer