98-364 Sample Questions & Answers

You work as the Database Administrator for a MySQL database server.

In an hour or so, you are able to bring a corrupted server online.

You execute the CHECK TABLE command and find that some of the InnoDB tables need to be repaired.

You restart the server and discover that auto-recover has failed.

Which of the following steps will you take to recover the corrupted InnoDB tables?

You want to recover one or more tablespaces to a point in time older than the rest of the database.

Which of the following are the recovery situations in which tablespace Point-in-Time Recovery (TSPITR) should be used? Each correct answer represents a part of the solution. (Choose all that apply.)

You are the database administrator for a MySQL database server.

The network contains new and old (pre-4.1) clients.

You configure another database server on the network.

You allow the network clients to connect to the new server.

Some users complain that when they try to connect to the server, they receive the following error:
ERROR 1251: The client does not support authentication protocol requested by the server; consider upgrading MySQL client

You do not want to upgrade any client or server right now, and want to enable all clients to connect to the new server successfully.

Which of the following steps will you take to resolve the issue?

Which of the following statements are correct regarding recovery of the InnoDB tables after a server crash? Each correct answer represents a complete solution. (Choose all that apply.)

You are a database developer for a database named Customers hosted on a SQL Server 2008 server.

Recently, several customers were deleted from the Customers database.

To ensure this is not repeated in future, you have decided to create a DML trigger to prevent it.

What code will create the trigger to meet your goals? Each correct answer represents a complete solution. (Choose all that apply.)

Which of the following are DML commands? Each correct answer represents a complete solution. (Choose all that apply.)