CET_TARDE - MTA Software Development Fundamentals 2

Question 1

How should you configure an application to consume a Web service?

Accepted Answer

Add a reference to the Web service in the application.

Answer

Add the Web service to the development computer.

Answer

Add a reference to the application in the Web service.

Answer

Add the Web service code to the application.

Question 2

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?

Accepted Answer

server-side

Answer

functional

Answer

dynamic

Answer

in-browser

Question 3

You are developing an application to display track and field race results. The application must display the race results twice. The first time it must display only the winner and runner-up. The second time it must display all participants. The code used to display results is shown below.

Accepted Answer

1-yield return

Accepted Answer

2-yield return

Accepted Answer

1-yield break

Accepted Answer

3-yield return

Answer

1-break

Answer

1-return

Answer

2-break

Answer

2-return

Answer

3-break

Answer

3-return

Answer

2-yield break

Answer

3-yield break

Question 4

A data warehouse database is designed to:

Accepted Answer

Enable business decisions by collecting, consolidating, and organizing data.

Answer

Support a large number of concurrent users.

Answer

Support real-time business operations.

Answer

Require validation of incoming data during real-time business transactions.

Question 5

Which language was designed for the primary purpose of querying data, modifying data, and managing databases in a Relational Database Management System?

Accepted Answer

SQL

Answer

Java

Answer

C++

Answer

Visual Basic

Question 6

This question requires that you evaluate the underlined text to determine if it is correct.
Converting a value type to a reference type in an object is called boxing.
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.

Accepted Answer

No change is needed

Answer

unboxing

Answer

interfacing

Answer

mapping

Question 7

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

Accepted Answer

YES

Accepted Answer

YES

Accepted Answer

NO

Question 8

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?

Question 9

You plan to create an application for your company. The application will run automated routines and write the results to a text-based log file. Little or no user interaction is required. Security requirements on the host computers prevent you from running applications on startup, and users must be able to see the status easily on the screen. The host computers also have limited memory and monitors that display only two colors. These computers will have no network connectivity. Which type of application should you use for this environment?

Accepted Answer

console-based

Answer

Directx

Answer

Windows Service

Answer

Windows Store app

Question 10

You are developing an application that tracks tennis matches. A match is represented by
the following class:

Accepted Answer

2

Answer

0

Answer

1

Answer

3

Question 11

You have a Windows Service running in the context of an account that acts as a non-privileged user on the local computer. The account presents anonymous credentials to any remote server. What is the security context of the Windows Service?

Accepted Answer

LocalService

Answer

LocalSystem

Answer

User

Answer

NetworkService

Question 12

The purpose of the Finally section in an exception handler is to:

Accepted Answer

Execute code regardless of whether an exception is thrown.

Answer

Conclude the execution of the application.

Answer

Execute code only when an exception is thrown.

Answer

Break out of the error handler.

Question 13

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

Accepted Answer

FROM

Accepted Answer

SELECT

Accepted Answer

WHERE

Answer

GET

Answer

WHAT

Question 14

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?

Accepted Answer

String

Answer

Float

Answer

Char

Answer

Decimal

Question 15

In which order do the typical phases of the Software Development Life Cycle occur?

Accepted Answer

Requirements gathering, design, development, and testing

Answer

Development, design, requirements gathering, and testing

Answer

Design, requirements gathering, development, and testing

Answer

Design, development, requirements gathering, and testing

Question 16

Which service can host an ASP.NET application?

Accepted Answer

Internet Information Services

Answer

Cluster Services

Answer

Remote Desktop Services

Answer

Web Services

Question 17

You have a website that includes a form for usemame and password. You need to ensure that users enter their username and password. The validation must work in all browsers. Where should you put the validation control?

Accepted Answer

in both the client-side code and the server-side code

Answer

in the client-side code only

Answer

in the Web.config file

Answer

in the server-side code only

Question 18

You are creating an application for a help desk center. Calls must be handled in the same order in which they were received. Which data structure should you use?

Accepted Answer

Queue

Answer

Binary tree

Answer

Stack

Answer

Hashtable

Question 19

Which programming language is characterized as client-side, dynamic and weakly typed?

Accepted Answer

JavaScript

Answer

HTML

Answer

ASP.NET

Answer

C#

Question 20

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

Accepted Answer

SELECT firstName, lastName, telephoneNumber FROM Students

Answer

WHERE Students SELECT *

Answer

SELECT firstName, lastName, telephoneNumber IN Students

Answer

SELECT * FROM Students

Answer

WHERE Students SELECT firstName, lastName, telephoneNumber

Question 21

This question requires that you evaluate the underlined text to determine if it is correct.
Converting a value type to a reference type in an object is called boxing.
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.

Accepted Answer

String Array

Answer

No change is needed

Answer

StoredProcedureCollection

Answer

Dictionary

Question 22

You create an object of type ANumber. The class is defined as follows.

Accepted Answer

3

Answer

Null

Answer

0

Answer

7

Question 23

Your application must pull data from a database that resides on a separate server. Which action must you perform before your application can retrieve the data?

Accepted Answer

Establish a connection to the database by using the appropriate data provider.

Answer

Configure the network routers to allow database connections.

Answer

Install the database on each client computer.

Answer

Create a routine that bypasses firewalls by using Windows Management Instrumentation (WMI).

Question 24

You are migrating several HTML pages to your website. Many of these pages contain HTML and tags. Which XHTML document type declaration should you use?

Question 25

The Dog class and the Cat class inherit from the Animal class. The Animal class includes a breathe() method and a speak() method. If the speak() method is called from an object of type Dog, the result is a bark. If the speak() method is called from an object of type Cat, the result is a meow. Which term is used to describe this object-oriented concept?

Accepted Answer

polymorphism

Answer

multiple inheritance

Answer

data hiding

Answer

encapsulation

Question 26

How many parameters can a default constructor have?

Accepted Answer

0

Answer

1

Answer

2

Answer

3 or more

Question 27

Which term is used to describe a class that inherits functionality from an existing class?

Accepted Answer

Derived class

Answer

Base class

Answer

Inherited class

Answer

Superclass

Question 28

You need to allow a consumer of a class to modify a private data member. What should you do?

Accepted Answer

Provide a public function that assigns a value to the data member.

Answer

Assign a value directly to the data member.

Answer

Provide a private function that assigns a value to the data member.

Answer

Create global variables in the class.

Question 29

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?

Accepted Answer

set

Answer

value

Answer

add

Answer

get

Question 30

This question requires that you evaluate the underlined text to determine if it is correct.
The Response.Redirect method is used to transfer processing of the current page to a new
page, and then return processing back to the calling page once processing of the new page has completed. 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.

Accepted Answer

Server.Execute method

Answer

No change is needed

Answer

Server.Transfer method

Answer

meta http-equiv="refresh" tag

Question 31

All objects in .NET inherit from which item?

Accepted Answer

the System.Object class

Answer

a value type

Answer

a reference type

Answer

the System.Type class

Question 32

This question requires that you evaluate the underlined text to determine if it is correct.
A data dictionary that describes the structure of a database is called metadata.
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.

Accepted Answer

No change is needed

Answer

normalization

Answer

a database management system (DBMS)

Answer

metacontent

Question 33

You are reviewing a design for a database. A portion of this design is shown in the exhibit. Note that you may choose to view 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.)

Accepted Answer

one-to-many

Answer

many-to-many

Answer

one-dimensional

Answer

one-to-one

Answer

multi-dimensional

Question 34

You need to group all the style settings into a separate file that can be applied to all the pages in a Web application. What should you do

Accepted Answer

Use a Cascading Style Sheet (CSS).

Answer

Use inline styles.

Answer

Use an Extensible Markup Language (XML) schema.

Answer

Use a WebKit.

Question 35

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.

Accepted Answer

No change is needed

Answer

first

Answer

third

Answer

fourth

Question 36

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.

Accepted Answer

cookie

Answer

No change is needed

Answer

form post

Answer

QueryString

Question 37

You are extending an application that stores and displays the results of various types of
foot races. The application contains the following definitions:

public interface IDisplayResult
{
    void Display();
}

public class Race
{
    public int Seconds;

public virtualvoid Display()
    {
         Console.WhiteLine(Seconds);
    }
}

The following code is used to display the result for a race:

var r1 = new FootRace();
var r2 = r1 as IDisplayResult;
r1.Seconds = 99;

r2.Display();
r1.Display();
r1.DisplayRaw();

The contents of the console must be as follows:
You need to implement the FootRace class.
Match the method declaration to the method body, (To answer, drag the appropriate declaration from the column on the left to its body on the right. Each declaration may be used once, more than once, or not at all. Each correct match is worth one point.)

Accepted Answer

public override void Display()

Accepted Answer

public void DisplayRaw()

Accepted Answer

void IDisplayResult.Display()

Answer

private void Display()

Question 38

You have a class named Truck that inherits from a base class named Vehicle. The Vehicle class includes a protected method named brake (). How should you call the Truck class implementation of the brake () method?

Accepted Answer

MyBase. brake();

Answer

Vehicle. brake ();

Answer

This. brake ();

Answer

Truck. brake ();

Question 39

Which two types of information should you include in an effective test case? (Choose two.)

Accepted Answer

the expected result from testing the case

Accepted Answer

multiple actions combined as a single step to test the case

Answer

any pre-conditions necessary to test the case

Answer

the stakeholders who originated the test case

Question 40

Where must Internet Information Services (IIS) be installed in order to run a deployed ASP.NET application?

Accepted Answer

on the computer that hosts the application

Answer

on the computer that you plan to deploy from

Answer

on the Application Layer Gateway Service

Answer

on the client computers

Question 41

You are creating the necessary variables for an application. The data you will store in these variables has the following characteristics:
✑ Consists of numbers
✑ Includes numbers that have decimal points
✑ Requires more than seven digits of precision
You need to use a data type that will minimize the amount of memory that is used. Which data type should you use?

Accepted Answer

double

Answer

decimal

Answer

byte

Answer

float

Question 42

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. )

Accepted Answer

For

Accepted Answer

While

Answer

If

Answer

Do. . . While

Question 43

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

Accepted Answer

NO

Accepted Answer

NO

Accepted Answer

YES

Question 44

You are designing a Windows Store application. You need to design the application so that users can share content by connecting two or more devices by physically tapping the devices together. Which user experience (UX) guideline for Windows Store applications should you use?

Accepted Answer

Share and data exchange

Answer

location-awareness

Answer

device-awareness

Answer

proximity gestures

Question 45

What is displayed when you attempt to access a Web service by using a Web browser?

Accepted Answer

a listing of methods that are available in the Web service

Answer

a directory listing of the Web service's application structure

Answer

an error page explaining that you have accessed the Web service incorrectly

Answer

a visual depiction of your preliminary connection to the Web service

Question 46

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

Accepted Answer

The line break tag is incorrectly formatted.

Answer

All tags are not in uppercase.

Answer

The body tag is missing a background attribute.

Answer

The HTML tags do not read XHTML.

Question 47

You are creating an application for a priority help desk center. The most recent call must be handled first.
Which data structure should you use?

Accepted Answer

stack

Answer

queue

Answer

hashtable

Answer

binary tree

Question 48

You execute the following code.

Accepted Answer

2

Answer

1

Answer

3

Answer

4

Question 49

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?

Accepted Answer

Option B

Answer

Option A

Answer

Option C

Answer

Option D

Question 50

You are reviewing the architecture for a system that allows race officials to enter the results of 5K race results. The results are then made available to students using a web application. The architecture is shown below: