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

Ensurepass

QUESTION 131

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

 

A.

Recover

B.

Restore

C.

Commit

D.

Attach

 

Correct Answer: B

 

 

 

 

 

 

QUESTION 132

Which statement deletes the rows where the employee’s phone number is not entered?

 

clip_image002

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: A

 

 

QUESTION 133

You develop a database to store data about textbooks. The data must be stored to process at a later time. Which database object should you use to store the data?

 

A.

View

B.

Table

C.

Function

D.

Stored procedure

 

Correct Answer: D

 

 

QUESTION 134

You need to delete a database table. Which data definition language (DDL) keyword should you use?

 

A.

ALTER

B.

DELETE

C.

DROP

D.

TRUNCATE

 

Correct Answer: C

 

 

QUESTION 135

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

 

The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.

 

Instructions:

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.

INTERSECT

C.

ALL

D.

UOIN

 

Correct Answer: B

 

 

QUESTION 136

You need to store the contact information for each student in your school database. You should store each student’s information in a:

 

A.

Stored procedure

B.

Function

C.

Row

D.

Variable

 

Correct Answer: C

 

 

QUESTION 137

One reason to create a stored procedure is to:

 

A.

Improve performance.

B.

Minimize storage space.

C.

Bypass case sensitivity requirements.

D.

Give the user control of the query logic.

 

Correct Answer: A

 

 

QUESTION 138

HOTSPOT

You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related
by the StateID column.

 

clip_image004

 

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

 

clip_image006

 

Correct Answer:

clip_image008

 

 

QUESTION 139

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

 

Use the ALTER statement to add a new table in a database.

 

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.

UPDATE

C.

INSERT

D.

CREATE

 

Correct Answer: D

 

 

QUESTION 140

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

 

Use the ALLOW SELECT command to give a user permission to read the data in a table.

 

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.

GRANT SELECT

C.

LET HEAD

D.

PERMIT READ

 

Correct Answer: B

 

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…