单项选择题

In which scenario will you create a hash cluster？（）

A. when you want the data to be returned automatically in chronological order
B. if the application uses queries joining tables only occasionally
C. if the queries against the clustered table use the equality operator （=） to retrieve the desired row
D. if the full table scan is executed often on only one of the clustered tables

<上一题目录下一题>

热门试题

单项选择题Theperformanceofyourdatabaseisaffectedbythepresenceoftwologmembersineachonlineredologgroupandtheplacementofredologmembersofagrouponthesamedisk.Youdecidetoplacetheredologmembersofagrouponseparatedisks.Whichviewwillyouquerytofindthenameandlocationofalltheonlineredologmembers？（）

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’）；