98-364 Free Practice Test

You need to store the contact information for each student in your school database. You should store each student's information in a:

1. A. Stored procedure
2. B. Function
3. C. Row
4. D. Variable

Correct Answer: C

You have a table named Employee that includes four columns. You execute the following statement:
SELECT *
FROM Employee
Which columns are returned?

1. A. all columns
2. B. only the last column
3. C. only the first column
4. D. only the first and last columns

Correct Answer: A

You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126.
Which statement should you use?

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: B

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:

1. A. Empty
2. B. Deleted
3. C. Unchanged
4. D. Archived

Correct Answer: A

You work at a coffee shop. They ask you to set up a website that stores charges on purchases.
You need to recommend a data type in a database table to run financial functions against the charged amounts.
Which data type should you recommend?

1. A. Money
2. B. Bit
3. C. Varchar
4. D. Binary

Correct Answer: A