Databases Design Section 9

1.  In an Oracle database, why would 1_TABLE not work as a table name?

Object names must not start with a number. They must begin with a letter. (*)
2.  Attributes become columns in a database table. True or False?
True (*)
3.  In a physical data model, an attribute becomes a _____________.
Column (*)
4.  In a physical data model, a relationship is represented as a:

Foreign Key (*)
5.  A foreign key always refers to a primary key in the same table. True or False?

False (*)
6.  Foreign keys must be null. True or False?
False (*)
7.  Column integrity refers to
Columns always containing values consistent with the defined data format (*)
8.  A foreign key cannot refer to a primary key in the same table. True or False?

False (*)
9.  In a physical model, many to many relationships are resolved via a structure called a(n): ________________
Intersection Table (*)
10.  One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False?
False (*)
11.  The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False?
False (*)
12.  It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False?
False (*)
13.  The "Arc Implementation" is a synonym for what type of implementation?
Supertype and Subtype Implementation (*)
14.  Which of the following is a valid reason for considering a Subtype Implementation?

Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
15.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?
True (*)