Microsoft 98-364 Actual Free Exam Questions & Community Discussion
Which statement will result in the creation of an index?
Correct Answer: D
Vote an answer
You are writing an SQL statement to retrieve rows from a table.
Which data manipulation language (DML) command should you use?
Which data manipulation language (DML) command should you use?
Correct Answer: C
Vote an answer
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:
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
Vote an answer
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?
You need to normalize the data to third normal form.
How many tables should you create?
Correct Answer: C
Vote an 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
Vote an answer
Which statement deletes the rows where the employee's phone number is not entered?
Correct Answer: D
Vote an answer
0
0
0
10