Microsoft Microsoft Certifications 98-361 Questions & Answers

• Question 111:

  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. B. C. D.

  Correct Answer: D

  to sort use: ORDER BY LastName, FirstName

• Question 112:

  Which language uses Data Definition Language (DDL) and Data Manipulation Language (DML)?

  A. Java

  B. C+ +

  C. SQL

  D. Pascal

  Correct Answer: C

  SQL uses DDL and DML.

• Question 113:

  A table named Student has columns named ID, Name, and Age. An index has been created on the ID column. What advantage does this index provide?

  A. It reorders the records alphabetically.

  B. It reorders the records numerically.

  C. It speeds up query execution.

  D. It minimizes storage requirements.

  Correct Answer: C

  Faster to access an index table.

• Question 114:

  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.

  Correct Answer: A

  In XHTML, the
  tag must be properly closed, like this:
  .

• Question 115:

  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. runat= "server"

  B. redirect*="HostPage. htm"

  C. AutoEventWireup="true"

  D. defaultRedirect="ServerPage. htm"

  Correct Answer: A

• Question 116:

  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. virtual directory

  C. application directory

  D. application server

  E. Web directory

  Correct Answer: AB

  *

  Create a Web Application An application is a grouping of content at the root level of a Web site or a grouping of content in a separate folder under the Web site's root directory. When you add an application in IIS 7, you designate a directory as the application root, or starting point, for the application and then specify properties specific to that particular application, such as the application pool that the application will run in.

  *

  You can make an Existing Virtual Directory a Web Application.

• Question 117:

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

  A. Add the Web service to the development computer.

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

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

  D. Add the Web service code to the application.

  Correct Answer: C

  Start by adding a Service Reference to the project. Right-click the ConsoleApplication1 project and choose "Add Service Reference":

• Question 118:

  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)

  Correct Answer: A

  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.

• Question 119:

  In the life cycle of an ASP. NET Web page, which phase follows the SaveStateComplete phase?

  A. Load

  B. Render

  C. PostInit

  D. PostBack

  Correct Answer: B

  The SaveStateComplete event is raised after the view state and control state of the page and controls on the page are saved to the persistence medium. This is the last event raised before the page is rendered to the requesting browser.

• Question 120:

  Which language allows you to dynamically create content on the client side?

  A. Cascading Style Sheets (CSS)

  B. JavaScript (JS)

  C. Extensible Markup Language (XML)

  D. Hypertext Markup Language (HTML)

  Correct Answer: B

  JavaScript (JS) is a dynamic computer programming language. It is most commonly used as part of web browsers, whose implementations allow client-side scripts to interact with the user, control the browser, communicate asynchronously, and alter the document content that is displayed.