1Z0-883 Real Exam Questions

Identify a performance impact when using the Performance Schema.

What is true regarding InnoDB locking?

You have table `apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell> mysqldump u root h server no-data apps userdata | mysql u root p apps Shell> mysql u root p h server e `ALTER TABLE `apps','userdata' ENGINE=InnoDB;' Shell> mysqldump u root p h server no-create-info order-by-primary apps userdata | mysql u root p apps What effect does the ?order-by-primary argument have on the mysqldump command?

You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database. You test whether the import was successful by using the following commands: Mysql> select user, host, password from mysql.user; 9 rows in set (0.00 sec) Mysql> show grants for `admin'@'%'; ERROR 1141 (42000): There is no such grant defined for user `admin' on host `%' Which command will fix this issue?

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?