This preview shows page 1. Sign up to view the full content.
Unformatted text preview: eges.
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
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
LGWR frequently waits on a checkpoint before performing a log switch. Which action
should a DBA take?
A. Add a redo log group.
B. Add additional archive processes.
C. Increase the number of rollback segments.
D. Increase the size of the rollback segments.
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.
B: The archive process does not affect frequ...
View Full Document
- Fall '09