Week #7 Quiz - CIST1220-Structured Query Language-SQL

A foreign key always refers to a primary key in the same table. True or False?

B) False

In a physical data model, a relationship is represented as a: A) Foreign Key B) Unique Identifier C) Column D) Primary Key

A) Foreign Key

What do you create when you transform a Many-to-Many relationship from your ER diagram into a physical design? A) Intersection table B) Foreign key constraints C) Intersection entity D) Primary key constraints

A) Intersection table

Foreign keys cannot be null when A) It is part of a primary key B) It refers to another table C) It contains three or more columns

A) It is part of a primary key

Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?

B) False

One-to-Many Optional to Mandatory becomes a _______________ on the Master table. A) Mandatory Foreign Key B) Nothing (There are no new columns created on the Master table) C) Optional Foreign Key D) Primary Key

B) Nothing (There are no new columns created on the Master table)

In a physical data model, an entity becomes a/an _____________. A) Constraint B) Table C) Column D) Attribute

B) Table

In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'? A) The database does not understand all capital letters B) You cannot have spaces between words in a table name C) JOBS is a reserved word D) EMPLOYEE is a reserved word

B) You cannot have spaces between words in a table name

Column integrity refers to A) Columns always having values B) Columns always containing positive numbers C) Columns always containing values consistent with the defined data format D) Columns always containing text data less than 255 characters

C) Columns always containing values consistent with the defined data format

The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ , and attributes become ____________. A) Foreign Keys, Columns B) Columns, Tables C) Tables, Columns D) Tables, Foreign Keys

C) Tables, Columns