Question: Which of the following is a NoSQL (i.e., not-relational) DBMS? (Select all that apply)
Answer Choices:
Access
SharePoint
Dynamo
Cassandra
Answer: Dynamo
Cassandra
Question: Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?
Answer Choices:
bullwhip effect
data administrator’s dilemma
lost-update problem
Answer: lost-update problem
Question: Identify the closed-source DBMS product(s) among the following. (Select all that apply)
Answer Choices:
DB2
MySQL
Access
Oracle Database
Answer: DB2
Access
Oracle Database
Question: An employee database includes a column named “Employee Number” to assign unique numbers to each employee. This column is referred to as an(n) _____.
Answer Choices:
functionally dependent key
primary key
foreign key
master key
Answer: primary key
Question: The characteristics of an entity are referred to as _____.
Answer Choices:
attribute(s)
relationship(s)
primary key(s)
foreign key(s)
Answer: attribute(s)
Question: Which of the following is an international standard language for processing a database?
Answer Choices:
JavaScript
SQL
DBScript
HTML
Answer: SQL
Question: A data integrity problem will occur only if _____.
Answer Choices:
the database is very large
queries are sent simultaneously to the database
a database has multiple administrators
data are duplicated in a database
Answer: data are duplicated in a database
Question: Identify the closed-source DBMS product(s) among the following. (Select all that apply)
Answer Choices:
DB2
MySQL
Access
Oracle Database
Answer: DB2
Oracle Database
Question: An employee database includes a column named “Employee Number” to assign unique numbers to each employee. This column is referred to as a(n) _____.
Answer Choices:
functionally dependent key
primary key
foreign key
master key
Answer: primary key
Question: Which of the following is an international standard language for processing a database?
Answer Choices:
JavaScript
SQL
DBScript
HTML
Answer: SQL
Question: The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.
Answer Choices:
1-line
forky
N-line
crow’s feet
Answer: crow’s feet
Question: Which of the following is true about the data model?
Answer Choices:
It describes the data and relationships that will be stored in the database.
It is the final blueprint of the database.
It does not undergo any changes once created.
It is prepared after creating the database.
Answer: It describes the data and relationships that will be stored in the database.
Question: Which of the following is a NoSQL (i.e., not-relational) DBMS? (select all that apply)
Answer Choices:
Access
SharePoint
Dynamo
Cassandra
Answer: Dynamo, Cassandra
Question: In an E-R diagram, which symbol is used to indicate that at least one entity of that type is required.
Answer Choices:
arrow
small oval
triangular block
vertical bar
Answer: vertical bar
Question: Identify the closed-source DBMS products(s) among the following. (Select all that apply)
(Note: closed-source products have a license fee contrary to open-source)
Answer Choices:
DB2
MySQL
Access
Oracle Database
Answer: DB2, Oracle Database
Question: An employee database includes a column named “Employee Number” to assign unique numbers to each employee. This column is referred to as a(n) __________.
Answer Choices:
functionally dependent key
primary key
foreign key
master key
Answer: primary key
Question: Before developing a database design, an administrator should create a _________.
Answer Choices:
query model
data application
data aggregator
data model
Answer: data model
Question: A(n) _____ is a formal request that the DBMS produces.
Answer Choices:
query
report
data entry form
data model
Answer: query