问题：多选题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
Monday, November 4, 2024
问题：多选题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
Sunday, October 20, 2024
问题：多选题Which three statements are true about memory buffer allocation by a MySQL Server?（）AGlobal buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freedBThread buffers are allocated when a client connects, and are freed when the client disconnectsCBuffers that are needed for certain operation are allocated when the operation starts, and freed when it endsDUser buffers are allocated at server startup and freed when the user is droppedEAll dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
Sunday, November 17, 2024
问题：多选题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
问题：单选题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
问题：单选题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
Tuesday, July 16, 2024
问题：单选题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
问题：单选题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
Thursday, September 19, 2024
问题：多选题A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）ADisabling connections from named pipes or socket files (depending on the operating system of the server)BEnabling and using SSL for connections to the Mysql databaseCInstalling Mysql on the application server, and running the database and application on the same serverDStarting the server with – bind- address=0.0.0.0 specifiedERunning the server with – skip-networking specifiedFLimiting logins to originate from the application server or the server's subnet'
Thursday, August 29, 2024
问题：多选题Which two options describe how MySQL Server allocates memory?（）AThread memory is pre-allocated up to thread_cache_size for performanceBEach connection may have its own per-thread memory allocationsCGlobal memory resources are allocated at server startupDEach thread allocates memory from a global pool
Monday, September 9, 2024
问题：单选题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
问题：单选题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= 1383B STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383C STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVED STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE
问题：单选题You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）A — quickB — skip-bufferC — single-transactionD — tab
问题：单选题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
问题：单选题You have a login-path named "adamlocal" that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correct for you deployment. You execute this command: $mysql_config_editor print –login-path=adamlocal What is the expected output of this command?（）A The command prints all parameter for the login-path. The password is replaced with starsB The command prints the encrypted entry for the login-path. The is only possible to see if an entry existsC The command prints all parameters for the login-path. The password is shown only when you provide the –password optionD The command prints all parameters for the login-path. The password is printed in plain tex
Wednesday, December 20, 2023
问题：单选题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
问题：多选题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
问题：单选题You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）A –skip-networking, to prohibit access from remote locationsB –reset-grant-tables, to start the server with only the mysql database accessibleC –read-only,to set all data to read-only except for super usersD –old-passwords, to start Mysql to use the old password format while running without the grant tables
问题：单选题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 recoveriesB Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDsC The server keeps track of which GTIDs have already been executed and skips thoseD Enforce_gtid_consistency is set to ON
问题：单选题You have enabled the Slow Query Log for a short period. When you process the Slow Query Log, you receive the following snip of output: Count: 100 Time=0 .22a (22s) Lock=0.00s (0s) Rows=0.0 (0), root[root] @localhost CREATE TABLE 't1' (id serial,id0 varchar(N) unique key,intcaoll INT (N) ,intco12 INT(N) ,intco13 INT(N) ,intco14 INT(N) ,intco15 INT(N) ,charcol1 VARVHAR(N) ,charcol2 VARCHAR(N) charcol3 VARCHAR (N) ,charcol4 VARVHAR(N) ,charcol5 VARCHAR(N) charcol6 VARCHAR (N) ,charcol7 VARVHAR(N) ,charcol8 VARCHAR(N) charcol9 VARCHAR (N) .charcol 10 VACHAR (N) ) Count: 64000 Time-0.02s (1213s) Lock=0.00s (6s) Rows=1.0 (64000), root [root]@ localhost SELECT intocl1, intco12, intco13, intco14, intco15, intco16,intco17, intco18 ,intcol9, intcol10, charcol1, charcol2, charcol3, charcol4, charcol5, charcol6 ,charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's' Count: 1 Time=0.02s (0s) Lock=0.00s (0s) Rows=1.0 (1) agent [agent] @localhost SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv FROM mysql.user WHERE CONCAT (user, 's', host) = CURRENT_USER （ ） Count: 48000 Time=0.02s (778s) Lock=0.00 (3s) Rows=1.0 (48000), root[root]@localhost SELECT intocl1,intcol2,intcol3, intcol4, intcol5, charcol1, charcol2, charcol3 ,charcol4, charcol5, charcol6, charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's' You want to tune the query such that it provides the greatest overall time savings. Which query will accomplish this?（）A CHEATE TABLE 't1' (id serial, id0 varchar (N) unique key, intcol1 INT (N) ,intcol2 INT (N), intcol3 INT(N) ,intcol4 INT(N), intcol5 INT(N), charool1 VARCHAR (N) ,charcol2 VARCHAR (N), charcol3 VARCHAR(N), charcol4 VARCHAR(N), charcol5 VARCHAR (N) ,charcol6 VARCHAR (N), charcol7 VARCHAR(N), charcol8 VARCHAR(N), charcol9 VARCHAR (N) ,charcol10 VARCHAR (N)B SELECT intcol1, intcol2, intcol3, intcol4, intcol5, intcol6, intcol7, intcol8, intcol9, Intcol10, intcol11, intcol12, intcol13, intcol14, intcol15, intcol16, intcol17, intcol18, intcol19, charcol10 FROM t1 WHERE id = 's'C SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv FROM mysql.user WHERE CONCAT (user,'s', host) = CURRENT_USER()D SELECT intcol1, intcol2, intcol3, intcol4, intcol5, charcol1, charcol2, charcol3, charcol4, charcol5, charcol6, charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's'
