Dictionary views dbatablespaces and dbafreespace will

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: ACE will provide information about space usage in a tablespace. Incorrect Answers: A: DBA_TABLES view shows information only about tables, not tablespaces. B: DBA_EXTENTS dictionary view provides information about extents, not about tablespaces. E: There is no DBA_SPACE_USAGE view in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 352-353 Chapter 7: Managing the Physical Database Structure QUESTION 112: Two tables have a parent-child relationship that will be enforced by a primary key constraint and foreign key constraint. You would like the flexibility to insert rows in the child table before inserting rows in the parent table. What must you create to enforce the primary key constraint with a unique index? Actualtests.com - The Power of Knowing 1Z0-023 A. Both constraints DEFERRABLE. B. The foreign key constraints DEFERRABLE and the primary key constraint NOT DEFERRABLE. C. Both constraints NOT DEFERRABLE, and use the SET CONSTRAINT command to defer checking of the foreign key constraint as needed. D. Both constraints NOT DEFERRABLE, and use the AL...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online