Which of the following is undertaken at any time prior to the logical design, provided that sufficient
information 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 and
its contents have no problems. Which of
the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. 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 web site users to determine store locations
information that is stored in the Stores table of the database. You are asked to add a column to the
Stores table. What data type should you use?