OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P14: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | Working with Schema Objects 581 3 FROM USER_C 4 WHERE TABLE_ ONSTRAINTS NAME LIKE CUST CONSTRAINT_NAME C TABLE_NAME R_CONSTRAINT_NAME SYS_C002792 C CUSTOMER_ADDRESSES SYS_C002793 C CUSTOMER_ADDRESSES SYS_C002794 C CUSTOMER_ADDRESSES SYS_C002795 C CUSTOMER_ADDRESSES PK_CUST_ADDRESSES P CUSTOMER_ADDRESSES FK_CUST_ADDRESSES R CUSTOMER_ADDRESSES PK_CUSTOMER_MASTER CK_ADD_TYPE2 C CUSTOMER_ADDRESSES CK_ADD_TYPE C CUSTOMER_MASTER PK_CUSTOMER_MASTER P CUSTOMER_MASTER UQ_CUST_EMAIL U CUSTOMER_MASTER PK_CUST_REFS P CUSTOMER_REFERENCES SYS_C002804 R CUSTOMER_REFERENCES PK_CUSTOMER_MASTER SYS_C002805 13 rows selected. SQL R CUSTOMER_REFERENCES PK_CUSTOMER_MASTER SQL SELECT CONSTRAINT_NAME GENERATED INDEX_NAME 2 FROM USER_CONSTRAINTS 3 WHERE TABLE_ NAME LIKE CUST CONSTRAINT_NAME GENERATED INDEX_NAME SYS_C002792 GENERATED NAME SYS_C002793 GENERATED NAME SYS_C002794 GENERATED NAME SYS_C002795 GENERATED NAME PK_CUST_ADDRESSES USER NAME PK_CUST_ADDRESSES FK_CUST_ADDRESSES USER NAME CK_ADD_TYPE2 USER NAME CK_ADD_TYPE USER NAME PK_CUSTOMER_MASTER USER NAME PK_CUSTOMER_MASTER UQ_CUST_EMAIL USER NAME CUST_EMAIL PK_CUST_REFS USER NAME PK_CUST_REFS SYS_C002804 GENERATED NAME SYS_C002805 13 rows selected. SQL GENERATED NAME 582 Chapter 10 Allocating Database Storage and Creating Schema Objects Summary This chapter discussed the most important aspect of the Oracle Database storing data. You learned to create both tablespaces and data files as well as to create schema objects that store the data. You found out how to create and manage tablespaces as well as how Oracle stores some schema objects as segments that are comprised of extents and data blocks. In addition you learned how to create and modify tables indexes and constraints. I also covered deferred constraint checking and how to configure foreign key constraints to support either deferrable or not deferrable implementations. A data file belongs to one tablespace and a tablespace can have one or more data files. The size of the .
