单项选择题

A. journal tableB. clustered tableC. mapping tableD. pa……

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

单项选择题You executed the following code： BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE （ NAME => ’JOB_A’， ATTRIBUTE => ’JOB_PRIORITY’， VALUE => 7）； END； After analyzing the above code， what conclusion will you draw？（）

A. The code will be executed successfully.
B. The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.
C. The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
D. The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.