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?

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?

John works as a Database Administrator for www.company.com Inc. The company has a SQL server
2008 database. John wants to define a valid data while adding or updating an entry in a table of a
relational database. Which of the following should he use to accomplish the task?

Adam works as a Database Designer for DataOne Inc. The company has a SQL Server database. Adam
has to ensure that either all the databases are updated or none of them are updated, so that the
databases remain synchronized. Which of the following will he use to accomplish the task?

Meryl works as a Database Designer for Klone Inc. She wants to create a table named Emp. She
issues the following query:
CREATE Table Emp (id Int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY name Char(10))
What will happen after executing this query?

James works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server
database. James has been assigned the task to store information for each object in the database.
Which of the following steps will help him accomplish the task?

Which of the following terms is described in statement below? “It is a collection of conceptual tools
for describing data, data relationship, data semantics, and consistency constraints.”

Philandrio Inc. is one of the largest drug manufacturing companies in the world. It has many offices
worldwide. Each office has a manpower of approximately 14,000. The managers themselves are
employees in the company. You are building a database for the company’s Human Resources
Department (HRD). You want to track the following attributes for each employee, and at the same
time, eliminate duplicate entries and minimize data storage wherever possible.
FirstName
MiddleName
LastName
EmployeeIdentityNumber
Address
Date_ of_ Hire
Department
Salary
ManagerIdentityNumber
Which of the following is the appropriate table detail sufficient to track the above attributes,
correctly and efficiently?

You work as a Database Administrator for Softech Inc.The company has a database that contains a
table named Emp. The Emp table has the EmpId, Name, Department, and Designation attributes.
Recently, the table was modified by adding the Phone attribute. Some employees have more than
one phone number.

Which of the following statements is true about the Emp table?