Ensurepass

QUESTION 101

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?

 

A.     varchar

B.     nvarchar

C.     geography

D.     GPS

 

Correct Answer: C

 

 

QUESTION 102

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.

 

A.     They can only be recovered from the dump files.

B.     They are automatically recovered at the server startup.

C.     They are recovered only after restarting the server with the innodb_force_recovery option configured.

D.     The innodb_force_recovery option opens the InnoDB tables in the read-only mode.

 

Correct Answer: BD

 

 

QUESTION 103

Which of the following ensures referential integrity between tables?

 

A.     Foreign key

B.     CHECK constraint

C.     Index

D.     Primary key

 

Correct Answer: A

 

 

QUESTION 104

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?

 

A.     Locking hints

B.     Check constraint

C.     Stored procedure

D.     View

 

Correct Answer: B

 

 

QUESTION 105

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?

 

A.     Native auditing

B.     Two-phase commit

C.     Encryption

D.     Concurrency control

 

Correct Answer: B

 

 

QUESTION 106

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?

 

A.     The query will fail, as the id and name attributes are created in lowercase.

B.     The query will execute partially, as it will create the table but will fail to create the attributes.

C.     The query will fail because the id and name attributes must be separated by a comma.

D.     The query will create a table named Emp.

 

Correct Answer: C

 

 

QUESTION 107

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?

 

A.     Identifying the information for objects

B.     Object modeling

C.     Object identification

D.     Identifying the relationships between objects

 

Correct Answer: A

 

 

QUESTION 108

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

 

A.     Data model

B.     Generic Data Model

C.     Relational model

D.     Entity-Relationship Model

 

Correct Answer: A

 

 

QUESTION 109

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?

 

A.     Only one table, Employee

B.     Three tables, Employee, Manager, and a table to link both these entities

C.     Two tables, Employee and Manager

D.     Either two or three tables

 

Correct Answer: A

QUESTION 110

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?

 

A.     It violates 1NF.

B.     It violates 2NF.

C.     It violates 3NF.

D.     It does not violate any normal form.

 

Correct Answer: A

 

Free VCE & PDF File for Microsoft 98-364 Real Exam

Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…