98-364 Free Practice Test

You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?

1. A. 3
2. B. 6
3. C. 9

Correct Answer: D

You need to rename a column in a database table.
Which data definition language (DDL) statement should you use?

1. A. ALTER
2. B. INSERT
3. C. CREATE
4. D. UPDATE

Correct Answer: A

Which statement will result in the creation of an index?

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

Correct Answer: A

Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of 12345. Which statement should you use?

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

Correct Answer: D

Which type of index changes the order in which the data is stored in a table?

1. A. non-sequential
2. B. sequential
3. C. non-clustered
4. D. clustered

Correct Answer: D