MTA Exam 98-361 Study Questions

Derived classes have an ........ relationship with their base class

"is-a"

Metadata

-is data that describes other data -summarizes basic info about data, which can make finding and working with particular instances of data easier

Converting a value type to a reference type in an object is called BOXING. A. No change is needed B. unboxing C. interfacing D. mapping

A. No change is needed

To improve performance, a SQL SELECT statement should use indexes. A. No change is needed B. joins C. grouping D. ordering

A. No change needed

Two classes named Circle and Square inherit from the Shape class. Circle and Square both inherit Area from the Shape class, but each computes Area differently. Which term is used to describe this object-oriented concept? • A. polymorphism • B. encapsulation • C. superclassing • D. overloading

A. Polymorphism

Which of the following must exist to inherit attributes from a particular class? • A. Public properties • B. A has-a relationship • C. An is-a relationship • D. Static members

A. Public properties

Which language uses Data Definition Language (DDL) and Data Manipulation Language (DML)? • A. SQL • B. C++ • C. Pascal • D. Java

A. SQL

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

A. Web Site C. Virtual Directory

Which three items are benefits of encapsulation? (Choose three.) • A. maintainability • B. flexibility • C. restricted access • D. inheritance • E. performance

A. maintainability B. flexibility C. restricted access Encapsulation is the packing of data and functions into a single component.

You need to allow a consumer of a class to modify a private data member. What should you do? A. Assign a value directly to the data member. B. Provide a private function that assigns a value to the data member. C. Provides a public function that assigns a value to the data member. D. Create global variables in the class.

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

You are building a web application that enables international exchange students to schedule phone calls with their prospective schools. The application allows students to indicate a preferred date and time for phone calls. Students may indicate no preferred time by leaving the date and time field empty. The application must support multiple time zones. Which data type should you use to record the student's preferred date and time? • A. uLong? • B. DateTime • C. SByte • D. DateTimeOffset?

D. DateTimeOffset Defines a date that is combined with a time of day that has a time zone awareness

The class 3 and the class 4 are derived from class 2 and the class 2 is derived from class 1 Which methods can the class 3 access ? • A. only m3, m4 • B. only m2, m3 • C. only ml, m3 • D. m1, m3, m3 • E. m2, m3, m4 • F. m1, m2, m3

F. m1, m2, m3

The driver that you use in unit testing simulates a calling unit and the stub simulates a called unit.

True

True or False A Queue is a first in, first out data structure.

True

True or False A Queue's items are stored in the order they were added.

True

True or False A linked list can be sorted

True

True or False In unit testing, each unit is tested separately before integrating the units into modules to test the interfaces b/w modules

True

True or False The primary goal of unit testing is to take the smallest piece of testable software in the application, isolate it from the remainder of the code, and determine whether it behaves exactly as expected.

True

True or False Within a XHTML document, the XML namespace attribute in the html tag is mandatory.

True

ERD Entity relationship diagram

are used to model entities, their attributes, and the relationships among entities. They can help you determine what data needs to be stored in a database.

The...... operator is similar to the cast operation but, in the case of as, if the type conversion is not possible, null is returned instead of raising an exception.

as

Method: Server.Transfer

sends all the info that has been assembled for processing by one .asp file to a second .asp file.

How many parameters can a default constructor have?

0 - if a class contains no instance constructor declarations, a default instance constructor is automatically provided. That default constructor simply invokes the parameter-less constructor of the direct base class.

You have a SQL Server database named MyDB that uses SQL Server Authentication. Which connection string should you use to connect to MyDB? A. Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales B. Data Source=MyDB; Integrated Security=SSPI; Initial Catalog=Sales C. Data Source=MyDB; Integrated Security=True; Initial Catalog=Sales D. Data Source=MyDB; Trusted_Connection=True; MultipleActiveResultSets=True; Initial Catalog=Sales

A

Which two types of info should you include in an effective test case (choose two) A. the expected result from testing the case. B. multiple actions combined as a single step to test the case C. any pre-conditions necessary to test the case D. the stakeholders who originated the test case.

A, B

What are two advantages of normalization in a database? (Choose two) A. prevents data inconsistencies B. reduces schema limitations C. minimizes impact of data corruption D. decreases space used on disk

A, D

The purpose of the Finally section in an exception handler is to: A. Execute code regardless of whether an exception is thrown. B. Conclude the execution of the applicaiton. C. Execute code only when an exception is thrown. D. Break out of the error handler.

A. Execute code regardless of whether an exception is thrown.

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? A. SELECT firstName, lastName, emailAddress FROM Students ORDER BY lastName, firstName B. SELECT firstName, lastName, emailAddress From Students SORT BY lastName, firstName C. SELECT firstName, lastName FROM Students ORDER BY lastName, firstName, emailAddress D. SELECT firstName, lastName, emailAddress FROM Students BY lastName, firstName

A. SELECT firstName, lastName, emailAddress FROM Students ORDER BY lastName, firstName

Which three phrases are advantages of connection pooling? (Choose three.) A. reduces time to create a connection B. requires no configuration C. reduces load on the server D. improved scalability E. improved performance

A. reduces time to create a connection. D. Improved scalability E. Improved performance

You are creating an application that presents users with a graphical interface. Users will run this application from remote computers. Some of the remote computers do not have the . NET Framework installed. Users do not have permissions to install software. Which type of application should you choose?

ASP.NET

You are creating an application that presents the user with a Windows Form. Which event is triggered each time the Windows Form receives focus? • A. Enter • B. Paint • C. Load • D. Activated

Answer : A Explanation: When you change the focus by using the mouse or by calling the Focus method, focus events of the Control class occur in the following order: Enter GotFocus LostFocus Leave Validating Validated

You have a class named Glass that inherits from a base class named Window. The Window class includes a protected method named break(). How should you call the Glass class implementation of the break() method? • A. Window.break(); • B. Glass.break(); • C. this.break(); • D. base.break();

Answer : A This question is too ambiguous. The answer could be both C & D (Technically D as it refers back to the base class). A would only work if the Window class or Break() method are declared as static, this would also defeat the object of the question though as it would refer to the Class its self rather than the base inherited class.

The process of transforming compiled C# code into an XML string for a web service is known as DESTERIALIZEATION. •A. No change is needed •B. serialization •C. decoding •D. encoding

B Steralization

When a web service is referenced from a client application in Microsoft Visual Studio, which two items are created? (Choose two.) • A. a stub • B. a.wsdl file • C. a proxy • D. a .disco file

B. .wsdl file D. .disco file A .wsdl file that referenced the Web service is created, together with supporting files, such as discovery (.disco and discomap) files, that include info about where the web serves is located.

You need to create a property in a class. Consumers of the class must be able to read the values of the property. Consumers of the class must be prevented from writing values to the property. Which property procedure should you include? • A. Return • B. Get • C. Set • D. Let

B. Get

When creating a site to utilize message queuing, the "IP address" must be configured to MSMQ. A. No change is needed B. protocol C. host header D. port

B. Protocol MSMQ is a messaging protocol that allows applications runin on separate servers/processes to communicate in a fail safe manner.

The _________ 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. A. Server.Transfer method B. Server.Execute method C. meta http-equiv='refresh'tag

B. Server.Execute method

Arguments are passed to console applications as a HASHTABLE object. A. No change is needed B. String Array C. StoredProcedureCollection D. Dictionary

B. String Array

The benefit of using a transaction when updating multiple tables is that the update CANNOT FAIL. A. No change is needed B. succeeds or fails as a unit C. finishes as quickly as possible D. can be completed concurrently with other transactions

B. Succeds or fails as a unit The benefit of using a transaction when updating multiple tables is that the update succeeds fails as a unit.

Which function does Simple Object Access Protocol (SOAP) provide when using Web services? A. directory of registered Web services B. communications protocol C. security model D. model for describing Web services

B. communications protocol

Internet Information Services (IIS) must be installed on the client computers in order to run a deployed ASP.NET application. A. No change is needed B. computer that hosts the application C. computer that you plan to deploy from D. Application Layer Gateway Service

B. computer that hosts the applicaiton

What does the Console.Error property do within a console-based application? A. sets the standard error input stream B. gets the standard error output stream C. gets the standard error input stream D. sets the standard error output stream

B. gets the standard error output stream

You are developing a database that other programmers will query to display race results. You need to provide the ability to query race results without allowing access to other information in the database. What should you do? A. Disable implicit transactions. B. place the query into a stored procedure. C. Create an index on the result table. D. Add an AFTER UPDATE trigger on the result table to reject updates

B. place the query into a stored procedure

The Dog class and the Cat class inherit from the Animal class. The animal class includes a breath() method and a 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? A. multiple inheritance B. polymorphism C. data hiding D. encapsulation

B. polymorphism

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

B. server-side

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

C, D

What are two methods that can be used to evaluate the condition of a loop at the start of each iteration? (choose two) A. if B. Do..while C. for D. while

C, D For and While constructs check at the start of each iteration.

You have a Microsoft ASP.NET web application. You need to store a value that can be shared across users on the server. Which type of state management should you use? • A. Session • B. ViewState • C. Application • D. Cookies

C. Application Explanation: Application state is a data repository available to all classes in an ASP.NET application. Application state is stored in memory on the server and is faster than storing and retrieving information in a database. Incorrect: not A: Session State contains information that is pertaining to a specific session (by a particular client/browser/machine) with the server. It's a way to track what the user is doing on the site.. across multiple pages...amid the statelessness of the Web. e.g. the contents of a particular user's shopping cart is session data. Cookies can be used for session state. Not B: Viewstate is a state management technique in asp.net. ASP.NET Viewstate is preserving the data between the requests or postbacks and stored in hidden fields on the page.

Your database administrators will not allow you to write SQL code in your application. How should you retrieve data in your application? A. Script a SELECT statement to a file. B. Query a database view. C. Call a stored procedure. D. Reference an index in the database.

C. Call a stored procedure

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

C. Do..While loop explanation: in a do..while loop the test is at the end of the structure, so it will be executed at least once.

The purpose of the Catch section in an exception handler is to: A. Break out of the error handler. B. Conclude the execution of the application. C. Execute code only when an exception is thrown. D. Execute code regardless of whether an exception is thrown.

C. Execute code only when an exception is thrown.

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

C. Inheritance

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? A. Vehicle. break (); B. This. brake (); C. MyBase.brake(); D. Truck.brake ();

C. MyBase.brake(); -MyBase is commonly used to access base class member that are overridden or shadowed in a derived class.

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

C. Private

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? • A. Add • B. value • C. Set • D. Get

C. Set

Which type of function can a derived class override? A. a non-virtual public member function B. a private virtual function C. a protected virtual member function D. a static function

C. a protected virtual member funtion

To minimize the amount of storage used on the hard drive by an application that generates many small files, you should make the PARTITION as small as possible. A. No change is needed B. file allocation table C. block size D. folder and file names

C. block size

You have a server that limits the number of data connections. What should you use to optimize connectivity when the number of users exceeds the number of available connections? A. Connection timeouts B. Named pipes C. Normalization D. Connection pooling

D. Connection Pooling

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. Windows Forms • B. Windows Service • C. Web-based • D. Console-based

D. Console based

You are creating an application that presents the user with a Windows Form. You need to configure the application to display a message box to confirm that the user wants to close the form. Which event should you handle? • A. Deactivate • B. Leave • C. FormClosed • D. FormClosing

D. FormClosing

You have a table named ITEMS with the following fields: ✑ ID (integer, primary key, auto generated) ✑ Description (text) ✑ Completed (Boolean) You need to insert the following data in the table: "Cheese", False Which statement should you use? A. INSERT INTO ITEMS (ID, Description, Completed) VALUES (1, 'Cheese', 0) B. INSERT INTO ITEMS (Description, Completed) VALUES ('Cheese', 1) C. INSERT INTO ITEMS (10, Description, Completed) VALUES (NEWID(), 'Cheese', 6) D. INSERT INTO ITEMS (Description, Completed) VALUES ('Cheese', 0)

D. INSERT INTO ITEMS (Description, Completed)VALUES ('Cheese', 0)

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?

D. Local Service Local Service, which runs in the context of an account that acts as a non-privileged user on the local computer, and presents anonymous credentials to any remote server.

In the life cycle of an ASP. NET Web page, which phase follows the SaveStateComplete phase? • A. PostBack • B. Postlnit • C. Load • D. Render

D. Render

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? A. value B. add C. get D. set

D. Set - set- users can write -get- users can't change the value

You are creating an ASP. NET Web application. Which line of code should you use to require a control to process on the computer that hosts the application? A. defaultRedirect="ServerPage. htm" B. redirect="HostPage. htm" C. AutoEvencWireup="true" D. runat="server"

D. runat="server"

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

Derived Class

True or False A linked list has a maximum of 100 nodes

False

True or False A queue has a limited number of items

False

True or False An entity relationship Diagram (ERD) is designed for an object-oriented database

False

True or False The 'has a' relationship between classes refers to inheritance.

False

True or False The 'is a' relationship between classes refers to composition

False

True or False XHTML attribute names must be in uppercase

False

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

G. Window Forms

Composition is a ...... relationship

Has a

Which service can host an ASP.Net Application?

IIS Internet Information Services

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

JavaScript

A data dictionary that describes the structure of a database is called _______________

Meta Data

Identifies how the data in one table is realted to the data in another table. (in a relational data base) Relationship is called______________

One-to-many

is the ability of derived classes to share common functionality with base classes but still define their own unique behavior.

Polymorphism

What are the basic state that a Windows service an be in?

Running Stopped Paused

You are creating an applicaiton for a priority help desk center. The most recent call must be handled first.

Stack (LIFO)

Arguments are passed to console applications as a ________ object

String Array

An entity relationship diagram (ERD) contains entities, relationships, and attributes

True

True or False Both composition and inheritance allows you to create sub-objects

True

True or False Cardinality refers to how one table is linked to another table; as one-to-many

True

True or False Within a XHTML document, the html, head, title, and body tags are mandatory.

True

True or False Within an XHTML document, the XHTML DOCTYPE declaration is mandatory.

True

True or False XHTML attribute values must be in quotation marks

True

True or False You can add new nodes anywhere in a linked list

True

True or false XHTML attribute minimization is forbidden

True

Valid SQL Keywords

WHERE FROM UPDATE INSERT DELETE SELECT ORDER BY GROUP BY

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

a list of methods that are available in the Web Service. - the server, in response to this request, displays the Web service's HTML description page. The web service HTML description page shows you all the Web service methods supported by a particular Web service.

Difference b/w Protected & Private

both are ACCESS Modifiers Private -will limit access within the class in which the field is defined. Protected -Access is restricted to the containing class and to any class that is derived directly or indirectly from the containing class.

Method: Response.Redirect

causes the browser to redirect the client to a different URL.

You have a website that includes a form for username 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?

in both the client-side code and the server-side code. -It is important not to forget that Java Script can be disabled in any browser, so client-side validation cannot be relied upon, we must always validate any submitted data on the server.

To avoid runtime errors such as the InvalidCastException, the.....operator can be used to check whether the cast is allowed before actually performing the cast,

is

Strongly typed

language checks the type of a variable before performing any operation.

Weakly typed

language does not check the type of variable before performing operations.