Which statement should be used?

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 […]

Read More

What is the outcome of executing the above statement?

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 […]

Read More

How would you identify all stored procedures that pose the same problem?

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 […]

Read More

Why did you receive this error?

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 […]

Read More

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. […]

Read More

Which subset of event attributes would indicate this error in the audit.log file?

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 […]

Read More

what is the most likely cause for this slowdown at the database level?

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. […]

Read More

What is the expected output of this command?

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 […]

Read More