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
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 256-259
Chapter 6: Basics of the Oracle Database Architecture
Place the steps for using an EXCEPTIONS table in the correct order. Answer:
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
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide