Microsoft Database Fundamentals - 98-364 Exam Practice Test
This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALTER statement to add a new table in a 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 correct.
Use the ALTER statement to add a new table in a 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 correct.
Correct Answer: D
Which constraint ensures a unique value in the ID column for each customer?
Correct Answer: B
You have the database table named Cars as defined below:
You have the following Structured Query Language (SQL) statement:
How many rows are returned by the SQL statement?
You have the following Structured Query Language (SQL) statement:
How many rows are returned by the SQL statement?
Correct Answer: A
You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?
Correct Answer: D
You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
Which database term is used to describe the relationship between ProductID and ProductCategory?
Correct Answer: B
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:
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.
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.
Correct Answer: C
Which keyword must be included in a create view statement?
Correct Answer: C