多选题Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（）ABoth technologies guarantee an identical copy of data on the secondary nodeBOnly MySQL can

第1题：

第2题：

第3题：

Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）

• A、12; only top-level statements and stored procedure events are logged
• B、111; top-level statements and all lower-level statements are logged
• C、3; only the top-level statements are logged
• D、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event

第4题：

Which two statements about Network Attached Storage are correct?（）

• A、Data is accessed using NFS or CIFS.
• B、Data is accessed at the block level.
• C、NAS is referred to as captive storage.
• D、Storage devices can be shared between users.
• E、A NAS implementation is not as fast as a DAS implementation.

第5题：

Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）

• A、MySQL Replication
• B、Distributed Replication Block Device
• C、Windows Server Failover Clustering
• D、MySQL Cluster

第6题：

Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（）

• A、Both technologies guarantee an identical copy of data on the secondary node
• B、Only MySQL can maintain a time-delayed copy of data on the secondary node
• C、Both technologies use the TCP/IP stack as their primary transmission medium
• D、DRBD uses shared-disk technology

第7题：

Which two statements are true regarding the USING and ON clauses in table joins?（）

• A、Both USING and ON clauses can be used for equijoins and nonequijoins 
• B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
• C、The ON clause can be used to join tables on columns that have different names but compatible data types 
• D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

A manufacturing company is using ProtecTIER TS7610 appliances in a spoke and hubconfiguration. ProtecTIER’s TS7610 replication technology at the hub will perform the followingaction on the replicated data being received：（）

• A、compress the incoming data stream as it is received
• B、store the alreadydeduplicated data stream unprocessed
• C、compare the incoming data to previously replicated data and store only the byte-level changes
• D、compare the incoming data to previously replicated data and store only the block-level changes

第15题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for a financial services company. Replication is configured between two SQL Server 2005 computers， and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a large amount of data. Since you are the database administrator， you need to make sure that data is replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during replication. In addition， you need to make sure that this data is replicated securely.  Which action should be performed？（）

• A、Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.
• B、Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for a standard subscription.
• C、Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.
• D、Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for an updateable subscription.

第16题：

Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）

• A、Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
• B、Using the statement RESET PERFORMANCE CACHE
• C、Using the statement FLUSH PERFORMANCE CACHE
• D、Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
• E、Disabling and re-enabling all instruments
• F、Restarting Mysql

第17题：

You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?（）

• A、All system users have access to the MySQL server via—login path local
• B、login-path can be used only for MySQL servers running on a local machine
• C、login-path allows you to provide login credentials without passing clear text passwords on the command line
• D、When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later

第18题：

You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

• A、 You must ensure that the SALES database is mounted or open.
• B、 You must restore a backup control file to perform a block media recovery.
• C、 You must take the tools01.dbf data file offline before you start a block media recovery.
• D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.
• E、 You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：