QUESTION 1

In your student directory database, the Students table contains the following fields:

 

firstName

 

lastName

 

emailAddress

 

telephoneNumtoer

 

You need to retrieve the data from the firstName, lastName, and emailAddress fields for all students listed in the directory. The results must be in alphabetical order according to lastName and then firstName.

 

Which statement should you use?

 

clip_image002

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: A

Explanation:

to sort use: ORDER BY LastName, FirstName

 

 

QUESTION 2

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

 

The duplication of code so that modifications can happen in parallel is known as separating.

 

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.

branching

C.

merging

D.

splitting

 

Correct Answer: B

Explanation:

When you develop applications in a team-based environment, you might need to access multiple versions of your application at the same time. If you copy one or more areas of your code into a separate branch, you can update one copy while you preserve the original version, or you can update both branches to meet different needs. Depending on your development goals, you can later merge the changes from multiple branches to create a single version that reflects all changes.

 

 

QUESTION 3

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

 

The default entry point for a console application is the Class method.

 

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.

Main

C.

Program

D.

Object

 

Correct Answer: B

Explanation:

The default entry point for a console application is the Class Main.

 

 

QUESTION 4

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

 

Correct 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 5

All objects in .NET inherit from which item?

 

A.

the System.Object class

B.

a value type

C.

a reference type

D.

the System.Type class

 

Correct Answer: A

Explanation:

The System.Object class supports all classes in the .NET Framework class hierarchy and provides low-level services to derived classes. This is the ultimate base class of all classes in the .NET Framework; it is the root of the type hierarchy.

 

 

QUESTION 6

You are creating an application that presents users with a graphical interface in which they can enter data. The application must run on computers that do not have network connectivity. Which type of application should you choose?

 

A.

Console-based

B.

Windows Forms

C.

Windows Service

D.

ClickOnce

 

Correct Answer: B

Explanation:

Use Windows Forms when a GUI is needed.

 

 

QUESTION 7

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

 

Correct Answer: B

Explanation:

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

 

 

 

QUESTION 8

Which type of application has the following characteristics when it is installed?

 

clip_image004Runs continuously in the background by default when the startup type is set to automatic

clip_image004[1]Presents no user interface

 

A.

Windows Service

B.

Windows Forms

C.

Console-based

D.

Batch file

 

Correct Answer: A

Explanation:

A Windows service runs in the background and has no interface.

 

 

QUESTION 9

You are creating a routine that will perform calculations by using a repetition structure. You need to ensure that the entire loop executes at least once. Which looping structure should you use?

 

A.

For

B.

While

C.

Do,,While

D.

For. ,,Each

 

Correct Answer: C

Explanation:

In a Do..While loop the test is at the end of the structure, so it will be executed at least once.

 

 

QUESTION 10

HOTSPOT

You are reviewing the following code that saves uploaded images.

 

clip_image006

 

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

 

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

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