READ Free Dumps For Oracle- 1z0-023
| Question ID 8884 | What are three examples of system privileges? (Choose three)
|
| Option A | UPDATE
|
| Option B | EXECUTE
|
| Option C | REFERENCES
|
| Option D | CREATE TABLE
|
| Option E | ALTER ANY INDEX
|
| Option F | CREATE SESSION
|
| Correct Answer | DEF |
Explanation Explanation/Reference: Explanation: Answers D, E and F are correct. CREATE TABLE, ALTER ANY INDEX, CREATE SESSION are system privileges. Incorrect Answers: A: UPDATE is an object privilege. Permits the grantee of this object privilege to update data into a table or view. B: EXECUTE is an object, not system, privilege. Permits the grantee to run a stored procedure or function. C: REFERENCES is object privilege. Permits the grantee to create or alter a table in order to create a FOREIGN KEY constraint against data in the referenced table. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 480-484 Chapter 10: Managing Database Use
| Question ID 8889 | LGWR frequently waits on a checkpoint before performing a log switch. Which action should a DBA take?
|
| Option A | Add a redo log group.
|
| Option B | Add additional archive processes.
|
| Option C | Increase the number of rollback segments.
|
| Option D | Increase the size of the rollback segments
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. To avoid situation when LGWR waits on a checkpoint before performing a log switch DBA needs to add a redo log group. Incorrect Answers: B: The archive process does not affect frequency of checkpoints. C: The number of rollback segments does not affect checkpoints. D: The size of rollback segments has nothing to do with checkpoints. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 328-330 Chapter 7: Managing the Physical Database Structure