Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 111:

  Which key uniquely identifies a row in a table?

  A. foreiqn

  B. primary

  C. local

  D. superkey

  Correct Answer: B

• Question 112:

  Which statement creates a composite key?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 113:

  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?

  A. The Customer table no longer exists.

  B. The Customer table is unaffected.

  C. The Customer table exists but has no data.

  D. The script fails.

  Correct Answer: A

• Question 114:

  In which situation do you need to perform a restore on a database?

  A. when data becomes corrupted in the database

  B. when you need to roll back a transaction

  C. when you encounter an error in your application

  D. when data needs to be deleted from the database

  Correct Answer: A

• Question 115:

  Which command should you use to give a user permission to read the data in a table?

  A. ALLOW SELECT

  B. LET READ

  C. PERMIT READ

  D. GRANT SELECT

  Correct Answer: D

• Question 116:

  You need to enable a new employee to authenticate to your database. Which command should you use?

  A. ALLOW USER

  B. CREATE USER

  C. ADD USER

  D. INSERT USER

  E. ALTER USER

  Correct Answer: B

• Question 117:

  Which keyword can be used in a create table statement?

  A. ORDER BY

  B. DISTINCT

  C. GROUP BY

  D. UNIQUE

  Correct Answer: D

• Question 118:

  You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?

  A. INTEGER

  B. DOUBLE

  C. COUNT

  D. FLOAT

  Correct Answer: A

• Question 119:

  Which statement will result in the creation of an index?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 120:

  You have the following table definition:

  CREATE TABLE Road (RoadID INTEGER NOT NULL, Distance INTEGER NOT NULL)

  The Road table contains the following data: You execute the following statement: INSERT INTO Road VALUES (1234, 36)

  

  What is the result?

  A. an error stating that NULL values are not allowed

  B. a new row in the table

  C. an error stating that duplicate IDs are not allowed

  D. a syntax error

  Correct Answer: B