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 updatedor none of them are updated, so that the databasesremain
synchronized. Which of the following will he use toaccomplish 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 theEmp table?

You work as an Application Developer for Nero Inc. You want to instruct the DBMS to set the transaction
isolation level so that when a user updates a tablein the database, other users cannot read the valueat the
same time. Which of the following methods will you use to define the transaction level?