Download New Updated (June) Microsoft 98-361 Practice Test 21-30

Ensurepass

QUESTION 21  (Topic 1)

 

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

 

A table whose attributes depend only on the primary key must be at least second normal form.

 

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.

first

C.

third

D.

fourth

 

Answer: A

Explanation: 2nd Normal Form Definition

 

A database is in second normal form if it satisfies the following conditions:

 

It is in first normal form

All non-key attributes are fully functional dependent on the primary key

 

 

QUESTION 22  (Topic 1)

 

A class named Manager is derived from a parent class named Employee. The Manager class includes characteristics that are unique to managers.

 

Which term is used to describe this object-oriented concept?

 

A.

Encapsulation

B.

Data modeling

C.

Inheritance

D.

Data hiding

 

Answer: C

Explanation: Classes (but not structs) support the concept of inheritance. A class that derives from another class (the base class) automatically contains all the public, protected, and internal members of the base class except its constructors and destructors.

 

Incorrect:

not A: Encapsulation is sometimes referred to as the first pillar or principle of object- oriented programming. According to the principle of encapsulation, a class or struct can specify how accessible each of its members is to code outside of the class or struct. Methods and variables that are not intended to be used from outside of the class or assembly can be hidden to limit the potential for coding errors or malicious exploits.

 

 

QUESTION 23  (Topic 1)

 

You need to create a stored procedure that passes in a person’s name and age.

 

Which statement should you use to create the stored procedure?

 

 

 

clip_image002

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Answer: B

Explanation: Example (nvarchar and int are best here):

The following example creates a stored procedure that returns information for a specific employee by passing values for the employee’s first name and last name. This procedure accepts only exact matches for the parameters passed.

 

CREATE PROCEDURE HumanResources.uspGetEmployees

@LastName nvarchar(50),

@FirstName nvarchar(50)

AS

 

SET NOCOUNT ON;

SELECT FirstName, LastName, JobTitle, Department

FROM HumanResources.vEmployeeDepartment

WHERE FirstName = @FirstName AND LastName = @LastName; GO

 

 

QUESTION 24  (Topic 1)

 

 

You are writing a Web application that processes room reservation requests. You need to verify that the room that a guest has selected is not already reserved by another guest.

 

Which type of programming should you use to determine whether the room is still available when the request is made?

 

A.

client-side

B.

server-side

C.

multithreaded

D.

batch processing

 

Answer: B

Explanation: For room availability we need to check a database located on a server.

 

 

QUESTION 25  (Topic 1)

 

You create an application that uses Simple Object Access Protocol (SOAP).

 

Which technology provides information about the application’s functionality to other applications?

 

A.

Web Service Description Language (WSDL)

B.

Extensible Application Markup Language (XAML)

C.

Common Intermediate Language (CIL)

D.

Universal Description, Discovery, and Integration (UDDI)

 

Answer: A

Explanation: WSDL is often used in combination with SOAP and an XML Schema to provide Web services over the Internet. A client program connecting to a Web service can read the WSDL file to determine what operations are available on the server. Any special datatypes used are embedded in the WSDL file in the form of XML Schema. The client can then use SOAP to actually call one of the operations listed in the WSDL file using for example XML over HTTP.

 

 

QUESTION 26  (Topic 1)

 

What are the three basic states that a Windows service can be in? (Choose three.)

 

A.

halted

B.

running

C.

stopped

D.

paused

E.

starting

 

Answer: BCD

Explanation: A service can exist in one of three basic states: Running, Paused, or Stopped.

 

 

QUESTION 27  (Topic 1)

 

What are two methods that can be used to evaluate the condition of a loop at the start of each iteration? (Each correct answer presents a complete solution. Choose two. )

 

A.

If

B.

Do. . . While

C.

For

D.

While

 

Answer: CD

Explanation: For and While constructs check at the start of each iteration.

 

 

QUESTION 28  (Topic 1)

 

You are designing a class for an application. You need to restrict the availability of the member variable accessCount to the base class and to any classes that are derived from the base class.

 

Which access modifier should you use?

 

A.

Internal

B.

Protected

C.

Private

D.

Public

 

Answer: C

 

 

QUESTION 29  (Topic 1)

 

The throw keyword is used to perform which two actions? (Choose two.)

 

A.

stop processing of the code

B.

move error handling to a separate thread

C.

raise exceptions

D.

re-throw exceptions as a different type

 

Answer: < font style="font-size: 10pt">CD

Explanation: * The Throw statement throws an exception that you can handle with structured exception-handling code (Try…Catch…Finally) or unstructured exception- handling code (On Error GoTo). You can use the Throw statement to trap errors within your code because Visual Basic moves up the call stack until it finds the appropriate exception- handling code.

 

* This example throws an ApplicationException exception.

Throw New ApplicationException

 

 

QUESTION 30  (Topic 1)

 

What are two possible options for representing a Web application within Internet Information Services (IIS)? (Each correct answer presents a complete solution. Choose two. )

 

A.

Web site

B.

Web directory

C.

Virtual directory

D.

Application server

E.

Application directory

 

Answer: AC

Explanation: * Create a Web Application

An application is a grouping of content at the root level of a Web site or a grouping of content in a separate folder under the Web site’s root directory. When you add an application in IIS 7, you designate a directory as the application root, or starting point, for the application and then specify properties specific to that particular application, such as the application pool that the application will run in.

* You can make an Existing Virtual Directory a Web Application.

 

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…