Microsoft Microsoft Certifications 98-361 Questions & Answers

• Question 201:

  You need to create an application that processes data on a last-in, first-out (LIFO) basis. Which data structure should you use?

  A. Queue

  B. Tree

  C. Stack

  D. Array

  Correct Answer: C

  A stack implements LIFO.

• Question 202:

  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?

  A. Isolation

  B. Normalization

  C. Integration

  D. Resolution

  Correct Answer: B

  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.

• Question 203:

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

  Correct Answer: A

  to sort use: ORDER BY LastName, FirstName

• Question 204:

  A data warehouse database is designed to:

  A. Enable business decisions by collecting, consolidating, and organizing data.

  B. Support a large number of concurrent users.

  C. Support real-time business operations.

  D. Require validation of incoming data during real-time business transactions.

  Correct Answer: A

• Question 205:

  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

  Correct Answer: D

  The Closing event occurs as the form is being closed.

• Question 206:

  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

  A.

  Windows Service

  B.

  Windows Forms

  C.

  Console-based

  D.

  Batch file

  Correct Answer: A

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

• Question 207:

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

  A. SQL

  B. C++

  C. Pascal

  D. Java

  Correct Answer: A

  SQL uses DDL and DML.

• Question 208:

  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 speeds up query execution.

  C. It minimizes storage requirements.

  D. It reorders the records numerically.

  Correct Answer: B

  Faster to access an index table.

• Question 209:

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

  A. Java

  B. SQL

  C. C++

  D. Visual Basic

  Correct Answer: B

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

• Question 210:

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

  A. Extensible Markup Language (XML)

  B. Cascading Style Sheets (CSS)

  C. Hypertext Markup Language (HTML)

  D. JavaScript (JS)

  Correct Answer: D

  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.