Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 21:

  You create the following table, which lists how many books you have on loan to your friends.

  

  Harry in San Francisco returns your books.

  Which statement will update your table correctly?

  A. UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' AND City = 'San Francisco')

  B. UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' OR City = 'San Francisco')

  C. UPDATE LoanedBooks SET Books = 0 WHERE (Name in 'Harry', 'San Francisco')

  D. INSERT INTO LoanedBooks SET Books = 0 WHERE ID =

  Correct Answer: A

• Question 22:

  This question requires that you evaluate the underlined text to determine if it is correct.

  Truncate is a database term used to describe the process of applying a backup to a damaged or corrupt database.

  Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement corrector.

  A. Change is needed

  B. Commit

  C. Attach

  D. Restore

  Correct Answer: D

• Question 23:

  This question requires that you evaluate the underlined text to determine if it is correct.

  Create a query that returns a set of table data by using the UPDATE statement.

  Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

  A. No change is needed

  B. INSERT

  C. REPLACE

  D. SELECT

  Correct Answer: D

• Question 24:

  Your class project requires that you help a charity to create a website that registers volunteers.

  The website must store the following data about the volunteers: Given name Surname Telephone number Email address

  You need to recommend a correct way to store the data.

  What do you recommend?

  A. Create a table that contains columns that are named given name, surname, phone number, and email.

  B. Create a table that contains rows that are named given name, surname, phone number, and email.

  C. Create a view that contains columns that are named given name surname, phone number, and email.

  D. Create a view that contains rows that are named given name surname, phone number, and email

  Correct Answer: A

• Question 25:

  This question requires that you evaluate the underlined text to determine if it is correct.

  You combine data from three tables into one table. The new table includes redundancy to optimize read performance.

  The data in the new table has been denormalized.

  Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

  A. No change is needed

  B. Normalized

  C. Truncated

  D. Indexed

  Correct Answer: A

• Question 26:

  You need to delete a database table.

  Which data definition language (DDL) keyword should you use?

  A. ALTER

  B. DELETE

  C. DROP

  D. TRUNCATE

  Correct Answer: C

• Question 27:

  You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data:

  

  You need to normalize the data to third normal form. How many tables should you create?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: C

• Question 28:

  You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below:

  

  You create a third table named ChapterLanguage to relate the Chapter table and the Language table.

  You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table. Which two columns should you select? (Choose two.)

  A. ChapterId

  B. LanguageId

  C. Country

  D. Region

  E. City

  F. LanguageName

  Correct Answer: AE

• Question 29:

  This question requires that you evaluate the underlined text to determine if it is correct.

  The JOIN keyword combines the results of two queries and returns only rows that appear in both result sets.

  Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

  A. No change is needed

  B. INTERSECT

  C. ALL

  D. UNION

  Correct Answer: B

  INTERSECT returns rows that are common to both queries

• Question 30:

  You have a database table that contains the following columns:

  

  You must insert the following record into the table:

  

  Which two Structured Query Language (SQL) statements can you use? (Choose two.)

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: BC