microsoft 98-364 practice test

Database Fundamentals


Question 1

Which keyword can be used in a create table statement?

  • A. ORDER BY
  • B. DISTINCT
  • C. GROUP BY
  • D. UNIQUE
Answer:

D

Discussions

Question 2

Which of the following are the main approaches in the database design? Each correct answer represents a complete
solution. (Choose three.)

  • A. Top-down approach
  • B. Bottom-up approach
  • C. Middle approach
  • D. Inside-out approach
Answer:

A B D

Discussions

Question 3

What is the relationship between the foreign key and primary key? Each correct answer represents a complete solution.
(Choose all that apply.)

  • A. A foreign key constraint works in conjunction with a primary key constraint to enforce referential integrity among related entities.
  • B. A foreign key ties attribute(s) of an entity to the primary key of another entity, for the purpose of creating a dependency.
  • C. There is no relationship between a primary key and a foreign key.
  • D. A foreign key and a primary key create a link between two entities.
Answer:

A B

Discussions

Question 4

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

  • A. Recover
  • B. Restore
  • C. Commit
  • D. Attach
Answer:

B

Discussions

Question 5

Which of the following statements is true about referential integrity?

  • A. It checks that no component of a primary key can have a null value and no duplicate entries can exist.
  • B. It checks that the value of a primary key must be consistent throughout the life of an instance.
  • C. It distinguishes between null values and zero entries.
  • D. It checks that no record in a child table can exist if its corresponding record is not available in the parent table.
Answer:

D

Discussions

Question 6

You have a table named Product that contains one million rows.
You need to search for product information in the Product table by using the product's unique ID.
What will make this type of search more efficient?

  • A. A cursor
  • B. A subquery
  • C. A trigger
  • D. An index
Answer:

D

Discussions

Question 7

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.

  • A. No change is needed
  • B. 1433 and 1434
  • C. 411 and 412
  • D. 67 and 68
Answer:

B

Discussions

Question 8

Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer represents a
complete solution. (Choose all that apply.)

  • A. INSERT
  • B. UPDATE
  • C. DELETE
  • D. SELECT
Answer:

B D

Discussions

Question 9

You execute the following statement:

This statement is an example of a/an:

  • A. Subquery
  • B. Union
  • C. Outer join
  • D. Cartesian product
Answer:

A

Discussions

Question 10

You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.
Which database object should you add to the Sales table?

  • A. Nonclustered index
  • B. Primary key
  • C. Foreign key
  • D. Clustered index
Answer:

B

Discussions
To page 2