单项选择题

A. V$LOGB. V$LOGFILEC. DBA_LOG_GROUPSD. V$LOG_HISTORYTh……

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

A. V$LOG
B. V$LOGFILE
C. DBA_LOG_GROUPS
D. V$LOG_HISTORY

<上一题目录下一题>

热门试题

单项选择题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