98-361 : Software Development Fundamentals : Part 02

98-361 : Software Development Fundamentals : Part 02

1. The purpose of the Catch section in an exception handler is to:

   • Break out of the error handler.
   • Conclude the execution of the application.
   • Execute code only when an exception is thrown.
   • Execute code regardless of whether an exception is thrown.

2. You execute the following code.

   

   How many times will the word Hello be printed?

   • 5
   • 6
   • 10
   • 12

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

   • PostBack
   • Postlnit
   • Load
   • Render
   Explanation:

   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.

4. 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?

   • defaultRedirect=”ServerPage. htm”
   • redirect=”HostPage. htm”
   • AutoEvencWireup=”true”
   • runat=”server”

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

   

   • All tags are not in uppercase.
   • The body tag is missing a background attribute.
   • The line break tag is incorrectly formatted.
   • The HTML tags do not read XHTML.
   Explanation:

   In XHTML, the <br> tag must be properly closed, like this: <br />.

6. You create an application that uses Simple Object Access Protocol (SOAP).

   Which technology provides information about the application’s functionality to other applications?

   • Web Service Description Language (WSDL)
   • Extensible Application Markup Language (XAML)
   • Common Intermediate Language (CIL)
   • Universal Description, Discovery, and Integration (UDDI)
   Explanation:

   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.

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

   • Extensible Markup Language (XML)
   • Cascading Style Sheets (CSS)
   • Hypertext Markup Language (HTML)
   • JavaScript (JS)
   Explanation:

   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.

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

   • Add the Web service to the development computer.
   • Add a reference to the Web service in the application.
   • Add a reference to the application in the Web service.
   • Add the Web service code to the application.
   Explanation:

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

9. What are two possible options for representing a Web application within Internet Information Services (IIS)? (Each correct answer presents a complete solution. Choose two. )

   • Web site
   • Web directory
   • Virtual directory
   • Application server
   • Application directory
   Explanation:

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

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

    • SQL
    • C++
    • Pascal
    • Java
    Explanation:

    SQL uses DDL and DML.

11. 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?

    • It reorders the records alphabetically.
    • It speeds up query execution.
    • It minimizes storage requirements.
    • It reorders the records numerically.
    Explanation:

    Faster to access an index table.

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

    • Java
    • SQL
    • C++
    • Visual Basic
    Explanation:

    SQL is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS).

13. You need to ensure the data integrity of a database by resolving insertion, update, and deletion anomalies.

    Which term is used to describe this process in relational database design?

    • Isolation
    • Normalization
    • Integration
    • Resolution
    Explanation:

    Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database using the defined relationships.

14. 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?

    

    • Option A
    • Option B
    • Option C
    • Option D
    Explanation:

    to sort use: ORDER BY LastName, FirstName

15. A data warehouse database is designed to:

    • Enable business decisions by collecting, consolidating, and organizing data.
    • Support a large number of concurrent users.
    • Support real-time business operations.
    • Require validation of incoming data during real-time business transactions.

16. 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?

    • Deactivate
    • Leave
    • FormClosed
    • FormClosing
    Explanation:

    The Closing event occurs as the form is being closed.

17. Which type of application has the following characteristics when it is installed?

    – Runs continuously in the background by default when the startup type is set to automatic

    – Presents no user interface

    • Windows Service
    • Windows Forms
    • Console-based
    • Batch file
    Explanation:

    A Windows service runs in the background and has no interface.

18. 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?

    • Windows Forms
    • Windows Service
    • Web-based
    • Console-based

19. You need to create an application that processes data on a last-in, first-out (LIFO) basis.

    Which data structure should you use?

    • Queue
    • Tree
    • Stack
    • Array
    Explanation:

    A stack implements LIFO.

20. 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?

    • Binary tree
    • Stack
    • Hashtable
    • Queue
    Explanation:

    A queue keeps the order of the items.