This component of sga temporarily stores in the

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: of SGA temporarily stores in the memory the redo entry information generated by DML statements run in user sessions until Oracle writes the information to disk. D: DATA BUFFER CACHE is not used for this purpose. This memory structure consists of buffers the size of database blocks that store data needed by SQL statements issued in user processes. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 256-259 Chapter 6: Basics of the Oracle Database Architecture QUESTION 34: Place the steps for using an EXCEPTIONS table in the correct order. Answer: Explanation: Correct order: Create the EXCEPTIONS table Execute ALTER TABLE with the execution clause Use the EXCEPTION table to locate rows with invalid data. Correct the rows with invalid data Execute ALTER TABLE to enable for constraint You need first create the EXCEPTIONS table, execute ALTER TABLE with the execution clause to find exceptions in data, analyze the EXCEPTIONS table to locate rows with invalid data, correct the rows with invalid data and after that enable constraint for table. Oracle 8, DBA C...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online