QUESTION 181

You need to ensure the data integrity of a database by resolving insertion, update, and deletion anomalies. Which term is used to describe this process in relational database design?

 

A.

Normalization

B.

Integration

C.

Isolation

D.

Resolution

 

Correct Answer: A

Explanation:

Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database using the defined relationships.

 

 

QUESTION 182

You have a class with a property.

 

You need to ensure that consumers of the class can write to the value of the property.

 

Which keyword should you use?

 

A.

Add

B.

value

C.

Set

D.

Get

 

Correct Answer: C

Explanation:

Set:

The set { } implementation receives the implicit argument “value.” This is the value to which the property is assigned.

 

clip_image002Property. On a class, a property gets and sets values. A simplified syntax form, properties are implemented in the IL as methods (get, set).

 

 

QUESTION 183

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

 

The bubble sort algorithm steps through the list to be sorted, comparing adjacent items and swapping them if they are in the wrong order.

 

Select the correct answer if the underlined text does not make the statement correct. Select “No change is needed” if the underlined text makes the statement correct.

 

A.

No change is needed

B.

merge

C.

library

D.

insertion

 

Correct Answer: A

 

 

QUESTION 184

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

 

A piece of text that is 4096 bytes or smaller and is stored on and retrieved from the client computer to maintain state is known as a ViewState.

 

Select the correct answer if the underlined text does not make the statement correct. Select “No change is needed” if the underlined text makes the statement correct.

 

A.

No change is needed

B.

cookie

C.

form post

D.

QueryString

 

Correct Answer: B

Explanation:

A piece of text that is 4096 bytes or smaller and is stored on and retrieved from the client computer to maintain state is known as a Cookie.

 

 

QUESTION 185

You are developing a database that other programmers will query to display race results.

 

You need to provide the ability to query race results without allowing access to other information in the database.

 

What should you do?

 

A.

Add an AFTER UPDATE trigger on the result table to reject updates.

B.

Create an index on the result table.

C.

Place the query into a stored procedure.

D.

Disable implicit transactions.

 

Correct Answer: C

 

 

QUESTION 186

Which function does Simple Object Access Protocol (SOAP) provide when using Web services?

 

A.

communications protocol

B.

model for describing Web services

C.

directory of registered Web services

D.

security model

 

Correct Answer: A

Explanation:

SOAP, originally defined as Simple Object Access Protocol, is a protocol specification for exchanging structured information in the implementation of web services in computer networks. It relies on XML Information Set for its message format, and usually relies on other application layer protocols, most notably Hypertext Transfer Protocol (HTTP) or Simple Mail Transfer Protocol (SMTP), for message negotiation and transmission.

QUESTION 187

HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

 

clip_image004

 

Correct Answer:

clip_image006

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 188

HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

 

clip_image008

 

Correct Answer:

clip_image010

 

 

QUESTION 189

A table named Student has columns named ID, Name, and Age. An index has been created on the ID column. What advantage does this index provide?

 

A.

It reorders the records alphabetically.

B.

It reorders the records numerically.

C.

It speeds up query execution.

D.

It minimizes storage requirements.

 

Correct Answer: C

Explanation:

Faster to access an index table.

 

QUESTION 190

You are creating a database for a student directory. The Students table contains the following fields:

 

clip_image012

 

Which statement will retrieve only the first name, last name, and telephone number for every student listed in the directory?

 

clip_image014

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: A

Explanation:

Use SELECT…FROM and list the fields you want to retrieve.

 

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

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