Peter works as a Database Administrator for UnrealTech Inc. Management instructs him to create a schema
that is gradually expanded from
one level to another through appropriate modifications. Which of the following approaches will he use to
accomplish the task?

You are the database administrator of a MySQL database server. Your network contains a combination of new
and old (pre-4.1) MySQL clients.
You are configuring a new server for testing purposes. You want to allow connections only by the clients that
have new-format passwords.
Which of the following steps will you take to accomplish the task?

Which of the following commands are used to terminate a transaction? Each correct answer represents a
complete solution. Choose all that apply.

Which of the following is undertaken at any time prior to the logical design, provided that sufficientinformation
is available regarding system requirements?

Which of the following refers to the system, processes, and procedures that protect a database from
unintended activities, such as
authenticated misuse, malicious attacks, or inadvertent mistakes made by authorized individuals or processes?

Mark works as a Database Administrator for Techworld Inc. He wants to remove the columns from a table that
are not dependent on the
primary key. Which of the following normal forms will help him accomplish the task?

You are a Database Administrator for MySQL database. Users are complaining of slow query execution in a
few tables. You need to ensure
that contents of those tables are accessed more efficiently. You are sure that the table structure andits
contents have no problems. Which of
the following steps will you take to accomplish thetask? Each correct answer represents a part of thesolution.
Choose two.

You are modifying a database that is used as a backend for a web site. The web site developers want to
include positional data that can be used by the website users to determine store locations information that is
stored in the Stores table of the database. You areasked to add a column to the Stores table. What data type
should you use?

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.

Which of the following ensures referential integrity between tables?