marți, 24 noiembrie 2009

Quiz: Basic Mapping: The Transformation Process


1. In a physical data model, a relationship is represented as a:
Column
Primary Key
Unique Identifier
Foreign Key (*)
2. Why would this table name NOT work in an Oracle database?
2007_EMPLOYEES
Numbers cannot be incorporated into table names
Table names must start with an alphabetic character (*)
Underscores “_” are not allowed in table names
None of the above
3. The transformation from an ER diagram to a physical design involves changing terminology. Relationships in the ER diagram become __________ , and primary unique identifiers become ____________.
Foreign keys, primary keys (*)
Primary keys, foreign keys
Foreign keys, mandatory business rules
Foreign keys, optional business rules
4. The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ , and attributes become ____________.
Columns, Tables
Tables, Columns (*)
Foreign Keys, Columns
Tables, Foreign Keys
5. In a physical data model, an entity becomes a _____________.
Attribute
Table (*)
Constraint
Column
6. Attributes become columns in a database table. True or False?
True (*)
False
7. In an Oracle database, why would the following table name not be allowed ‘EMPLOYEE JOBS’?
The database does not understand all capital letters
EMPLOYEE is a reserved word
JOBS is a reserved word
You cannot have spaces between words in a table name (*)

Niciun comentariu:

Trimiteţi un comentariu