单项选择题
You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）
A. Window
B. Program
C. Job class
D. Window group
相关考题
-
单项选择题
Consider the following configuration： /devices/D1is a member of disk group dgroupA. /devices/D2is a member of disk group dgroupA. /devices/D3is a member of disk group dgroupA. You plan to add a new disk， /devices/D4，to the disk group dgroupA. You execute the following command： SQL> ALTER DISKGROUP dgroupA ADD DISK ’/devices/D*’； Which task would be accomplished by the command？（）
A. The command adds the new disk， D4， to the disk group.
B. The command would result in an error because the is no disk by the name "’/devices/D*’"
C. The command will be ignored because disks starting with "D" are already members of the disk group.
D. The command would result in an error because no wildcard characters can be used in the disk name.
E. The command first detaches all the member disks starting with "D"， and the reattaches them including the new disk. -
单项选择题
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
A. It would return information regarding only the last committed transaction.
B. It would return only the active transactions in all the undo segments in the database.
C. It would return only the committed transactions in all the undo segments in the database.
D. It would return both active and committed transactions in all the undo segments in the database.
E. It would return information regarding the transactions that began and were committed in the last 30 minutes. -
多项选择题
YouareworkingonanOracleDatabase10gdatabase.YouenabledtheFlashbackDatabasefeature.Whichtwostatementsregardingflashbacklogsaretrue？（）
A. Flashback logs are not archived.
B. Flashback logs are maintained in redo log files.
C. Flashback logs are maintained in the Flash Recovery Area.
D. Flashback logs are used to maintain Flashback Database related errors.
E. Flashback logs need to be cleared manually after you disable Flashback Database.
