Oracle MySQL Database Administration 1Z0-908認證考試題庫（含答案）

PAGEPAGE1OracleMySQLDatabaseAdministration1Z0-908認證考試題庫（含答案）一、單選題1.Examinethissnippetfromthebinarylogfilenamedbinlog.000036.Therentaltablewasaccidentallydropped，andyoumustrecoverthetableYouhaverestoredthelastbackup，whichcorrespondstothestartofthebinlog.000036binarylog.Whichmandwillpletetherecovery?A、mysqlbinlog--stop-position=500324binlog.000036|mysqlB、mysqlbinlog--stop-datetime='2019-11-2014.55.16'binlog.000036|mysqlC、mysqlbinlog--stop-position=500453binlog.000036|mysqlD、mysqlbinlog--stop-datetime='2019-11-2014.55.18'binlog.000036|mysql答案：A2.

AdeveloperaccidentallydroppedtheInnoDBtableCustomersfromthepanydatabase.

Thereisadatadircopyfromtwodaysagointhedbbackupdirectory.

Whichsetofstepswouldrestoreonlythemissingtable?A、StoptheMySQLServerprocess,andexecute:

Mysqlbackup--datadir=/var/lib/mysql--backup-dir=/dbbackup--include-tables'pany'.Customers'copy-backStartthemysqldprocess.B、StoptheMySQLServerprocessandrestartitwiththemand:

Mysqld--basedir=/usr/local/mysql--datadir=/var/lib/mysql

Runmysqldumponthistableandrestorethedumpfile.C、StoptheMySQLServerprocessandrestartitwiththemand:

Mysqld--basedir=/usr/local/mysql--datadir=/dbbackup

Runmysqldumponthistableandrestorethedumpfile.D、StoptheMySQLServerprocess,copytheCustomers.ibdfilefromthedbbackupdirectory,andstartthemysqldprocess.答案：C3.

Binarylogeventsforthe'mydb1'schemamustbecopiedtoadifferentschemaname'mydb2'.

Whichmandwilldothis?A、mysqlbinlog--rewrite-db='mydb1->mydb2'|mysqlB、mysqlbinlog--datebase=mydb1--database=mydb2|mysqlC、mysqlbinlog--rewrite-db='mydb1'--rewrite-db='mydb2'ImysqlD、mysqlbinlog--read-from-remote-server--rawIsed's/mydb1/mydb2/g'lmysql答案：A4.YourMySQLinstanceiscapturingahugeamountoffinancialtransactionseverydayinthefinancedatabase.panypolicyistocreateabackupeveryday.Themaintablesbeingupdatedareprefixedwithtransactions-.Thesetablesarearchivedintotablesthatareprefixedwitharchives-eachmonth.Whichoptimizationprocessbestdescribeswhathappenswiththeredologs?A、Theredologsarebackeduponlyiftherearechangesshowingforthetransactionstables.B、Thetransactiontablesarebackedupfirst,thenthearchivetablesandredologs.C、Theredologsarebackedupfirst,thenthetransactionandarchivetables.D、Theredologsarenotbackedupatall.E、Thearchivetablesarebackedupfirst,thenthetansactiontablesandredologs.答案：E5.

Whichstatementistrueaboutthemy.inifileonaWindowsplatformwhileMySQLserverisrunning?

Choosethebestanswer.A、MySQLserverdoesnotusethemy.inioptionfileforserverconfigurationoptions.B、TheoptionfileisreadbytheMySQLserverserviceonlyatstartup.C、Editingthefilewillimmediatelychangetherunningserverconfiguration.D、UsingSETPERSISTwillupdatethemy.inifile.答案：B6.

HowcanmysqldmultibeconfiguredtoallowMySQLinstancestousethesameportnumber?A、TheinstanceshaveappropriatenetmaskssetB、Theinstancesusedifferentuseraccountsuniquetoeachinstance.C、Theinstancesusedifferentsocketnames.D、TheinstanceslistenondifferentIPaddresses,（bind-address來實現(xiàn)）答案：D7.

Examinethismand,whichexecutessuccessfully:

Mysqlbackup--user=dba--password--port=3306--with-timestamp--only-know-file-types–backup-dir=/exprot/backups

BackupWhichstatementistrue?A、Onlytablesstoredintheirowntablespacesarebackedup.B、Onlynon-encryptedfilesarebackedup.C、Thebackupincludesonlydatafilesandtheirmetadata.D、OnlyInnoDBdataandlogfilesarebackedup.E、OnlyfilesforMySQLoritsbuilt-instorageenginesarebackedup.答案：E8.

Examinethemand,whichexecutesuccessfully:

Shell>mysqld--initialize-insecure

Whichstatementistrue?A、Theinstallationcreatesatemporarytestenvironmentwithdatainthe/tmpdirectory.B、TheinstallationiscreatedwithoutenforcingorgeneratingSSLcertificates.C、Therootpasswordiscreatedintheerrorloginplaintext.D、Therootpasswordisnotcreatedallowingeasyaccessfromthesamehost答案：D9.ExaminethisSQLstatement：WhichsetofprivilegeswillallowTomtoexecutethisSQLstatement?Choosethebestanswer.A、GRANTUPDATEON'world`.*TO`tom``%`；GRANTALLPRIVILEGESON'world'.country'TO`tom``%`；B、GRANTUPDATEON'world'.`city'TO`tom``%GRANTSELECTON'world'.*TO`tom`%°C、GRANTUPDATEON'world'.`cityTO`tom``%GRANTSELECTON'world'.countryTOtom''%D、GRANTALLPRIVILEGESON`world`.'city'TO`tom``%GRANTSELECT(`code')ON'world'.`country'TOtom``%答案：B10.Examinethesemandsandoutput：WhichconnectionIDisholdingthemetadatalock?A、21B、25C、6D、22E、20F、24答案：E11.ThelanguagestableusesMylSAMandthecountriestableusestheInnoDBstorageengine.Whatisthecontentofbothtablesafterexecutingthesestatements?A、countrieshasonerow，languageshasnone.B、Bothtableshaveonerow.C、Bothtablesareempty.D、languageshasonerow，coutrieshasnone.答案：D12.Examinethesemandsandresults：WhichstatementwillprovideJanewiththerequiredprivilegesbasedontheprincipleofleastprivilege?A、GRANTCREATETEMPORARYTABLES，INSERT，UPDATE，DELETE，SELECTONsales.totalsalesTojane；B、GRANTCREATETEMPORARYTABLESONsales.*Tojane；C、GRANTCREATETEMPORARYTABLESONsales.totalsalesTojane；D、GRANTALLONsales.*tojane；答案：B13.Examinethismand，whichexecutessuccessfully：Whichstatementistrueaboutthecopy-backprocess?Choosethebestanswer.A、ItrestoresfilesfromthedatadirectorytotheiroriginalMySQLserverlocations.B、ItrestoresfilesfromthebackupdirectorytotheiroriginalMySQLserverlocations.C、Thecopy-backprocessisusedtooverwriteanewbackupoveranexistingbackup.D、Thecopy-backprocessmakesinconsistentbackups.答案：B14.

YouarehavingperformanceissueswithMySQLinstances.

ThoseserversaremonitoredwithMySQLEnterpriseMonitor.

UsingQueryAnalyzer，wheredoyoubegintolookforproblemqueries?A、Lookforquerieswithbigprolongedspikesinrowactivity/accessgraphinthetimesseriesgraph.B、Sortthe"Exec"columnandcheckforSQLquerieswithhighQueryResponseTimeindex(QRTi)values.C、LookforquerieswithlowtotallatencytimesintheLatencysectioninthetimeseriesgraph.D、Sortthe"Exec"columnandcheckforSQLquerieswithlowQueryResponseTimeindex(QRTi)values.答案：D15.

WhereisthedefaultdatadirectorylocatedafterinstallingMySQLusingRPMonOracleLinux7?A、/usrB、/usr/mysqlC、/etc/fD、/var/lib/mysqlE、/usr/bin答案：D16.WhatisthereasonforSSLnotbeingused?Choosethebestanswer.A、ItisconnectedviaaUNIXsocketB、Acurrentdatabaseisnotselected.Thereisnothingtoencrypt.C、Therootusercannotuseencryption.D、Therootusermustusessl_fips_mode=ON答案：A17.

Whichconditionistrueabouttheuseofthehashjoinalgorithm?A、Thesmallestofthetablesinthejoinmustfitinmemoryassetbyjoin_buffer_size.B、Noindexcanbeusedforthejoin.C、Thequerymustaccessnomorethantwotables.D、Atleastoneofthetablesinthejoinmusthaveahashindex.答案：B18.Examinethismandandoutput：Whichstatementistrue?A、Firewall_access_deniedisthenumberofconnectionattemptsfromprohibitedhoststhataredenied.B、Firewall_cached_entriesisthenumberofstatementsfoundinthequerycacheforusersinDETECTINGmode.C、Firewall_access_grantedisthenumberofconnectionsgrantedfromwhitelistedhosts.D、Firewall_access_suspiciousisthenumberofstatementsloggedassuspiciousforusersinDETECTINGmode.答案：D19.

Whatisthecorrectsyntaxforusingtransparentdataencryption

WithanexistingInnoDBtable?A、ALTERTABLEt1ENCRYPTION='Y'；B、ALTERTABLEt1WITHENCRYPTIONUSINGMASTERKEY；C、ALTERTABLEt1SETTDE='ON'；D、ALTERTABLEt1ADDENCRYPTEDTABLESPACE='Y'；答案：A20.Acolleagueplainsaboutslowresponsetimeonyourwebsite.Examinethisqueryandoutput：Whatisthemostlikelycauseforthehighnumberoflockwaits?A、YouusetheMyISAMstorageengineformostmontables.B、YouusetheInnoDBstorageengineandstatementswaitwhiledataisinserted.C、TheInnodbBufferpoolisfull.D、Yourtableaccesseswaitfortheoperatingsystemlevelflush.答案：A21.Examinethisconfiguration：A、Theself-signedcertificateisequallysecureandequallytrustedB、Theself-signedcertificateismoresecureandlesstrusted.C、Theself-signedcertificateislesssecureandequallytrustedD、Theself-signedcertificateisequallysecureandlesstrusted.E、Theself-signedcertificateismoresecureandequallytrustedF、Theself-signedcertificateislesssecureandlesstrusted答案：F22.Examinethispartialreport：Whatinformationdoesthisqueryprovide?A、totalmemoryusedbyconnectionnumber10B、totalmemoryusedacrossallconnectionsassociatedwiththeuseronconnectionnumber10C、totalmemoryusedbythefirst10threadsD、totalmemoryusedbythreadnumber10E、totalmemoryusedacrossallconnectionsassociatedwiththeuseronthreadnumber10F、totalmemoryusedbythefirst10connections答案：A23.Youencounteredaninsufficientprivilegeerrorinthemiddleofalongtransaction.Thedatabaseadministratorisinformedandimmediatelygrantstherequiredprivilege：Howcanyouproceedwithyourtransactionwiththeleastinterruption?A、Rollbackthetransactionandstartthetransactionagaininthesamesession.B、Changethedefaultdatabaseandre-executethefailedstatementinyourtransaction.C、Re-executethefailedstatementinyourtransaction.D、Closetheconnection，reconnect，andstartthetransactionagain.答案：C24.WhatdoestheslaveI/Othreaddo?A、monitorsandschedulesI/OcallstothesubsystemfortherelaylogsB、connectstothemasterandrequestsittosendupdatesrecordedinitsbinarylogsC、acquiresalockonthebinarylogforreadingeacheventtobesenttotheslaveD、readstherelaylogandexecutestheeventscontainedinthem答案：B25.YouwanttologonlythechangesmadetothedatabaseobjectsanddataontheMySQLsystem.Whichlogwilldothisbydefault?A、slowquerylogB、binarylogC、errorlogD、generalquerylogE、auditlogtothedatabaseobjectsanddataontheMySQLsystem.答案：B26.YouhavejustinstalledMySQLonOracleLinuxandadjustedyour/etc/fparameterstosuityourinstallation.Examinetheoutput:Whatstatementistrueaboutthestartattempt?A、MySQLserverwasnotstartedduetoaproblemwhileexecutingprocess2732.B、systemdfoundthemysqldservicedisabledandfailedtostartit.C、MySQLservercontinuedtostartupeventhoughanotherprocessexisted.D、systemdwailedfor30secondsbeforetimingoutandstartupfailed.E、systemdattemptedtostartmysqld,foundanothersystemdmysqldprocessrunning,andshutitdown.答案：A27.Examinethesetworeportstaken100secondsapart:GLOBALSTATUS1.GLOBALSTATUS2.YourMySQLsystemnormallysupports50-75concurrentconnections.Whichconfigurationchangewillimproveperformanee?A、decreasetable_definition_cacheB、decreaseopen_files_limitC、increasetable_open_cacheD、increasemax_connections答案：C28.Examinethesemands，whichexecutesuccessfullyontheic1host：Whichstatementistrueifprimarynodeic1fails?A、Nodeic2beesthenewprimaryandexistingtransactionsareconsideredstaleandrolledback.B、Nodeic3beesthenewprimaryandexistingtransactionsareconsideredstaleandrolledback.C、Nodeic3beesthenewprimaryandisignoreduntilanybacklogoftransactionsispleted.D、Onlytwonodesremainsotheelectionprocessisuncertainandmustbedonemanually.E、Nodeic2beesthenewprimaryandisignoreduntilanybacklogoftransactionsispleted.答案：C29.ExaminethefullpathnameofthebackupimagefromMySQLEnterpriseBackupwiththe--pressoption:/backup/full/mybackup/myimage.imgMfcontainsthisdata:[mysqlbackup]Backup-dir=/backup/full/myrestoreBackup-image=/backup/full/mybackup/myimage.imgunpressYoumustperformadatabaserestoretoanewmachine.Whichmandcanprovisionthenewdatabaseindatadiras/data/MEB?A、mysqlbackup--defaults-file=f--datadir=/data/MEBrestore-and-apply-logB、mysqlbackup--defaults-file=f--datadir=/data/MEBimage-to-dir-and-apply-logC、mysqlbackup--defaults-file=f--datadir=/data/MEBapply-log-and-copy-backD、mysqlbackup--defaults-file=f--datadir=/data/MEBcopy-back-and-apply-logE、mysqlbackup--defaults-file=f--datadir=/data/MEBimage-to-dir答案：D30.WhatdoestheslaveI/Othreaddo?A、connectstothemasterandrequestsittosendupdatesrecordedinitsbinarylogsB、monitorsandschedulesI/OcallstothesubsystemfortherelaylogsC、readstherelaylogandexecutestheeventscontainedinthemD、acquiresalockonthebinarylogforreadingeacheventtobesenttotheslave答案：A31.

Whichmandenablesrule-basedMySQLAuditingcapabilties?A、shell>mysql<audit_log_filter_linux_install.sqlB、shell>mysqld--initialize--log-raw=audit.logC、mysql>INSTALLPLUGINaudit_log；D、mysql>INSTALLPONENTaudit_log；答案：A32.Youreconfigureandstartaslavethatwasnotreplicatingforseveraldays.TheconfigurationfileandCHANGEMASTERmandarecorrect.ExaminetheGTIDinformationfrombothmasterandslave:Whichstatementistrue?A、Replicationwillfailbecausethemasterdoesnothavetherequiredtransactionwithbbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbbGTIDsinitsbinarylogs.(Correct)B、Replicationwillfailbecausethemasterhasalreadypurgedtransactionswithcccccccc-cccc-cccc-cccc-ccccccccccGTIDs.C、Replicationwillfailbecauseofinconsistentnumbersincccccccc-cccc-cccc-cccc-ccccccccccccGTIDs.D、Replicationwillfailbecausetheslavehaspurgedmoreaaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaatransactionsthanthemaster.答案：A33.Choosethebestanswer.Whichutilitywouldyouusetoviewthequeriesintheslowquerylogsortedbyaveragequerytime?A、mysqlcheckB、mysqlshowC、mysqlimportD、mysqldumpE、mysqldumpslow答案：E34.YouareusingtheInnoDBengineandtheinnodb_file_per_tableoptionisset.YoudeleteasignificantnumberofrowsofalargetablenamedFACTORY.INVENTORY.WhichmandwillreorganizethephysicalstorageoftabledataandassociatedindexdatafortheINVENTORYtable，InordertoreducestoragespaceandimproveI/Oefficiency?A、CHECKTABLEFACTORY.INVENTORYB、ANALYZETABLEFACTORY.INVENTORYC、OPTIMIZETABLEFACTORY.INVENTORYD、mysqlcheck-uroot-pFACTORY.INVENTORYE、mysqldump-uroot-pFACTORYINVENTORY答案：C35.Examinetheseentriesfromthegeneralquerylog：AllUPDATEstatementsreferenceexistingrows.Whichdescribestheouteofthesequenceofstatements?A、Adeadlockoccursafterinnodb_lock_wait_timeoutseconds.B、Connection24experiencesalockwaittimeoutC、Connection25experiencesalockwaittimeout.D、Allstatementsexecutewithouterror.E、Adeadlockoccursimmediately.答案：E36.

MySQLprogramslookforoptionfilesinstandardlocations.

Whichmethodwillshowtheoptionfilesandtheorderinwhichtheyareread?A、mysql>SHOWGLOBALVARIABLES；B、shell>mysql--print-defaultsC、shell>mysqladmin--debugD、shell>mysqld--help--verbose答案：D37.Examinethisstatement，whichexecutessuccessfully：Whichchangeenablesthequerytosucceedwhileaccessingfewerrows?A、ALTERTABLEworld.cityADDINDEX(Name)；B、ALTERTABLEworld.cityaddSPATIALINDEX(Name)，C、ALTERTADLEworld.cityaddFULLTEXTINDEX(Name);D、ALTERTABLEworld.cisaddSPATIALINDEX(Population);E、ALTERTABLEworld.cityADDINDEX(Population)；F、ALTERTABLEworld.cityADDFULLTEXTINDEX(Population);答案：E38.

Whichfeatureisprovidedbymulti-sourcereplication?

Choosethebestanswer.A、providingamonsourceforthesamedatatobereplicatedtootherserversB、allowingmultipleserverstobackuptooneserverC、managingconflictsbetweentwosetsofthesamedataD、providingmulti-sourcereplicationwhereallserversactasthemaster答案：B39.

YouarehavingperformanceissueswithMySQLinstances.ThoseserversaremonitoredwithMySQLEnterpriseMonitor.

UsingQueryAnalyzer，wheredoyoubegintolookforproblemqueries?A、Sortthe“Exec"columnandcheckforSQLquerieswithlowQueryResponseTimeindex(QRTi)values.B、LookforquerieswithlowtotallatencytimesintheLatencysectioninthetimesseriesgraphC、Sortthe"Exec"columnandcheckforSQLquerieswithhighQueryResponseTimeindex(QRTi)values.D、Lookforquerieswithbigprolongedspikesinrowagtiyity/access，graphinthetimesseriesgraph.答案：A40.MySQLisinstalledonaLinuxserverwiththisconfiguration:[mysqld]User=mysqlDatadir=/data/mysqlWhichmethodsetsthedefaultauthenticationtoSHA-256hashingforauthenticatingUseraccountpasswords?A、Setvalidate-user-plugins=caching_sh32_passwordintheconfigurationfile.B、Adddefaultauthenticationplugin=sha256passwordintheconfigurationfile.C、Adddefaultauthenticetion_plugin=mysqlnativepasswordintheconfigurationfile.D、DefineCREATEUSERIDENTIFIEDWITHsha256_passwordintheMySQLinstance.答案：B41.WhichstatementistrueaboutMySQLEnterpriseTransparentDataEncryption(TDE)?A、MySQLTDEusesanappropriatekeyringplugintostorethekeysinacentralzedlocation.B、BothMyISAMandInnoDBtablescanbeencryptedbysettingthekeyring_engine=ALLvariableintheMySQLconfigurationfile.C、LosttablespaceencryptionkeyscanberegeneratedonlyifthemasterdatabasekeyisknownorpresentintheKeyVaultspecification.D、TDEcanencryptInnoDBandMyISAMtablesonlywhenthetablesarestoredintheSYSTEMtablespace.答案：A42.Examinethisstatement，whichexecutessuccessfully：Whichchangeenablesthequerytosucceedwhileaccessingfewerrows?A、ALTERTABLEworld.cityADDINDEX(Name)；B、ALTERTABLEworld.cityADDSPATIALINDEX(Name)；C、ALTERTABLEworld.cityADDFULLTEXTINDEX(Name)；D、ALTERTABLEworld.cityADDFULLTEXTINDEX(Population)；E、ALTERTABLEworld.cityADDSPATIALINDEX(Population)；F、ALTERTABLEworld.cityADDINDEX(Population)；答案：F43.

Examinethismand,whichexecutessuccessfully:

Mysqlbackup--user=dba--password–port3306--with-timestamp--backup-dir=/export/backupsbackup-and-apply-log

Whichstatementistrue?A、ThebackupaccessestheMySQLserverfilesbyusingapre-existingconnectionB、Thedatabaseserverisputintoaread-onlystateforthedurationofthebackup.C、AnofflinebackupofInnoDBtablesistaken.D、ThebackupcanbeimpactedwhenDDLoperationsrunduringthebackup.答案：D44.YourecentlyupgradedyourMYSQLinstallationtoMYSQL8.0.Examinethisdienoterror:WhichoptionwillallowthisclienttoconnecttoMYSQLServer?A、[mysqld]Defaultauthenticationplugin=sha256_passwordB、[mysqld]Defaultauthentication_plugin=caching_sha2_passwordC、ALTERUSERuserIDENTIFIEDWITHmysql_native_passwordBY'password';D、ALTERUSERuserIDENTIFIEDWITHcaching_sha2_passwordE、ALTERUSERuserIDENTIFIEDWITHsha256_passwordF、[mysqld]

Default_authentication_plugin=mysql_nativepassword答案：C45.Fournodesareconfiguredtousecircularreplication.Examinetheseconfigurationparametersforeachnode：Whichstatementistrue?A、Settingslave_parallel_type=DATABASEwon'tworkforcircularreplication；itshouldbesettoLOGICALCLOCK.B、SettingslavepreservemitordertoONwillimprovedataconsistency.C、Cross-databaseconstraintscancausedatabaseinconsistency.D、Eachslavethreadisresponsibleforupdatingaspecificdatabase.E、IncreasingslaveparallelworkerswillimprovehighavailabilityF、SettingtransactionallowbatchingtoONwillimprovedataconsistency.答案：C46.AnattempttorecoveranInnoDBClusterfails.Examinethissetofmessagesandresponses：A、TheclusterisrunningandthereisatleastoneONLINEinstanceB、Theinstancedeployedonhost3mustbesynchronizedfromadonordeployedonhost1byusingthemandcluster.addInstance('host1.3377').C、Itispossibletodeterminethemostup-to-dateinstancebyparingdifferentglobaltransactionidentifier(GTID.setswithGTID_SUBSET(set1,set2)D、Theactivesessioninstanceisinvalidandmustbere-createdbyusingthemandshell.connect('host3.3377').E、Theinstancedeployedonhost3mustberebuiltwithabackupfromtheprimaryinstance.答案：C47.

YoumustconfiguretheMySQLmand-lineclienttoprovidethehighestleveloftrustandsecuritywhenconnectingtoaremoteMySQLServer

Whichvalueof--ssl-modewilldothis?A、PREFERREDB、VERIFY_CAC、REQUIREDD、VERIFY_IDENTITY答案：D48.

WhichstatementistrueaboutInnoDBpersistentindexstatistics?A、Increasinginnodb_stats_persistent_sample_pagesdetermineshigherpagesscanningspeed，atthecostofincreasedmemoryusage.B、IndexstatisticsarecalculatedfrompagesbufferedinthebufferpoolfortableswithInnoDBstorageengine.C、Tablesarescannedandindexstatisticsrecalculatedwhenaninstanceisrestarted.D、UpdatingindexstatisticsisanI/Oexpensiveoperation.E、Executionplansbasedontransientindexstatisticsimproveprecisionwheninnodbstatspersistentsamplepagesisincreased.F、Settinginnodbstatsautorecalc=ONcausesstatisticstobeupdatedautomaticallywhenanewindexiscreated答案：E49.YouhaveaMySQLsystemwith500GBofdatathatneedsfrequentbackups.YouuseamixofMylSAMandInnoDBstorageenginesforyourdata.Examineyourbackuprequirement：Whichoptionfulfillsallbackuprequirements?A、TakeaphysicalbackupoftheMySQLsystem.B、UsetheClonePlugintocopythedatatoanotherMySQLsystem.C、TakealogicalbackupoftheMySQLsystem.D、TakeyourbackupfromaslaveoftheMySQLsystem.答案：D50.Whichsetofactionswouldallowtheslavetocontinuereplicatingwithouterroneoustransactions?A、RESETMASTER；SETGLOBALgtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa：1-2312；SETGLOBALgtid_executed=aaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaa：1-10167；B、RESETMASTER；SETGLOBALgtid_purged=aaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaa：1-10167；C、RESETSLAVE；SETGLOBALgid_purged=aaaaa-aaa-aaaa-aaaa-aaaaaaaa：1-3820；SETGLOBALgtid_executed=aaaaaa-aaaa-aaa-aaaa-aaaaaaaaaaa：1-10300；D、SETGLOBALgtid_purged=aaaaaa-aaa-aaa-aaaa-aaaaaaaa：1-2312，Bbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbb：1-9；SETGLOBALgtid_executed=aaaaaaa-aaaa-aaaa-aaaa-aaaaaa：1-10167；E、RESETSLAVE；

SETGLOBALgtid_purged=aaaaaaa-aaa-aaaa-aaa-aaaaaaaa：1-10167；答案：B51.Youareusinganexistingserverwithanewconfiguration.MySQLServerfailstostart.Examinethissnapshotoftheerrorlog：Whichactionwouldallowtheservertostart?A、Removeib_logfile0andib_logfile1filesfromthefilesystem.B、Executemysqladminflush-logs.C、Firstrunmysqld--initializetorefreshthesizeofib_logfile.D、Createanewib_logfile0fileofsize26214400.答案：A52.

YouwishtostoretheusernameandpasswordforaclientconnectiontoMySQLserverinafileonalocalfilesystem.

Whichisthebestwaytoencryptthefile?A、UsetheAES_ENCRYPT()MySQLfunctionontheoptionfileB、Usemysql_secure_installationtoencryptstoredlogincredentials.C、UseatexteditortocreateanewdefaultsfileandencryptitfromLinuxprompt.D、Usemysql_config_editortocreateanencryptedfile.答案：D53.Youwanttodumpalldatabaseswithnamesthatstartwith"db".Whichmandwillachievethis?A、mysqIdump--include-tables=db.%--result-file=all_db_backup.sqlB、mysqldump--include-databases=db--result-file=all_db_backup.sqlC、mysqldump--include-databases=db.%--result-file=all_db_backup.sqlD、mysqldump>alldb_backup.sql答案：D解析：此題如果選項C是mysqlpump，那么就應(yīng)該選擇選項C。如果沒有mysqlpump的選項，則只能選擇選項D?？荚嚂r注意審題，看清選項。54.Examinethismand，whichexecutessuccessfully：Whichactivityisperformed?A、MySQLRouterisrestarted.B、MySQLRouterconfiguresalltheclusternodesbasedontheinformationretrievedfromtheInnoDBclustermetadataserver.C、MySQLRouterisconfiguredbasedontheinformationinfilesindirectory_path.D、MySQLRouterconfiguresitselfbasedontheinformationretrievedfromtheInnoDBclustermetadataserver.答案：D55.Examinethesestatementsandoutput：Whichstatementistrue?A、Theuserfailedtodefineausernameandtheconnectingusernamedefaultedto'''%'.B、Theuserisauthorizedasthersmithlocalhostuser.C、Theuserisauthenticatedastheanonymousproxyuser'''%'.D、Theuserisloggedinwith--user=accountingasanoption.E、Theuserisauthorizedastheaccountinglocalhostuser.答案：E56.

Whichsteporsetofstepscanbeusedtorotatetheerrorlog?A、ExecuteSETGLOBALlog_error='<newerrorlogfile>'.B、ExecuteSETGLOBALmax_error_count=<numberofmessagesatpointtorotate>.C、ExecuteSETGLOBALexpire_logs_days=0toenforcealogrotation.D、Renametheerrorlogfileondisk，andthenexecuteFLUSHERRORLOGS.答案：D57.Whichstatementistrue?A、Itdefinesauinnodbtablespaceoptionsrelativetoastartingparentdirectory.B、Itaddsmoretemporaryworkspaceinadditiontotheinnodb_tmpdirlocation.C、Itmovesallinnodbtablespacestothe/innodb_extrasdirectorytoenableanewInnodb_data_home_dirtobedefined.D、Itisnotnecessarybecauseinnodb_data_home_dirisalreadydefined.E、Itallowsscanningofotherlocationstodiscovermoreinnodbtablespaces答案：E58.YourMySQLenvironmenthasasynchronousposition-basedreplicationwithonemasterandoneslave.TheslaveinstancehadadiskI/Oproblemsoitwasstopped.Youdeterminedthattheslaverelaylogfileswerecorruptedandunusable,butnootherfilesaredamaged.YourestartMySQLServer.Howcanreplicationberestored?A、Therelaylogsfromthemastershouldbeusedtoreplacethecorruptedrelaylogs.B、Theslaverelaylogsshouldbedeleted;thenexecuteSTARTSLAVE;C、Theslaveneedstoberestoredfrombackup.D、Theslaverelaylogsshouldbedeleted;executeCHANGEMASTERtoadjustthereplicationrelaylogfilename,ThenissueSTARTSLAVE;答案：D59.TherehasbeenanaccidentaldeletionofdatainoneofyourMySQLdatabases.Youdeterminethatallentriesinthebinarylogfileafterposition1797mustbereplayedExaminethispartialmand：Whichoperationwillpletethemand?A、--write-to-remote-servermustbeaddedtothemandlinetoupdatethedatabasetables.B、ItcanbepipedintotheMySQLServerviathemand-lineclientC、Youmustuse--stop-position=1797toavoidtheDELETEstatementthatcausedtheinitialproblem.D、NochangesrequiredItautomaticallyupdatestheMySQLServerwiththedata答案：B60.ExaminethispartialoutputforInnoDBClusterstatus：Whichstatementexplainsthestateoftheinstancedeployedonhost2?A、Itcanrejointheclusterbyusingthemanddba.rebootClusterFrompleteOutage().B、Ithasbeenexpelledfromtheclusterbecauseofatransactionerror.C、Itcanrejointheclusterbyusingthemandcluster.addInstance('<user>host3:3377').D、IthasbeenremovedfromtheclusterbyusingthemandSTOPGROUP_REPLICATION；E、Itcanberecoveredfromadonorinstanceonhost3byusingthemandCluster.rejoinInstance('<user>host3:3377").答案：D61.

YouplantoupgradeyourMySQL5.7instancetoversion8.

Youhaveinstalledthe8buildofMySQLShell.

Examinethismandexecutedfromtheoperatingsystemshellprompt:

MysqlshurirootSlocalhost:3306--utilcheck-for-server-upgrade

Whichstatementistrue?A、Itdocumentsanyproblemswithyour5.7tablestomakethemreadytoupgradeto8.B、ItfailsbecausetheoperationnamemustbeincamelCase.C、Itfixesanyproblemswithyour5.7tablestomakethemreadytoupgradeto8.D、Itismandatorytoclearthehistoryofpriorresultsbeforeexecutingthisprocessasecondtimeorlater.E、ItfailsbecausecheckForServerUpgrademustbeexecutedonlywlthinanactiveshellsessionasamethodoftheutilobject.F、ItismandatorytorunthismandsothatMySQL8.0software'sauto-upgradeprocesshasthedetailsitneedstooperateproperly.答案：A62.

Youissuethismand:SHOWSLAVESTATUS\G

Intheoutput,thereisavalueforSecondsbehindmaster.

Howisthistimecalculated?A、ItisthetimebetweentheI/Othreadreceivingdetailsofthemaster'slasttransactionandthetimeitwaswrittentotherelaylogontheslave.B、ItisthetimebetweenthemostrecenttransactionappliedbyaSQLthreadandthetimeitwasmittedonthemaster.C、Itisthetimebetweenthemostrecenttransactionwrittentotherelaylogsandthetimeitwasmittedonthemaster.D、ItisthetimebetweentheI/Othreadreceivingdetailsofthemaster'slasttransactionandthetimeitwasappliedbytheSQL

Thread.答案：B63.Considerthisshelloutputandexecutedmanods:WhichstatementistrueaboutMySQLservershutdown?A、kill-15shouldbeavoided.Useothermethodssuchasmysqlariminshutdnwnorsyaramut1stopmysqld.B、kill-15andkill-9areeffectivelythesameforcedshutdownthatriskmittedtransactionsnotwrittentodisk.C、kill-15carriesoutanormalshutdownprocess,suchasmysqladminshutdown.D、mysqld_safeprohibitsmandsthatwouldharmtheoperationoftheserver.Anerrorwouldbereturnedbythekillmand.答案：C64.UsersreporterrorswhentryingtoconnectfromandisconnectingusingtheMysql_native_passwordauthenticationplugin.Examinethesemandsandoutput：Whichstatementidentifiesthecauseoftheerrors?A、max_connectionsistoosmallB、NetworkconnectivityissuesoccurringbetweenclientandtheMySQLinstance.C、ConnectionsareattemptedwithoutavaliduseraccountorpasswordD、Useraccountsaredefinedusingthemysql_native_paswordpluginforpasswordauthentication.E、thread_cacheistoosmallF、skip_name_resolveisenabled.答案：D65.

WhichcharactersaremostmonlyusedinaSQLinjectionattack?Choosethebestanswer.A、'and"B、<and>C、null(\0)andnewline(\n)D、^and$E、+and-答案：A66.Themysqldinstancehastheconnectioncontrolpluginenabledwiththesesettings：Theminimumandmaximumdelaysneedtobeincreasedto3000and5000respectivelyAmandisexecuted：Whatistheresult?A、Theminimumconnectionvalueischangedto2000.B、Onlytheminimumconnectionvalueisincreasedto3000.C、Theminimumvalueincreasesto3000andthemaximumvalueincreasesto4000.D、Anerrorisreturned.答案：D67.Examinethisparametersetting：Whateffectdoesthishaveonauditing?A、Itwillforcetheloadoftheauditpluginevenincaseoferrorsatserverstart.B、Itcausestheauditlogtobecreatedifitdoesnotexist.C、Itpreventstheauditpluginfrombeingremovedfromtherunningserver.D、Itpreventstheauditlogfrombeingremovedorrotated.答案：C68.

Choosethebestanswer.

Youexecutethismand：

Shell>mysqlpump--exclude-databases=%--users

Whichstatementistrue?A、Itcreatesalogicalbackupofallmetadata，butcontainsnotabledataB、ItretumsanerrorbecausethemysqldumpmandshouldhavebeenusedC、ItcreatesalogicalbackupofonlytheusersdatabaseD、ItcreatesalogicalbackupofallMySQLuseraccounts.答案：D69.

YouuseRowBasedReplicationandneedtosee"pseudo-SQL"statementsforthereplicationeventthatislocatedinthelog_filepositionNNNNNfile

Whichmandshouldyouuse?A、mysqlshow--debug--stop-position=NNNNN