Microsoft 98-361 Online Practice Questions and Exam Preparation

Microsoft 98-361 Online Questions & Answers

• Question 81:

  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
  B. SQL

  ---

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

• Question 82:

  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
  B. Normalization

  ---

  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 83:

  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', 6)
  A. INSERT INTO ITEMS (ID, Description, Completed) VALUES (1, 'Cheese', 0)

• Question 84:

  You are creating a variable for an application.

  You need to store data that has the following characteristics in this variable:

  1.

  Consists of numbers and characters

  2.

  Includes numbers that have decimal points Which data type should you use?

  A. String
  B. Float
  C. Char
  D. Decimal
  A. String

  ---

  Need a string to store characters.

• Question 85:

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

  ---

  to sort use: ORDER BY LastName, FirstName

• Question 86:

  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
  A. Windows Service

  ---

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

• Question 87:

  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.
  C. Add a reference to the Web service in the application.

  ---

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

• Question 88:

  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

  ---

  The Closing event occurs as the form is being closed.

• Question 89:

  For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

  Hot Area:

  

  

• Question 90:

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

  A. a visual depiction of your preliminary connection to the Web service
  B. a listing of methods that are available in the Web service
  C. an error page explaining that you have accessed the Web service incorrectly
  D. a directory listing of the Web services application structure
  A. a visual depiction of your preliminary connection to the Web service