Online Access Free 98-364 Practice Test

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.

• A.No change is needed
• B.Six
• C.Zero
• D.Three

Denormalization is performed in order to:

• A.Improve query performance.
• B.Create smaller tables.
• C.Reduce redundancy.
• D.Eliminate repeating groups.

You develop a database to store data about textbooks. The data must be stored to process at a later time.
Which database object should you use to store the data?

• A.Stored procedure
• B.View
• C.Table
• D.Function

This question requires that you evaluate the underlined text to determine if it is correct.
The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those 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 correct

• A.DROP TABLE
• B.ALTER TABLE
• C.TRUNCATE TABLE
• D.No change is needed

This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.
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

• A.INTERSECT
• B.No change is needed
• C.ALL
• D.UOIN