98-364 Free Practice Test

In which situation do you need to perform a restore on a database?

1. A. when data becomes corrupted in the database
2. B. when you need to roll back a transaction
3. C. when you encounter an error in your application
4. D. when data needs to be deleted from the database

Correct Answer: A

Which category of SQL statements is used to add, remove, and modify database structures?

1. A. Data access language (DAL)
2. B. Data manipulation language (DML)
3. C. Data control language (DCL)
4. D. Data definition language (DDL)

Correct Answer: D

You have the following table definition:
CREATE TABLE Road (RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:

You execute the following statement: INSERT INTO Road VALUES (1234, 36)
What is the result?

1. A. an error stating that NULL values are not allowed
2. B. a new row in the table
3. C. an error stating that duplicate IDs are not allowed
4. D. a syntax error

Correct Answer: B

This question requires that you evaluate the underlined text to determine if it is correct. You have two tables. Each table has three rows.
Nine rows will be included in the Cartesian product of these two tables.
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 corrector.

1. A. No change is needed
2. B. Zero
3. C. Three
4. D. Six

Correct Answer: A

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.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A