Unformatted text preview: ACE will provide information about space usage in a tablespace.
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
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
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
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide