[简答题]After two months they__in the countryside.

[单选题]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

[单选题]‡- 17It took the experts several months to decide on the _( ) for the new airport. 
A.

source

B.

earth

C.

site

D.

character

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

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

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

[单选题]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.WhichtwoqueriesareexamplesofsuccessfulSQLinjectionattacks?
A.SELECTuserpasswdFROMmembers
WHEREuser='?';INSERTINTOmembers('user''passwd'.VALUES('bob@example.com''secret'.;--';
B.SELECTuserphoneFROMcustomersWHEREname='\;DROPTABLEusers;--';
C.SELECTidnameFROMuserWHEREuser.id=(SELECTmembers.idFROMmembers.;
D.SELECTidnameFROMuserWHEREid=23ORid=32OR1=1;
E.SELECTidnameFROMuserWHEREid=23ORid=32AND1=1;
F.SELECTemailpasswdFROMmembers
WHEREemail='INSERTINTOmembers('email''passwd'.VALUES
('bob@example.com''secret'.;--';

[多选题]two.Whichtwoaretrueaboutbinarylogsusedinasynchronousreplication?
A.Themasterconnectstotheslaveandinitiateslogtransfer.
B.Theycontaineventsthatdescribeallqueriesrunonthemaster.
C.Theycontaineventsthatdescribedatabasechangesonthemaster.
D.Theyarepulledfromthemastertotheslave.
E.Theycontaineventsthatdescribeonlyadministrativecommandsrunonthemaster.

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

[多选题]two.Whichtwostorageenginesprovideaviewofthedataconsistentwiththestoragesystematanymoment?
A.InnoDB
B.ARCHIVE
C.MyISAM
D.MEMORY
E.NDB

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

[多选题]two.AllMySQLServerinstancesbelongingtoInnoDBClusterhaveSSLconfiguredandenabled.YoumustconfigureInnoDBClustertouseSSLforgroupcommunication.Whichtwostatementsaretrue?
A.AnexistingInnoDBClustermustbedissolvedandcreatedfromscratchtoenableSSLforgroupcommuncation.
B.IfonlysomeInnoDBClustermembersareenabledforSSLgroupcommunicationand--ssl-mode=PREFRREDcommunicationwillfallbacktounencryptedconnection.
C.SSLgroupcommunicationmustbeenabledatclustercreationtimebyspecifyingcreateCluster({memberSslMode:'REQUIRED'}.
D.SSLgroupcommunicationcanbeenabledforanexistingclusteroneinstanceattimebysettinggroup_eplication_ssl_mode.
E.SSLgroupcommunicationrequirestheuseofanadditionalsetofparametersgroup_replication_recovery_*.
F.ConfiguringSSLgroupcommunicationalsoconfiguresSSLdistributedrecovery.

[多选题]two.WhichtwostatementsaretrueaboutMySQLservermulti-sourcereplication?
A.ItmustuseGTIDreplication.
B.Itisnotcompatiblewithauto-positioning.
C.Itneedstobere-instancedafteracrashtomaintainconsistency.
D.Itusesonlytime-basedreplicationconflictresolution.
E.Itdoesnotattempttodetectorresolvereplicationconflicts.
F.Itreliesonrelay_log_recoveryforresilientoperations.

[多选题]two.WhichtwostatementsaretrueaboutMySQLEnterpriseBackup?
A.Itcreateslogicalbackups.
B.Itsupportsbackinguponlytablestructures.
C.Itcanperformhotorwarmbackups.
D.ItsupportsbackupofaremoteMySQLsystem.
E.ItsupportsrestoringtoaremoteMySQLsystem.
F.Itsupportsthecreationofincrementalbackups.

[多选题]two.Whichtwostatementsaretrueaboutgeneraltablespaces?
A.Generaltablespacessupporttemporarytables.
B.Droppingatablefromageneraltablespacereleasesthespacebacktotheoperatingsystem.
C.Anewtablecanbecreatedexplicitlyinageneraltablespace.
D.Anexistingtablecanbemovedintoageneraltablespace.
E.Ageneraltablespacecanhavemultipledatafiles.

[多选题]two.AnexistingasynchronousreplicationsetupisrunningMySQL8.WhichtwostepsareapartofimplementingGTIDreplication?
A.EnableGTIDbyexecutingthisonthemasterandtheslave:SETGLOBALGTID_ENABLED=on;
B.OntheslavealtertheMySQLmasterconnectionsettingwith:
ALTERchannelCHANGEMASTERTOMASTER_AUTO_POSITION=1;
C.ExecutethisontheslavetoenableGTID:RESETSLAVE;STARTSLAVEGTID_NEXT=AUTOMATIC;
D.ExecutethisontheslavetoenableGTID:STARTSLAVEIO_THREADWITHGTID;
E.RestartMySQL(masterandslave.withtheseoptionsenabled:--gtid_mode=ON--log-bin--log-slave-updates--enforce-gtid-consistency
F.OntheslavealtertheMySQLmasterconnectionsettingwith:CHANGEMASTERTOMASTER_AUTO_PSITION=1;