多选题Which two events will cause a slave server to create a new relay log file?（）AExecution of the FLUSH LOGS statementBStarting of the SQL threadCReaching the slave_pendign _jobs_size_max limitDExecution of FULSH TABLES WITH READ LOCKEStarting of the I/O t

题目
多选题
Which two events will cause a slave server to create a new relay log file?（）
A

Execution of the FLUSH LOGS statement

B

Starting of the SQL thread

C

Reaching the slave_pendign _jobs_size_max limit

D

Execution of FULSH TABLES WITH READ LOCK

E

Starting of the I/O thread

相似考题

1.A MySQL replication slave is set up as follows: User all InnoDB tablesReceives ROW-based binary logs Has the read-only optionThe replication slave has been found in an error state.You check the MySQL error log file and find the following entries:2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 10622013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’Error_code: 10622013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix theproblem, and restart the slave SQL thread with SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?（）A.The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sqlB.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows functionC.For tables with UNIQUE keys, statement-based replication must be used maintain integrityD.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewriteE.The applications have the SUPER privilege, which allows them to update rows

2.Which two events will cause a slave server to create a new relay log file?()A.Execution of the FLUSH LOGS statementB.Starting of the SQL threadC.Reaching the slave_pendign _jobs_size_max limitD.Execution of FULSH TABLES WITH READ LOCKE.Starting of the I/O thread

3.Which statement is true about FLUSH LOGS command?()A.It requires the RELOAD, FILE, and DROP privilegesB.It closes and reopens all log filesC.It closes and sends binary log files to slave serversD.It flushes dirty pages in the buffer pool to the REDO logs

4.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

更多“多选题Which two events will cause a slave server to create a new relay log file?（）AExecution of the FLUSH LOGS statementBStarting of the SQL threadCReaching the slave_pendign _jobs_size_max limitDExecution of FULSH TABLES WITH READ LOCKEStarting of the I/O t”相关问题

  • 第1题：

    You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.

    You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.

    The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.

    Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)

    A. On drive C, create a transaction log.

    On drive D, create a data file in the PRIMARY filegroup.

    On drive E, create a data file in the SECONDARY filegroup.

    B. On each drive, create a transaction log.

    On each drive, create a data file in the PRIMARY filegroup.

    C. On drive D, create a transaction log.

    On drive E, create a data file in the PRIMARY filegroup.

    D. On the PRIMARY filegroup, create all tables and all indexes.

    E. On the PRIMARY filegroup, create all tables. On the SECONDARY filegroup, create all indexes.

    F. On the PRIMARY filegroup, create the Parts table and its indexes.

    On the SECONDARY filegroup, create all other tables and their indexes.


    正确答案：AE
    A,E 解析：Explanation:
    A: The transaction log should be placed on a separate disk. A transaction log would not benefit of two or more disks since it is sequential. Create two data files on two separate physical disks would improve performance.

    E: Separating the tables and the indexes improve performance for in particular joins.

    Note: With SQL Server 2000 it is possible to create tables or indexes on specific filegroups. This allows us to control where the database's tables and indexes are physically located as filegroups can be placed on different hard drives. Placing tables in one filegroup and the table's nonclustered indexes in another filegroup on different physical disk can improve database performance because it will allow separate threads to access the tables and indexes.

    However, a table and its clustered index cannot be separated into different filegroups as the clustered index determines the physical order of the data in the table. Furthermore, the transaction log should be placed on a physically separate disk. The transaction log file is written serially; therefore, using a separate, dedicated disk allows the disk heads to stay in place for the next write operation. This will further improve performance.

    Incorrect Answers:
    B: To improve performance, the transaction log should not be placed on the same physical disk that the tables or indexes are placed on. The transaction log file is written serially; therefore, placing it on a separate, dedicated disk allows the disk heads to stay in place for the next write operation and thus improves performance.

    Furthermore, placing tables in one filegroup and the table's nonclustered indexes in another filegroup on different physical disk can improve database performance because it will allow separate threads to access the tables and indexes. However, a table and its clustered index cannot be separated into different filegroups as the clustered index determines the physical order of the data in the table.

    C: The transaction log should be placed on a physically separate disk. The transaction log file is written serially; therefore, using a separate, dedicated disk allows the disk heads to stay in place for the next write operation. This will further improve performance. In this solution, the tables and their indexes are placed on the same disk. This solution thus does not take advantage of the performance improvements that can be realised through the correct utlization of the available hardware.

    D: In this solution, the tables and their indexes are placed on the same disk. This solution thus does not take advantage of the performance improvements that can be realised through the correct utlization of the available hardware.

    F: Greater performance gains can be realized by placing tables in one filegroup and the table’s nonclustered indexes in another filegroup on different physical disk. This will allow separate threads to access the tables and indexes.

  • 第2题：

    You need to design a strategy to log access to the company Web site. What should you do？（）

    • A、Enable logging on the company Web site and select the NCSA Common Log File Format. Store the log files on a SQL Server computer
    • B、Use System Monitor to create a counter log that captures network traffic to the Web server by using the Web Service object. Store the log files on a SQL Server computer
    • C、Run the Network Monitor on the Web server. Create a capture filter for the SNA protocol and save the results to a capture file. Store the capture file on a SQL Server computer
    • D、Enable logging on the company Web site and select ODBC Logging. Configure the ODBC logging options by using a nonadministrative SQL account

    正确答案:D

  • 第3题：

    Which two create an InputStream and open file the “file.txt” for reading？ （）

    • A、 InputStream in=new FileReader（“file.txt”）；
    • B、 InputStream in=new FileInputStream（“file.txt”）；
    • C、 InputStream in=new InputStreamFileReader （“file.txt”， “read”）；
    • D、 FileInputStream in=new FileReader（new File（“file.txt”））；
    • E、 FileInputStream in=new FileInputStream（new File（“file.txt”））；

    正确答案:B,E

  • 第4题：

    An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）

    • A、STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383
    • B、STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383
    • C、STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE
    • D、STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE

    正确答案:C

  • 第5题：

    Which statement is true about FLUSH LOGS command?（）

    • A、It requires the RELOAD, FILE, and DROP privileges
    • B、It closes and reopens all log files
    • C、It closes and sends binary log files to slave servers
    • D、It flushes dirty pages in the buffer pool to the REDO logs

    正确答案:B

  • 第6题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. In the options below, which log should you check?（）  

    • A、You should check SQL1.log
    • B、You should check SQLAGENT.OUT
    • C、You should check log_xx.trc
    • D、You should check ERRORLOG

    正确答案:B

  • 第7题：

    You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） 

    • A、Create the database by using a single data file and a single log file.
    • B、Create the database by using a single data file and multiple log files.
    • C、Create the database by using a single log file and multiple filegroups.
    • D、Create the database by using a single log file and a filegroup that has multiple data files.

    正确答案:C

  • 第8题：

    You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. Your network includes domain controllers, file and print servers, and application servers. The application servers run a variety of programs, including Microsoft SQL Server 2000 and Microsoft Exchange Server 2003. Your staff are responsible for monitoring current system performance on all servers. You need to enable your staff to use System Monitor to gather performance data for each unique server type. The data will be used for trend analysis and forecasting. Which two actions should you perform? （）(Each correct answer presents part of the solution. Choose two)

    • A、For each server, add the most common performance counters and save them as an HTML file.
    • B、For each server, add the most common performance counters and save them as a counter report file.
    • C、Create trace logs based on the file and schedule and trace logs to gather data.
    • D、Create alerts on the file and schedule the alerts to gather data.
    • E、Create counter logs based on the file and schedule the counter logs to gather data.

    正确答案:A,E

  • 第9题：

    多选题
    A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary logs Has the read-only option The replication slave has been found in an error state. You check the MySQL error log file and find the following entries: 2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’ Error_code: 1062 2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?（）
    A

    The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql

    B

    The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function

    C

    For tables with UNIQUE keys, statement-based replication must be used maintain integrity

    D

    The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite

    E

    The applications have the SUPER privilege, which allows them to update rows


    正确答案： A,E
    解析： 暂无解析

  • 第10题：

    多选题
    Which two events will cause a slave server to create a new relay log file?（）
    A

    Execution of the FLUSH LOGS statement

    B

    Starting of the SQL thread

    C

    Reaching the slave_pendign _jobs_size_max limit

    D

    Execution of FULSH TABLES WITH READ LOCK

    E

    Starting of the I/O thread


    正确答案： B,E
    解析： 暂无解析

  • 第11题：

    多选题
    When backing up a replication slave, which three should also be backed up in addition to data?（）
    A

    The master.info and relay.info files

    B

    The relay log files

    C

    The relay index file

    D

    Mysql.slave_master_info table

    E

    Mysql.slave_relay_log_info table

    F

    Mysql.slave_worker_info table


    正确答案： D,F
    解析： 暂无解析

  • 第12题：

    多选题
    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


    正确答案： D,E
    解析： 暂无解析

  • 第13题：

    Which two statements describe the behavior of the server's SQL mode?（）

    • A、The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax
    • B、The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE
    • C、The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command
    • D、The server's SQL mode, when globally set on a slave server, applies to events sent from the master

    正确答案:A,C

  • 第14题：

    Which two statements regarding system logging on a Juniper enterprise router are correct？（）

    • A、The system log has a proprietary format.
    • B、System logs must be sent to a remote device.
    • C、New system logs can be created and archived.
    • D、Most software processes create their own logs.

    正确答案:C,D

  • 第15题：

    An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）

    • A、Gtid_mode must be set to AUTO during point in time recoveries
    • B、Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs
    • C、The server keeps track of which GTIDs have already been executed and skips those
    • D、Enforce_gtid_consistency is set to ON

    正确答案:C

  • 第16题：

    Which two events will cause a slave server to create a new relay log file?（）

    • A、Execution of the FLUSH LOGS statement
    • B、Starting of the SQL thread
    • C、Reaching the slave_pendign _jobs_size_max limit
    • D、Execution of FULSH TABLES WITH READ LOCK
    • E、Starting of the I/O thread

    正确答案:A,E

  • 第17题：

    You manage a SQL Server 2005 computer that was installed using default settings. After a power failure， the SQL Server （MSSQLSERVER） service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform？（）

    • A、In Event Viewer， view the system log.
    • B、In Event Viewer， view the application log.
    • C、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog.1 file.
    • D、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog file.
    • E、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/SQLAgent.out file.

    正确答案:A,B,D

  • 第18题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E://drive. The job logs information to the text file. You get a report from users saying that the server doesn'；t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn'；t function any loner. As the IT support， you have to identify the reason for the failure of the SQL Server Agent service.  Which log should you check？ （）

    • A、You should check ERRORLOG
    • B、You should check QL1.log
    • C、You should check SQLAGENT.OUT
    • D、You should check log_xx.trc

    正确答案:C

  • 第19题：

    You are one of the network administrators for All network servers run Windows Server 2003. TestKing operates a total of four offices. The office where you work has 15 servers. You are responsible for supporting and maintaining all of these servers. You need to design a monitoring plan that will achieve the following goals: 1. Track all performance changes on the servers. 2. Record performance data to anticipate the need for future upgrades. What should you do?（）

    • A、On each server in your office, use Performance Logs and Alerts to create a baseline log. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.
    • B、From a monitoring computer, use Performance Logs and Alerts to create a baseline log for each server in your office. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.
    • C、On each server in your office, use Performance Logs and Alerts to create threshold-based alerts. Configure the alerts to send a message to your monitoring computer when they are triggered. Set each alert to start a new scan when the alert finishes.
    • D、From a monitoring computer use Performance Logs and Alerts to create a new counter set in System Monitor. Configure the counters to run continuously.

    正确答案:B

  • 第20题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive.  In the options below, which log should you check? （） 

    • A、You should check SQL1.log 
    • B、You should check SQLAGENT.OUT 
    • C、You should check log_xx.trc 
    • D、You should check ERRORLOG 

    正确答案:B

  • 第21题：

    多选题
    You manage a SQL Server 2005 computer that was installed using default settings. After a power failure， the SQL Server （MSSQLSERVER） service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform？（）
    A

    In Event Viewer， view the system log.

    B

    In Event Viewer， view the application log.

    C

    In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog.1 file.

    D

    In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog file.

    E

    In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/SQLAgent.out file.


    正确答案： E,B
    解析： 暂无解析

  • 第22题：

    多选题
    Which two create an InputStream and open file the “file.txt” for reading？ （）
    A

    InputStream in=new FileReader（“file.txt”）；

    B

    InputStream in=new FileInputStream（“file.txt”）；

    C

    InputStream in=new InputStreamFileReader （“file.txt”， “read”）；

    D

    FileInputStream in=new FileReader（new File（“file.txt”））；

    E

    FileInputStream in=new FileInputStream（new File（“file.txt”））；


    正确答案： D,C
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements describe the behavior of the server's SQL mode?（）
    A

    The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax

    B

    The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE

    C

    The server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value command

    D

    The server's SQL mode, when globally set on a slave server, applies to events sent from the master


    正确答案： D,A
    解析： 暂无解析

  • 第24题：

    多选题
    A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary logs Has the read-only option The replication slave has been found in an error state. You check the MySQL error log file and find the following entries: 2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’ Error_code: 1062 2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?（）
    A

    The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql

    B

    The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function

    C

    For tables with UNIQUE keys, statement-based replication must be used maintain integrity

    D

    The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite

    E

    The applications have the SUPER privilege, which allows them to update rows


    正确答案： A,D
    解析： 暂无解析

相关内容