11gocmu 試験問題を無料オンラインアクセス

Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.
The steps to recover the damaged data files are follows:
1.Mount the database
2.Open the database
3.Recover the data file
4.Restore the data file
5.Make the data file offline
6.Make the data file online
Which option identifies the correct sequence that you must use to recover the data files?

• A.2, 5, 4, 3, 6
• B.1, 5, 4, 3, 6, 2
• C.2, 4, 3
• D.5, 2, 4, 3, 6
• E.1, 4, 3, 2

View the Exhibit and examine the output.
You execute the following RMAN command to perform the backup operation:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8;
BACKUP DATABASE FILESPERSET 4;
}
What is the multiplexing level in the preceding backup process?

• A.4
• B.0
• C.7
• D.8

You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.
How would you accomplish this task?

• A.Implement Database Resource Manager
• B.Set metric threshold
• C.Enable resumable timeout for user sessions
• D.Add directives to Automatic Database Diagnostic Monitor (ADDM)

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database? (Choose Two)

• A.Performing complete recovery using all available backups
• B.Copying the online redo log files from the target database to the duplicate database
• C.Generating a new, unique DBID for the duplicate database
• D.Restoring the target data files to the duplicate database
• E.Creating the control file for the duplicate database

The user SYS creates a job by using the following command:

Which two statements are true about the job that was created by the preceding command? (Choose two.)

• A.The job is enabled by default after creation
• B.The globalization environment that exists at the time of the job creation prevails at the job runs
• C.The job executes with the privileges of the user SYS
• D.The job is automatically dropped after the end date