1z0-883 試験問題を無料オンラインアクセス

You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave.
Which command would you execute from a Mysql prompt?

• A.STOP SLAVE;
  SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
  START SLAVE;
• B.STOP SLAVE;
  SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3";
  BEGIN;
  COMMIT;
  SET GTID_NEXT="AUTOMATIC";
  START SLAVE
• C.STOP SLAVE;
  RESET SLAVE;
  BEGIN;
  SKIP NEXT GTID;
  COMMIT;
  START SLAVE;
• D.STOP SLAVE;
  BEGIN;
  SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3";
  COMMIT;
  START SLAVE;

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') does not exist
How would you identify all stored procedures that pose the same problem?

• A.Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES WHERE DEFINER='bob@localhost';.
• B.Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE USER='bob' and HOST=' localhost';.
• C.Examine the Mysql error log for other ERROR 1449 messages.
• D.Execute SHOW ROUTINES WHERE DEFINER='bob@localhost'.
• E.Execute SELECT * FROM mysql.routines WHERE DEFINER='bob@localhost';.

What are four capabilities of the mysql client program?

• A.Creating, dropping, and modifying tables and indexes
• B.Displaying replication status information
• C.Creating and dropping databases
• D.Initiating a binary backup of the database by using the START BACKUP command
• E.Creating and administering users
• F.Shutting down the server by using the SHUTDOWN command

Which two requirements would lead towards a high availability solution?

• A.When data loss is unacceptable
• B.When application is a single point of failure
• C.When data must be refactored
• D.When uptime is critical
• E.When application concurrency is static

Which two capabilities are granted with the SUPER privilege?

• A.Allowing a client to kill other client connections
• B.Allowing change of the server runtime configuration
• C.Allowing a client to shut down the server
• D.Allowing client accounts to take over the account of another user