A. use DBMS_IJOB package
B. use Oracle Scheduler
C. use DBMS_JOB package
D. use Oracle Data Pump Export and Import
您可能感兴趣的试卷
你可能感兴趣的试题
A. The database allows only queries; no other statements are allowed.
B. The database re-creates the missing redo log files automatically.
C. The database continues to function normally with the existing files.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.
A. the RMAN LIST command
B. the DBNEWID utility
C. the RMAN REPORT command
D. the RMAN BLOCKRECOVER command
E. the RMAN CROSSCHECK command
F. the ANALYZE command
A. use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
B. restore the entire database from the most recent backup and open it
C. recover the table by using the Flashback Table feature
D. perform point-in-time recovery to recover the table
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file:
1.RESTORE CONTROLFILE;
2.RESTORE DATABASE;
3.ALTER DATABASE MOUNT;
4.SQL ALTER TABLESPACE temp ADD TEMPFILE
5.ALTER DATABASE OPEN RESETLOGS;
6.RECOVER DATABASE;
7.STARTUP NOMOUNT;
In what sequence would you use this process to perform the recovery?()
A. 2, 7, 3, 5, 1, 6, 4
B. 2, 1, 7, 6, 3, 5, 4
C. 7, 1, 3, 2, 6, 5, 4
D. 7, 2, 3, 1, 4, 6, 5
A. The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.
B. Before the instance starts, you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens because two redo log groups still exist.
E. The instance starts and the database opens, but every attempt to write to redo log files fails with an error.
A. until Thursday morning
B. until that point in time when the database is opened
C. until that point in time when the recovery is performed
D. until last Sunday’s backup
E. until that point in time when the table is dropped and purged
F. until Wednesday evening
A. streams pool
B. shared pool
C. log buffer
D. keep buffer cache
E. recycle buffer cache
A. You need to mention it with every BACKUP command.
B. The block change tracking feature is used automatically by RMAN.
C. You need to configure it using the CONFIGURE command.
D. You need to set the necessary initialization parameters to direct RMAN to use the feature.
A. The member jobs would get dropped when the job class is dropped.
B. Both the jobs would be executed concurrently.
C. The member jobs would get disabled when the job class is dropped.
D. The attributes defined at the class level would be applied to both the jobs.
E. Jobs in the job class must have been assigned the same priority.
A. DB_4K_CACHE_SIZE only
B. DB_8K_CACHE_SIZE only
C. DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
D. DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
E. SGA_TARGET and DB_4K_CACHE_SIZE
F. DB_CACHE_SIZE only
最新试题
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()
In which case would you use the Flashback Database feature to perform a recovery?()
You lost the PRODSTD tablespace, which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace?()
View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database?()
You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()
You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’20040805:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()
You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()