B the user peter will be created with system

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: B: The user peter will be created with SYSTEM tablespace as the default and TEMP tablespace as the temporary tablespace. D: The code above is correct, user peter will be successfully created. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 466 Chapter 10: Managing Database Use QUESTION 6: An oracle user receives the following error: ORA-01555 SNAPSHOP TOO OLD What are two possible solutions? (Choose two) A. Increase the extent size of the rollback segments. B. Perform media recovery. C. Increase the number of rollback segments. D. Increase the size of the rollback segment tablespace. E. Increase he value of OPTIMAL storage parameter. Answer: A, E Explanation: Answers A and E are correct. Recall that rollback segments allow transaction-level read consistency for all statements running on the database. A long-running query in one session that starts before a change on that data is committed by another session will see the data as it existed pre-commit. I Oracle can not provide a read-consistent view of data, the following error will ensure "ORA-01555 - snapshot too old (rollback segment too small)&quo...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online