The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP – INTERVAL ‘6’ MINUTE) WHERE ename = ‘ALLEN’; What are the minimum requirements for the statement to…
Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the…
The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the…
In which two situations would you rebuild an index using the ALTER INDEX—– REBUILD command? A. to change a unique index into a non-unique index B. to change index storage options C. to enable index monitoring D. to move the…
You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by…
Which two statements are true about a job chain? (Choose two.) A. A job chain can contain a nested chain of jobs. B. The jobs in a job chain cannot have more than one dependency. C. A job of the…
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up. A. The data file backup is done with multiple channels B. The data files…
Your production database is functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the production database to anther host, SHOST2, for testing new applications.…
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? A. The time when the last flashback operation in your…
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the tablespace in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance…