Microsoft Database Fundamentals (98-364) Free Practice Test
Question 1
HOTSPOT
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.
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.
Correct Answer:
Question 2
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.
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Correct Answer:
Question 3
You have a table named Product that contains one million rows.
You need to search for product information in the Product table by using the product's unique ID.
What will make this type of search more efficient?
You need to search for product information in the Product table by using the product's unique ID.
What will make this type of search more efficient?
Correct Answer: D
Question 4
This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALLOW SELECT command to give a user permission to read the data in a table.
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
Use the ALLOW SELECT command to give a user permission to read the data in a table.
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
Correct Answer: D
Question 5
You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted.
What is the result in the database?
What is the result in the database?
Correct Answer: A
Question 6
You need to delete a database table.
Which data definition language (DDL) keyword should you use?
Which data definition language (DDL) keyword should you use?
Correct Answer: D
Question 7
You need to combine the results of two queries into a single result that contains all of the rows from both queries.
Which Structured Query Language (SQL) statement should you use?
Which Structured Query Language (SQL) statement should you use?
Correct Answer: C
Question 8
You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.
You need to change the ProductCategory value for all the spoons in the Product table to
43.
Which statement should you use?
You need to change the ProductCategory value for all the spoons in the Product table to
43.
Which statement should you use?
Correct Answer: C
Question 9
Which statement creates a composite key?
Correct Answer: A
Question 10
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.)
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.)
Correct Answer: C,F