98-364 sample questions

Question 1

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

Accepted Answer

UPDATE

Accepted Answer

SELECT

Answer

INSERT

Answer

DELETE

Question 2

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

Accepted Answer

Object modeling

Answer

Identifying the relationships between objects

Answer

Gathering information

Answer

Object identification

Question 3

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?

Accepted Answer

Database transaction

Answer

Database security

Answer

Concurrency control

Answer

Two-phase commit

Question 4

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?

Accepted Answer

Run the OPTIMIZE TABLE command.

Answer

Run the ANALYZE TABLE command.

Answer

Run the REPAIR TABLE command.

Answer

Recover the tables from the last backup.

Question 5

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.)

Accepted Answer

To recover a tablespace that contains rollback segments

Accepted Answer

To recover a table that has become logically corrupted

Accepted Answer

To recover a DML statement that has affected only a subset of the database

Answer

To recover a tablespace on a very large database.

Question 6

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?

Accepted Answer

Run the server with the -old-password option.

Answer

Run the server with the -secure-auth option.

Answer

Run the server with the -allow-old option.

Answer

Run the server with the -enable-old option.

Top vendors

Top exams

Free 98-364 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 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.)

6 more free samples are waiting