Create table alter any index create session are

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: eges. 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 128: 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 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 frequ...
View Full Document

Ask a homework question - tutors are online