Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 121:

  The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

  A. View

  B. Function

  C. Index

  D. Stored procedure

  E. Trigger

  Correct Answer: C

• Question 122:

  One reason to add an index is to:

  A. Decrease storage space.

  B. Increase database security.

  C. Improve performance of select statements.

  D. Improve performance of insert statements.

  Correct Answer: C

• Question 123:

  You have a table that contains the following data.

  

  You break the table into the following two tables.

  

  This process is referred to as:

  A. defragmentation

  B. normalization

  C. fragmentation

  D. denormalization

  Correct Answer: B

• Question 124:

  You have a table that contains the following data.

  

  Which database term is used to describe the relationship between ProductID and ProductCategory?

  A. Cohort

  B. Relationally dependent

  C. Deterministic

  D. Functionally dependent

  E. Compositional

  Correct Answer: D

• Question 125:

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

  

  Correct Answer:

  

• Question 126:

  The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.

  

  Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 127:

  The following illustration shows the structure of a clustered index in a single partition:

  

  Instructions: Use the drop-down menus to select the answer choice that completes each statement Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 128:

  You have the following table:

  

  Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

  Hot Area:

  

  Hot Area:

  

  Correct Answer:

  

• Question 129:

  You need to set up a database to provide a view of North American mammals. Match the Structured Query Language (SQL) statements to the SQL query.

  Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 130:

  You have a database table that stores information about school attendance. You have a data set that is defined as follows:

  

  You have the following requirements:

  StudentName must consist of a string of characters.

  GradeLevel must be only a whole number.

  DaysAbsent can have one number after the decimal.

  Match the data types to the column names.

  Instructions: To answer, drag the appropriate data type from the column on the left to its column name on the right Each data type may be used once, more than once, or not at all. Each correct match is worth one point.

  Select and Place:

  

  Correct Answer: