HI 410- Exam 2 Study Questions with complete solutions
graded A+ (verified)
1. Which database type stores both the data element and Object-
oriented database
the method for its use?
A. Relational database
B. Object-oriented database
C. Hierarchical database
D. Flat file database
2. A primary key Uniquely identifies a
record
A. Uniquely identifies a record
B. Contains only numerical values
C. May be repeated across rows
D. Represents the relationship between two
fields
False
3. T/F: The fields in a database represent the rows
of the database
True
4. T/F: The records in a database are the rows of
data in the database
5. SQL is an acronym for: Structured Query
Lan- guage
6. SQL is used to manipulate: Data in a relational
data- base
A. Data in a relational database
B. Data in a flat file database
C. A data warehouse
D. Unstructured data
7. Which phase of data modeling includes a Conceptual model
description of the business process?
, HI 410- Exam 2 Study Questions with complete solutions
graded A+ (verified)
A. Physical model
B. Logical model
C. Conceptual model
D. Final model
8. Which phase of data modeling describes the Logical model
relation- ship between the data tables?
A. Physical model
B. Logical model
C. Conceptual model
D. Final model
9. What is one of the two outputs from a data ERD
modeling process?
A. ERD
B. SQL
C. NDC
D. DBMS
10. Which portion of the data modeling process maps out Diagram 0
the relationships between the tables?
A. Context-level data flow diagram
B. Conceptual model
C. Diagram 0
D. Diagram 2
11. The choice of which DBMS to use Size and scope of the
depends on
data- base
A. Physical data model
B. Conceptual data model
graded A+ (verified)
1. Which database type stores both the data element and Object-
oriented database
the method for its use?
A. Relational database
B. Object-oriented database
C. Hierarchical database
D. Flat file database
2. A primary key Uniquely identifies a
record
A. Uniquely identifies a record
B. Contains only numerical values
C. May be repeated across rows
D. Represents the relationship between two
fields
False
3. T/F: The fields in a database represent the rows
of the database
True
4. T/F: The records in a database are the rows of
data in the database
5. SQL is an acronym for: Structured Query
Lan- guage
6. SQL is used to manipulate: Data in a relational
data- base
A. Data in a relational database
B. Data in a flat file database
C. A data warehouse
D. Unstructured data
7. Which phase of data modeling includes a Conceptual model
description of the business process?
, HI 410- Exam 2 Study Questions with complete solutions
graded A+ (verified)
A. Physical model
B. Logical model
C. Conceptual model
D. Final model
8. Which phase of data modeling describes the Logical model
relation- ship between the data tables?
A. Physical model
B. Logical model
C. Conceptual model
D. Final model
9. What is one of the two outputs from a data ERD
modeling process?
A. ERD
B. SQL
C. NDC
D. DBMS
10. Which portion of the data modeling process maps out Diagram 0
the relationships between the tables?
A. Context-level data flow diagram
B. Conceptual model
C. Diagram 0
D. Diagram 2
11. The choice of which DBMS to use Size and scope of the
depends on
data- base
A. Physical data model
B. Conceptual data model
