98-364 Free Practice Test

You need to establish a set of permissions that you can routinely assign to new users. What should you create?

1. A. Resource
2. B. Group
3. C. List
4. D. Role

Correct Answer: D

What is one difference between an update statement and a delete statement?

1. A. An update statement can change only one row.
2. B. A delete statement cannot use a where clause.
3. C. An update statement does not remove rows from a table.
4. D. A delete statement works only within a stored procedure.

Correct Answer: C

You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department
This type of operation is called a/an:

1. A. Intersection
2. B. Outer join
3. C. Equi-join
4. D. Cartesian product

Correct Answer: D

You have a table named Product that contains the following data.

The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.
You execute the following statement:
INSERT INTO Product VALUES (3296, 'Table', 4444)
What is the result?

1. A. a foreign key constraint violation
2. B. a syntax error
3. C. a new row in the Product table
4. D. a primary key constraint violation
5. E. a new row in the Category table

Correct Answer: D

HOTSPOT
You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column.

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A