多选题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 maintain a time-delayed copy of data on the secondary nodeCBoth technologies use the TCP/IP stack as their primary transmission mediumDDRBD uses shared-disk technology
多选题
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
参考解析
解析：
暂无解析
相关考题：
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 nodeB.Only MySQL can maintain a time-delayed copy of data on the secondary nodeC.Both technologies use the TCP/IP stack as their primary transmission mediumD.DRBD uses shared-disk technology
Which High Availability solution can provide a consistent, time－delayed (for example, one hour) snapshot of the live production database?() A.MySQL ReplicationB.Distributed Replication Block DeviceC.Windows Server Failover ClusteringD.MySQL Cluster
When backing up a replication slave, which three should also be backed up in addition to data?() A.The master.info and relay.info filesB.The relay log filesC.The relay index fileD.Mysql.slave_master_info tableE.Mysql.slave_relay_log_info tableF.Mysql.slave_worker_info table
Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?() A.Mysql NDB ClusterB.Mysql ReplicationC.Distributed Replicated Block Device (DRBD) and MysqlD.Windows Cluster and MysqlE.Solaris Cluster and Mysql
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_currentB.Using the statement RESET PERFORMANCE CACHEC.Using the statement FLUSH PERFORMANCE CACHED.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentE.Disabling and re-enabling all instrumentsF.Restarting Mysql
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 loggedB.111; top-level statements and all lower-level statements are loggedC.3; only the top-level statements are loggedD.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
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.
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 receivedB、store the alreadydeduplicated data stream unprocessedC、compare the incoming data to previously replicated data and store only the byte-level changesD、compare the incoming data to previously replicated data and store only the block-level changes
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 loggedB、111; top-level statements and all lower-level statements are loggedC、3; only the top-level statements are loggedD、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
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.
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.
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_currentB、Using the statement RESET PERFORMANCE CACHEC、Using the statement FLUSH PERFORMANCE CACHED、Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentE、Disabling and re-enabling all instrumentsF、Restarting Mysql
Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）A、MySQL ReplicationB、Distributed Replication Block DeviceC、Windows Server Failover ClusteringD、MySQL Cluster
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 localB、login-path can be used only for MySQL servers running on a local machineC、login-path allows you to provide login credentials without passing clear text passwords on the command lineD、When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later
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 nodeB、Only MySQL can maintain a time-delayed copy of data on the secondary nodeC、Both technologies use the TCP/IP stack as their primary transmission mediumD、DRBD uses shared-disk technology
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.
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
多选题Which two statements about the WLAN Solution Engine （WLSE） are true？（）AWLSE supports centralized configuration.BWLSE supports distributed configuration.CWLSE can pick up statistics on a device even if the device is not properly configured.DWLSE can be used to upgrade the firmware on APs and bridges.EWLSE monitors device fault and performance conditions but cannot report any policy misconfigurations
多选题Which two statements about Network Attached Storage are correct?（）AData is accessed using NFS or CIFS.BData is accessed at the block level.CNAS is referred to as captive storage.DStorage devices can be shared between users.EA NAS implementation is not as fast as a DAS implementation.
多选题Which two statements are true regarding the USING and ON clauses in table joins?（）ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
多选题Which two statements are true regarding partitioning in Mysql?（）ATables with BLOB and TEXT columns cannot be partitionedBPartitioning allows easier management of smaller data sets for certain queriesCPartitioning allows different columns to be stored in separate filesDThe partitioning expression is an integer or function that returns an integer value or NULL valueEPartitioning is only available for those storage engines that implements it natively
多选题Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?（）AMysql NDB ClusterBMysql ReplicationCDistributed Replicated Block Device (DRBD) and MysqlDWindows Cluster and MysqlESolaris Cluster and Mysql
多选题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 maintain a time-delayed copy of data on the secondary nodeCBoth technologies use the TCP/IP stack as their primary transmission mediumDDRBD uses shared-disk technology
单选题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：（）Acompress the incoming data stream as it is receivedBstore the alreadydeduplicated data stream unprocessedCcompare the incoming data to previously replicated data and store only the byte-level changesDcompare the incoming data to previously replicated data and store only the block-level changes
多选题What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）AFile system snapshotsBMysqldumpslowCMysqlhotcopyDMysqldump with – binary-data optionEMysql Enterprise Backup
多选题Certkiller.com has an active directory forest on a single domain. Certkiller needs a distributed application that employs a custom application. The application is directory partition software named PARDAT. You need to implement this application for data replication. Which two tools should you use to achieve this task（）ADnscmd.BNtdsutil.CIpconfigDDnsutilEAll of the above
多选题Which two statements correctly describe the relation between a data file and the logical database structures（）AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system （OS）blocks
多选题You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN. Which two statements are correct in this scenario？（）AYou must ensure that the SALES database is mounted or open.BYou must restore a backup control file to perform a block media recovery.CYou must take the tools01.dbf data file offline before you start a block media recovery.DYou must put the database in NOARCHIVELOG mode to perform a block media recovery.EYou can perform only a complete media recovery of individual blocks； point-in-time recovery of individual data blocks is not supported.