CET_TARDE - MTA Software Development Fundamentals 2

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

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?

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.

A data warehouse database is designed to:

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

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.

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

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?

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?

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

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?

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

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

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?

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

Which service can host an ASP.NET application?

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?

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?

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

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

This question requires that you evaluate the underlined text to determine if it is correct. Arguments are passed to console applications as a Hashtable object. 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.

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

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?

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

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?

How many parameters can a default constructor have?

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

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

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?

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.

All objects in .NET inherit from which item?

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.

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

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

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.

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.

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

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?

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

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

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?

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

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

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?

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

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

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?

You execute the following code.

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?

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: