1z0-043章節(jié)練習(xí)(2019.04.25)

Exhibit，View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting？ （）

Exhibit： Using Database Control， you have scheduled a job to shrink the TRANStable residing on the TTtablespace. The job would run at 5：00 p.m. every Friday.When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk. What could have been the reason for this？（）

In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. 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？（）

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？（）