Up To The Minute Microsoft MTA Software Development Fundamentals 98-361 Testing Engine

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

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 2

What are two advantages of normalization in a database? (Choose two.)

• A. reduces schema limitations
• B. minimizes impact of data corruption
• C. decreases space used on disk
• D. prevents data inconsistencies

Answer: CD

NEW QUESTION 3

Which service can host an ASP.NET application?

• A. Internet Information Services
• B. Cluster Services
• C. Remote Desktop Services
• D. Web Services

Answer: A

Explanation:
Using Internet Information Services (IIS) Manager, you can create a local Web site for hosting an ASP.NET Web application.

NEW QUESTION 4

The elements of an array must be accessed by:

• A. Calling the item that was most recently inserted into the array.
• B. Using a first-in, last-out (FILO) process.
• C. Using an integer index.
• D. Calling the last item in the memory array.

Answer: C

NEW QUESTION 5

Which three items are benefits of encapsulation? (Choose three.)

• A. restricted access
• B. flexibility
• C. maintainability
• D. performance
• E. inheritance

Answer: ABC

Explanation:
Encapsulation is the packing of data and functions into a single component. In programming languages, encapsulation is used to refer to one of two related but distinct notions, and sometimes to the combination thereof:
* A language mechanism for restricting access to some of the object's components.
* A language construct that facilitates the bundling of data with the methods (or other functions) operating on that data.
Incorrect:
not E: Encapsulation is one of the four fundamental OOP concepts. The other three are inheritance, polymorphism, and abstraction.

NEW QUESTION 6

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.

NEW QUESTION 7

Which three are valid SQL keywords? (Choose three.)

• A. GET
• B. FROM
• C. SELECT
• D. WHAT
• E. WHERE

Answer: BCE

Explanation:
Example:
SELECT * FROM CustomersWHERE Country='Mexico';

NEW QUESTION 8

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

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

• A. WHERE Students SELECT *
• B. SELECT firstName, lastName, telephoneNumber FROM Students
• C. SELECT firstName, lastName, telephoneNumber IN Students
• D. SELECT * FROM Students
• E. WHERE Students SELECT firstName, lastName, telephoneNumber

Answer: B

Explanation:
Use SELECT??FROM and list the fields you want to retrieve.

NEW QUESTION 9

In this XHTML code sample, what will cause an error?

• A. The line break tag is incorrectly formatted.
• B. The HTML tags do not read XHTML.
• C. The body tag is missing a background attribute,
• D. All tags are not in uppercase.

Answer: A

Explanation:
In XHTML, the <br> tag must be properly closed, like this: <br />.

NEW QUESTION 10

How does a console-based application differ from a Windows Store app?

• A. Windows Store apps do not provide a method for user input
• B. Console-based applications do not display a graphical interface.
• C. Windows Store apps can access network resources.
• D. Console-based applications require the XNA Framework to run.

Answer: B

NEW QUESTION 11

You are creating a variable for an application.
You need to store data that has the following characteristics in this variable:
✑ Consists of numbers and characters
✑ Includes numbers that have decimal points
Which data type should you use?

• A. String
• B. Float
• C. Char
• D. Decimal

Answer: A

Explanation:
Need a string to store characters.

NEW QUESTION 12

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. Common Intermediate Language (CIL)
• C. Extensible Application Markup Language (XAML)
• 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.

NEW QUESTION 13

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

Answer: B

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

NEW QUESTION 14

In your student directory database, the Students table contains the following fields:
firstName lastName emailAddress telephoneNumber
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?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: D

Explanation:
to sort use: ORDER BY LastName, FirstName

NEW QUESTION 15

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. For
• B. D
• C. . . While
• D. If
• E. While

Answer: AD

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

NEW QUESTION 16

This question requires that you evaluate the underlined text to determine if it is correct. Converting an object to a more general type is called upcasting.
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. downcasting
• C. interfacing
• D. flexing

Answer: A

Explanation:
Casting up a hierarchy means casting from a derived object reference to a base object reference.

NEW QUESTION 17

You are reviewing a design for a database. A portion of this design is shown in the exhibits. Note that you may choose either the Crow's Foot Notation or Chen Notation version of the design. (To view the Crow's Foot Notation, click the Exhibit A button. To view the Chen Notation, click the Exhibit B button. )


Which term is used to describe the Customer component?

• A. Field
• B. Attribute
• C. Property
• D. Entity

Answer: D

Explanation:
Customer is a table (entity).

NEW QUESTION 18

This question requires that you evaluate the underlined text to determine if it is correct. To improve performance, a SQL SELECT statement should use indexes.
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. joins
• C. grouping
• D. ordering

Answer: A

NEW QUESTION 19

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. functional
• B. dynamic
• C. in-browser
• D. server-side

Answer: D

NEW QUESTION 20

This question requires that you evaluate the underlined text to determine if it is correct. Converting an object to a more general type is called upcasting.
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. downcasting
• C. interfacing
• D. flexing

Answer: :A

Explanation:
Casting up a hierarchy means casting from a derived object reference to a base object reference.

NEW QUESTION 21

You need to evaluate the following expression:
(A>B) AND (C<D)
What is the value of this expression if A=3, B=4, C=4, and D=5?

• A. 4
• B. 5
• C. False
• D. Null
• E. True

Answer: D

Explanation:
A>B is false.

NEW QUESTION 22

You are creating an application that accepts input and displays a response to the user. You cannot create a graphical interface for this application.
Which type of application should you create?

• A. Web-based
• B. Windows Service
• C. Windows Forms
• D. console-based

Answer: A

NEW QUESTION 23

You execute the following code.

How many times will the word Hello be printed?

• A. 49
• B. 50
• C. 51
• D. 100

Answer: B

Explanation:
The % operator computes the remainder after dividing its first operand by its second. All numeric types have predefined remainder operators.
In this case the reminder will be nonzero 50 times (for i with values 1, 3, 5,..,99).

NEW QUESTION 24

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-Each
• B. For
• C. While
• D. Do-While

Answer: D

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

NEW QUESTION 25
......