考题
能使数据库记录只显示当前记录且能暂停的命令是()。
A、GOTOB、DISPC、USED、CREATE
考题
数据库记录的显示命令有LIST和()。
A、GOTOB、DISPC、USED、CREATE
考题
数据库记录的显示命令是指()、DISP。
A、GOTOB、LISTC、USED、CREATE
考题
能使数据库记录满屏显示而不暂停的命令是()。
A、GOTOB、LISTC、USED、CREATE
考题
Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass:SQLBEGINDBMS_SCHEDULER.CREATE_JOB_CLASS(JOB_CLASS_NAME=’LOW_PRIORITY_CLASS’,RESOURCE_CONSUMER_GROUP=’LOW_GROUP’,LOGGING_LEVEL=DBMS_SCHEDULER.LOGGING_FULL,LOG_HISTORY=1200,COMMENTS=’LOWJOBPRIORITYCLASS’);END;SQL/Whatwillbetheresultoftheabovecommand?()A.Thecommandwillbeexecutedsuccessfully.B.ThecommandwillfailbecauseRESOURCE_CONSUMER_GROUPisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.C.ThecommandwillfailbecauseLOGGING_LEVELisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.D.ThecommandwillfailbecauseLOG_HISTORYisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.E.Thecommandwillfailbecause1200isaninvalidvaluefortheLOG_HISTORYparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.
考题
Youhavecreatedaresourceplan,DAY.Youexecutethefollowingcode:SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE(PLAN=’DAY’,COMMENT=’DEPARTMENTSPLAN’,GROUP_OR_SUBPLAN=’DEPARTMENTS’,CPU_P1=0);END;Then,youissuethefollowingcode:SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE(PLAN=’DAY’,COMMENT=’DEPARTMENTSPLAN’,GROUP_OR_SUBPLAN=’DEVELOPERS’,CPU_P2=100);END;Whatwillbetheimpactofexecutingtheabovecode?()
考题
YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles?()A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’;B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH;C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’;D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’;
考题
Yourapplicationrequiresthatyouprogrammaticallymanipulateanonqueryrecordgroup.Whichthreebuilt-inscanyouuse?()
A.CREATE_GROUPB.ADD_GROUP_NOWC.POPULATE_GROUPD.ADD_GROUP_COLUMNE.CREATE_GROUP_FROM_QUERY
考题
下列四组SQL命令,全部属于数据定义语句的命令是()A.CREATE,DROP,UPDATEB.CREATE,DROP,ALTERC.CREATE,DROP,GRANTD.CREATE,DROP,SELECT
考题
下列哪组SQL命令全部属于数据定义语句的命令?()A.CREATE,DROP,ALTERB.CREATE,DROP,SELECTC.CREATE,DROP,GRANTD.CREATE,DROP,UPDATE