Database Fundamentals Free Sample Questions

Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer represents a complete solution. (Choose all that apply.)

Which of the following steps in database planning is used to record an object so that it is represented visually in the system?

Which of the following provides reliable units of work that allow correct recovery from failures and keeps a database consistent even in cases of system failure?

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?