98-364 Free Practice Test

This question requires that you evaluate the underlined text to determine if it is correct.
You combine data from three tables into one table. The new table includes redundancy to optimize read performance.
The data in the new table has been denormalized.
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 correct.

1. A. No change is needed
2. B. Normalized
3. C. Truncated
4. D. Indexed

Correct Answer: A

This question requires that you evaluate the underlined text to determine if it is correct. A row holds information for a single record in a table.
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 correct

1. A. No change is needed
2. B. Column
3. C. Data type
4. D. View

Correct Answer: A

This question requires that you evaluate the underlined text to determine if it is correct. Ports 20 and 21 are the default ports to secure a SQL Server.
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 correct.

1. A. No change is needed
2. B. 1433 and 1434
3. C. 411 and 412
4. D. 67 and 68

Correct Answer: B

A database contains two tables named Customer and Order. You execute the following statement:
DELETE FROM Order
WHERE CustomerID = 209
What is the result?

1. A. The first order for CustomerID 209 is deleted from the Order table.
2. B. All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.
3. C. All orders for CustomerID 209 are deleted from the Order table.
4. D. CustomerID 209 is deleted from the Customer table.

Correct Answer: C

A named group of SQL statements that can be executed in a database is called a:

1. A. Subroutine
2. B. Formula
3. C. Stored procedure
4. D. Method

Correct Answer: C