问题:单选题Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECT e . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone_no, ' – ') AS 'office_no' 'coalesce (ph2 .phone_no, ' – ') AS 'cell_no' FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = 'office' LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = 'mobile' The tables employees and employee_phone are InnoDB tables; all columns are used in this view. The contents of the phone_list view are as follows: Mysql> select * from phone_list; 1 row in set (0.00 sec) Which method can you use to change the cell_no value to '555-8888' for John Doe?()A INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile')B UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe'C DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888)D UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1
查看答案
问题:多选题What are three facts about backups with mysqldump?()ACan back up a remote database serverBAllow a consistent backup to be takenCAre always faster to restore than binary backupsDAre able to back up specific items within a databaseECreate automatically compressed backupsFWill lock all storage engines for duration of backup
问题:多选题Which two are correct steps in taking a binary backup of MyISAM tables?()AAlways stop the server prior to the backupBStop the server or lock the tables prior to the backupCStop the server or lock the databases prior to the backupDMake a copy of the .frm, .myd, and the .myi filesEMake a copy of the binary log and tablespace files
问题:多选题Which two statements describe the behavior of the server's SQL mode?()AThe server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxBThe server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATECThe server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value commandDThe server's SQL mode, when globally set on a slave server, applies to events sent from the master
问题:单选题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
问题:多选题Which three methods will show the storage engine for the Country table?()AABBCCDDEE
问题:单选题You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?()A Mysqld uses internal configuration versioning and reverts to the previous configurationB When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakesC The mysqld_safe script skips the unknown variable and starts using the remaining configuration changesD Mysqld prints to the error log about an unknown variable, and then exits
问题:单选题While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?()A Activating the MySQL Enterprise thread pool pluginB Relocating your data and log files to separate storage devicesC Disconnecting idle localhost client sessionsD Implementing storage engine data compression options
问题:单选题You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as follows: The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query: SELECT TABLE_SCHEMA, 'ENGINE', COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= 'BASE TABLE' GROUP BY TABLE_SCHEMA, 'ENGINE' ; Why is this query slow to execute?()A Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tablesB Aggregating details from various storage engine caches for the final output is time consumingC Collecting information requires various disk-level operations and is time consumingD Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming
问题:多选题When backing up a replication slave, which three should also be backed up in addition to data?()AThe master.info and relay.info filesBThe relay log filesCThe relay index fileDMysql.slave_master_info tableEMysql.slave_relay_log_info tableFMysql.slave_worker_info table
问题:多选题Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?()AMysql> USE sakila; LOAD DATA INFILE 'sakila2013.sql';BShell> mysql –u root –p sakila sakila2013.sqlCShell> mysql import –u root –p sakila sakila2013.sqlDShell> mysql –u root -p –e 'use sakila; source sakila2013.sql'EShell> mysql –u root –p –silent < sakila2013.sql
问题:多选题You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?()AUse the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORYBChange the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY tableCStop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary tableDSet binlog_format=MIXED with the – replicate-ignore-temp-table optionEUse the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
问题:单选题You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?()A The snapshot size will continue to grow as changes to the volume are madeB The snapshots take a significant amount of disk space as they are a duplicate copy of the dataC The system can only support one snapshot per volume, and you need to remove it to be able to take your next backupD The system keeps a copy of changes in memory and can cause an out of memory event
问题:多选题Which two requirements would lead towards a high availability solution?()AWhen uptime is criticalBWhen data must be refactoredCWhen application concurrency is staticDWhen data loss is unacceptableEWhen application is a single point of failure
问题:多选题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?()AThe slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sqlBThe slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows functionCFor tables with UNIQUE keys, statement-based replication must be used maintain integrityDThe root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewriteEThe applications have the SUPER privilege, which allows them to update rows
问题:多选题What are four capabilities of the mysql client program?()ACreating, dropping, and modifying tables and indexesBInitiating a binary backup of the database by using the START BACKUP commandCDisplaying replication status informationDShutting down the server by using the SHUTDOWN commandECreating and dropping databasesFCreating and administering users
问题:多选题Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?()AUsing DELETE statements, for example, DELETE FROM performance_schema.events_watis_currentBUsing the statement RESET PERFORMANCE CACHECUsing the statement FLUSH PERFORMANCE CACHEDUsing TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentEDisabling and re-enabling all instrumentsFRestarting Mysql
问题:单选题Consider the following: Which statement best describes the meaning of the value for the key_len column?()AIt shows the total size of the index rowBIt shows how many columns in the index are examinedCIt shows the number of characters indexed in the keyDIt shows how many bytes will be used from each index row
问题:单选题ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 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 684 Why did you receive this error?()A The slave SQL thread does not have DELETE privileges to execute on test.t1 table.sB The table definition on the slave -litters from the masterC Multi-threaded replication slaves can have temporary errors occurring for cross database updatesD The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist