Microsoft Database Fundamentals - 98-364 FREE EXAM DUMPS QUESTIONS & ANSWERS
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:
HOTSPOT
The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
Correct Answer:
You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category.
You execute a statement on the Product table that deletes all the products in the Furniture category.
After you execute the statement, the result set of the view is:
You execute a statement on the Product table that deletes all the products in the Furniture category.
After you execute the statement, the result set of the view is:
Correct Answer: B
Vote an answer
You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?
Correct Answer: B
Vote an answer
What is one difference between an update statement and a delete statement?
Correct Answer: B
Vote an answer
You have the following table definition:
CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20))
You need to insert a new product. The product's name is Plate and the product's ID is 12345.
Which statement should you use?
CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20))
You need to insert a new product. The product's name is Plate and the product's ID is 12345.
Which statement should you use?
Correct Answer: D
Vote an answer
You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements.
You need to ensure that a column or combination of columns uniquely identifies each row of a table.
Which constraint should you define?
You need to ensure that a column or combination of columns uniquely identifies each row of a table.
Which constraint should you define?
Correct Answer: C
Vote an answer
Which constraint ensures a unique value in the ID column for each customer?
Correct Answer: B
Vote an answer