MTA WHOLE NEW

The primary purpose of internet Information Services (IIS) is to: 1. develop ASP.NET Web applications 2. publish ASP.NET Web applications 3. test ASP.NET Web applications 4. host ASP.NET Web applications

4. host ASP.NET Web applications

Class members declared as ____ can be accessed by other classes defined in the same assembly 1. public 2. protected 3. private 4. internal

4. internal

Internet Information Services (IIS) maintains information on: 1. the location of a Web Site's database 2. passwords for password-protected Web sites 3. network accounts that are permitted to access a database 4. the location of Web site's files

4. the location of Web site's files

___ clause specifies the database object from which the records are being selected. 1. SELECT 2. WHERE 3. ORDER BY 4. * 5. FROM

5. FROM

___ operator determines whether a string matches a pattern 1. SELECT 2. WHERE 3. ORDER BY 4. * 5. LIKE

5. LIKE

__ memory is used for local variables, points to location. 1. heap 2. stack 3. queue

2. stack

___ indicates no character or any character or group of characters. 1. # 2. > 3. % 4. * 5. LIKE

3. %

___ data provider is a bridge between an application and data source 1. DataProvider 2. XmlDataSource 3. .NET 4. ListView 5. DataList

3. .NET

You have an Employee class. You need to expose a class member to hold the value of each employee's department. What should you create? 1. A private method 2. A public event 3. A public property 4. A default constructor

3. A public property

You open a command prompt and enter ftp. You are then presented with a screen shown in the graphical exhibit. This is an example of which type of application 1. Windows service 2. Windows Forms 3. Console. 4. ASP.NET

3. Console.

Notepad is an example of a: 1. Windows service 2. Multiple-document interface (MDI) application 3. Web service 4. Single-document interface (SDI) application

4. Single-document interface (SDI) application

A data structure that stores data on a First-In First-Out (FIFO) basis is called: 1. a heap 2. an array 3. a stack 4. a queue

4. a queue

*Karl: quality assurance specialist *Sarah: Developer *Jeff: Solutions architect *Missy: Technical support specialist *Don: Business analyst Match to the following: Requirements analysis Design process Software development Software testing Release management

Don: Requirements analysis Jeff: Design process Sarah: Software development Karl: Software testing Missy: Release management

What term best describes a procedure that is automatically invoked when an object is first instantiated? 1. Constructor 2. Method 3. Creator 4. Routine

1. Constructor

a class constructor has no parameters. What type of constructor is this? 1. Default 2. Overridden 3. Overloaded 4. Virtual

1. Default

A class named Shape contains a method named CalculateArea that is declared as protected. Which classes can access the CalculateArea method? 1. Only the Shape class and all classes that inherit from Shape 2. Only classes that do not inherit from Shape 3. All other classes that are declared as Public 4. All other classes that are declared without an access modifier

1. Only the Shape class and all classes that inherit from Shape

___ clause specifies the fields to be selected. 1. SELECT 2. WHERE 3. ORDER BY 4. * 5. FROM

1. SELECT

____ used in a try-catch-____ statement. 1. else 2. finally 3. do 4. foreach

2. finally

What is a benefit of stored procedures in a database? 1. They can be ported between different database management systems (DBMS) without modification 2. They reduce network traffic and execution time by compiling and storing SQL statements in the database 3. They can execute in the process of the client applications that call them 4. They allow client applications to manage individual copies of SQL statements

1. They can be ported between different database management systems (DBMS) without modification

Is an application that runs in the background without user interaction. Does not provide a user interface. 1. Windows service 2. Windows Forms 3. Console. 4. ASP.NET

1. Windows service

A data structure that stores data on a last-in first-out (LIFO) basis is called. 1. a stack 2. a heap 3. a queue 4. an array

1. a stack

___ used to repeat execution for every element in an array or collection. 1. else 2. finally 3. do 4. foreach

4. foreach

The Car class and the Truck class both inherit characteristics from the Vehicle class. However, the Truck class has methods that are unique to the Truck class, and the Car class has methods that are unique to the Car class. Methods belonging to these two classes can only be accessed by code that is in the same class. Which object-oriented programming term describes this concept? 1. Encapsulation 2. Inheritance 3. Data hiding 4. Polymorphism

1. Encapsulation

Which tool or application is used to host Web sites? 1. Internet information Services 2. Microsoft SQL Server 3. Microsoft Visual SourceSafe 4. Service Control Manager (SCM)

1. Internet information Services

A database table named Book has the following fields: ISBN Title DatePublished PublisherID You need to retrieve the value of the PublisherID for all records where the ISBN field begins with 0972. Which SQL statement should you use? 1. SELECT PublisherID WHERE ISBN LIKE '0972%' 2. SELECT PublisherID WHERE ISBN BEGINS '0972' 3. SELECT PublisherID FOR ISBN > '0972' 4. SELECT PublisherID WITH ISBN > '0972'

1. SELECT PublisherID WHERE ISBN LIKE '0972%'

You want to return values from all fields and all rows in a table named Suggestions Which structured Query Language (SQL) query should you use? 1. SELECT* FROM Suggestions 2. SELECT* FROM Suggestions WHERE SuggestionsID < 10000000 3. SELECT ? FROM Suggestions 4. SELECT ! FROM Suggestions

1. SELECT* FROM Suggestions

What is unit testing? 1. Testing to ensure that such small unit of code behaves as expected 2. Testing to ensure that the entire application meets the requirements. 3. Testing to ensure that all the components of a multi-tiered application communicate as expected 4. Testing to ensure that bugs fixed in previous releases are still fixed in later releases.

1. Testing to ensure that such small unit of code behaves as expected

You need to represent a number that has a decimal places requiring 15 digits of precision. Which numeric data types could you use? (each correct answer presents a complete solution. Choose two) 1. decimal 2. int 3. double 4. float

1. decimal 3. double

You create an if statement that specifies a condition You need to include code that should execute if the condition is not true What should you use? 1. else 2. finally 3. do 4. foreach

1. else

You need to iterate through a collection of strings and print each items in the collection. You do not know how many items are in the collection. You do not want to cast the collection to IEnumerable Which loop structure should you use? 1. foreach 2. while 3. for 4. do-while

1. foreach

Object composition: 1. has-a 2. is-a

1. has-a

Class instances get allocated on the _____ because they have no predefined storage allocation. 1. heap 2. stack 3. queue

1. heap

__ memory is used to for class object instances. 1. heap 2. stack 3. queue

1. heap

What is the purpose of a primary key in a relational database table? 1. it uniquely identifies a record in the table 2. it creates a foreign key constraint to a parent table 3. it defines the complete data definition language (DDL) statement for the table 4. it always creates a non-clustered index on the table

1. it uniquely identifies a record in the table

You want the members of a class to be accessible only to code that is within the same class. Which access modifier should you use? 1. private 2. public 3. protected 4. internal

1. private

You need to model an "is a" relationship. What should you do? 1. Create a class that references another class instance 2. Create a class that accesses properties on another class 3. Create a class that inherits from another class 4. Create a class that invokes methods on another class

2. Create a class that accesses properties on another class

Which of the following characteristics does a console application have? 1. It can share its functionality by being loaded into the processes of other applications 2. It can run with minimal user interaction without mouse input 3. It provides a rich graphical user interface that accepts mouse and keyboard input 4. It can start automatically by the Service Control Manager (SCM)

2. It can run with minimal user interaction without mouse input

You execute the following Structured Query Language (SQL) query: SELECT * FROM Users ORDER BY LastName, FirstName What happens when the query runs? 1. It selects all fields and all records form the Users table sorted by LastName and then FirstName. 2. It selects all fields and all records from the Users table, displaying LastName first, and FIrstName second. 3. It selects only the LastName and the FirstName from the Users table, sorted by Lastname and then FirstName 4. It generates an error because LastName and FirstName are not specified in the SELECT clause

2. It selects all fields and all records from the Users table, displaying LastName first, and FIrstName second.

Cannot host. Relational database management System. Database tables. 1. Internet information Services 2. Microsoft SQL Server 3. Microsoft Visual SourceSafe 4. Service Control Manager (SCM)

2. Microsoft SQL Server

What must you invoke to instantiate a class? 1. Event 2. Property 3. Constructor 4. Field

2. Property

In the lifecycle of an ASP.NET Web page, which phase follows the PreRenderComplete phase? 1. PreInit 2. SaveStateComplete 3. Init 4. Render

2. SaveStateComplete

You implement a method to create an instance of a class named Shape and store it in a local variable How do the stack and the heap participate in the creation of the Shape instance? 1. The Shape instance is created on the heap. The stack is not used 2. The Shape instance is created on the heap. The stack stores a pointer to the Shape instance 3. The Shape instance is created on the stack. The heap stores a pointer to the Shape instance 4. The Shape instance is created on the stack. The hap is not used

2. The Shape instance is created on the heap. The stack stores a pointer to the Shape instance

____ clause includes a condition to filter the results returned by a query. 1. SELECT 2. WHERE 3. ORDER BY 4. * 5. FROM

2. WHERE

Provides a rich graphical user interface that supports keyboard and mouse input. 1. Windows service 2. Windows Forms 3. Console. 4. ASP.NET

2. Windows Forms

You need to develop an application that provides a rich graphical user interface and that runs locally on users' desktops. Which type of application should you create? 1. ASP.NET 2. Windows Forms 3. Console 4. Web service

2. Windows Forms

What type of application presents no user interface? 1. Console-based 2. Windows service 3. Web Forms 4. Windows Forms

2. Windows service

You want to display data from an XML file on your Web page. Which control provides the necessary information to access the XML file that the application can read and display the data? 1. DataProvider 2. XmlDataSource 3. ListView 4. DataList

2. XmlDataSource

When a single inheritance model is used: 1. a base class can contain only one member 2. a class can inherit from only one base class 3. a derived class cannot override any base class members 4. base class members are not available in a derived class

2. a class can inherit from only one base class

What execute the following code. int a = 6; int b = 4; int y = 6; int z = 2; bool _result; _result = (a <(b-z) && (y>z)); What is the value of the variable named _result when the code has executed? 1. Null 2. false 3. 2 4. true

2. false

___ runs whenever code exits the try block. Even unhandled exceptions. Except for when StackOverFlowExecption is encountered 1. try-catch-finally 2. finally block 3. catch block

2. finally block

Inheritance OOP: 1. has-a 2. is-a

2. is-a

Class members declared as ____ can be accessed by derived classes. 1. public 2. protected 3. private 4. internal

2. protected

In software development, a model that is created during the planning and specification phase is called a: 1. hosted application 2. prototype 3. deployment 4. flowchart

2. prototype

Allows you to test for a condition and then executes a set of statements if the condition succeeds. 1. foreach 2. while 3. for 4. do-while

2. while

The catch block of an error handler: 1. records an error code and exits the application 2. records an error code and exits the exception handler 3. Executes when an exception is thrown 4. executes every time the code runs

3. Executes when an exception is thrown

What is the purpose of a virtual directory in Microsoft Internet information Services (IIS) 1. It provides access to different versions of an operating system 2. It serves as a container for application pools 3. It acts as a logical directory to Web browsers for locating Web resources 4. It represents a logical disk for storing session-related data

3. It acts as a logical directory to Web browsers for locating Web resources

These controls are used to display data on the Web page. Pick two: 1. DataProvider 2. XmlDataSource 3. ListView 4. DataList

3. ListView 4. DataList

Source control repository. Keeps track of different items such as code. 1. Internet information Services 2. Microsoft SQL Server 3. Microsoft Visual SourceSafe 4. Service Control Manager (SCM)

3. Microsoft Visual SourceSafe

___ clause determines the order in which the records are returned by the query. 1. SELECT 2. WHERE 3. ORDER BY 4. * 5. FROM

3. ORDER BY

A class hierarchy is defined as follows: SqlLogger inherits from DbLogger, and DbLogger inherits from Logger. Logger defines a method named WriteToLog. DbLogger and SqlLogger override this method. You declare a variable named appLogger of type DbLogger. You create an instance of SqlLogger and assign it to the appLogger variable. You can call the WriteToLog method. What happens when you call this method? 1. The WriteToLog methodof the Logger class executes. 2. The WriteToLog method of the DbLogger class executes 3. The WriteToLog method of the SqlLogger class executes 4. An exception occurs

3. The WriteToLog method of the SqlLogger class executes

____ catches exceptions in the handler. Executes special code when the exception is thrown. 1. try-catch-finally 2. finally 3. catch block

3. catch block

Which statement about classes and structures is true? 1. Classes are allocated on the stack, and structures are allocated on the heap 2. classes are passed by value and structures are passed by reference 3. classes are allocated on the heap and structures are allocated on the stack 4. classes are value types and structures are reference types

3. classes are allocated on the heap and structures are allocated on the stack

___ block executes a set of statements while or until a condition succeeds. Repetition 1. else 2. finally 3. do 4. foreach

3. do

Allows you to execute a set of statements a set number of times. 1. foreach 2. while 3. for 4. do-while

3. for

In relational database design, the process of eliminating unnecessary duplication in the data is called: 1. isolating 2. shrinking 3. normalization 4. separation

3. normalization

The Tricycle class and the Bicycle class are both derived from the ToysWithWheels class. Both inherit the WheelNumber property from the ToysWithWheels class. When an instance of the Tricycle is instantiated, WheelNumber = 3. When an instance of the Bicycle class is instantiated, WheelNumber = 2. Which object-oriented programming term describes this concept? 1. data hiding 2. inheritance 3. polymorphism 4. encapsulation

3. polymorphism

You are solutions developer for your company. You are asked to author a C# desktop application that will run on low-cost, commodity hardware. In your source code, you need to define a variable that will hold values between -32,768 and 32,767. The data type must minimize the memory footprint of the application and support maximum performance. Which data type should you choose for your variable? 1. uint 2. int 3. short 4. byte

3. short

A class member defined with the private access modifier can only be accessed from: 1. derived classes 2. classes defined in the same assembly 3. the class in which it is defined 4. other public classes

3. the class in which it is defined

The ____ notation in the SELECT clause can be interpreted as selecting all of the columns in the specified table or view. 1. SELECT 2. WHERE 3. ORDER BY 4. *

4. *

Users access application from their Web browsers 1. Windows service 2. Windows Forms 3. Console. 4. ASP.NET

4. ASP.NET

You need to configure a Web application to consume a Web service. What should you do? 1. Add the Web service code to the application 2. Register the application with the Web service 3. Add a reference to the application in the Web service 4. Add a reference to the Web service in the application

4. Add a reference to the Web service in the application

Used to manage Windows Services, runs in background without graphical user interface. 1. Internet information Services 2. Microsoft SQL Server 3. Microsoft Visual SourceSafe 4. Service Control Manager (SCM)

4. Service Control Manager (SCM)

You are creating a Web application for someone who sews custom-made clothing. The application will use a simple shopping cart. Interested buyers can put together specifications for garments and place garments in the shopping cart to receive an estimate of the cost. Which classes should you create to model the requirements and minimize the number of classes? 1. ShoppingCart class, Garment class, TotalGarmentSelected class 2. ShoppingCart class, Garment class, Quantity class, Size class, Color class 3. ShoppingCart class, Garment class, Quantity class 4. ShoppingCart class, Garment class

4. ShoppingCart class, Garment class

A .NET data provider is a: 1. user account that has permission to access a database 2. special code in your application that allows it to connect to a database 3. database or file where data is stored 4. bridge between an application and a data source

4. bridge between an application and a data source

Executes the loop first time and then tests the loop condition. 1. foreach 2. while 3. for 4. do-while

4. do-while

You want to execute a set of statements 10 times 1. foreach 2. do 3. while 4. for

4. for