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: 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: The characteristics of an entity are referred to as _____.
Answer Choices:
attributes
relationships
primary key(s)
foreign key(s)
Answer: attributes
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: Identify the closed-source DBMS product(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
Access
Oracle Database
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: 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: Which of the following is an international standard language for processing a database?
Answer Choices:
JavaScript
SQL
DBScript
HTML
Answer: SQL
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: 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: 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: 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: 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: The characteristics of an entity are referred to as _______.
Answer Choices:
attributes
relationships
primary key(s)
foreign key(s)
Answer: attributes
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 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
normalization problem
Answer: lost-update problem