单项选择题

YouarecreatingtheDEPT_SALdatablockfromthePAYHISTform.UsersshouldbeabletoenteravaliddepartmentIDnumber,whichwillthendisplaytheemployeesalaryinformationforthatdepartment.Thisdatablockcouldpotentiallyretrievealargenumberofrecords.Sinceuserswillprobablyonlyviewasmallnumberoftheserecords,only10recordsshouldbefetchedatonetime.Howwouldyoucreatethedatablock?（）
A.SelectTheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,entertheprocedurenameintheQueryDataSourceColumnsproperty,andtheprocedurecodeintheQueryDataSourceArgumentsproperty.
B.ChooseTools->DataBlockWizard,selectTableasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.
C.ChooseTools->DataBlockWizard,select,Viewasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.
D.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,altertheQueryDataSourceTypepropertyto‘FROMclausequery‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.
E.SelecttheDataBlocknodeintheObjectNavigatorandclicktheCreatebutton.AltertheQueryDataSourceType,QueryDataSourceName,QueryDataSourcesColumns,andQueryDataSourceArgumentspropertiestocreateastoredprocedurethatusesaredcursor.

A.UsersshouldbeabletoenteravaliddepartmentIDnumber,whichwillthendisplaytheemployeesalaryinformationforthatdepartment.Thisdatablockcouldpotentiallyretrievealargenumberofrecords.Sinceuserswillprobablyonlyviewasmallnumberoftheserecords,only10recordsshouldbefetchedatonetime.Howwouldyoucreatethedatablock?（）
A.SelectTheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,entertheprocedurenameintheQueryDataSourceColumnsproperty,andtheprocedurecodeintheQueryDataSourceArgumentsproperty.
B.ChooseTools->DataBlockWizard,selectTableasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.
C.ChooseTools->DataBlockWizard,select,Viewasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.
D.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,altertheQueryDataSourceTypepropertyto‘FROMclausequery‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.
E.SelecttheDataBlocknodeintheObjectNavigatorandclicktheCreatebutton.AltertheQueryDataSourceType,QueryDataSourceName,QueryDataSourcesColumns,andQueryDataSourceArgumentspropertiestocreateastoredprocedurethatusesaredcursor.

<上一题目录下一题>

热门试题

单项选择题

Youexecutethefollowingsetofcommandstocreateadatabaseuserandtograntthesystemprivilegesinyourproductionenvironment.SQL>CREATEUSERuser01IDENTIFIEDBYoracleDEFAULTTABLESPACEtbs1TEMPORARYTABLESPACEtempPROFILEdefault SQL>GRANTcreatesession，createtableTOuser01；Whileexecutingthecommandtocreateatable，theusergetsthefollowingerrormessageandtheCREATETABLE..commandfails.ERRORatline1：ORA-01950：noprivilegesontablespaceWhatcouldbethepossiblereasonforthiserrormessage？（）

A.
B..commandfails.

单项选择题

You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.C: ＞ mysqld – install Mysql56 – defaults – file = C : my –opts.cnf What is the expected outcome?（）A.Mysql is installed as the Windows service name Mysql56, and uses c: my-opts.cnf as the configuration fileB.An error message is issued because – install is not a valid option for mysqldC.A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: my-opts.cnfD.Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: my-opts.cnf configuration file

A.C:
B.cnf
C.Mysql
D.cnf
E.An
F.A
G.6
H.cnf
I.Mysqld
J.6
K.cnf