CIS 110 EXAM QUESTIONS AND
CORRECT ANSWERS
The hierarchy of data from the lowest element up, in a relational database would be as
follows:
a. Record/Field/Table/Relationship
b. Field/Record/Table/Database/Schema/Catalog
c. Table/Attribute/Tuple/Database
d. None of the above - Answer- b. Field/Record/Table/Database/Schema/Catalog
To create and enforce a one-to-many relationship between two tables in a relational
database, the following must be true:
a. One table must be the Parent and one table must be the Child (may also be a Parent
to another table)
b. The value in a FK field must match the value of the PK field (if Enforce Referential
Integrity is checked)
c. Primary and Foreign Key values are required by design
d. All of the above - Answer- d. All of the above
In a relational database, all data is stored in the following containers:
a. Objects
b. Databases
c. Tables, Tables, and nothing but Tables
d. All of the above - Answer- c. Tables, Tables, and nothing but Tables
Which of the following would not be stored in the database:
a. Dates
b. Calculated Fields
c. Pictures
d. Memo's - Answer- b. Calculated Fields
Access, Oracle, SQL Server, MySQL are all examples of:
a. Databases
b. Tables
c. Networks
d. Database Management Systems (DBMS's) - Answer- d. Database Management
Systems (DBMS's)
Relational databases prefer using what type of cardinality (relationships):
, a. Many-to-Many
b. One-to-Many
c. One-to-One
d. Both B and C could be used in relational databases, although B is the most popular -
Answer- d. Both B and C could be used in relational databases, although B is the most
popular
What types of objects can databases provide that give an added advantage over other
data storage types of software:
a. Forms and Reports
b. Tables
c. Queries/Views
d. all of the above - Answer- d. all of the above
A digital device would include any item you could plug into an outlet?
True
False - Answer- False
The purpose of most computer hardware and peripherals (external, not internal) is to
provide Input, Processing, Storage, and Output.
True
False - Answer- True
Computer hardware would include the following except:
a. CPU
b. RF Signals
c. Keyboard
d. Printer - Answer- b. RF Signals
The purpose of Random Access Memory (RAM) is to:
a. Hold programs in short-term storage while they are actively running
b. Decrease the time required to get processing instructions to the processor
c. To hold data permanently, with or without power going to the unit
d. both a and b - Answer- d. both a and b
Types of long term storage devices include the following:
a. Hard Disk Drive (HDD)
b. Solid State Drive
c. Memory Cards
d. All of the above - Answer- d. All of the above
Which of the following is relevant to using cloud storage?
a. Requires network capability
b. It matters where we store things as we need to know where their stored
c. Dependent on another person/company maintaining and securing the data
CORRECT ANSWERS
The hierarchy of data from the lowest element up, in a relational database would be as
follows:
a. Record/Field/Table/Relationship
b. Field/Record/Table/Database/Schema/Catalog
c. Table/Attribute/Tuple/Database
d. None of the above - Answer- b. Field/Record/Table/Database/Schema/Catalog
To create and enforce a one-to-many relationship between two tables in a relational
database, the following must be true:
a. One table must be the Parent and one table must be the Child (may also be a Parent
to another table)
b. The value in a FK field must match the value of the PK field (if Enforce Referential
Integrity is checked)
c. Primary and Foreign Key values are required by design
d. All of the above - Answer- d. All of the above
In a relational database, all data is stored in the following containers:
a. Objects
b. Databases
c. Tables, Tables, and nothing but Tables
d. All of the above - Answer- c. Tables, Tables, and nothing but Tables
Which of the following would not be stored in the database:
a. Dates
b. Calculated Fields
c. Pictures
d. Memo's - Answer- b. Calculated Fields
Access, Oracle, SQL Server, MySQL are all examples of:
a. Databases
b. Tables
c. Networks
d. Database Management Systems (DBMS's) - Answer- d. Database Management
Systems (DBMS's)
Relational databases prefer using what type of cardinality (relationships):
, a. Many-to-Many
b. One-to-Many
c. One-to-One
d. Both B and C could be used in relational databases, although B is the most popular -
Answer- d. Both B and C could be used in relational databases, although B is the most
popular
What types of objects can databases provide that give an added advantage over other
data storage types of software:
a. Forms and Reports
b. Tables
c. Queries/Views
d. all of the above - Answer- d. all of the above
A digital device would include any item you could plug into an outlet?
True
False - Answer- False
The purpose of most computer hardware and peripherals (external, not internal) is to
provide Input, Processing, Storage, and Output.
True
False - Answer- True
Computer hardware would include the following except:
a. CPU
b. RF Signals
c. Keyboard
d. Printer - Answer- b. RF Signals
The purpose of Random Access Memory (RAM) is to:
a. Hold programs in short-term storage while they are actively running
b. Decrease the time required to get processing instructions to the processor
c. To hold data permanently, with or without power going to the unit
d. both a and b - Answer- d. both a and b
Types of long term storage devices include the following:
a. Hard Disk Drive (HDD)
b. Solid State Drive
c. Memory Cards
d. All of the above - Answer- d. All of the above
Which of the following is relevant to using cloud storage?
a. Requires network capability
b. It matters where we store things as we need to know where their stored
c. Dependent on another person/company maintaining and securing the data
