1/1NIIT1終極資料-小學教育

1．Whichofthefollowingisnotanapplication(應用程序)software?________A)MSVisualStudioB)LinuxC)PhotoShopD)MSOffice2．Whichofthefollowingisaninputdevice(輸入設(shè)備)?______

A)PrinterB)MicrophoneC)SpeakerD)VDU(圖像顯示部件)

3．Whichmouseissensitivetopressureandmotion?_____

A)WirelessB)LightPenMouseC)TouchPadMouseD)TrackballMouse4．WhichofthefollowingWebBrowerrequiredverylittleharddiskspace?A)InternetExplorerB)NetscapeNavigatorC)OperaD)Mozilla

5．Whichisadifferencebetweenanalgorithm(算法)andaflowchart(流程圖)?_____A)AflowchartisapartofanalgorithmB)Bothcannotbecompared

C)Algorithmisthegraphicalrepresentationofaflowchart

D)Flowchartisagraphicalrepresentation(圖形化表示形式)ofaprogram6．Convert(轉(zhuǎn)換)isa?

A)NamespaceB)ClassC)Function(函數(shù))D)Escape(逸出)sequence（數(shù)組）character

7．Inthestatement（語句）,usingSystem,Systemisa?

A)Namespace(命名空間)B)ClassC)ObjectD)Keyword

8．ifanarrayisdeclaredas,intarr=newint[5],thetotalnumberofelementsinthearrayis?

A)5B)2C)1D)0

9．whichofthefollowingisanexampleoffunctionoverloading?A)voidfuncharfunB)voidfunvoidfun1C)voidfun(int)voidfun(char)

D)voidfun1(int,int)voidfun2(char,char)

10．whichofthefollowingistrueaboutabstract（抽象）classes?A)AnabstractclassdefinespropertiescommontotheclassesderivedfromitB)AnabstractclasscanbedeclaredasfinalC)Abstractclassescannotbeextended

D)Classesdeclaredusingtheabstractkeywordcanbeinstantiated

11．IdentifytheSQLstatement,whichwillretrieve（使恢復）alistofEmployeesfrom

thetableEmployeeswiththecolumnheadingforemp_idasEmployeeIdentityNumber.A)SELECTDISTINCTemp_id(EmployeeIdentityNumber)fromEmployeesB)SELECTemp_idLIKEEmployeeIdentityNumberfromEmployeesC)SELECTemp_idAS[EmployeeIdentityNumber]fromEmployeesD)SELECTemp_id=EmployeeIdentityNumberfromEmployees

12．WhichofthefollowingpropertiesdoesatransactionNOTposses?A)AtomicityB)ConsistencyC)IsolationD)Separation

13．Whichdatabase（數(shù)據(jù)庫）objectwillyoucreatetoenforce（實施）businessrule?

A)StoredProcedures（存儲程序）B)Views（視圖）C)TriggersD)Indexes（索引）

14．Whichdatefunctionwouldyouusetoextract(引出)aspecified（指定的）part,suchasday,month,oryearfromthespecifieddate?A)DATEPARTB)DATEADDC)DATEDIFFD)DATENAME

15．Inwhichsituationyoumustcreateaclusteredindex?A)DatabaseusesdecisionsupportsystemB)Columnstoressequentialdata

C)QuerycoversallthecolumnsinatableD)QuerycontainsaWHEREclause

16．WhichofthefollowingisnotaDBMS?_____

A)OracleB)LinuxC)MicrosoftSQLServerD)Sybase

17．”ColumnPriceshouldbegreaterthan$1000andlowerthan$2000”.Thiskindofconstraintbelongsto_________functionofDBMS.

A)restoreB)synchronousC)securityD)integrityconstraint18．WhatistherightresultafterexecutionofSQLstatements“Selectdateadd(dd,12,'2023-12-10')”?____

A)2023-12-22B)2023-12-10C)2023-12-12D)2023-6-1019．WhichofthefollowingSQLstatementscanbeusedtocreatenewdatabaseobjects?____

A)DDLB)DMLC)DCLD)DQL

20．Whichofthefollowingoperatorsisusedtodisplayasetofrecords（記錄）thatcontainvalueswithinarangeinacolumn（列）?______

A)ORB)>=C)BETWEEN..ANDD)%

21．Whichofthefollowingwildcard（字符）representsasinglecharacter?_____A)%B)_C)[]D)[^]

22．Whichofthefollowingisnotavalidtypeoftrigger?______A)InsertTriggerB)UpdateTriggerC)DeleteTriggerD)BeforeTrigger23.The?complierisusedforC#

A)ccB)cscC)c++D)csn24.intNumber1=0;intNumber2=0;

intArray1=newint{2,3,4,5,6,7,8,9,10,11};foreach(intCtrinArray1){if(Ctr%2==1)

Number1++;else

{Number2++;

Console.Write(Ctr);}}

Whatistheoutputofthecode?

A)357911B)246810C)CtrD)234567891011

25.Whichofthefollowinglocksenableotherstoviewthedatabeingmodified（修改的）bythecurrenttransaction?A)sharedlockB)exclusivelockC)updatelockD)intentlock

26.WhichofthefollowingcomponentsofSQLServer2023isusedtocopyanddistribute（區(qū)分）dataanddatabaseobjectsfromonedatabaseservertoanother?A)ReplicationB)ServicebrokerC)Full-textsearchD)Notificationservices

二、閱讀程序?qū)懡Y(jié)果（每小題5分，共10分）1.

usingSystem;

usingSystem.Collections.Generic;usingSystem.Text;namespaceMultiArray{

classMultiArryExample

{staticvoidMain(stringargs){intn=0;intsum=0;introwsum;

int[,]mArray=newint[2,4]{{1,2,3,4},{5,6,7,8}};for(introw=0;row0)n++;

Console.Write(\rowsum=rowsum+mArray[row,col];}

sum=sum+rowsum;

Console.Write(\Console.WriteLine;}

Console.WriteLine(\

Console.WriteLine(\Console.ReadLine;}}}2.

usingSystem;publicclassA

{

publicvirtualvoidFun1(inti){

Console.WriteLine(i);}

publicvoidFun2(Aa){

a.Fun1(1);Fun1(5);}}

publicclassB:A{

publicoverridevoidFun1(inti){

base.Fun1(i+1);}

publicstaticvoidMain{

Bb=newB;Aa=newA;a.Fun2(b);b.Fun2(a);

Console.ReadLine;}}

//b.Fun1(1);2//Fun1(5);5//a.Fun1(1)1

//Fun1(5)->base.Fun1(5+1)6

三、程序填空（每空2分，共10分）

/*ThefunctionoffollowingprogramisthatCalculatethefactorialofthenumberenteredbyauser.(Thelimitofusersinputshouldbe1-20)*/usingSystem;classFactorial{

staticlongFac1;

publicstaticboolFac(longn,outlonganswer){

longk;

boolok=true;

if()//userinputshouldbe1-20{ok=false;}else

{

;for(k=2;k<=n;++k){

;}}

;returnok