Exam1pass 000-917 exam braindumps free download

IT certification exam demo free download

Exam

Title::IBM000-917SystemAdministrationfor

IBMInformixDynamic

ServerV10

Version:Demo

1.Adbspacewasrecentlyaddedtoadatabaseserver.Whichofthefollowingcommandswillhelpidentify

IT certification exam demo free download

whetherdisklayoutproblemsexistasaresultofaddingthedbspace?

A.onstat-giob

B.onstat-giov

C.onstat-giof

D.onstat-gglo

Answer:C

2.Thefollowingerrormessageappearsinthedatabaseservermessagelog:

09:28:43AbortingLongTransaction:tx0xa43c728username:sallyruid:200

Thistransactionhasrolledback.Whichofthefollowingbestdescribesthesituationintheerrormessage?

A.Atransactionhasspannedmultiplelogical-logfilesandhascausedthelogical-logfilestofillto100%full.

B.Atransactionhascausedthephysical-logfiletofilltothepercentageindicatedbytheLTXHWMconfigurationparameter.

C.Atransactionhascausedasinglelogical-logfiletofilltothepercentageindicatedbytheLTXHWMconfigurationparameter.

D.Atransactionstartingintheoldestlogisopen,andthepercentageoflogical-logfilesfilledhaspassedtheLTXHWMconfigurationparameter.

Answer:D

3.Giventhefollowinginformationcollectedbythe'onstat-d'

command:

Whattypeofdbspaceisthe'temp_space2'dbspace?

A.Blobdbspace

B.Normaldbspace

C.Mirroreddbspace

D.Temporarydbspace

Answer:B

IT certification exam demo free download

4.ADatabaseAdministratorisconfiguringthefilestoestablishnetworkconnectionsonaUNIXsystem,whichusesasocketsinterfaceandaTCP/IPprotocol.

TheDBSERVERNAMEconfigurationparameterhasbeensetto'dbserver1'andthenameoftheUNIXhostmachineis'chicago1'.Theservicenameusedis'sqlexec'.

Whichofthefollowingentriesinthesqlhostsfileshouldbeused?

A.chicago1sqlexecdbserver1onsoctcp

B.chicago1onsoctcpdbserver1sqlexec

C.dbserver1onsoctcpsqlexecchicago1

D.dbserver1onsoctcpchicago1sqlexec

Answer:D

5.Adatabaseserverhasbeenrunningfordaysbutaftermonthlyreportswererun,thefollowingmessageappearedintheonline.log:

12:25:01Memoryallocationerror

Whichofthefollowingmostlikelycausedtheerror?

A.TheDS_TOTAL_MEMORYhasbeenreached.

B.Theswapspaceonthecomputerhasbeensettoohigh.

C.Anoperatingsystemlimitonsharedmemoryhasbeenreached.

D.TheBUFFERSandSHMVIRTSIZEconfigurationparametersarelargerthanthemaximumsegmentsizeallowed.

Answer:C

6.Imageswithanaveragesizeof50bytesaretobestoredaslargeobjectsinthedatabase.Foradatabaseserverthatusesa4KBpagesize,whichofthefollowingmethodsshouldbeusedtostorethelargeobjectsandutilizediskspacemostefficiently?

A.Createanormaldbspacetostorethelargeobjects.

B.Createablobspacewitha2KBblobpagesizetostorethelargeobjects.

C.Createablobspacewithan8KBblobpagesizetostorethelargeobjects.

D.Createablobspacewitha16KBblobpagesizetostorethelargeobjects.

IT certification exam demo free download

Answer:A

7.ADatabaseAdministratorneedstoknowthephysicallocationofatable.Whichofthefollowingcommandswouldshowthisinformation?

A.oncheck-pe

B.oncheck-pr

C.oncheck-pR

D.oncheck-pp

Answer:A

8.Tospecifywhichconfigurationfiletouse,theONCONFIGenvironmentvariablemustbesettothe:

http://www.77cn.com.cnoftheconfigurationfiletouse.

B.pathoftheconfigurationfiletouse.

C.pathandnameoftheconfigurationfiletouse.

D.$INFORMIXDIR/etcdirectorywheretheconfigurationfilewillbelocated.

Answer:A

9.WhichofthefollowingbestdescribesexternalbackupsontheIBMInformixDynamicServer?

A.Anexternalbackupallowsbackupsusingonbarorontape;databasetransactionsareactiveduringexternalbackups.

B.Anexternalbackupallowsbackupsusingonbarorontape;databasetransactionsaresuspendedduringexternalbackups.

C.Anexternalbackupallowsbackupsusingoperatingsystemorthird-partyutilities;transactionsareactiveduringexternalbackups.

D.Anexternalbackupallowsbackupsusingoperatingsystemorthird-partyutilities;transactionsaresuspendedduringexternalbackups.

Answer:D

10.Followingareoutputsof'onstat-k'and'onstat-u'command:

IT certification exam demo free download

Usersarereportingthattheycannotaccessatablebecausetheyaregettingerrorsindicatingthatthetableislocked.TheLockaddress'a155380'isholdingalockonthetable.Whatisthesessionidforlockaddress'a155380'?

A.34

B.36

C.38

D.40

Answer:D

11.Adatabaseserverisexperiencingslowqueryresponsetimes.Operatingsystemutilitiesshowthatall6CPUsareataround50%utilization.Therearecurrently4CPUVPsconfiguredonthedatabaseserver.Ofthefollowing,whichisthemostprobablechangethatcouldbemadetocorrectthisproblem?

A.AddmoreAIOVPs.

B.AddmoreCPUVPs.

C.TurnonProcessorAffinity.

D.Addmorephysicalprocessorstothemachine.

Answer:B

12.Queryingthesysmasterdatabasetablesysdatabasesreturnsarowwithavalueof1foris_loggingand

IT certification exam demo free download

avalueof0foris_buff_logandis_ansi;Whatisthecurrentlogstatusofthedatabase?

A.ANSI

B.Notlogged

C.Bufferedlogging

D.Unbufferedlogging

Answer:D

13.Inwhichofthefollowingsituationsisacheckpointrequested?

A.Whenthelogicallogsarefilled

B.Whenthephysicallogfileis75%full

C.Whenabuffered-loggingdatabaseiscreated

D.WhenthevalueoftheLTXHWMconfigurationparameterispassed

Answer:B

14.ADatabaseAdministratorisconfiguringtheNETTYPEconfigurationparametertosetthenumberofpollthreadsforsharedmemoryconnections.Theadministratorwouldliketoallow100users,2pollthreads,andrunthepollthreadsonaCPUVP.Basedontheaboveinformation,theDatabaseAdministratorshouldconfiguretheNETTYPEparameterwithwhichofthefollowingentries?

A.ipcshm,2,50,CPU

B.ipcshm,50,2,NET

C.ipcshm,100,2,CPU

D.ipcshm,2,100,CPU

Answer:A

15.ExternalCfunctionsaretobecreatedandregisteredinthedatabase …… 此处隐藏：5653字，全部文档内容请下载后查看。喜欢就下载吧 ……