READ Free Dumps For Oracle- 1z0-023
| Question ID 8781 | Which memory area in the SGA us used by Oracle when compiling an SQL statement?
|
| Option A | Context area
|
| Option B | Log buffer area
|
| Option C | Shared pool area
|
| Option D | Data buffer cache
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. Oracle uses SHARED POOL area to compile an SQL statement. SHARED POOL includes the LIBRARY CACHE, used for storing parsed SQL statement text and the statement's execution plan for reuse, the DICTIONARY CACHE, sometimes also referred to as the ROW CACHE, which is used for storing recently accessed information from the Oracle data dictionary. The optional SHARED POOL structure contains session information about user processes connected to Oracle. Incorrect Answers: A: There is no CONTEXT area in the SG A. There are BUFFER CACHE, SHARED POOL and REDO LOG BUFFER in the SGA of Oracle instance. B: LOG BUFFER area is not used when compiling an SQL statement. This component 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 ID 8782 | You are loading data from an external system into an Oracle table. You will add constraints to the table after loading the data. You are willing to accept data from the external system that violates the constraints. However, you must prevent future changes to the table that would violate the constraint. Which constraint state should you use?
|
| Option A | ENABLE VALIDATE.
|
| Option B | DISABLE VALIDATE.
|
| Option C | ENABLE DEFERRED.
|
| Option D | ENABLE NOVALIDATE.
|
| Option E | DISABLE NOVALIDATE
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. ENABLE NOVALIDATE constraint will enforce the constraint for new data entering the table but don't care about data that already exists in the table. Incorrect Answers: A: ENABLE VALIDATE constraint forces Oracle to validate all the data in the constrained column to ensure that data meets the constraint criteria. B: There is no DISABLE VALIDATE option in Oracle, just DESABLE. D: ENABLE DEFERRABLE option exists, not ENABLE DEFERRED. E: There is no DISABLE NOVALIDATE option in Oracle, just DESABLE. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 436 Chapter 9: Managing Database Objects II