Oracle MySQL Database Administration 1Z0-908认证考试题库（含答案）

OracleMySQLDatabaseAdministrationlZO-908认证考试题

库（含答案）

一'单选题

1.ExaminethissnippetfromthebinaryIogfiIenamedbinIog.000036.

TherentaItabIewasaccidentaIIydropped,andyoumustrecoverthetabIe

YouhaverestoredtheIastbackup,whichcorrespondstothestartofthebinIog.0

00036binaryIog.

WhichmandwiIIpIetetherecovery?

A、mysqIbinIog-stop-position=500324binIog.0000361mysqI

B\mysqIbinIog—stop-datetime='2019-11-2014.55.16'binIog.0000361mysqI

C、mysqIbinIog—stop-position=500453binIog.0000361mysqI

DvmysqIbinIog-stop-datetime='2019-11-2014.55.18'binIog.0000361mysqI

答案：A

2.

AdeveIoperaccidentaIIydroppedtheInnoDBtabIeCustomersfromthepanydataba

Thereisadatadircopyfromtwodaysagointhedbbackupdirectory.

WhichsetofstepswouIdrestoreonIythemissingtabIe?

A、StoptheMySQLServerprocess,andexecute:

MysqIbackup-datadir-/var/1ib/mysqI-backup-dir-/dbbackup-incIude-ta

bIes'pany'.Customers'copy-backStartthemysqIdprocess.

B、StoptheMySQLServerprocessandrestartitwiththemand:

MysqId-basedir-/usr/1ocaI/mysqI-datadir=/var/1ib/mysqI

RunmysqIdumponthistabIeandrestorethedumpfiIe.

C、StoptheMySQLServerprocessandrestartitwiththemand:

MysqId-basedir=/usr/1ocaI/mysqI-datadir=/dbbackup

RunmysqIdumponthistabIeandrestorethedumpfiIe.

DvStoptheMySQLServerprocess,copytheCustomers.ibdfiIefromthedbbackupd

irectory,andstartthemysqIdprocess.

答案：C

3.

BinaryIogeventsforthe'mydbl'schemamustbecopiedtoadifferentschemaname'

mydb2'.

WhichmandwiIIdothis?

A、mysqIbinIog-rewrite-db21'mydbl->mydb2'|mysqI

B、mysqIbinIog-datebase二mydbl-database二mydb21mysqI

C、mysqIbinIog-rewrite-db='mydbl'-rewrite-db='mydb2'ImysqI

D\mysqIbinIog-read-from-remote-server-rawlsed's/mydb1/mydb2/g'Imys

ql

答案：A

4.YourMySQLinstanceiscapturingahugeamountoffinanciaItransactionsevery

dayinthefinancedatabase.panypoIicyistocreateabackupeveryday.

ThemaintabIesbeingupdatedareprefixedwithtransactions~.

ThesetabIesarearchivedintotabIesthatareprefixedwitharchives-eachmont

h.

mysqjh；♦口「--zptimist;c-busy-tab!LmAfiiiiric*?\.transactions-.*Mbackup

WhichoptimizationprocessbestdescribeswhathappenswiththeredoIogs?

AvTheredoIogsarebackeduponIyiftherearechangesshowingforthetransactio

nstabIes.

B、ThetransactiontabIesarebackedupfirst,thenthearchivetabIesandredoIo

gs.

C、TheredoIogsarebackedupfirst,thenthetransactionandarchivetabIes.

DvTheredoIogsarenotbackedupataII.

E、ThearchivetabIesarebackedupfirst,thenthetansactiontabIesandredoIog

s.

答案：E

5.

Whichstatementistrueaboutthemy.inifiIeonaWindowspIatformwhiIeMySQLser

verisrunning?

Choosethebestanswer.

A、MySQLserverdoesnotusethemy.inioptionfiIeforserverconfigurationopti

ons.

B、TheoptionfiIeisreadbytheMySQLserverserviceonIyatstartup.

CvEditingthefilewiIIimmediateIychangetherunningserverconfiguration.

D\UsingSETPERSISTwiIIupdatethemy.inifiIe.

答案：B

6.

HowcanmysqIdmu11ibeconfiguredtoaIIowMySQLinstancestousethesameportnum

ber?

AvTheinstanceshaveappropriatenetmasksset

B、Theinstancesusedifferentuseraccountsuniquetoeachinstance.

C、Theinstancesusedifferentsocketnames.

D、TheinstancesIistenondifferentIPaddresses,（bind-address来实现）

答案：D

7.

Examinethismand,whichexecutessuccessfuIIy:

MysqIbackup-user二dba-password-port=3306—with-timestamp-onIy-know

-fiIe-types-backup-dir=/exprot/backups

BackupWhichstatementistrue?

A、OnIytabIesstoredintheirowntabIespacesarebackedup.

B、OnIynon-encryptedfiIesarebackedup.

C、ThebackupincIudesonIydatafiIesandtheirmetadata.

D、OnIyInnoDBdataandIogfiIesarebackedup.

E、OnlyfiIesforMySQLoritsbuiIt-instorageenginesarebackedup.

答案：E

8.

Examinethemand,whichexecutesuccessfuIIy:

SheII>mysqId-initialize-insecure

Whichstatementistrue?

A、TheinstaIIationcreatesatemporarytestenvironmentwithdatainthe/tmpdi

rectory.

B、TheinstaIIationiscreatedwithoutenforcingorgeneratingSSLcertificate

s.

C、TherootpasswordiscreatedintheerrorIoginpIaintext.

D、TherootpasswordisnotcreatedaIIowingeasyaccessfromthesamehost

答案：D

9.ExaminethisSQLstatement：

UPDATEworld.city

SETPopulation=Population♦1.1

WHERECountiyCodeIN(SELECTCodeFROMworld.country

WHEREContinent='Asia•)

WhichsetofprivilegeswiIlaiIowTomtoexecutethisSQLstatement?Choosethebe

stanswer.

A、GRANTUPDATEON'world'.；

GRANTALLPRIVILEGESON'world'.country'TO'tom''%'；

B、GRANTUPDATEON'worId'city'TO'tom''%

GRANTSELECTON'world'.*T0'tom'%°

C、GRANTUPDATEON'worId'.'cityTO'tom''%

GRANTSELECTON1worId1.countryTOtom11%

D、GRANTALLPRIVILEGESON'worId'.'city'TO'tom''%

GRANTSELECT('code1)ON1worId','country'TOtom''%

答案：B

10.

Examinethesemandsandoutput：

mysql>SHOWFULLPROCESSLIST;

+•

IXd|User1.・•|StateIInfo

I6|evenjschedulerI.・•!WaitingonemptyqueueINULL

120|root1...IINULL

121)root1..•1|NULL

122|root1・・.1Waitingfortablemetadatalockioptimizetabletest.demo_test

124|root1・・.WaitingfortablemetadatalockIsr-iect*fromtest.demotest

125|rootI..•|starting1SHXFULLPROCESSLIST

+・

叫fsql>SELECTobject_type,object_schema,object_nare,locketype,lock_statusrowner_thread_i

->FROMperformance_schema.raetadaralocks.<HEREob-act_scneraa!=*performance_schema,;

1OBJECT_TYPE1OBJECT_SCHEMA|OBJECT_NAMELOCK_TYPE1LOCK_STATUSIOWNER_THRE

1TABLEItestdeno_test|SHARED_READ|GRANTED|

1TABLE1tost1demo_test|SHAREQRITEIGRANTED

1SCHEMAItest1NULL~|INTENTION_EXCLUSIVEGRANTED

1TABLEItestIdemo_test|SHARED_N。二READ/RITE।PENDING1

♦+--«4.-

mysq!>?ELF/'Tchread_id,prc：esslist_id,processlist_user,parent_thread_id

->FROMper£ormanc»_sch»ma.threadsWHEREprocesslist_us«ra，root';

THREAD」DIPROCESSLIST-IDIPROCESSLIST一USER|PARENT_THREAD_ID

60|20|root|NULL

61|211rootINULL

62|22|xootI1

64|24|soot11

65|25|xootINULL

X.

WhichconnectionIDishoIdingthemetadataIock?

A、21

B、25

C、6

D、22

E、20

F、24

答案：E

11.TheIanguagestabIeusesMyISAMandthecountriestabIeusestheInnoDBstorag

eengine.

BEGIN;

INSERTINTOlanguages(lang)VALa£$("Italian*1^2；

H

INSERTiNTOcountries(countryVALIE~1•jalV)-

ROLLBACK;

WhatisthecontentofbothtabIesafterexecutingthesestatements?

Avcountrieshasonerow,Ianguageshasnone.

B、BothtabIeshaveonerow.

C、BothtabIesareempty.

DvIanguageshasonerow,coutrieshasnone.

答案：D

12.

ExaminethesemandsandresuIts：

mysql>feHOWGRANTSFORjane;

++

IGrantsforjane@%|

++

IGRANTUSAGEONTO'jane'0'%'1

|GRANTSELECTON'SALES」TO、jane、@'V|

2rowsinset(0.00sec)

JanemustcreateatemporarytablenamedTOTALSALESintheSALESdatabase.

WhichstatementwiIIprovideJanewiththerequiredpriviIegesbasedontheprinc

ipIeofIeastpriviIege?

A、GRANTCREATETEMPORARYTABLES,INSERT,UPDATE,DELETE,SELECTONsaIes.

totaIsaIesTojane；

B\GRANTCREATETEMPORARYTABLESONsaIes.*Tojane；

C、GRANTCREATETEMPORARYTABLESONsaIes.totaIsaIesTojane；

D\GRANTALLONsaIes.*tojane；

答案：B

13.

Examinethismand,whichexecutessuccessfuIIy：

mysqlbackup-defaults-file=/backups/f-backup-dir=/backups/fiillcopy-1

Whichstatementistmeaboutthecopy-backprocess'1Choosethebestanswer.

Whichstatementistrueaboutthecopy-backprocess?Choosethebestanswer.

A、ItrestoresfiIesfromthedatadirectorytotheiroriginaIMySQLserverIocat

ions.

B、ItrestoresfiIesfromthebackupdirectorytotheiroriginaIMySQLserverIoc

ations.

C、Thecopy-backprocessisusedtooverwriteanewbackupoveranexistingbackup.

DvThecopy-backprocessmakesineonsistentbackups.

答案：B

14.

YouarehavingperformanceissueswithMySQLinstances.

ThoseserversaremonitoredwithMySQLEnterpriseMonitor.

UsingQueryAnaIyzer,wheredoyoubegintoIookforprobIemqueries?

A、LookforquerieswithbigproIongedspikesinrowactivity/accessgraphinthe

timesseriesgraph.

B、Sortthe"Exec"coIumnandcheckforSQLquerieswithhighQueryResponseTimei

ndex(QRTi)vaIues.

C、LookforquerieswithIowtotaIIatencytimesintheLatencysectioninthetime

seriesgraph.

D\Sortthe"Exec"coIumnandcheckforSQLquerieswithIowQueryResponseTimein

dex(QRTi)vaIues.

答案：D

15.

WhereisthedefauItdatadirectoryIocatedafterinstaIIingMySQLusingRPMonOr

acIeLinux7?

As/usr

B、/usr/mysqI

Cv/etc/f

D、/var/1ib/mysqI

E、/usr/bin

答案：D

16.

YourMySQLServerisrunninglocallyonyourLinuxinstallMion.andhasSSLconnectionsconfiguredbutnotmandatory

#myiqi«uroot*hlocaihost-p

Enterpassword

welcometotheMySQLmonitorCommandsendwith.or

YourMySQLconnectiontdis9

ServerversionS018-commeraalMySQLEnterpnseServer-Commeraal

mysql>STATUS.

Connectionid9

Currentdatabase

Cunentuserroot@localhost

SSLNotinuse

Currentpagerstdeut

Usingoutfite''

Usingdelimiter,

Serververnon8018-commercialMySQLEnterpriseServer-Commercial

Protocolvemon10

ConnectionLocalhostviaUNIXsocket

serverchvactersetutf3mb4

Dbcharactersetutf3mb4

ClientcharactersetutfBmb4

ConnchaactersetutfSmb4

UNIXsocket/var/hb/mysql/my$qlsock

Uptime2min54sec

Threads2QuestionsIQslowqueries0opens132Fluihtables3opentables52Queneipersecondsvg0057

mysql>SHOWGLOBALVARIABLESWHEREVanablejameLIKE'"1%'ANDVrfue

♦._____♦--♦

|Van«ble_name|ValueI

1城.s|capem1

|isl_cert|servcr-certpem1

|ssl_fipi_mode|OFF1

1凡key|serverkeypem1

♦♦♦A

WhatisthereasonforSSLnotbeingused?Choosethebestanswer.

Av11isconnectedviaallNIXsocket

B、AcurrentdatabaseisnotseIected.Thereisnothingtoencrypt.

C、Therootusercannotuseencryption.

DvTherootusermustusessl_fips_mode=ON

答案：A

17.

WhichconditionistrueabouttheuseofthehashjoinaIgorithm?

AvThesmaIIestofthetabIesinthejoinmustfitinmemoryassetbyjoin_buffer_s

ize.

B、Noindexcanbeusedforthejoin.

C、ThequerymustaccessnomorethantwotabIes.

D\AtIeastoneofthetabIesinthejoinmusthaveahashindex.

答案：B

18.Examinethismandandoutput：

mysql>SHOWGLOBALSTATUSLIKE,Firewalli,;

+————————————一一一一一^^一十一一—

1Variabl^_naro&|Value।

FirevfAll_access_denied

IFlravall^accesB_grentedi4

IFirGwallaccesssuspicious|3

IFlrewall_cach®d^?ntxies।11\

Whichstatementistrue?

AvFirewaIl_access_deniedisthenumberofconnectionattemptsfromprohibite

dhoststhataredenied.

B、FirewaIl_cached_entriesisthenumberofstatementsfoundinthequerycache

forusersinDETECTINGmode.

C、FirewaII_access_grantedisthenumberofconnectionsgrantedfromwhiteIis

tedhosts.

D、FirewaIl_access_suspiciousisthenumberofstatementsIoggedassuspiciou

sforusersinDETECTINGmode.

答案：D

19.

Whatisthecorrectsyntaxforusingtransparentdataencryption

WithanexistingInnoDBtabIe?

A、ALTERTABLEtlENCRYPTION='Y'；

B、ALTERTABLEtlWITHENCRYPTIONUSINGMASTERKEY；

GALTERTABLEtlSETTDE='ON'；

D、ALTERTABLEtlADDENCRYPTEDTABLESPACE='Y'；

答案：A

20.AcoIIeaguepIainsaboutsIowresponsetimeonyourwebsite.

Examinethisqueryandoutput：

mysql>showglobalstatuslike'Table_lock%#;

Variable_name|Value

1

TablelocksimmediateI53148

Table_locks_waited!17716

4

2rowsinset(0.00sec)

WhatisthemostIikeIycauseforthehighnumberofIockwaits?

AvYouusetheMyISAMstorageengineformostmontabIes.

B、YouusetheInnoDBstorageengineandstatementswaitwhiIedataisinserted.

C、TheInnodbBufferpooIisfuII.

D、YourtabIeaccesseswaitfortheoperatingsystemIeveIfIush.

答案：A

21.Examinethisconfiguration：

AvTheseIf-signedcertificateisequaIIysecureandequaIIytrusted

B、TheseIf-signedcertificateismoresecureandIesstrusted.

CvTheseIf-signedcertificateisIesssecureandequaIIytrusted

DvTheseIf-signedcertificateisequaIIysecureandIesstrusted.

E、TheseIf-signedcertificateismoresecureandequaIIytrusted

F、TheseIf-signedcertificateisIesssecureandIesstrusted

答案：F

22.ExaminethispartiaIreport：

mysql>SHOWFULLPROCESSLIST；

++++——

IId|User|HostI♦♦♦

++++

I4|event_scheduler|localhost|...

I9|rootIlocalhost:51502|...

I10IrootIlocalhost:51670|.

Examinethisquery:

SELECTSUM(m.CURRENT_NUMBER_OF_BYTES_USED)ASTOTAL

FROMperformance_schema.meniory_sununary_by_thread_by_event_namem

INNERJOINperformance_scheina.threadst

ONm・THREAD_ID=t.THREAD_ID

WHEREt.PROCESSLIST_It二10；

Whatinformationdoesthisqueryprovide?

A\totaImemoryusedbyconnectionnumberl0

B、totaImemoryusedacrossaIIconnectionsassociatedwiththeuseronconnecti

onnumberl0

C、totaImemoryusedbythefirst1Othreads

D、totaImemoryusedbythreadnumberl0

E、totaImemoryusedacrossaIIconnectionsassociatedwiththeuseronthreadnu

mberlO

F、totaImemoryusedbythefirst1Oconnections

答案：A

23.YouencounteredaninsufficientpriviIegeerrorinthemiddIeofaIongtransa

ction.

ThedatabaseadministratorisinformedandimmediateIygrantstherequiredpriv

iIege：

GRANTUPDATEONworld.cityTO'userT;

HowcanyouproceedwithyourtransactionwiththeIeastiinterruption?

A、RoIIbackthetransactionandstartthetransactionagaininthesamesession.

B、ChangethedefauItdatabaseandre-executethefaiIedstatementinyourtrans

action.

C、Re-executethefaiIedstatementinyourtransaction.

DvCIosetheconnection,reconnect,andstartthetransactionagain.

答案：c

24.WhatdoesthesIavel/Othreaddo?

AvmonitorsandscheduIesl/OcaIIstothesubsystemforthereIayIogs

B、connectstothemasterandrequestsittosendupdatesrecordedinitsbinaryIo

gs

C、acquiresaIockonthebinaryIogforreadingeacheventtobesenttothesIave

D、readsthereIayIogandexecutestheeventscontainedinthem

答案：B

25.YouwanttoIogonIythechangesmadetothedatabaseobjectsanddataontheMySQ

Lsystem.

WhichIogwiIIdothisbydefau11?

AvsIowqueryIog

B、binaryIog

C、errorIog

D、generaIqueryIog

E、auditIogtothedatabaseobjectsanddataontheMySQLsystem.

答案：B

26.YouhavejustinstaIIedMySQLonOracIeLinuxandadjustedyour/etc/my.cnfpa

rameterstosuityourinstaIIation.

Examinetheoutput:

■systemctlstart,mysqld

Jobtormysaid.uq拿，小、..一―一

mysqld.service-and-journalctl-xe-for晨::;廿exitedwit.

♦»ystemctlBtatusmyaqld.service

mysqld.service-MySQLS«rv«r

Load":loaded(/iwir/lib/ayatead/ayatwH/inysqld.service;enabledrenu

Active:failed(Result:exit-cod。)«incaThu2019-12-12D)：54:53A-DT

Doca:man:mysqld(8)

http://d，v*nysql.com/doc/rwfman/en/usxng-systwi•htail

:2132ExecStai:1:*/usr/Bbin/9nyBqIdSMYSQIJ_OPTS<cod*««xico.1

Process:270SEx«cStartPr>«/usr/bin/!nysqid_pxa^',/9tmd(ccxl^exited,i

IteinPID：27329t^atU0&1/FAILVHfi)

Seamus:"89rv^rstartupxnprogress**

Whatstatementistrueaboutthestartattempt?

AvMySQLserverwasnotstartedduetoaprobIemwhiIeexecutingprocess2732.

B、systemdfoundthemysqIdservicedisabIedandfaiIedtostartit.

C\MySQLservercontinuedtostartupeventhoughanotherprocessexisted.

DvsystemdwaiIedfor30secondsbeforetimingoutandstartupfaiIed.

E、systemdattemptedtostartmysqId,foundanothersystemdmysqIdprocessrunn

ing,andshutitdown.

答案：A

27.

ExaminethesetworeportstakenlOOsecondsapart:

GL0BALSTATUS1.

GL0BALSTATUS2.

YourMySQLsystemnormaIIysupports50-75concurrentconnections.

WhichconfigurationchangewiIIimproveperformanee?

AvdecreasetabIe_definition_cache

B、decreaseopen_files_limit

C、increasetabIe_open_cache

D、increasemax_connections

答案：c

28.

Examinethesemands,whichexecutesuccessfuIIyontheidhost：

mysqlsh>dba.createCluster(•clusterl',{memberweight:35))

mysqlsh>varmycluster=dba.getCluster()

mysqlsh>mycluster.addinstance(•ic@ic2*,{memberweight:2S})

mysqlsh>mycluster.addlnstance(*ic@ic31,{memberWeight:50))

Nowexaminethisconfigurationsetting,whichisthesameonallnodes:

group_replication__consistency=BEFORE_ON_PRIMARY_FAILOVER

WhichstatementistrueifprimarynodeidfaiIs?

AvNodeic2beesthenewprimaryandexistingtransactionsareconsideredstaIea

ndroIIedback.

B、Nodeic3beesthenewprimaryandexistingtransactionsareconsideredstaIea

ndroIIedback.

C、Nodeic3beesthenewprimaryandisignoreduntiIanybackIogoftransactionsi

spIeted.

D、OnIytwonodesremainsotheeIectionprocessisuncertainandmustbedonemanu

ally.

E、Nodeic2beesthenewprimaryandisignoreduntiIanybackIogoftransactionsi

spIeted.

答案：C

29.

ExaminethefuIIpathnameofthebackupimagefromMySQLEnterpriseBackupwithth

e-pressoption:/backup/full/mybackup/myimage,img

MysqIbackup,cnfcontainsthisdata:

[mysqIbackup]

Backup-dir=/backup/fuIl/myrestore

Backup-image=/backup/full/mybackup/myimage,imgunpress

Youmustperformadatabaserestoretoanewmachine.

Whichmandcanprovisionthenewdatabaseindatadiras/data/MEB?

AvmysqIbackup一一defauIts-fiIe=mysqIbackup,cnf一一datadir=/data/MEBresto

re-and-appIy-Iog

B、mysqIbackup-defauIts-fiIe=mysqIbackup,cnf-datadir=/data/MEBimage

-to-dir-and-appIy-1og

C、mysqIbackup一一defauIts-file=mysqIbackup,cnf一一datadir=/data/MEBappIy

-Iog-and-copy-back

D、mysqIbackup一一defauIts-fiIe二mysqIbackup,cnf一一datadir-/data/MEBcopy-

back-and-appIy-Iog

E、mysqIbackup一一defauIts-fiIe二mysqIbackup,cnf一一datadir-/data/MEBimage

-to-dir

答案：D

30.

WhatdoesthesIavel/Othreaddo?

A、connectstothemasterandrequestsittosendupdatesrecordedinitsbinaryIo

gs

B、monitorsandscheduIesl/0caIIstothesubsystemforthereIayIogs

C、readsthereIayIogandexecutestheeventscontainedinthem

D、acquiresaIockonthebinaryIogforreadingeacheventtobesenttothesIave

答案：A

31.

WhichmandenabIesruIe-basedMySQLAuditingcapabi11ies?

A、sheII>mysqI<audit_Iog_fiIter_linux_instaII.sqI

B\sheII>mysqId--initialize--1og-raw=audit.log

C、mysqI>INSTALLPLUGINaudit_Iog；

D、mysqI>INSTALLPONENTaudit_Iog；

答案：A

32.

YoureconfigureandstartasIavethatwasnotrepIicatingforseveraIdays.Theco

nfigurationfiIeandCHANGE

MASTERmandarecorrect.ExaminetheGTIDinformationfrombothmasterandsIave:

Master:

gtids_executed:aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-321,

bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-50,

cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

gtids_purged:aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1T00,

bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:l-10r

cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Slave:

gtids_executed:aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:l-160r

cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

gtids_purged:aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-70.

cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Whichstatementistrue?

AvRepIicationwiIIfaiIbecausethemasterdoesnothavetherequiredtransacti

onwithbbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbbGTIDsinitsbinaryIogs.(Corre

ct)

B、RepIicationwiIIfaiIbecausethemasterhasaIreadypurgedtransactionswit

hcccccccc-cccc-cccc-cccc-ccccccccccGTIDs.

CvRepIicationwiIIfaiIbecauseofineonsistentnumbersincccccccc-cccc-ccc

c-cccc-ccccccccccccGTIDs.

D、RepIicationwiIIfaiIbecausethesIavehaspurgedmoreaaaaaaaa-aaaa-aaaa-

aaaa-aaaaaaaaaaaatransactionsthanthemaster.

答案：A

33.

Choosethebestanswer.

WhichutiIitywouIdyouusetoviewthequeriesinthesIowqueryIogsortedbyavera

gequerytime?

AvmysqIcheck

B、mysqIshow

C、mysqIimport

D、mysqIdump

E、mysqIdumpsIow

答案：E

34.

YouareusingtheInnoDBengineandtheinnodb_fiIe_per_tabIeoptionisset.

YoudeIeteasignificantnumberofrowsofaIargetabIenamedFACTORY.INVENTORY.

WhichmandwiIIreorganizethephysicaIstorageoftabIedataandassociatedinde

xdatafortheINVENTORYtabIe,

Inordertoreducestoragespaceandimprovel/Oefficiency?

A、CHECKTABLEFACTORY.INVENTORY

B、ANALYZETABLEFACTORY.INVENTORY

C\OPTIMIZETABLEFACTORY.INVENTORY

D、mysqIcheck-uroot-pFACTORY.INVENTORY

E、mysqIdump-uroot-pFACTORYINVENTORY

答案：c

35.ExaminetheseentriesfromthegeneraIqueryIog：

TltMIdCotnmandArgument

2019-12-17T0024Connectroot9localhostonmyd

2019-12-11T00Qu”，select00versi.on_coinin

2019-12-17TO0rootdlocalhostonmydJ

2019-12-17T00select88version_connn<

2019-12-nT00STARTTRANSACTION

2019-12-17T00UPDATEtlSETval■1

2019-12-17T0025QuerySTARTTRANSACTION

2019-12-17T0025QueryUPDATEt2SETval-5

2019-12-17T0025QueryUPDATEtlSETval«1(

2019-12-17T0Q24QueryUPDATEt2SETval=4：

AIIUPDATEstatementsreferenceexistingrows.

Whichdescribestheouteofthesequenceofstatements?

A、AdeadIockoccursafterinnodb_lock_wait_timeoutseconds.

B\Connection24experiencesaIockwaittimeout

C、Connection25experiencesaIockwaittimeout.

D、AlIstatementsexecutewithouterror.

E、AdeadIockoccursimmediateIy.

答案：E

36.

MySQLprogramsIookforoptionfiIesinstandardIocations.

WhichmethodwiIIshowtheoptionfiIesandtheorderinwhichtheyareread?

AvmysqI>SH0WGL0BALVARIABLES；

B、sheII>mysqI-print-defauIts

C、sheII>mysqIadmin-debug

D\sheII>mysqId-heIp-verbose

答案：D

37.Examinethisstatement,whichexecutessuccessfuIIy：

woxXdL•CXy(

IDInXNOTNVX-X.AUTOXNCRKMFNT*

WhichchangeenabIesthequerytosucceedwhiIeaccessingfewerrows?

A、ALTERTABLEworId.cityADDINDEX(Name)；

B、ALTERTABLEworId.cityaddSPATIALINDEX(Name),

C、ALTERTADLEworId.cityaddFULLTEXTINDEX(Name);

D、ALTERTABLEworId.cisaddSPATIALINDEX(Population);

E、ALTERTABLEworId.cityADDINDEX(Population)；

F、ALTERTABLEworId.cityADDFULLTEXTINDEX(PopuIation);

答案：E

38.

Whichfeatureisprovidedbymu11i-sourcerepIication?

Choosethebestanswer.

A、providingamonsourceforthesamedatatoberepIicatedtootherservers

B、alIowingmu11ipIeserverstobackuptooneserver

C、managingconfIictsbetweentwosetsofthesamedata

Dvprovidingmu11i-sourcerepIicationwhereaIIserversactasthemaster

答案：B

39.

YouarehavingperformanceissueswithMySQLinstances.Thoseserversaremonito

redwithMySQLEnterpriseMonitor.

UsingQueryAnaIyzer,wheredoyoubegintoIookforprobIemqueries?

AvSorttheuExec"coIumnandcheckforSQLquerieswithIowQueryResponseTimei

ndex(QRTi)vaIues.

B、LookforquerieswithIowtotaIIatencytimesintheLatencysectioninthetime

sseriesgraph

C、Sortthe"Exec"coIumnandcheckforSQLquerieswithhighQueryResponseTimei

ndex(QRTi)vaIues.

D、LookforquerieswithbigproIongedspikesinrowagtiyity/access,graphint

hetimesseriesgraph.

答案：A

40.MySQLisinstaIIedonaLinuxserverwiththisconfiguration:

[mysqId]

User二mysqI

Da