Oracle 12c SQL, Casteel - Exam Preparation Test Bank (Downloadable Doc)

True / False


1. A database is a physical storage device for data.
a. True

b. False

ANSWER: False

POINTS: 1

REFERENCES: 2

QUESTION TYPE: True / False



2. A field is a basic unit of data also referred to as a record.
a. True

b. False

ANSWER: False

POINTS: 1

REFERENCES: 3

QUESTION TYPE: True / False



3. A character is a basic unit of data and can consist of a number, letter, or special symbol.
a. True

b. False

ANSWER: True

POINTS: 1

REFERENCES: 2

QUESTION TYPE: True / False



4. A collection of fields is a file.

, a. True

b. False

ANSWER: False

POINTS: 1

REFERENCES: 3

QUESTION TYPE: True / False



5. A collection of records is a file.
a. True

b. False

ANSWER: True

POINTS: 1

REFERENCES: 3

QUESTION TYPE: True / False



6. A field in the logical design of a database corresponds to a row in the physical table of a
relational database.
a. True

b. False

ANSWER: False

POINTS: 1

REFERENCES: 3

QUESTION TYPE: True / False



7. A record in the logical design of a database corresponds to a row in the physical table of a
relational database.

, a. True

b. False

ANSWER: True

POINTS: 1

REFERENCES: 3

QUESTION TYPE: True / False



8. The Systems Development Life Cycle is a series of steps that can be used to guide the
development process for a database management system.
a. True

b. False

ANSWER: True

POINTS: 1

REFERENCES: 4

QUESTION TYPE: True / False



9. An entity is represented by a column in the Entity-Relationship Model.
a. True

b. False

ANSWER: False

POINTS: 1

REFERENCES: 4

QUESTION TYPE: True / False



10. Only one type of relationship can be represented in an Entity-Relationship Model.
a. True

, b. False

ANSWER: False

POINTS: 1

REFERENCES: 5

QUESTION TYPE: True / False



11. The following types of relationships can be included in an Entity-Relationship Model: one-to-
one, one-to-many, many-to-many.
a. True

b. False

ANSWER: True

POINTS: 1

REFERENCES: 5
6

QUESTION TYPE: True / False



12. A one-to-many relationship cannot be included in a relational database.
a. True

b. False

ANSWER: False

POINTS: 1

REFERENCES: 6

QUESTION TYPE: True / False



13. A one-to-many relationship means that an occurrence of a specific entity can only exist once
in each table.
a. True