Database Fundamentals Practice Questions
Prepare for 98-364 with more than an answer.
- 1
You are the database administrator of a MySQL server that runs on a Windows server.
All clients are local clients.
For security, you want to disable connections from the remote clients.
Which of the following steps will you take to accomplish the task?
Show answer details
Correct answer: C
C
- 2
Which of the following are the correct statements of using the Flashback Query feature in Oracle? Each correct answer represents a complete solution. (Choose all that apply.)
Show answer details
Correct answer: A
A, B
- 3
You work as a Database Administrator for InfoTech Inc.
The company has a database and they want you to create a design for a database that will support the enterprise’s operations and objectives.
Which of the following will you use to accomplish the task?
Show answer details
Correct answer: B
B
- 4
Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer represents a complete solution. (Choose all that apply.)
Show answer details
Correct answer: B, D
B, D
B, D
- 5
Which of the following steps in database planning is used to record an object so that it is represented visually in the system?
Show answer details
Correct answer: D
D
- 6
Which of the following provides reliable units of work that allow correct recovery from failures and keeps a database consistent even in cases of system failure?
Show answer details
Correct answer: D
D
