[简答题]There are two vacant seats___the plane.

[判断题]The belt on the vacant seat should be tighten before take-off and landing.
A.正确
B.错误

[单选题]5.If in a two-nation (A and B), two-commodity (X and Y) world, it is established that nation A has a comparative advantage in commodity X, then nation B must hav e:
A.A.an absolute advantage in commodity Y
B.B.an absolute disadvantage in commodity Y
C.C.a comparative disadvantage in commodity Y
D.D.a comparative advantage in commodity Y

[单选题]two.TherearefiveMySQLinstancesconfiguredwithaworkinggroupreplication.Examinetheoutputofthegroupmembers:mysql>SELECTMEMBER_IDMEMBER_STATEFROMperformance_schema.replication_group_members;Whichtwostatementsaretrueaboutnetworkpartitioninginthecluster?
A.Thegroupreplicationwillbufferthetransactionsontheonlinenodesuntiltheunreachablenodesreturnonline.
B.Amanualinterventiontoforcegroupmemberstobeonlytheworkingtwoinstancesis
Required.

[单选题]two.WhichtwostatementsaretrueaboutMySQLInstaller?
A.ItprovidesonlyGUI-driveninteractiveinstallations.
B.ItinstallsmostOracleMySQLproducts.
C.ManualdownloadofseparateproductpackagesisrequiredbeforeinstallingthemthroughMySQLInstaller.

[单选题]two.WhichtwostatementsaretrueaboutusingMySQLEnterpriseMonitorQueryAnalyzer?
A.Itispossibletoretrieveanormalizedstatementbutnevertheexactstatementthatwasexecuted.
B.ThesinglequeryQRTipiechartintheQueryAnalyzerviewisbasedontheaverageexecutionofallstatements.
C.ItispossibletoimportdataintotheQueryAnalyzerfromheterogeneoussourcessuchasCSV.
D.Itispossibletolistandanalyzestatementsinanarbitrarygraphrangeselectionfromtimeseries
Graphs.

[单选题]two.Youareusingmysqlcheckforservermaintenance.Whichtwostatementsaretrue?
A.Themysqlcheck--check--all-databasescommandtakestablewritelockswhileperformingaseriesofcecks.
B.Themysqlcheck--repair--all-databasescommandcanrepairanInnoDBcorruptedtable.
C.Themysqlcheck--analyze--all-databasescommandperformsaseriesofcheckstospoteventualtableorruptions.
D.Themysqlcheckcommandcanberenamedmysqlrepairsothatitrepairstablesbydefault.

[单选题]two.WhichtwoMySQLShellcommandsareexcludedfromtheInnoDBClustercreationprocedure?
A.cluster.addInstance(.#添加节点
B.dba.configureLocalInstance(.##持久化配置信息
C.dba.checkInstanceConfiguration(.##检查节点
D.cluster.setPrimaryInstance(.##设置主节点
E.dba.configureInstance(.##检查配置
F.dba.createCluster(.#创建集群
G.cluster.forceQuorumUsingPartitionOf(.#将集群从quorum丢失场景恢复到可操作状态。

[多选题]two.YouadministerathreenodesingleprimaryInnoDBCluster.Examinecluster.status(.displayedhere:"statusText":"ClusterisONLINEandcantolerateuptoONEfailure."Whichtwostatementsaretrue?
A.Iftwoinstancesareunreachablebecauseofnetworkfailuretheclusterwillreconfiguretoworkwithasingleinstance.
B.Reconfiguringtheclusterasmulti-primarywillincreasetolerancetotwofailures.
C.Thereisaquorumandtransactionscanbecommittednormally.
D.Iftwoinstancescrashitwillproduceanoutage.
E.Restartinganarbitraryinstancewillalwaysprovokeprimaryinstancefailover.
F.ShuttingdowntwoinstanceswiththeSHUTDOWNcommandwillproduceanoutage.

[多选题]two.WhichtwoaretrueaboutdifferencesbetweenlogicalandphysicalupgradesofMySQL
Databases?
A.Logicalupgradesaremuchfasterbecausetheydonotrequirerestartingthemysqldprocess.
B.Physicalupgradesaremuchfasterbecausetheydonotrequirerestartingthemysqldprocess.
C.Physicalupgradesareperformedforcurrentinstancesonbaremetaldeploymentswhereaslogicalupradesareusedforvirtualmachinesorcontainerizedinstances.
D.Post-upgradetablestoragerequirementsafterphysicalupgradesareusuallysmallerthanthatafterloicalupgrades.
E.Post-upgradetablestoragerequirementsafterlogicalupgradesareusuallysmallerthanthatafterphyicalupgrades.
F.Physicalupgradesleavedatainplacewhereaslogicalupgradesrequiredatatoberestoredfrommysqlump-typebackupstakenbeforetheupgrades.

[多选题]two.YourMySQLinstallationisrunninglowonspaceduetobinarylogs.Youneedtoreduceyurlogspaceusageurgently.Whichtwosetsofactionswhencompletedwillaccomplishthis?
A.UsePURGEBINARYLOGSto.
B.UseSETGLOBALbinlog_expire_logs_seconds=andruntheFLUSHBINARYLOGScommand.
C.UseSETGLOBALbinlog_expire_logs_seconds=andrestarttheserver.
D.UseSETPERSISTbinlog_expire_logs_seconds=.
E.Setbinlog_expire_logs_seconds=0inmy.cnfandrestarttheserver.
F.Setbinlog_expire_logs_secondsinmy.cnf.

[多选题]two.OnexaminationyourMySQLinstallationdatadirhasbecomerecursivelyworldread/write/executable.Whataretwomajorconcernsofrunninganinstallationwithincorrectfileprivileges?
A.ExtrastartuptimewouldberequiredfortheMySQLservertoresettheprivileges.
B.MySQLbinariescouldbedamageddeletedoraltered.
C.SQLinjectionscouldbeusedtoinsertbaddataintothedatabase.
D.Datafilescouldbedeleted.
E.Userscouldoverwriteconfigurationfiles.

[多选题]two.Whichtwostatementsaretrueaboutusingbackupsofthebinarylog?
A.Binarylogsarerelativelysmallandthereforeexcellentforlong-termstorageanddisasterrecovery.
B.Binarylogscanalwaysbeusedtounapplyunwantedschemachanges.
C.Multiplebinarylogscanbeusedtorestoredata.
D.Theyallowforpoint-in-timerecoveryofthedata.
E.Multiplebinarylogscanbeappliedinparallelforfasterdatarestoration.

[多选题]two.MaryconnectstoaLinuxMySQLServerfromaclientonaWindowsmachine.Examinethsstatementandoutput:Whichtwoaretrue?
A.MaryconnectedfromaclientmachinewhoseIPaddressis192.0.2.101.
B.MaryconnectedtothedatabaseserverwhoseIPaddressis192.0.2.101.
C.Maryhastheprivilegesofaccountmary@%.
D.MaryconnectedusingaUNIXsocket.
E.Maryauthenticatedtotheaccountmary@192.0.2.101.

[多选题]two.oumadesometabledefinitionchangestoaschemainyourMySQLServer.WhichtwostatementsreflecthowMySQLServerhandlesthetabledefinitionchanges?
A.MySQLServerstoresacopyoftheserializeddataintheInnoDBusertablespace.
B.MySQLwritesSDItothebinarylogfordistributedbackups.
C.MySQLimplicitlyexecutesFLUSHTABLESandstoresasnapshotbackupofthemetadata.
D.Themetadataisserializedin(SDI.
E.MySQLkeepsInnoDBmetadatachangesin.sdifilesindatadir.

[多选题]two.Examinethisstatementwhichexecutessuccessfully:CREATEUSERmary@192.0.2.100IDENTIFIEDBY'P@SSw0rd'REQUIRENONEPASSWORDEXPIRE;Whichtwoaretrue?
A.Marymustconnectusingtheusername'mary@192.0.2.100'.
B.MaryrequiresnopasswordtoconnecttotheMySQLserver.
C.Marymustconnectfromtheclientmachine192.0.2.100.
D.MarycannotconnecttotheMySQLserveruntiltheDBAresetsherpassword.
E.Marycannotquerydatauntilshechangesherpassword.

[多选题]two.ExaminethiscommandwhichexecutessuccessfullyonInnoDBCluster:dba.dropMetdataschema(.Whichtwostatementsaretrue?
A.Themysql_innodb_cluster_metadataschemaisdroppedfromtheinstancewheretheconnectionwaestablished.
B.GroupReplicationisstilloperationalbutInnoDBClustermustbereimportedunderMySQLShell.
C.Thecommanddropsthemysql_innodb_cluster_metadataschemaandre-createsit.
D.ConnectionsdrivenbyMySQLRouterarenotaffectedbythecommand.
E.Themysql_innodb_cluster_metadataschemaisdroppedfromallreachablemembersofthecluster.
F.GroupReplicationwillbedissolvedandallmetadatapurged.

[多选题]two.ExaminethisMySQLclientcommandtoconnecttoaremotedatabase:mysql-hremote.example.org-uroot-p--protocol=TCP--ssl-mode=Whichtwo--ssl-modevalueswillensurethatanX.509-compliantcertificatewillbeusedtoestablishtheSSL/TLSconnectiontoMySQL?
A.DISABLED
B.REQUIRED
C.VERIFY_IDENTITY.
D.PREFERED
E.VERIFY_CA

[多选题]two.WhichtwoareusecasesofMySQLasynchronousreplication?
A.Youcanscalereadsbyaddingmultipleslaves.
B.MySQLEnterpriseBackupwillautomaticallybackupfromanavailableslave.
C.Youcanscalewritesbycreatingareplicatedmesh.
D.Itguaranteesnearreal-timereplicationbetweenamasterandaslave.
E.Itallowsbackuptobedoneontheslavewithoutimpactingthemaster.