98-364

98-364 practice questions, page 2 of 10, with answer review and explanations.

Question 6

Which statement creates a composite key?

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

Question 7

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. The Customer table no longer exists.
  2. The Customer table is unaffected.
  3. The Customer table exists but has no data.
  4. The script fails.

Question 8

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

  1. when data becomes corrupted in the database
  2. when you need to roll back a transaction
  3. when you encounter an error in your application
  4. when data needs to be deleted from the database

Question 9

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

  1. ALLOW SELECT
  2. LET READ
  3. PERMIT READ
  4. GRANT SELECT

Question 10

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

  1. ALLOW USER
  2. CREATE USER
  3. ADD USER
  4. INSERT USER
  5. ALTER USER