Microsoft Database Fundamentals - 98-364 Exam Practice Test
Question 1
This question requires that you evaluate the underlined text to determine if it is correct.
Ports 20 and 21 are the default ports to secure a SQL Server.
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.
Ports 20 and 21 are the default ports to secure a SQL Server.
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 2
In SQL, an insert statement is used to add a:
Correct Answer: A
Question 3
The Product table contains the following data.
You execute the following statement:
SELECT COUNT(*)
FROM Product WHERE Quantity > 18
What is the value returned by this statement?
You execute the following statement:
SELECT COUNT(*)
FROM Product WHERE Quantity > 18
What is the value returned by this statement?
Correct Answer: C
Question 4
You need to store the first name, last name, and student ID for 100 students.
This information will be stored in a table as:
This information will be stored in a table as:
Correct Answer: B
Question 5
You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product to
glass.
What should you include in the update statement?
You need to write an UPDATE statement to change the name of a specific product to
glass.
What should you include in the update statement?
Correct Answer: B
Question 6
Which statement will result in the creation of an index?
Correct Answer: C
Question 7
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.
Which data type should you use?
Which data type should you use?
Correct Answer: A
