A simple master-to-slave replication is currently being used. The following information isextracted from the SHOW SLAVE STATUS output: Last_SQL_Error: Error ‘Duplicate entry‘8’ for key ‘PRIMARY’ ‘ on query. Default database: ‘mydb’. Query: ‘insert into mytableVALUES (‘8’ , ‘George’) ‘ Skip_Counter: 0 Retrieved _Gtid_Set:38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1 You execute a “SHOWCREATE TABLE mytable” on the […]
Consider the following statement on a RANGE partitioned table: ALTER TABLE ordersDROP PARTITION p1, p3; What is the outcome of executing the above statement? A. A syntax error will result as you cannot specify more than one partition in the same statement. B. All data in pi and p3 partitions are removed and the table […]
You inherit a legacy database system when the previous DBA, Bob, leaves the company.You are notified that users are getting the following error: mysql> CALL film_in_stock (40, 2,@count); ERROR 1449 (HY000): The user specified as a definer (‘bon’@’localhost’) doesnot exist How would you identify all stored procedures that pose the same problem? A. Execute SHOW […]
When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer
When designing an InnoDB table, identify an advantage of using the BIT datatype Insteadof one of the integer datatypes. A. BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved. B. The BIT columns can be manipulated with the bitwise operators &, |, ~, […]
ROW-based replication has stopped working. You investigate the error log file and find thefollowing entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not executeDelete_rows event on table test.t1; Can’t find record in ‘t1’, Error_code: 1032; handler errorHA_ERR_KEY_NOT_FOUND; the event’s master log 56_master-bin. 000003, end_log_pos851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can’t find record in […]
Which two commands will restore the sakila database without interfering with other running database?
Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –psakila > sakila2013.sql Which two commands will restore the sakila database withoutinterfering with other running database? A. Mysql> USE sakila; LOAD DATA INFILE ‘sakila2013.sql’; B. Shell> mysql –u root –p sakila sakila2013.sql C. Shell> mysql import –u root –p sakila sakila2013.sql D. […]
Consider the Mysql Enterprise Audit plugin. You are checking user accounts and attemptthe following query: Mysql> SELECT user, host, plugin FROM mysql.users; ERROR 1146(42S02): Table ‘mysql.users’ doesn’t exist Which subset of event attributes would indicatethis error in the audit.log file? A. NAME=”Query” STATUS=”1146” SQLTEXT=” Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/> B. NAME=”Query” STATUS=”1146” SQLTEXT=”select […]
Which query would you use to find connections that are in the same state for longer than 180 seconds?
Which query would you use to find connections that are in the same state for longer than180 seconds? A. SHOW FULL PROCESSLIST WHEER Time > 180; B. SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 180 SECOND) ); C. SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB (NOW ( ), INTERVAL […]
A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries doesnot fluctuate. Note the following details about this environment: A web application uses alimited set of queries. The Query Cache hit rate is high. All resultsets fit into the QueryCache. […]
You have a login-path named “adamlocal” that was created by using themysql_config_editor command. You need to check what is defined for this login_path toensure that it is correct for you deployment. You execute this command: $mysql_config_editor print –login-path=adamlocal What is the expected output of thiscommand? A. The command prints all parameter for the login-path. The […]