Microsoft 98-364 Online Practice Questions and Exam Preparation

Microsoft 98-364 Online Questions & Answers

• Question 1:

  HOTSPOT

  Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

  Hot Area:

  

  

• Question 2:

  Which two keys establish a relationship between two tables? (Choose two.)

  A. candidate
  B. foreign
  C. superkey
  D. local
  E. primary
  B. foreign
  E. primary

• Question 3:

  You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column.

  The results include: All customers and their orders Customers who have no orders

  Which type of join do these results represent?

  A. Complete join
  B. Partial join
  C. Inner join
  D. Outer join
  D. Outer join

• Question 4:

  You have a table named Employee that includes the following columns:

  EmployeeID Smp1oyeeName Which statement should you use to return the number of rows in the table?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 5:

  You have a database that contains 10 terabytes of data. You need to back up the database every two hours. Which type of backup should you use?

  A. archive
  B. incremental
  C. partial
  D. full
  C. partial

• Question 6:

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

  A. Subroutine
  B. Formula
  C. Stored procedure
  D. Method
  C. Stored procedure

• Question 7:

  Which key uniquely identifies a row in a table?

  A. foreiqn
  B. primary
  C. local
  D. superkey
  B. primary

• Question 8:

  This question requires that you evaluate the underlined text to determine if it is correct.

  A key defines the amount of storage space that is allocated to a value in a column.

  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. format
  C. data type
  D. validator
  C. data type

• Question 9:

  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
  B. Primary key

• Question 10:

  Which command should you use to add a column to an existing table?

  A. MODIFY
  B. ALTER
  C. UPDATE
  D. INSERT
  E. CHANGE
  B. ALTER