The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）

单项选择题You executed the following code：   SQL> CERATE TABLE COUNTRY   （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，   COUNTRY_NAME VARCHAR2（20），   CURRENCY_NAME VARCHAR2（20），   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））   ORGANIZATION INDEX；   Which types of tables will be created automatically？（）

A. journal table
B. clustered table
C. mapping table
D. partitioned table

单项选择题Youarecreatingajobclass.Youwantaccesstothedetailedinformationforalltherunsofeachjobintheclassandeveryoperationperformedoneveryjobintheclass.WhichsettingwillyouusefortheLOGGING_LEVELparameter？（）

A. LOGGING_OFF
B. LOGGING_RUNS
C. LOGGING_FULL
D. LOGGING_NULL

单项选择题Youwanttoviewthenameofaprogramassociatedwithajobformakingsomechangestotheprogram.Whichviewwillyouquerytofindthenameoftheprogramassociatedwiththejob？（）

A. DBA_SCHEDULER_JOB_RUN_DETAILS
B. DBA_SCHEDULER_RUNNING_JOBS
C. DBA_SCHEDULER_JOBS
D. DBA_SCHEDULER_JOB_LOG

单项选择题Youwanttopurgejobentriesolderthan5daysfromthejoblog.Youdonotwanttopurgewindowlogentries.Whichcommandwillyouusetoaccomplishthistask？（）

A. EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；
B. EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；
C. EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；
D. EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；

单项选择题Yoursystemperformsheavytransactionprocessingbetween8：00A.M.and5：00P.M.butrunsbatchprocessingandreportsafterthat.Youdecidetocreateaseparateresourceplantogovernresourceallocationforeachtimeperiod.Whichschedulerobjectwillyouusetoswitchautomaticallybetweenthetworesourceplans？（）

A. Window
B. Program
C. Job_Class
D. Window group