[Free] Download New Latest (January 2016) Microsoft 98-364 Real Exam 151-160

Ensurepass

QUESTION 151

You need to store the first name, last name, and student ID for 100 students. This information will be stored in a table as:

 

A.

100 items and three cells.

B.

100 rows and three columns.

C.

three rows and 100 columns.

D.

three items and 100 cells.

 

Correct Answer: B

 

 

QUESTION 152

The terms “bitmap,” “b-tree,” and “has
h” refer to which type of database structure?

 

A.

View

B.

Function

C.

Index

D.

Stored procedure

E.

Trigger

 

Correct Answer: C

 

 

QUESTION 153

You execute the following statement:

 

clip_image002

 

This statement is an example of a/an:

 

A.

Subquery

B.

Union

C.

Outer join

D.

Cartesian product

 

Correct Answer: A

 

QUESTION 154

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.

 

When volunteers ask to be removed from mailing lists, the table must be updated.

 

You need to use a transaction to ensure that the database has data integrity and referential integrity.

 

Which statement should you use?

 

clip_image004

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: B

 

 

QUESTION 155

This question requires that you evaluate the underlined text to determine if it is correct.

 

Use indexing to create, remove, or change database objects.

 

Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

 

A.

No change is needed.

B.

Data manipulation language (DML) statements

C.

Data definition language (DDL) statements

D.

A unique constraint

 

Correct Answer: C

 

 

QUESTION 156

You have a table of products with fields for ProductID, Name, and Price.

 

You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.

 

Which clause should you use in your update statement?

 

A.

THAT

B.

WHERE

C.

GROUP BY

D.

HAVING

 

Correct Answer: B

 

 

QUESTION 157

One difference between a function and a stored procedure is that a function:

 

A.

Must be called from a trigger.

B.

Must return a value.

C.

Cannot contain a transaction.

D.

Cannot accept parameters.

 

Correct Answer: B

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 158

HOTSPOT

You have the following table:

 

clip_image006

 

Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

 

clip_image008

 

Correct Answer:

clip_image010

 

 

 

 

 

 

 

QUESTION 159

HOTSPOT

The following illustration shows the structure of a clustered index in a single partition:

 

clip_image012

 

Use the drop-down menus to select the answer choice that completes each statement Each correct selection is worth one point.

 

clip_image014

 

Correct Answer:

clip_image016

 

 

QUESTION 160

DRAG DROP

You have two database tables as defined below. The first table contains information about students. The second table contains information about courses. The two tables are related by CourseID.

 

clip_image018

 

Match the CourseName to the StudentName.

 

To answer, drag the appropriate CourseName from the column on the left to its StudentName on the right. Each CourseName may be used once, more than once, or not at all. Each correct match is worth one point.

 

clip_image020

 

Correct Answer:

clip_image022

 

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…