NIIT1终极资料.docx
- 文档编号:28918738
- 上传时间:2023-07-20
- 格式:DOCX
- 页数:159
- 大小:125.77KB
NIIT1终极资料.docx
《NIIT1终极资料.docx》由会员分享,可在线阅读,更多相关《NIIT1终极资料.docx(159页珍藏版)》请在冰豆网上搜索。
NIIT1终极资料
1.Whichofthefollowingisnotanapplication(应用程序)software?
________
A)MSVisualStudioB)LinuxC)PhotoShopD)MSOffice
2.Whichofthefollowingisaninputdevice(输入设备)?
______
A)PrinterB)MicrophoneC)SpeakerD)VDU(图像显示部件
)
3.Whichmouseissensitivetopressureandmotion?
_____
A)WirelessB)LightPenMouseC)TouchPadMouseD)TrackballMouse
4.WhichofthefollowingWebBrowerrequiredverylittleharddiskspace?
A)InternetExplorerB)NetscapeNavigatorC)OperaD)Mozilla
5.Whichisadifferencebetweenanalgorithm(算法)andaflowchart(流程图)?
_____
A)Aflowchartisapartofanalgorithm
B)Bothcannotbecompared
C)Algorithmisthegraphicalrepresentationofaflowchart
D)Flowchartisagraphicalrepresentation(图形化表示形式)ofaprogram
6.Convert(转换)isa?
A)NamespaceB)ClassC)Function(函数)D)Escape(逸出)sequence(数组)character
7.Inthestatement(语句),usingSystem,Systemisa?
A)Namespace(命名空间)B)ClassC)ObjectD)Keyword
8.ifanarrayisdeclaredas,int[]arr=newint[5],thetotalnumberofelementsinthearrayis?
A)5B)2C)1D)0
9.whichofthefollowingisanexampleoffunctionoverloading?
A)voidfun()charfun()
B)voidfun()voidfun1()
C)voidfun(int)voidfun(char)
D)voidfun1(int,int)voidfun2(char,char)
10.whichofthefollowingistrueaboutabstract(抽象)classes?
A)Anabstractclassdefinespropertiescommontotheclassesderivedfromit
B)Anabstractclasscanbedeclaredasfinal
C)Abstractclassescannotbeextended
D)Classesdeclaredusingtheabstractkeywordcanbeinstantiated
11.IdentifytheSQLstatement,whichwillretrieve(使恢复)alistofEmployeesfrom
thetableEmployeeswiththecolumnheadingforemp_idasEmployeeIdentityNumber.
A)SELECTDISTINCTemp_id(EmployeeIdentityNumber)fromEmployees
B)SELECTemp_idLIKEEmployeeIdentityNumberfromEmployees
C)SELECTemp_idAS[EmployeeIdentityNumber]fromEmployees
D)SELECTemp_id=EmployeeIdentityNumberfromEmployees
12.WhichofthefollowingpropertiesdoesatransactionNOTposses?
A)AtomicityB)Consistency
C)IsolationD)Separation
13.Whichdatabase(数据库)objectwillyoucreatetoenforce(实施)businessrule?
A)StoredProcedures(存储程序)B)Views(视图)
C)TriggersD)Indexes(索引)
14.Whichdatefunctionwouldyouusetoextract(引出)aspecified(指定的)part,suchasday,month,oryearfromthespecifieddate?
A)DATEPARTB)DATEADD
C)DATEDIFFD)DATENAME
15.Inwhichsituationyoumustcreateaclusteredindex?
A)Databaseusesdecisionsupportsystem
B)Columnstoressequentialdata
C)Querycoversallthecolumnsinatable
D)QuerycontainsaWHEREclause
16.WhichofthefollowingisnotaDBMS?
_____
A)OracleB)LinuxC)MicrosoftSQLServerD)Sybase
17.”ColumnPriceshouldbegreaterthan$1000andlowerthan$2000”.Thiskindofconstraintbelongsto_________functionofDBMS.
A)restoreB)synchronousC)securityD)integrityconstraint
18.WhatistherightresultafterexecutionofSQLstatements“Selectdateadd(dd,12,'2010-12-10')”?
____
A)2010-12-22B)2011-12-10C)2022-12-12D)2011-6-10
19.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)UpdateTrigger
C)DeleteTriggerD)BeforeTrigger
23.The?
complierisusedforC#
A)ccB)cscC)c++D)csn
24.intNumber1=0;
intNumber2=0;
int[]Array1=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.WhichofthefollowingcomponentsofSQLServer2005isusedtocopyanddistribute(区分)dataanddatabaseobjectsfromonedatabaseservertoanother?
A)ReplicationB)Servicebroker
C)Full-textsearchD)Notificationservices
二、阅读程序写结果(每小题5分,共10分)
1.
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
namespaceMultiArray
{
classMultiArryExample
{staticvoidMain(string[]args)
{intn=0;
intsum=0;
introwsum;
int[,]mArray=newint[2,4]{{1,2,3,4},{5,6,7,8}};
for(introw=0;row<2;row++)
{rowsum=0;
for(intcol=0;col<4;col++)
{if(mArray[row,col]>0)n++;
Console.Write("{0}\t",mArray[row,col]);
rowsum=rowsum+mArray[row,col];
}
sum=sum+rowsum;
Console.Write("={0}",rowsum);
Console.WriteLine();
}
Console.WriteLine("n={0}",n);
Console.WriteLine("sum={0}",sum);
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;
}
}
classFactorial1
{
staticvoidMain(string[]args)
{longFac1;
boolok;
longNumber;
Console.WriteLine("EntertheNumberforcalculatingfactorial(1-20):
");
Number=long.Parse(Console.ReadLine());
ok=;//functioncall
if(ok)
Console.WriteLine("Factorial("+Number+")="+Fac1);
else
Console.WriteLine("Incorrectvalue");
Console.ReadLine();
}
}
2.
/*Thefunctionoffollowingprogramisthatcheckapalindrome(回文)characterarray*/
usingSystem;
namespaceManipulateArray
{
classpalindrome
{
staticvoidMain(string[]args)
{
char[]str=newchar[10];
Console.WriteLine(“EnteraPalindromestring(Max10char):
”);
;
//CallingtheCheckPalidromemethod
Console.WriteLine(CheckPalindrome(str));
Console.ReadLine();
}
privatestaticboolCheckPalindrome(char[]myString)
{
intstartChar;
intlastChar;
;
;
while(startChar { if(myString[startChar]==myString[lastChar]) { ; ; } else { returnfalse; } } returntrue; } } } 四、画流程图(6分) Drawaflowcharttoacceptthreenumbersanddisplaythelargestnumber. Drawaflowcharttodisplaytheaverageoffirsttenoddnumbers. 五、编程题(14分) Pleasedevelopaprogramusingtheabstractclasses,YouhastoCreateaDraw()functionintheprogram,todisplaythefollowingstatements. It’saPoint. It’saLine. It’saCircle. usingSystem; namespaceDrawShapes { publicabstractclassDrawingObject { publicabstractvoidDraw(); } publicclassLine: DrawingObject { publicoverridevoidDraw() { Console.WriteLine("It’saLine."); } } publicclassCircle: DrawingObject { publicoverridevoidDraw() { Console.WriteLine("It’saCircle."); } } publicclassSquare: DrawingObject { publicoverridevoidDraw() { Console.WriteLine("It’saSquare."); } } publicclassDrawDemo { publicstaticintMain(string[]args) { DrawingObject[]dObj=newDrawingObject[3]; dObj[0]=newLine(); dObj[1]=newCircle(); dObj[2]=newSquare(); foreach(DrawingObjectdrawObjindObj) { drawObj.Draw(); } Console.ReadLine(); return0; } } } 2. PhilipAndersonisasoftwaredeveloperwhoworksforMegaTechnologies.Heiscurrentlyundertheprojectofgeometriccalculations.Philiphastodevelopaprogram,whichperformsthefollowingtasks: 1.Calculatetheareaofcircle. 2.Calculatethevolumeofthecube Hehastodevelopthecodeusinganinterface. usingSystem; namespaceCalculateArea { interfaceArea { voidcalcArea(doubleRadius); } interfacevolume { voidcalc1(intSide); } publicclassCircleCube: Area { publicvoidcalcArea(doubleRadius) { doublePie=3.14; doubleResult; Result=Pie*Radius*Radius; Console.WriteLine("TheAreaofacircleis: {0}",Result); } publicvoidcalcVolume(intSide) { intResult; Result=Side*Side*Side; Console.WriteLine("TheVolumeofacubeis: {0}",Result); } } classclass1 { publicstaticvoidMain(string[]args) { CircleCubeobj=newCircleCube(); doubleRadius; intSide; Console.WriteLine("Entertheradiusofthecircle"); Radius=Convert.ToDouble(Console.ReadLine()); obj.calcArea(Radius); Console.WriteLine("Enterthesideofthecube"); Side=Convert.ToInt32(Console.ReadLine()); obj.calcVolume(Side); Console.ReadLine(); } } } 六、E/R图绘制及与关系模式的转换(10分) Acompanyhasanumberofemployees.TheattributesofEmployeeincludeemployeeID,name,address,andbirthdate.Thecompanyalsohasseveralprojects.AttributesofProjectincludeprojectNameandstartDate.Eachemployeemaybeassignedtooneormoreprojects,ormaynotbeassignedtoaproject.Aprojectmayhaveanynumberofemployeesassigned.Anemployee’sbillingratemayvarybyproject,andthecompanywishestorecordtheapplicablebillingrate(Billing_Rate)foreachemployeewh
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- NIIT1 终极 资料
![提示](https://static.bdocx.com/images/bang_tan.gif)