98-364 Free Practice Test

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?

1. A. The Customer table no longer exists.
2. B. The Customer table is unaffected.
3. C. The Customer table exists but has no data.
4. D. The script fails.

Correct Answer: A

HOTSPOT
The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.

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

You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:

1. A. Inherited delete
2. B. Cascade delete
3. C. Functional delete
4. D. Waterfall delete
5. E. Domino delete

Correct Answer: B

This question requires that you evaluate the underlined text to determine if it is correct. Views are database objects that contain all of the data in a database.
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. Queries
3. C. Stored procedures
4. D. Tables

Correct Answer: D

You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?

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

Correct Answer: D