更多"[单选题] Three hundred miles ________ "的相关试题:
[单选题]three.Whicharethreebenefitsofusingmysqlbackupinsteadofmysqldump?
A.mysqlbackupcanperformpartialbackupofstoredprograms.
B.mysqlbackupallowslogicalbackupswithconcurrencyresultinginfasterbackupsandrestores.
C.mysqlbackupintegratestapebackupandhasthevirtualtapeoption.
D.mysqlbackupcanbackuptableswiththeInnoDBenginewithoutblockingreducingwaittimesduetocontention.
[多选题]three.Whichthreeactionsareeffectiveincapacityplanning?
A.addingcircularreplicationnodesforincreasedDMLcapability
B.buyingmoreRAM
C.buyingmoredisk
D.buyingmoreCPU
E.basingexpectedgrowthonanaverageofthelast3years
F.upgradingtothelatestapplicationversion
G.monitoringOSresourcesforpatterns
H.consultingtheapplicationteamaboutanyfutureprojectsanduse
[多选题]three.Whichthreerequirementsmustbeenabledforgroupreplication?
A.replicationfilters
B.semi-syncreplicationplugin
C.slaveupdateslogging
D.binarylogchecksum
E.primarykeyorprimarykeyequivalentoneverytable
F.binarylogMIXEDformat
G.binarylogROWformat
[多选题]three.Whichthreesetsofiteminformationarevisibleinthemysqlsystemdatabase?
A.timezoneinformationanddefinitions
B.helptopics
C.plugins
D.auditlogevents
E.performancemonitoringinformation
F.rollbacksegments
G.informationabouttablestructures
[多选题]three.WhichthreestatementsaretrueaboutMySQLreplication?
A.EachslavemusthaveitsownMySQLuserforreplication.
B.AreplicationusermusthavetheSELECTprivilegeforalltablesthatneedtobereplicated.
C.EachinstanceinareplicationtopologymusthaveauniqueserverID.
D.Anyinstancecanhavemultipleslavesbutitcanhaveonlyonemaster.
E.BinarylogscontainonlytransactionsoriginatingfromasingleMySQLinstance.
F.ReplicationcanuseonlyTCP/IPconnections.
G.Binaryloggingmustbeenabledonthemasterinordertoreplicatetootherinstances.
[多选题]three.WhichthreeactionswillsecureaMySQLserverfromnetwork-basedattacks?
A.Constructaperimeternetworktoallowpublictraffic
B.PlacetheMySQLinstancebehindafirewall.
C.Usenetworkfilesystem(NFS.forstoringdata.
D.Changethelisteningportto3307.
E.UseMySQLRoutertoproxyconnectionstotheMySQLserver.
F.Allowconnectionsfromtheapplicationserveronly.
[多选题]three.AuserwantstoconnectwithoutenteringhisorherusernameandpasswordontheLinux
Commandprompt.Whichthreelocationscanbeusedtostoretheuser'smysqlcredentialstosatisfythisrequirement?
A.$HOME/.mysqlrcfile
B./etc/my.cnffile
C.DATADIR/mysqld-auto.cnffile
D.$HOME/.my.cnffile
E.$HOME/.mylogin.cnffile
F.$MYSQL_HOME/my.cnffile
G.$HOME/.mysql/auth/loginfile
[多选题]three.WhichthreecommandscanreportallthecurrentconnectionsrunningontheMySQLserver?
A.SELECT*FROMperformance_schema.events_transactions_current
B.SELECT*FROMperformance_schema.threads
C.SHOWFULLPROCESSLIST
D.SELECT*FROMinformation_schema.processlist
E.SHOWEVENTS
F.SELECT*FROMsys.metrics
G.SELECT*FROMinformation_schema.events
H.SELECT*FROMsys.statement_analysis
[多选题]three.WhichthreesettingscontrolglobalbufferssharedbyallthreadsonaMySQLserver?
A.tmp_table_size
B.innodb_buffer_pool_size
C.table_open_cache
D.sort_buffer_size
E.key_buffer_size
F.read_buffer_size
[多选题]three.Examinethesestatementswhichexecutesuccessfully:TRUNCATEtest;BEGIN;INSERTINTOtest(idname.VALUES(1"Hello".;ROLLBACK;SELECTidFROMtest;Whichthreestorageengineswouldreturnanonemptyrecordsetforthetesttablewhenexecutingthestatements?
A.MEMORY
B.BLACKHOLE
C.ARCHIVE
D.NDB
E.MyISAM
F.InnoDB
[多选题]three.AMySQLserverismonitoredusingMySQLEnterpriseMonitor'sagentlessinstallation.Whichthreefeaturesareavailablewiththisinstallationmethod?
A.MySQLReplicationmonitoring
B.security-relatedadvisorwarnings
C.CPUutilization
D.diskusageanddiskcharacteristicsincludingdiskadvisorswarnings
E.MySQLQueryAnalysisdata
F.operatingsystemmemoryutilization
G.network-relatedinformationandnetworkcharacteristics
[多选题]three.Whichthreearecharacteristicsofanewlycreatedrole?
A.Itisstoredinthemysql.roletable.
B.ItcanbedroppedusingtheDROPROLEstatement.
C.Itcanbeprotectedwithapassword.
D.Itcanbegrantedtouseraccounts.
E.ItcanberenamedusingtheRENAMEROLEstatement.
F.Itiscreatedasalockedaccount.
[多选题]three.Examinethiscommandwhichexecutessuccessfully:cluster.addInstance('
@:'{recoveryMethod:'clone'}.Whichthreestatementsaretrue?
A.Itisalwaysslowerthan{recoveryMethod:'incremental'}.
B.InnoDBtablespacesoutsidethedatadirareabletobecloned.
C.Atargetinstancemustexistthenitwillbeprovisionedwithdatafromaninstancealreadyin
Theclusterandjoinedtothecluster.
D.TheaccountusedtoperformthisrecoveryneedstheBACKUP_ADMINprivilege.
E.Anewinstanceisinstalledinitializedandprovisionedwithdatafromaninstancealreadyintheclusterandjoinedtothecluster.
F.InnoDBredologsmustnotrotateforthedurationoftheexecution;otherwisetherecoverywillfail.
[多选题]three.YourMySQLserverisrunningontheMicrosoftWindowsplatform.Whichthreelocalconnectionprotocolsareavailabletoyou?
A.UDP
B.sharedmemory
C.SOCKET
D.namedpipes
E.XProtocol
F.TCP/IP
[多选题]three.WhichthreearerequirementsforasecureMySQLServerenvironment?
A.Minimizethenumberofnon-MySQLServer-relatedprocessesrunningontheserverhost.
B.RestrictthenumberofOSusersthathaveaccessattheOSlevel.
C.EnsureappropriatefilesystemprivilegesforOSusersandgroups.
D.KeeptheentiresoftwarestackononeOShost.
E.Encryptthefilesystemtoavoidneedingexactfile-systempermissions.
F.RunMySQLserverastherootusertopreventincorrectsudosettings.
[多选题]three.YoumustrunmultipleinstancesofMySQLServeronasinglehost.Whichthreemethodsaresupported?
A.UsesystemtoolstolockeachinstancetoitsownCPU.
B.UseresourcegroupstolockdifferentinstancesonseparateCPUs.
C.Runmysqldwith--datadirdefinedforeachinstance.
D.RunMySQLServerdockercontainers.
E.Startmysqldormysqld_safeusingdifferentoptionfilesforeachinstance.
F.Usesystemdwithdifferentsettingsforeachinstance.
[多选题]three.WhichthreestatementsaretrueaboutMySQLEnterpriseFirewall?
A.OnWindowssystemsitiscontrolledandmanagedusingtheWindowsInternetConnectionFirewallcontrolpanel.
B.Systemtablesnamedfirewall_usersandfirewall_whitelistinthemysqldatabaseprovide
Persistentstorageoffirewalldata.
C.ItisavailableonlyinMySQLEnterpriseversions.
D.ItprovidesINFORMATION_SCHEMAtablesthatenableviewsintofirewalldata.
E.FirewallfunctionalityisdependentonSHA-256andANSI-specificfunctionsbuiltintothemysql.firewalltable.
F.Itshowsonlynotificationsforblockedconnectionswhichoriginatedoutsideofyournetwork'sprimarydomain.
[多选题]three.WhichthreemethodsdisplaythecompletetabledefinitionofanInnoDBtable?
A.hexdump-v-Ctable.frm
B.REPAIRTABLEtableUSE_FRM
C.mysqldump--no-dataschematable
D.QuerytheInformationSchema.
E.SELECT*FROMtable1\G
F.SHOWCREATETABLE
[多选题]three.IdentifythreefunctionsofMySQLEnterpriseMonitor.
A.Analyzequeryperformance.
B.Startalogicalbackup.
C.DeterminetheavailabilityofmonitoredMySQLservers.
D.Centrallymanageusers.
E.StartaMySQLEnterprisebackup.
F.Centrallymanageserverconfigurations.
G.StartandstopMySQLServer.
H.Createcustomizedalertsandprovidenotificationalerts.
