还剩25页未读，继续阅读
本资源只提供10页预览，全部文档请下载后查看！喜欢就下载吧，查找使用更方便
文本内容:
1.For whatapplications isSybase IQideally suitedChoose3Decision SupportSystemOnline TransactionProcessingDistributed DataMartData WarehouseReal-time UpdateApplications
2.The benefitsof Sybase IQ are:Choose4Fully flexibleschema supportReducesongoing tuningof databasesIncreasesthe needof DBAresources afterinitial installSupportsmulti-server configurationIncreasesI/Os withless CPUand memoryusage
3.For which of the following systemsshould youNOT useSybase IQDataWarehouseDecision SupportSystemDistributed DataMartOnline TransactionProcessing
23.Which of the followingconstraints inCREATE TABLEwillautomatically createa UniqueHG index on a column Choose2Primary KeyForeignKeyUniqueIQ Unique
24.Which of the following does a G-Array pagecontainQuery PlaninformationRow Idsfor all rows containing the samevalueUnique keybit-mapsPrimary keybit-maps
25.Which statementbest describesa regularnon-unique HGindexAB-tree witha bitmaparray foreach distinctvalueA B-tree withaG-Array containingpages ofrow-idsA B-tree withdistinct valuesand row-ids in the LeafpagesA bitmapcontainingthebinary relationshipof eachcolumn
26.You havethree largedata filesto loadinto a table.What isthemost efficientloading methodto useSpecifyall threefiles in the Fromclause,so theyare loadedas asingletransaction.Load theindividual filesand commiteach,so thereare threeseparatetransactions.Drop allHG indexes on the table before loading.Drop allindexesonthe tablebeforeloading.
27.What isthe maximumvalue forthe LOAD_MEMORY_MBdatabase option
50010001500200028.What happensif the IQ TemporaryStore fillsup whenexecutinga LOADTABLE commandSybase IQ suspendsloading untila dbspaceis addedto theIQTemporary Store.The loadfails andno datais loaded.A partialload iscompleted atthe lastfull row,and the LOADTABLE commandexits.The loadrolls backto theend of the lastfull fileloaded,and theLOADTABLE commandexits.The loadrolls backto thelast multipleof theNOTIFY value.
29.Which datafile can be loadedinto Sybase IQ usingthe LOADTABLEcommand Choose2Data fromanother databaseFlatfile withfixed-length fieldsMSWord filePDFfileFlat filewith delimitedfields
30.Which of the followingconditions are required toload datainparallel usingthe LOADTABLE commandChoose2Must specify the WITHCHECKPOINT ONload optionMust specify theROW DELIMITEDBY loadoptionMustspecifythe IGNORECONSTRAINT loadoptionInput data must bevariable lengthInputdatamustbe fixedlength orfully delimited
31.From whichof the followingdoestheLOADTABLE commandloaddataASCII orBinary DataFilesOther SybaseDatabase ServersOtherIQ TablesRemote/Foreign DatabaseServers
32.By default,where doSybase IQquery plansappearIn afile in the databasedirectoryIn theclient program,such asdbisqlIn theIQ messagesfileIn thetransaction log
33.If youexecute the following sequenceof statementsin theordershown,what arethe contentsof theoutfilecreatetable foocoll int;insert intofoo values1;insert intofoovalues2;commit;set temporaryoptionTEM P_EXTRACT_N AMEl=outfilerr;select count*from foo;select*from foo;At thispoint,the contentsof thefile named“outfile are:1,22,L count*2zempty.
34.What typesof selectqueries willuse theWordWD indexChoose2:Queries that use LIKEQueriesthat useGROUP BYQueriesthat usethe CONTAINSquery verbQueriesthatuseBETWEEN
35.With aWD indexon“address”,the statement“select*fromcustomers whereaddresscontains Ave,1255will dowhichof the followingReturnallrows that containeither Aveor1255Return onlyrowsthatcontain bothAve and‘1255’lignore theWD indexand choosethe FPindexFail on a syntaxerror
36.Select threemethods to add userstoaSybase IQserver.Choose3CREATE LOGINGRANTCONNECTspjqaddloginsp_adduserSybase Central
37.Which isthe overallauthority fordatabase managementDBAdboPUBLICsaSYS
38.Which of the followingcan beused toaddusers toan IQserver Choose2grant connectsp_iq_process_loginspjqaddloginspjqmodifyadmin
39.Sybase IQenforces whichANSI IsolationLevel:Level0Level1Level2Level
340.What isTRUE aboutsn叩shot versioningChoose2Allows onereader andmultiple writersper tableAllowsmultiple readersand onewriter pertableAlso referredto astable-level versioningSupportsANSI isolation level
241.Data pagesfor newtable versionscreated bySybase IQare・・stored inthe…IQ MainStore.IQ TemporaryStore.Local IQ Store.Catalog Store.Swap space.
42.Which ANSIisolationleveldoes IQuseLevel0Level1Level2Level
343.In Chainedtransaction mode...Choose2an implicitBEGIN TRANbegins everystatement.an explicitBEGIN TRANneeds tobe specified.a transaction is committedonly whenan explicit COMMIT isexecuted.there isno needto specifyexplicitCOMMITto committhetransaction.
44.Sybase IQsapproach totransaction
4.Which dbspacecontains thesystem tablesand storedprocedures necessarytomanage anIQ databaseCatalog StoreIQ StoreIQ Temporary StoreIQ Message LogIQServer Log
5.What isthe default port forSybase IQ
15212638450050006.Ident讦ythetrue statementsabout clientaccess toSybaseIQ.Choose3ODBC supports all SybaseIQ data typesJDBC supportsall SybaseIQ datatypesOpen ClientsupportsallSybaseIQ data typesIQComponent Integration Services canmap totables onother databaseserversIQ ComponentIntegrationServicesis idealfor joiningIQ tablesto non-IQ proxyprocessing is called:OLAPsnapshot versioningNothing,as transactionprocessingisnotallowedtable levellocking
45.Review the following backupstatement:Backup databaseIncremental to7dev/rmt/0nr Whatcomponentsarebacked upChoose2Full backupof Catalog StoreBacks upchanges ofCatalog Storesince lastfull IQ backup.Backs upchanges toIQ Storesince lastfull IQ backupBacks upchanges toCatalog Storesince lastIQbackupof anytype.Backs upchanges toIQ Storesince lastIQbackupof anytype
46.Which of the followingare TRUEabout theBACKUPcommandThe defaultaction isa fullbackup.The defaultaction isan incrementalsince fullbackup.The defaultaction isan incrementalbackup.The defaultactionisa virtualdecoupled backup.Requires exclusiveaccess bythe DBAto the database.
47.What isNOT avalid typeof databasebackupFullbackupVirtual backupIncrementalbackupCatalog backupIncrementalsince full
48.Which statementsare TRUEIQ Multiplex can have multiplewriter nodes.Reader nodescanhavetheir ownlocal datastore.OS levelraw partitionsarerequiredforMultiplex on multiple hosts.IQMultiplexrequires multiplephysical hoststo start.
49.Which of the followingare TRUEabout IQMultiplexChoose2May haveone or more write servers.May haveoneor morequery servers.Must havea shareddisk subsystemconnectedto allnodes.Must resideonmultiplehosts.
50.Which of the followingstatement isNOT trueofMultiplexMultiplex consistsof oneormoreIQinstances sharinga singleCatalogStore.A multiplexdatabase mayonly have1writeserver.A multiplexdatabase mayhave manyquery servers.A singlenode IQserver canbe upgradedto multiplex.
51.Which ofthe followingrequire query serversynchronization inSybaseIQChoose3creating anew loginaccountcreating anew queryserverexecution ofDDL inthe sharedIQ MainStorerestarting anexcluded queryserverrestoring aqueryserver
52.Which ofthe following is trueof theMINIMIZE_STORAGE databaseoptionIt minimizesstorage bycompressing blanksand nulls.It isequivalent toplacing anIQ UNIQUE255clause oneverynew column.It causesbackups tobe compressed.It improvesthe performanceof loads.
53.Sybase recommendswhat RAIDLevelfor anIQ Installation0+
1234554.Which oneofthe followingisFALSE aboutnetworkconnections inSybase IQJDBCand ODBCare recommendedand support all datatypes.Open Clientdoes notsupportallIQdatatypes.IQ CISand INSERT...LOCATION alluseODBC andJDBC.There aredifferent internalenvironments andsettings forODBCJDBCand OpenClient connections.
55.If auser setstheMINIMIZE_STORAGE optionto ON,then creates a table,andthen loads50,000unique valuesinto avarchar50columnin the table,how manybytes does each row take
1505156.If auser creates atable,then setstheMINIMIZE_STORAGE optionto ON,and thenloads50,000unique valuesinto achar50column inthetable,howmany bytesdoeseachrowtake125051used todisplay detailedinformation aboutthe currentdatabase,including thepercentages ofspace usedintheIQStore andIQ TemporaryStoresp_iqstatussp_iqviewsp_iqcheckdbsp_iqestdbspaces
58.How doyou auditSQL commandsissued toyourdatabaseCreate aSQL capturelog withthetables
7.Which IQcomponent canbe builtonaraw deviceChoose2IQ StoreCatalogStoreIQ TemporaryStoreIQ MessageLogCatalog StoreTransaction LogIQServer Logs
8.Identify the defaultportnumber forboth ASAand SybaseIQ:
100026383600400048369.What isthedefaultport forthe utilityserver/database23682836-zo startupparameterRead theIQ MessageLogUse sp_iqstatusUse sp_iqcontext
59.What is used tomonitorbuffer cacheactivityspjqstatusspjqcontextspjqcheckdbIQ UTILITIESIQUNIQUEprocedure willdisplay thenumber of active transactionversionsspjqcheckdbspjqcontextsp_iqstatussp_iqtransaction
2638500010.Which ofthe followingwould betrue aboutthedatabasecreated withthefollowing commandCREATE DATABASE7sybasedb/production.db,IQ PATH7dev/md/rdsk/iqr IQ SIZE500IQ PAGESIZE65536The sizeofthedatabase wouldbe64K.The sizeofthedatabase wouldbe500MB.The sizeofthedatabase wouldbe500K.The sizeofthedatabase wouldbe500GB.
11.Identify theIQTemporaryStore inthefollowing CREATE DATABASE scriptCREATE DATABASE/d:\\SybaseIQ\\megaphone\\megaphone.db,LOG ON/d:\\SybaseIQ\\megaphone\\megaphoneJog,IQ PATHdzWSybaselQWmegaphoneWmegaphone.iq IQSIZE40IQ PAGESIZE65536MESSAGE PATH/d:\\SybaseIQ\\megaphone\\megaphone.iqmsg,TEMPORARYPATH/d:\\SybaseIQ\\megaphone\\megaphoneJqtmp,TEMPORARY SIZE20megaphone.iqmegaphone.iqmsgmegaphone.iqtmp
12.The IQDatabase Devicesare called.Table SpacesdbspacesIndexSpacesPartitions
13.Identify theIQMessageLog inthefollowingCREATE DATABASEscriptCREATE DATABASE^dzWSybaselQWmegaphoneWmegaphone.db LOG ON/d:\\SybaseIQ\\megaphone\\megaphoneJog,IQ PATHdzWSybaselQWmegaphoneWmegaphone.iq IQSIZE40IQ PAGESIZE65536MESSAGE PATH,drWSybaselQWmegaphoneWmegaphone.iqmsg TEMPORARY PATH/d:\\SybaseIQ\\megaphone\\megaphone.iqtmp,TEMPORARY SIZE20megaphone.iqmegaphone.iqmsgmegaphone.iqtmp
14.Identify theCatalogStoreinthefollowingCREATE DATABASEscript.CREATEDATABASE/d:\\SybaseIQ\\megaphone\\megaphone.db,LOGON/d:\\SybaseIQ\\megaphone\\megaphoneJog,IQ PATHdrWSybaselQWmegaphoneWmegaphone.iq^IQSIZE40IQ PAGESIZE65536MESSAGE PATH/d:\\SybaseIQ\\megaphone\\megaphone.iqmsg,TEMPORARYPATH/d:\\SybaseIQ\\megaphone\\megaphone.iqtmpr TEMPORARYSIZE20megaphone.dbmegaphone.logmegaphone.iqmegaphone.iqmsgmegaphone.iqtmp
15.Given thecommand:CREATE DBSPACEmydbspace AS7dev/mdbspace.iqf IQSTORE SIZE2048Which ofthefollowingistrueIt createsa databasenamed mydbspace.It increasestheIQStore by2048MB.The pagesize is
2048.The physicaldevice nameis mydbspace.
16.Which ofthefollowingare trueof localtemporary tablesChoose2The table exists untilit isexplicitly removedThetable existsuntil theconnection endsThetable isaccessible onlyto theconnection thatcreates itThetableexistsintheIQStore
17.Which oneofthefollowing indextypes canbe declaredUniqueLFCMPWDTIME
18.Which indexescanbecreated onacolumndefined asvarchar5OOChoose3FPLFHGCMPWDHNG
19.Every columnnamed inthe WHEREand GROUP BY clauseof aselectstatement shouldcontain whichofthefollowingHG or LF indexHNG orLFindexHNGorHG indexLFor DATEindex
20.Which ofthefollowingare usedto determineindex typeselectionsfor acolumn Choose2How thecolumn isused e.g.Joins,GROUPBY,aggregationNumber ofrows inthe tableCardinalityofthedatatypeofthecolumnNumber ofcolumns inthetable
21.Defining aPRIMARY KEYconstraint ona columnautomatically...createsaG-Array.createsaunique HGindexon that column.creates anHNG indexon thatcolumn.drops anyother indexonthatcolumn,except forthe FPindex.
22.Which constraintisusedwithin theCreate Tablecommand toestablishthe estimatedcardinality ofx valuesofacolumnCardinalityxDistinctxFast ProjectionxIQUniquexValuesx。
个人认证
优秀文档
获得点赞 0
