单项选择题
A. Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.
B. Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.
C. Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.
D. Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
单项选择题 You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’2004-08-05:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()
单项选择题 Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m. as follows: SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9:00 a.m. on the same table as follows: SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *ERROR at line 1:ORA-00942: table or view does not exist Client B needs the dropped table and reports the problem to you.With reference to this scenario, which action should you take?()
多项选择题 An RMAN backup job fails, displaying the following error: ORA-19809: limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in the future? ()