Oracle 1Z0-053 Actual Free Exam Questions & Community Discussion

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

You can back up the RMAN recovery catalog with RMAN.

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?

What command would you issue to enable automated backups of control files?

Which of these represent the main components of Database Resource Manager? (Choose all that apply.)

You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)

You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:
LOG_ARCHIVE_DEST 1 = 'LOCATION=/disk1/arch MANDATORY' LOG _ARCHIEVE_DEST 2 = 'LOCATION=/disk2/arch' LOG_ARCHIVK_DEST_3 = 'LOCATION=/diSk3/arch LOG_ARCH1VK_DEST_4 = 'LOCATION=/disk4/arch' LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.
What happens in an event of log switch?

Which two statements regarding a SQL profile are true? (Choose two.)

Which RMAN backup command is used to create the block-change tracking file?

You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?

When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?

Which setting enables the baselines by default in Oracle Database 11g?

A user named Arren is executing this query:
select table_name, operation, undo_sql
from flashback_transaction_query t, (select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123) e where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem.
Which of the following SQL statements will correct this problem?

In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)

Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)