Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 131:

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

  Your class project requires that you help a charity set up a website.

  The website collects information about volunteers. Each volunteer record must be uniquely identified.

  The following information is stored for each volunteer:

  Given name

  Surname

  Date of birth

  Phone number

  Photo

  You need to create a table to meet the requirements.

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

  You have two database tables as defined below. The first table contains information about students. The second table contains information about courses. The two tables are related by CourseID.

  

  Match the CourseName to the StudentName.

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

  Select and Place:

  

  Correct Answer:

  

• Question 134:

  HOTSPOT

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

  HOTSPOT

  You have a user that has server roles as defined below:

  

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

  The following illustration shows backup strategies that use the simple recovery model and the full recovery model:

  

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

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

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

  You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column.

  

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

  You are structuring a table in a relational database.

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

  Hot Area:

  

  Correct Answer: