Microsoft 98-364 - Database Fundamentals Exam
Page: 2 / 47
Total 235 questions
Question #6 (Topic: Single Topic)
Which statement creates a composite key?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Question #7 (Topic: Single Topic)
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?
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.
Answer: A
Question #8 (Topic: Single Topic)
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
Answer: A
Question #9 (Topic: Single Topic)
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
Answer: D
Question #10 (Topic: Single Topic)
You need to enable a new employee to authenticate to your database.
Which command should you use?
Which command should you use?
A. ALLOW USER
B. CREATE USER
C. ADD USER
D. INSERT USER
E. ALTER USER
Answer: B
