中国移动网上大学题库IT数据库无L1

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

ITL120157301430:12333:26.83%1.A.B.C.D.B2.openLISTENERdbaLSNRCTLSTOPA.B.C.D.C3.onstat-gact___A.VPB.C.C4.HDRDRAUTO2HDR___A.HDRHDRB.FOCC.HDRHDRD.HDRHDRA12015527930ITL15.OracleA.B.C.D.A6.()A.modelB.masterC.sybsystemdbD.sybsystemprocsD7.pORACLEDBASQLASMSQL>selectgroup_number,name,statefromv$ASM_DISKGROUP;GROUP_NUMBERNAMESTATE0DGROUP1DISMOUNTED2DGROUP2MOUNTED3DGROUP3MOUNTED/pA.DGROUP1DBAB.DGROUP1C.DGROUP1DISMOUNTEDD.ASMA8.IDS___A.chunkB.dbspacesC.pageD.extentE.tblsapcesA12015527930ITL19.SQLServerWindowsA.taskmgrB.perfmonC.mstscD.services.mscB12015527930ITL110.pMYSQL180/pA.SHOWFULLPROCESSLISTWHEERTime180;B.SELECT*FROMINFORMATION_SCHEMA.SESSION_STATUSWHERESTATE(DATE_SUB(NOW(),INTERVAL180SECOND));C.SELECT*FROMINFORMATION_SCHEMA.PROCESSLISTWHERETIME180;D.SELECT*FROMINFORMATION_SCHEMA.EVENTSWHERESTARTS(DATE_SUB(NOW(),INTERVAL180SECOND));C11.SQLServerA.UPDATEB.SELECTC.DROPD.USEB12.pinformix20/pA.onstat-dB.onstat-mC.onstat-kD.onstat-lB13.AA.CURSORB.INDEXC.VIEWD.TABLEC14.ORACLEopathA.$ORACLE_HOME/network/adminB.$ORACLE_HOME/binC.$ORACLE_HOME/OPAtchD.$ORACLE_BASEC15.onstat-gath___A.B.VPC.C16.pinformix,___/pA.B.C.B17.pinformix/pA.oncheck-peB.oncheck-ptC.oncheck-ppD.oncheck-prB18.IDS___A.B.B19.HDRDRAUTO3HDR___A.HDRHDRB.FOCC.HDRHDRD.HDRHDRB12015527930ITL120.IDS___A.B.C.C12015527930ITL121.IDSI/OVP___A.aioB.admC.cpuD.lioA22.1.2.ALTERDATABASEARCHIVELOG3.mount4.DB_RECOVERY_FILE_DEST$ORACLE_HOME/dest_1.5.A.1,3,4,5,2B.4,1,3,2,5C.1,3,2,5;4notrequiredD.4,1,5,2;3notrequiredC23.Sybase()A./sybase/binB./sybase/tmpC./sybase/ASE-12_0/D./sybase/ASE-12_0/installD12015527930ITL124.Oracle?A.B.C.D.C25.reodologORA-00313:openfailedformembersofloggroup1ofthread1ORA-00312:onlinelog1thread1:''D:\REDO01.LOG''redologA.ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP1;B.ALTERDATABASECLEARLOGFILEGROUP1;C.ALTERDATABASEDROPLOGFILEGROUP1;D.ALTERDATABASEDROPLOGFILEMEMBER''D:\REDO01.LOG'';A26.A.COUNTB.TO_NUMBERC.AVGD.SUBSTRC27.A.B.C.D.D28.SQLServerA.modelB.tempdbC.masterD.msdbC29.IDS(HDR)___A.B.C.HDRD.A12015527930ITL130.IDS___A.B.C.D.C31.poracle/pA.B.C.D.A32.A.CONNECTB.CREATESESSIONC.RESOURCED.DBAB33.sqlA..ndfB..tifC..mdfD..ldfB34.OracleA.MinusB.IntersectC.UnionD.UnionallC35.IDSadmVPA.4B.1C.3D.2B36.A.onstat-lB.onstat-mC.onstat-kD.onstat-dD37.MSSQLSERVERA.sp_dbB.sp_dbhelpC.sp_helpD.sp_helpdbD12015527930ITL138.SQLA.GRANTB.CTEATEC.SELECTD.REVOKEA39.SQLA.ALTERTABLEB.UPDATETABLEC.CHANGETABLED.MODIFYTABLEA40.OraclecharvarchardateA.dateB.to_dateC.ctodateD.todateB41.pinformixdbexport___/pA.tB.cC.oC42.IDSONCONFIG=onconfigonconfig___A./etcB.$HOME/etcC.$INFORMIXDIR/etcC12015527930ITL143.poracle/pA.AVGB.TO_NUMBERC.COUNTD.SUBSTRC44.IDSVP___A.cpuB.lioC.admD.aioB12015527930ITL145.IDSI/O___A.extentB.pageC.chunkD.dbspacesE.tblspacesB12015527930ITL146.SMIDB___A.syslogsB.sysdatabasesC.sysdbspacesD.systabnamesE.syschunksD12015527930ITL147.poracledb/pA.$ORACLE_HOMEB.C.D.A48.sysfragments___A.B.SMIA49.SQLServerA.B.C.D.A12015527930ITL150.SQLServerA.USEB.DROPC.UPDATED.SELECTC51.pinformix___/pA.B.C.C52.pinformixsyslogs___/pA.B.C.C53.IDSsessionpool___A.B.C.B12015527930ITL154.3a.b.c.d.e.recoverdatabaseusingbackupcontrolfilef.A.a,d,fB.c,e,fsC.a,b,e,fD.a,e,fA55.SQLServerA.B.C.D.A56.SQLServer2008A.SQLServerManagementStudioSQLServerB.SQLServerManagementStudioC.SQLServerManagementStudioSQLServerD.SQLServerManagementStudioSQLServerA12015527930ITL157.pinformix___/pA.B.HPLC.dbexportC58.SQLServerA.sys.database_filesB.sys.statsC.sys.errorD.sys.messagesD12015527930ITL159.onmode-dmakeprimarySERVER___A.SDSB.RSSC.HDRC60.immediate1.sga2.3.redo4.5.6.7.A.1,2,3,5,6,4;step7isnotrequiredB.7,1,5,2,3,6,4C.7,1,5,2,3,6;step4isnotrequiredD.1,5,7,2,3,6;step4isnotrequiredC61.pOracle/pA.opatchlsinventoryB.opatchapplyC.opatchrollbackD.opatchprereqA62.IDS(HDR)___A.B.C.D.HDRD12015527930ITL163.IDS___A.B.B12015527930ITL164.SQLServerTCP/IPA.8080B.1433C.80D.2433B65.poracle/pA.opatchrollbackB.opatchutilC.opatchprereqD.opatchapplyD66.dbpsu?A.mountB.readonlyC.D.openC67.A.B.FlashbackRecoveryC.RMAND.FlashbackDropD68.RSS___A.B.B69.A.userB.scottC.hrD.systemD70.poracle/pA.latch:sharedpoolB.cursor:pinSwaitonXC.enq:TX-rowlockcontentionD.dbfilescatteredreadC71.IDSA.onbarB.ontapeC.archeckerC12015527930ITL172.A.B.C.dbaD.C73.pinformix/pA.oncheck-ptB.oncheck-peC.oncheck-ppD.oncheck-prD74.dbfilesequentialreadP3A.B.C.D.C75.SMIDB___A.sysdbspacesB.sysdatabasesC.syschunksD.systabnamesE.syslogsB76.dbfilesequentialreadP1A.B.C.D.B77.___A.onlineB.offlineC.quiescentB78.10Gv$sessionA.eventsB.sidC.eventD.sql_idC79.WHEREA.FlashbackQueryB.FlashbackTableC.FlashbackTransactionQueryD.FlashbackVersionsQueryE.FlashbackDropB80.AdaptiveServerA.shutdownB.startserverC.sp_helpsortD.showserverA81.SQLA.DROPB.DELECTC.CLEARD.REMOVEB82.pSQLServer/pA.CREATTABLEB.CREATSCHEMAC.CREATINDEXD.CREATVIEWA83.poracledbfilesequentialreadP2/pA.B.C.D.D84.A.onstat-mB.onstat-dC.onstat-lD.onstat-kC85.AdaptiveServer()A.sybsystemdbB.masterC.tempdbD.modelE.sybsystemprocsABCDE12015527930ITL186.poracle/pA.B.C

1 / 25
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功