IS361 Data Management Concepts
1. A disadvantage of database management systems is the redundancy of data.
a. True
b. False
Answer: b
2. A set of tables could be in 2NF, but not in 1NF at the same time.
a. True
b. False
Answer: b
3. An un-normalized database model cannot be implemented in a database management
system.
a. True
b. False
Answer: b
4. Data warehouses can be used for managerial decisions as well as day-to-day business
operation in a company.
a. True
b. False
Answer: a
5. A client’s computer runs an application as a “thin” client if it loads most of the application
software inside the client’s computer, but it streamlines the processes to use fewer
resources.
a. True
b. False
Answer: a
6. Transforming data to fit requirements of a data warehouse is not part of the ETL process.
a. True
b. False
Answer: b
7. Metadata is data that goes beyond current data and is used for prescriptive analytics in big
data.
a. True
b. False
Answer: b
8. Primary keys in tables are never indexed because they are always in order.
a. True
b. False
Answer: b
9. NoSQL is only used when one does not want to use concerned with data that cannot be
accessed using SQL.
a. True
b. False
, Answer: a
10. A relationship that has attributes on its own can be represented in an ERD with a(n):
Weak entity
Ternary relationship
Associative entity
Answer: Ternary relationship
11. A flat file on paper with a list of students and their grades is an example of a:
Sequential file
Indexed file
Hashed file
Answer: Sequential file
12. A database has a laptop table with records for 20 laptops. Each one of these laptops is
assigned to only one and distinct user from a User table that also has 20 users. The
database is queried with the following command:
SELECT * FROM Laptops, Users;
How many records will this select command produce?
Less than 20
Exactly 20
More than 20
Answer: More than 20
13. The following are techniques to control data integrity in a database, EXECPT
Enforcing the use of data types in fields
Not allowing null values in fields that are part of primary keys
Not allowing null values in fields that reference foreign keys
Enforcing ranges of values in fields
Answer: Field < file < record
14. From the smallest to the largest piece of data which of the following is the correct order?
File < record < field
Field < record < file
Record < field < file
Field < file < record
Answer: Field < record < file
15. The following are types of attributes for entities in an ERD, EXCEPT:
Composite
Associative
Partial identifier
Derived
1. A disadvantage of database management systems is the redundancy of data.
a. True
b. False
Answer: b
2. A set of tables could be in 2NF, but not in 1NF at the same time.
a. True
b. False
Answer: b
3. An un-normalized database model cannot be implemented in a database management
system.
a. True
b. False
Answer: b
4. Data warehouses can be used for managerial decisions as well as day-to-day business
operation in a company.
a. True
b. False
Answer: a
5. A client’s computer runs an application as a “thin” client if it loads most of the application
software inside the client’s computer, but it streamlines the processes to use fewer
resources.
a. True
b. False
Answer: a
6. Transforming data to fit requirements of a data warehouse is not part of the ETL process.
a. True
b. False
Answer: b
7. Metadata is data that goes beyond current data and is used for prescriptive analytics in big
data.
a. True
b. False
Answer: b
8. Primary keys in tables are never indexed because they are always in order.
a. True
b. False
Answer: b
9. NoSQL is only used when one does not want to use concerned with data that cannot be
accessed using SQL.
a. True
b. False
, Answer: a
10. A relationship that has attributes on its own can be represented in an ERD with a(n):
Weak entity
Ternary relationship
Associative entity
Answer: Ternary relationship
11. A flat file on paper with a list of students and their grades is an example of a:
Sequential file
Indexed file
Hashed file
Answer: Sequential file
12. A database has a laptop table with records for 20 laptops. Each one of these laptops is
assigned to only one and distinct user from a User table that also has 20 users. The
database is queried with the following command:
SELECT * FROM Laptops, Users;
How many records will this select command produce?
Less than 20
Exactly 20
More than 20
Answer: More than 20
13. The following are techniques to control data integrity in a database, EXECPT
Enforcing the use of data types in fields
Not allowing null values in fields that are part of primary keys
Not allowing null values in fields that reference foreign keys
Enforcing ranges of values in fields
Answer: Field < file < record
14. From the smallest to the largest piece of data which of the following is the correct order?
File < record < field
Field < record < file
Record < field < file
Field < file < record
Answer: Field < record < file
15. The following are types of attributes for entities in an ERD, EXCEPT:
Composite
Associative
Partial identifier
Derived
