A.Mysqld uses internal configuration versioning and reverts to the previous configuration
B.When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes
C.The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes
D.Mysqld prints to the error log about an unknown variable, and then exits
您可能感兴趣的试卷
你可能感兴趣的试题
A.MySQL Replication
B.Distributed Replication Block Device
C.Windows Server Failover Clustering
D.MySQL Cluster
A.Mysqlaccess
B.Mysqldump
C.Mysqlshow
D.Mysqlslow
E.Mysqldumpslow
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 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'
A.It implements High Availability by using the .NET Connector's' load balancing capabilities
B.It is shared-nothing architecture
C.It is provided by means of IP- level disk replication
D.It relies on the shared disk architecture being visible to both servers
A.When uptime is critical
B.When data must be refactored
C.When application concurrency is static
D.When data loss is unacceptable
E.When 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 locations
B.–reset-grant-tables, to start the server with only the mysql database accessible
C.–read-only,to set all data to read-only except for super users
D.–old-passwords, to start Mysql to use the old password format while running without the grant tables
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
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
A.Setting — skip-networking when remote connections are not required
B.Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
C.Setting specific GRANT privilege to limit remote authentication
D.Setting – mysql_secure_configuration to enable paranoid mode
E.Using SSL when transporting data over remote networks
最新试题
MySQL is installed on a Linux server and has the following configuration:What is the purpose of changing ownership of datadir to the ‘mysql’ user?()
Which statement is true about the log-output variable?()
Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start.Which two statements would explain why the service did not start?()
Your developers have created table to store some of their program's data.After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…'What should you do to improve the overall performance?()
Which three are properties of the MyISAM storage engine?()
An employee cannot access the company database. You check the connection variables:What is a valid explanation for why one of the users is unable to connect to the database?()
Consider the following:Which statement best describes the meaning of the value for the key_len column?()
Which two statements describe the behavior of the server's SQL mode?()
Which two statements are true about setting the per-thread buffers higher than required?()
A general purpose MySQL instance is configured with the following options:—log-slow-queries—long-query-time=,0001—log-slow-admin-queries—general-log—log-bin—binlog-format=STATEMENT—innodb-flush-log-at-trx-commit=1Which three statements are true()。