Question 1 (Received 0 out of 0 points)
Question: Which of the following problems associated with storing data in a list
is avoided by storing data in a relational database?
Your answer: No response
Correct answer: All of the above.
Question 2 (Received 0 out of 0 points)
Question: When the primary key of one relation is placed in a second relation to
represent a relationship, the attribute in the second relation is called a
foreign key.
Your answer: No response
Correct answer: True
Question 3 (Received 0 out of 0 points)
Question: If the condition exists such that knowing the value of attribute X
determines the value attribute Y, then attribute Y is functionally dependent on
attribute X.
Your answer: No response
Correct answer: True
Question 4 (Received 0 out of 0 points)
Question: The component of a database that makes it self-describing is the
___________.
Your answer: No response
Correct answer: metadata
Question 5 (Received 0 out of 0 points)
Question: In the general division of labor between database applications and the
DBMS, the application program determines which tables need to be modified.
Your answer: No response
Correct answer: False
Question 6 (Received 0 out of 0 points)
Question: Any table that meets the definition of a relation is said to be in
second normal form.
Your answer: No response
Correct answer: False
Question 7 (Received 0 out of 0 points)
Question: The primary (or candidate) key of a relation functionally determines
all the other attributes in the relation.
Your answer: No response
Correct answer: True
Question 8 (Received 0 out of 0 points)
Question: Databases are seldom used by individuals.
Your answer: No response
Correct answer: False
Question 9 (Received 0 out of 0 points)
Question: Since surrogate keys are used to uniquely identify rows, their values
are normally displayed prominently on all forms and reports for the users to
see.
Your answer: No response
Correct answer: False
Question 10 (Received 0 out of 0 points)
Question: MedicineCode --> (MedicineName, ShelfLife, Manufacturer, Dosage)
Given the functional dependency above, which of the following statements is not
known to be true?
Your answer: No response
Correct answer: MedicineName is a determinant.
Question 11 (Received 0 out of 0 points)
Question: The use of surrogate keys usually complicates application programming
since most DBMS products require the application program to generate surrogate
key values.
Your answer: No response
Correct answer: False
Question 12 (Received 0 out of 0 points)
Question: The purpose of a database is to help people keep track of things.
Your answer: No response
Correct answer: True
Question 13 (Received 0 out of 0 points)
Question: Which of the following terms is synonymous with ?tuple??
Your answer: No response
Correct answer: row
Question 14 (Received 0 out of 0 points)
Question: The relationship between two attributes which denotes that if the
value of the first attribute is known, the value of the second attribute can be
determined, is called a dependent entity.
Your answer: No response
Correct answer: False
Question 15 (Received 0 out of 0 points)
Question: A key that contains more than one attribute is called a(n) __________
key.
Your answer: No response
Correct answer: composite key
Question 16 (Received 0 out of 0 points)
Question: Which of the following is not true of UML?
Your answer: No response
Correct answer: UML is a subset of the E-R diagrams standard.
Question 17 (Received 0 out of 0 points)
Question: For a column to be defined as the primary key using the ALTER TABLE
statement, the column must have been given the property NOT NULL.
Your answer: No response
Correct answer: True
Question 18 (Received 0 out of 0 points)
Question: To force the DBMS to remove duplicate rows from the results of a SQL
SELECT query, the keyword DISTINCT must be used.
Your answer: No response
Correct answer: True
Question 19 (Received 0 out of 0 points)
Question: In SQL, the WHERE clause is used to specify which columns will be
included in the result.
Your answer: No response
Correct answer: False
Question 20 (Received 0 out of 0 points)
Question: Which of the following is not true about primary keys?
Your answer: No response
Correct answer: Primary keys must be a single attribute.
Question 21 (Received 0 out of 0 points)
Question: When using SQL to create a table, a column is defined by declaring, in
this order: data type, column name, and properties.
Your answer: No response
Correct answer: False
Question 22 (Received 0 out of 0 points)
Question: UML has quickly replaced the E-R Model as the most popular technique
for creating data models.
Your answer: No response
Correct answer: False
Question 23 (Received 0 out of 0 points)
Question: Which of the following SQL commands would be used to remove both the
data and the table structure of a table named STUDENT?
Your answer: No response
Correct answer: DROP TABLE STUDENT;
Question 24 (Received 0 out of 0 points)
Question: If one instance of ENTITY B must be related to one and only one
instance of ENTITY A, and one instance of ENTITY A may be related to many
instances of ENTITY B, which of the following should be written in the
relationship symbol of the figure below?
Your answer: No response
Correct answer: 1:N
Question 25 (Received 0 out of 0 points)
Question: Which of the following data types used in SQL would define a
fixed-length text field of 10 characters?
Your answer: No response
Correct answer: char(10)
Question 26 (Received 0 out of 0 points)
Question: Data from a maximum of three tables can be combined through the use of
subqueries in SQL.
Your answer: No response
Correct answer: False
Question 27 (Received 0 out of 0 points)
Question: Given only the excerpt of an E-R model shown below, which of the
following is known to be true?
Your answer: No response
Correct answer: Many instances of ENTITY A may be related to one instance of
ENTITY B.
Question 28 (Received 0 out of 0 points)
Question: The PRODUCT entity instance is the collection of all PRODUCT entity
classes.
Your answer: No response
Correct answer: False
Question 29 (Received 0 out of 0 points)
Question: In SQL, the order of the rows that result from a SELECT statement can
be set using the SORT BY phrase.
Your answer: No response
Correct answer: False
Question 30 (Received 0 out of 0 points)
Question: Which SQL keyword is used to eliminate duplicate rows in the results
of a SQL SELECT query?
Your answer: No response
Correct answer: DISTINCT
Question 31 (Received 0 out of 0 points)
Question: Relationships with the degree 2 are often called binary relationships.
Your answer: No response
Correct answer: True
Question 32 (Received 0 out of 0 points)
Question: Which of the following is not one of the five SQL built-in functions?
Your answer: No response
Correct answer: MODE
Question 33 (Received 0 out of 0 points)
Question: Which of the following is not a standard data type used in SQL?
Your answer: No response
Correct answer: text
Question 34 (Received 0 out of 0 points)
Question: When an entity class has a relationship with itself, it is called a
recursive relationship.
Your answer: No response
Correct answer: True
Question 35 (Received 0 out of 0 points)
Question: Which SQL keyword is used to apply conditions to restrict groups that
appear in the results of a SELECT query that uses GROUP BY?
Your answer: No response
Correct answer: HAVING
Question 36 (Received 0 out of 0 points)
Question: To represent a many-to-many relationship in the relational model, an
intersection relation is used.
Your answer: No response
Correct answer: True
Question 37 (Received 0 out of 0 points)
Question: Which of the following is not necessarily true of a relation that is
in 4NF?
Your answer: No response
Correct answer: It is in DK/NF.
Question 38 (Received 0 out of 0 points)
Question: What concurrent processing problem occurs when a transaction rereads
data and finds new rows that were inserted by a different transaction since the
prior read?
Your answer: No response
Correct answer: Phantom reads
Question 39 (Received 0 out of 0 points)
Question: To represent a many-to-many relationship in the relational model, a
union relation is used.
Your answer: No response
Correct answer: False
Question 40 (Received 0 out of 0 points)
Question: What is the least restrictive isolation level that will prevent
nonrepeatable reads?
Your answer: No response
Correct answer: Repeatable Read
Question 41 (Received 0 out of 0 points)
Question: The first step in representing entities using the relational model is
to determine which identifier will be used as the key.
Your answer: No response
Correct answer: False
Question 42 (Received 0 out of 0 points)
Question: Given the 1:N recursive relationship shown in the figure indicating
that a Member may sponsor many other members but a Member is sponsored by only
one other Member, which of the following would represent the correct
implementation? (PK = Primary Key)
Your answer: No response
Correct answer: MEMBER (MemberID(PK), Name, Phone, SponsoredBy)
Question 43 (Received 0 out of 0 points)
Question: The need to add the same data to multiple rows of a relation about one
theme because the relation contains data about multiple themes is an example of
an insertion anomaly.
Your answer: No response
Correct answer: True
Question 44 (Received 0 out of 0 points)
Question: R. Fagin defined the domain key / normal form, and a relation in this
form has no anomalies.
Your answer: No response
Correct answer: True
Question 45 (Received 0 out of 0 points)
Question: The term DBA refers to ____________.
Your answer: No response
Correct answer: database administrator
Question 46 (Received 0 out of 0 points)
Question: A recursive relationship is a relationship among entities of the same
class.
Your answer: No response
Correct answer: True
Question 47 (Received 0 out of 0 points)
Question: One advantage of optimistic locking is that the lock is obtained only
after the transaction is processed.
Your answer: No response
Correct answer: True
Question 48 (Received 0 out of 0 points)
Question: The recovery method where the database is restored using the saved
data, and all transactions since the save are reapplied is called rollforward
recovery.
Your answer: No response
Correct answer: True
Question 49 (Received 0 out of 0 points)
Question: Given the generic relation: GENERIC (PKey1, PKey2, Attribute1,
Attribute2, Attribute3), and the functional dependencies: (PKey1, PKey2) -->
Attribute1 and PKey2 --> (Attribute2, Attribute3), which of the following is
true?
Your answer: No response
Correct answer: GENERIC is not fully normalized.
Question 50 (Received 0 out of 0 points)
Question: Which of the following is not a means of processing databases?
Your answer(s):
No response
Correct answer(s):
• Programs coded in COBOL.
• Internet applications using ASP.
• Processed by stored procedures and triggers.
• Programs coded in Java or C#.
• All of the above are means of processing a database.
Question 51 (Received 0 out of 0 points)
Question: Given ENTITY A and ENTITY B shown in the figure, which of the
following would display the correct placement of foreign keys in the relational
model? (PK = Primary Key, FK = Foreign Key)
Your answer: No response
Correct answer: ENTITY A (Attribute1(PK), Attribute2, Attribute3); ENTITY B
(Attribute4(PK), Attribute5, Attribute6, Attribute1(FK))
Question 52 (Received 0 out of 0 points)
Question: Which of the following is a type of trigger than can be invoked in
place of DBMS insert, update, or delete actions?
Your answer: No response
Correct answer: INSTEAD OF triggers
Question 53 (Received 0 out of 0 points)
Question: What is the least restrictive isolation level that will prevent dirty
reads?
Your answer: No response
Correct answer: Read Committed
Question 54 (Received 0 out of 0 points)
Question: Only large database systems have a need for database administration.
Your answer: No response
Correct answer: False
Question 55 (Received 0 out of 0 points)
Question: Once a relation has been defined for an entity, it should be examined
according to normalization criteria.
Your answer: No response
Correct answer: True
Question 56 (Received 0 out of 0 points)
Question: Database Administration is an important business function whose
purpose is to manage the database to maximize its value to the organization.
Your answer: No response
Correct answer: True
Question 57 (Received 0 out of 0 points)
Question: If a weak entity is ID dependent but not existence dependent, it can
be represented using the same techniques as a strong entity.
Your answer: No response
Correct answer: False
Question 58 (Received 0 out of 0 points)
Question: Which of the following is the first step in representing entities
using the relational model?
Your answer: No response
Correct answer: Define a relation for each entity
Question 59 (Received 0 out of 0 points)
Question: From a pragmatic standpoint, the only important rule of normalization
is that the determinant of every functional dependency must be a candidate key.
Your answer: No response
Correct answer: True
Question 60 (Received 0 out of 0 points)
Question: A trigger is similar to a stored procedure, except that it is written
to be invoked by the DBMS when a specified event occurs.
Your answer: No response
Correct answer: True
Question 61 (0 points possible)
Question: Given the relation PROJECT(ProjectID, Name, Department, MaxHours),
write a SQL query statement that will list all rows and columns for which the
maximum hours are in the range 100.0 to 150.0.
Your answer:
No response
Correct answer:
SELECT ProjectID, Name, Department, MaxHours
FROM PROJECT
WHERE MaxHours BETWEEN 100.0 AND 150.0;
[alternate answers]
SELECT *
FROM PROJECT
WHERE MaxHours BETWEEN 100.0 AND 150.0;
SELECT *
FROM PROJECT
WHERE MaxHours => 100.0
AND MaxHours =< 150.0;
Question 62 (0 points possible)
Question: Restaurant Meal Check
Determine the entities implied by the following, unnormalized table(s). Draw an
appropriate E-R diagram.
Meal Check(Check Number, Booth Number, Session, Date, Meal, Server Number,
Server Name, Food total, Tax, Tip, Check Total, (Seat Number, Guest Description,
(Menu Item Number, Item Name, Item Price)))
This document concerns meal check information. For a given meal check
(identified by the check number), there will be a single server assigned to a
single customer group (usually occupying a booth.) Each time a different group
occupies the booth, there is a new session number (the session numbers start
anew every day.) The server's number and name appear on the check as well as the
meal (breakfast, lunch, dinner) and date. Also, there may be several different
item orders appearing on the check for each of one or more guests (id'ed by seat
number.) For each item order that appears, the item number, name, and price will
be displayed. The price is from the current menu table.
Your answer:
No response
Correct answer:
Question 63 (0 points possible)
Question: Dental Patient Record
a.) List the functional dependencies in the following table subject to the
specified conditions.
b.) Convert this table to an equivalent collection of tables that are in 3NF.
Patient (Household Number, Household Name, Household City, Household State,
Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service
Description, Service Fee))
This is a table concerning information about patients of a dentist. Each patient
belongs to a household. The household head is responsible for paying for dental
services for all members of the household. The household head is designated in
the table by "HH" being part of the patient number.
Be sure to do both parts a. and b. of this question.
Your answer:
No response
Correct answer:
Question 64 (0 points possible)
Question: Game Statistics
a.) List the functional dependencies in the following table subject to the
specified conditions.
b.) Convert this table to an equivalent collection of tables that are in 3NF.
Game Statistics(Game Number, Opponent, Game Date, (Referee Number, Referee Last
Name, Penalties Called), (Player Number, Player Last Name, Game Points, Season
Average Points, Career Average Points))
This table represents a game statistics summary for the school team. For a given
game (identified by the unique game number), there will be a single opponent,
but three referees. The school team will have at least 5 players in each and
every game. The season and career scoring averages are only updated after each
game, not during the game.
Your answer:
No response
Correct answer:
Question 1 (Received 0 out of 0 points)
Question: The DBMS translates requests into instructions for the computer
operating system to read and write data in the database files.
Your answer: No response
Correct answer: True
Question 2 (Received 0 out of 0 points)
Question: STUDENT (SID, S-Name, Major, AdvisorID)
ADVISOR (AdvisorID, A-Name, Office, Phone)
Given the relations above such that each student is assigned to one advisor,
which of the following is true?
Your answer: No response
Correct answer: AdvisorID is a foreign key.
Question 3 (Received 0 out of 0 points)
Question: Which of the following is not contained in the components of all
databases?
Your answer: No response
Correct answer: application metadata
Question 4 (Received 0 out of 0 points)
Question: Candidate keys may or may not be unique.
Your answer: No response
Correct answer: False
Question 5 (Received 0 out of 0 points)
Question: Which of the following functional dependency diagrams accurately
represents the following situation:
A campus has many buildings.
Each building has a unique name.
Each building has many rooms.
All rooms in any given building are numbered sequentially starting at ?101?.
Each room has a certain capacity although many rooms in the same building or
different buildings may have the same capacity.
Each room is assigned to a single department.
A department may have many rooms in one or more buildings, each with the same or
different capacities.
Your answer: No response
Correct answer: (BuildingName, RoomNumber) --> (Capacity, Department)
Question 6 (Received 0 out of 0 points)
Question: In a database, tables are related to each other by ___________.
Your answer: No response
Correct answer: placing row identifiers where necessary
Question 7 (Received 0 out of 0 points)
Question: Since surrogate keys are used to uniquely identify rows, their values
are normally displayed prominently on all forms and reports for the users to
see.
Your answer: No response
Correct answer: False
Question 8 (Received 0 out of 0 points)
Question: During the normalization process, the remedy for a relation that is
not well-formed is to ___________.
Your answer: No response
Correct answer: break it into two or more relations that are well-formed
Question 9 (Received 0 out of 0 points)
Question: When the primary key of one relation is placed into a second relation,
it is called a _________.
Your answer: No response
Correct answer: foreign key
Question 10 (Received 0 out of 0 points)
Question: A key that contains two or more attributes is called a foreign key.
Your answer: No response
Correct answer: False
Question 11 (Received 0 out of 0 points)
Question: Most organizations create and use their own database management system
(DBMS) products.
Your answer: No response
Correct answer: False
Question 12 (Received 0 out of 0 points)
Question: To create a well-formed relation through normalization, every
determinant must be a candidate key.
Your answer: No response
Correct answer: True
Question 13 (Received 0 out of 0 points)
Question: A key must be unique.
Your answer: No response
Correct answer: False
Question 14 (Received 0 out of 0 points)
Question: Null values can cause problems because they are ambiguous.
Your answer: No response
Correct answer: True
Question 15 (Received 0 out of 0 points)
Question: If the condition exists such that knowing the value of attribute X
determines the value attribute Y, then attribute Y is functionally dependent on
attribute X.
Your answer: No response
Correct answer: True
Question 16 (Received 0 out of 0 points)
Question: The basic format for documenting cardinalities in UML is x..y, where x
is the maximum cardinality and y is the minimum cardinality.
Your answer: No response
Correct answer: False
Question 17 (Received 0 out of 0 points)
Question: To force the DBMS to remove duplicate rows from the results of a SQL
SELECT query, the keyword DISTINCT must be used.
Your answer: No response
Correct answer: True
Question 18 (Received 0 out of 0 points)
Question: The SUM built-in function in SQL is used to total the values in a
numeric column.
Your answer: No response
Correct answer: True
Question 19 (Received 0 out of 0 points)
Question: Conditions after the WHERE require single quotes around value for
columns that have which data type?
Your answer: No response
Correct answer: Both a and b
Question 20 (Received 0 out of 0 points)
Question: Which of the following is true about identifiers of entities?
Your answer: No response
Correct answer: The value of an identifier may identify a set of entity
instances.
Question 21 (Received 0 out of 0 points)
Question: Which of the following is not a source for user requirements during
the requirements stage of developing a database system?
Your answer: No response
Correct answer: All of the above are sources for user requirements.
Question 22 (Received 0 out of 0 points)
Question: Which type of join, although not included in standard SQL, was created
to allow unmatched rows to appear in the result of a join operation?
Your answer: No response
Correct answer: OUTER JOIN
Question 23 (Received 0 out of 0 points)
Question: The data model is a representation of the content, relationships, and
constraints of the data needed to support the system requirements.
Your answer: No response
Correct answer: True
Question 24 (Received 0 out of 0 points)
Question: Maximum cardinality indicates whether or not an instance of one entity
class must be related to at least one instance of another entity class.
Your answer: No response
Correct answer: False
Question 25 (Received 0 out of 0 points)
Question: One type of strong entity is the ID-dependent entity.
Your answer: No response
Correct answer: False
Question 26 (Received 0 out of 0 points)
Question: The result for SELECT statements in SQL is a relation unless the
result is a single number.
Your answer: No response
Correct answer: False
Question 27 (Received 0 out of 0 points)
Question: The order of the columns returned by an SQL SELECT statement are
determined by the:
Your answer: No response
Correct answer: order they are listed in following SELECT
Question 28 (Received 0 out of 0 points)
Question: Which of the following would not be contained in a use case?
Your answer: No response
Correct answer: A prototype of the system performing a given task.
Question 29 (Received 0 out of 0 points)
Question: Which of the following activities is not performed during the
implementation phase of developing a database system?
Your answer: No response
Correct answer: Transforming the data model into a database design
Question 30 (Received 0 out of 0 points)
Question: Which SQL keyword is used to specify a condition that rows must meet
to be included in the results of an SQL SELECT query?
Your answer: No response
Correct answer: WHERE
Question 31 (Received 0 out of 0 points)
Question: If one instance of ENTITY B must be related to one and only one
instance of ENTITY A, and one instance of ENTITY A may be related to many
instances of ENTITY B, which of the following should be written in the
relationship symbol of the figure below?
Your answer: No response
Correct answer: 1:N
Question 32 (Received 0 out of 0 points)
Question: When using SQL to create a table, a column is defined by declaring, in
this order: data type, column name, and properties.
Your answer: No response
Correct answer: False
Question 33 (Received 0 out of 0 points)
Question: The representation of the content, relationships, and constraints of
the data needed to support the system requirements is the _________.
Your answer: No response
Correct answer: data model
Question 34 (Received 0 out of 0 points)
Question: The PRODUCT entity instance is the collection of all PRODUCT entity
classes.
Your answer: No response
Correct answer: False
Question 35 (Received 0 out of 0 points)
Question: Use cases can be used to validate the data model, design, and
implementation.
Your answer: No response
Correct answer: True
Question 36 (Received 0 out of 0 points)
Question: Which normal form is defined as any table meeting the definition of a
relation?
Your answer: No response
Correct answer: 1NF
Question 37 (Received 0 out of 0 points)
Question: A transaction in which all steps must be completed successfully or
none of them will be completed is called a durable transaction.
Your answer: No response
Correct answer: False
Question 38 (Received 0 out of 0 points)
Question: To represent a many-to-many relationship in the relational model, a
union relation is used.
Your answer: No response
Correct answer: False
Question 39 (Received 0 out of 0 points)
Question: The characteristic of a transaction that indicates that either all of
the transaction actions need to be completed or none of them will be is called
_________.
Your answer: No response
Correct answer: atomic
Question 40 (Received 0 out of 0 points)
Question: With optimistic locking, locks are first issued, then the transaction
is processed, and then the locks are released.
Your answer: No response
Correct answer: False
Question 41 (Received 0 out of 0 points)
Question: The key of the parent entity becomes part of the key of an ID
dependent entity.
Your answer: No response
Correct answer: True
Question 42 (Received 0 out of 0 points)
Question: Transactions have a growing phase, in which locks are obtained and a
shrinking phase, in which locks are released.
Your answer: No response
Correct answer: True
Question 43 (Received 0 out of 0 points)
Question: A trigger is similar to a stored procedure, except that it is written
to be invoked by the DBMS when a specified event occurs.
Your answer: No response
Correct answer: True
Question 44 (Received 0 out of 0 points)
Question: A dirty read is a problem with concurrent processing when a
transaction rereads data it has already read and finds modifications or
deletions caused by another transaction.
Your answer: No response
Correct answer: False
Question 45 (Received 0 out of 0 points)
Question: The need to add the same data to multiple rows of a relation about one
theme because the relation contains data about multiple themes is an example of
a deletion anomaly.
Your answer: No response
Correct answer: False
Question 46 (Received 0 out of 0 points)
Question: Which of the following is true about representing a weak entity with
the relational model?
Your answer: No response
Correct answer: If the weak entity is ID dependent, the key of the parent entity
must be part of the key of the weak entity.
Question 47 (Received 0 out of 0 points)
Question: Lock granularity refers to whether a lock is placed by the DBMS
automatically or is placed by a command from the application program.
Your answer: No response
Correct answer: False
Question 48 (Received 0 out of 0 points)
Question: Which of the following is a type of trigger than can be invoked in
place of DBMS insert, update, or delete actions?
Your answer: No response
Correct answer: INSTEAD OF triggers
Question 49 (Received 0 out of 0 points)
Question: A ______________ is a point of synchronization between the database
and the transaction log.
Your answer: No response
Correct answer: checkpoint
Question 50 (Received 0 out of 0 points)
Question: When attempting to delete data about one theme results in the loss of
data about another theme because the data for both themes are stored in the same
relation, it is called a(n) ____________.
Your answer: No response
Correct answer: none of the above
Question 51 (Received 0 out of 0 points)
Question: To represent a M:N relationship in the relational model, an
intersection relation is created to represent the relationship itself.
Your answer: No response
Correct answer: True
Question 52 (Received 0 out of 0 points)
Question: DK/NF requires that all constraints on data values be logical
implications of the definitions of domains and keys.
Your answer: No response
Correct answer: True
Question 53 (Received 0 out of 0 points)
Question: Relationships that are 1:1 and are mandatory in both directions often
indicate that the two entities should be combined into a single entity.
Your answer: No response
Correct answer: True
Question 54 (Received 0 out of 0 points)
Question: Which of the following is the correct technique for representing a 1:N
relationship in the relational model?
Your answer: No response
Correct answer: The key of the entity on the one side is placed into the
relation for the entity on the many side.
Question 55 (Received 0 out of 0 points)
Question: Rollback requires the use of logs, but rollforward does not.
Your answer: No response
Correct answer: False
Question 56 (Received 0 out of 0 points)
Question: Which of the following is true about a shared lock?
Your answer: No response
Correct answer: It allows reads to the locked item.
Question 57 (Received 0 out of 0 points)
Question: When a change in the data concerning one theme occurs that causes many
rows of the table to be modified because the table contains data about multiple
themes, we call this characteristic a modification anomaly.
Your answer: No response
Correct answer: True
Question 58 (Received 0 out of 0 points)
Question: When data about one theme cannot be entered in a relation until data
about a second theme is also available because both themes are stored in the
same relation, this is called a(n) ____________.
Your answer: No response
Correct answer: insertion anomaly
Question 59 (Received 0 out of 0 points)
Question: To represent a 1:N relationship in the relational model, the key of
either entity may be placed as a foreign key in the other entity.
Your answer: No response
Correct answer: False
Question 60 (Received 0 out of 0 points)
Question: To represent a 1:N relationship in the relational model, the key of
the entity on the one side of the relationship is placed as a foreign key in the
entity on the many side of the relationship.
Your answer: No response
Correct answer: True
Question 61 (0 points possible)
Question: Given the relation PROJECT(ProjectID, Name, Department, MaxHours),
write a SQL statement that eliminates the row for the Project with ID# 1600
only.
Your answer:
No response
Correct answer:
DELETE
FROM PROJECT
WHERE ProjectID = 1600;
Question 62 (0 points possible)
Question: Dental Patient
Determine the entities implied by the following, unnormalized table(s). Draw an
appropriate E-R diagram.
Patient (Household Number, Household Name, Household City, Household State,
Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service
Description, Service Fee))
This is a table concerning information about patients of a dentist. Each patient
belongs to a household. The household head is responsible for paying for dental
services for all members of the household. The household head is designated in
the table by "HH" being part of the patient number.
Your answer:
No response
Correct answer:
Question 63 (0 points possible)
Question: Dental Patient Record
a.) List the functional dependencies in the following table subject to the
specified conditions.
b.) Convert this table to an equivalent collection of tables that are in 3NF.
Patient (Household Number, Household Name, Household City, Household State,
Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service
Description, Service Fee))
This is a table concerning information about patients of a dentist. Each patient
belongs to a household. The household head is responsible for paying for dental
services for all members of the household. The household head is designated in
the table by "HH" being part of the patient number.
Be sure to do both parts a. and b. of this question.
Your answer:
No response
Correct answer:
Question 64 (0 points possible)
Question: College Student
Using your knowledge of a college environment, determine the functional
dependencies that exist in the following table. After these have been
determined, convert this table to an equivalent collection of tables that are in
3NF.
Student(Student Number, Student Name, Number Credits, Advisor Number, Advisor
Name, Dept Number, Dept Name, (Course Number, Course Description, Course Term,
Grade))
Remember there are 2 parts:
a) functional dependencies, and
b) 3NF tables
Your answer:
No response
Correct answer:
Question 1 (Received 0 out of 0 points)
Question: The DBMS receives data update requests from the application program.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 2 (Received 0 out of 0 points)
Question: Which of the following is not true of surrogate keys?
Your answer: No response
Correct answer: They are meaningful to the users.
--------------------------------------------------------------------------------
Question 3 (Received 0 out of 0 points)
Question: Databases are key components of _____.
Your answer(s):
No response
Correct answer(s):
e-commerce
Web-based applications
censuses
management decision support systems
--------------------------------------------------------------------------------
Question 4 (Received 0 out of 0 points)
Question: Which of the following is a strategy used by desktop DBMS products
like Microsoft Access to make it easier for people to develop personal database
systems?
Your answer: No response
Correct answer: The DBMS product takes the role of the DBMS and the database
application.
--------------------------------------------------------------------------------
Question 5 (Received 0 out of 0 points)
Question: A surrogate key may be appropriate under which of the following
circumstances?
Your answer(s):
No response
Correct answer(s):
The candidate keys available would produce a lot of data duplication when
representing relationships.
The candidate keys available would be prone to typographical errors.
Both a and c.
--------------------------------------------------------------------------------
Question 6 (Received 0 out of 0 points)
Question: Microsoft Access is an example of a ___________.
Your answer: No response
Correct answer: database management system
--------------------------------------------------------------------------------
Question 7 (Received 0 out of 0 points)
Question: The use of surrogate keys usually complicates application programming
since most DBMS products require the application program to generate surrogate
key values.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 8 (Received 0 out of 0 points)
Question: The unique keys that are not chosen to be the primary key are called
composite keys.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 9 (Received 0 out of 0 points)
Question: Any table that meets the definition of a relation is said to be in
second normal form.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 10 (Received 0 out of 0 points)
Question: Which of the following would not be an example of metadata?
Your answer: No response
Correct answer: All of the above are metadata.
--------------------------------------------------------------------------------
Question 11 (Received 0 out of 0 points)
Question: A key that contains more than one attribute is called a(n) __________
key.
Your answer: No response
Correct answer: composite key
--------------------------------------------------------------------------------
Question 12 (Received 0 out of 0 points)
Question: Given the functional dependency for the attributes of ENTITY1, X à (A,
B, C), X is a candidate key for the relation ENTITY1 (A, B, C, X).
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 13 (Received 0 out of 0 points)
Question: The primary (or candidate) key of a relation functionally determines
all the other attributes in the relation.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 14 (Received 0 out of 0 points)
Question: One important relational design principle is that ___________.
Your answer: No response
Correct answer: every determinant must be a candidate key
--------------------------------------------------------------------------------
Question 15 (Received 0 out of 0 points)
Question: A rule that requires every value in a foreign key to match values in
the corresponding primary key is called a referential integrity constraint.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 16 (Received 0 out of 0 points)
Question: Which of the following would not be contained in a use case?
Your answer: No response
Correct answer: A prototype of the system performing a given task.
--------------------------------------------------------------------------------
Question 17 (Received 0 out of 0 points)
Question: One shortcoming of UML is its inability to represent weak entities.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 18 (Received 0 out of 0 points)
Question: In SQL, the LIKE keyword can be used to select on partial values.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 19 (Received 0 out of 0 points)
Question: Which SQL keyword is used to eliminate duplicate rows in the results
of a SQL SELECT query?
Your answer: No response
Correct answer: DISTINCT
--------------------------------------------------------------------------------
Question 20 (Received 0 out of 0 points)
Question: Which of the following is the correct technique for representing a
weak entity in UML-style E-R diagrams?
Your answer: No response
Correct answer: Placing a filled-in diamond next to the strong entity
--------------------------------------------------------------------------------
Question 21 (Received 0 out of 0 points)
Question: The number of entity classes involved in a relationship is the
cardinality of the relationship.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 22 (Received 0 out of 0 points)
Question: Which of the following is not a basic element of the E-R Model?
Your answer: No response
Correct answer: Use cases
--------------------------------------------------------------------------------
Question 23 (Received 0 out of 0 points)
Question: When using SQL to create a table, specifying a data type of Char(10)
indicates a fixed length field of 10 characters.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 24 (Received 0 out of 0 points)
Question: Attribute specifications are the documentation of the attributes' data
format and properties.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 25 (Received 0 out of 0 points)
Question: In SQL, to refer to a range in a WHERE clause, use the WITHIN keyword.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 26 (Received 0 out of 0 points)
Question: When an entity class has a relationship with itself, it is called a
recursive relationship.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 27 (Received 0 out of 0 points)
Question: The result for SELECT statements in SQL is a relation unless the
result is a single number.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 28 (Received 0 out of 0 points)
Question: Which of the following can not be done using the ALTER TABLE command?
Your answer: No response
Correct answer: All of the above can be done using the ALTER TABLE command.
--------------------------------------------------------------------------------
Question 29 (Received 0 out of 0 points)
Question: Which of the following is not one of the five SQL built-in functions?
Your answer: No response
Correct answer: MODE
--------------------------------------------------------------------------------
Question 30 (Received 0 out of 0 points)
Question: A prototype is a working demonstration of selected portions of the
future system.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 31 (Received 0 out of 0 points)
Question: During the design phase of developing a database system, the users are
asked about the need for changes to existing forms and reports.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 32 (Received 0 out of 0 points)
Question: Use cases are descriptions of the ways users will employ the features
and functions of the new information system.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 33 (Received 0 out of 0 points)
Question: In UML-style E-R diagrams, the entity class symbol contains what
information in the second segment?
Your answer: No response
Correct answer: Attributes
--------------------------------------------------------------------------------
Question 34 (Received 0 out of 0 points)
Question: In SQL, the order of the rows that result from a SELECT statement can
be set using the SORT BY phrase.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 35 (Received 0 out of 0 points)
Question: When using SQL to create a table, a column is defined by declaring, in
this order: data type, column name, and properties.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 36 (Received 0 out of 0 points)
Question: A trigger cannot be fired because of the actions of another trigger.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 37 (Received 0 out of 0 points)
Question: Transaction results are kept in a log, which contains records of the
data changes in chronological order.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 38 (Received 0 out of 0 points)
Question: In certain circumstances, a single entity may be broken into relations
for performance reasons.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 39 (Received 0 out of 0 points)
Question: Recursive relationships can be represented in the relational model
using the same techniques that are used for binary relationships.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 40 (Received 0 out of 0 points)
Question: To normalize a relation, the determinant of every functional
dependency should be a candidate key.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 41 (Received 0 out of 0 points)
Question: Boyce-Codd Normal Form was created to address the problem of
multi-valued dependencies.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 42 (Received 0 out of 0 points)
Question: Which of the following is a type of trigger than can be invoked in
place of DBMS insert, update, or delete actions?
Your answer: No response
Correct answer: INSTEAD OF triggers
--------------------------------------------------------------------------------
Question 43 (Received 0 out of 0 points)
Question: A stored procedure is invoked automatically by the DBMS whenever
certain events occur.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 44 (Received 0 out of 0 points)
Question: Two-phased locking can be used to ensure that transactions are
serializable.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 45 (Received 0 out of 0 points)
Question: A trigger is like a stored event except that it is invoked by the DBMS
when specified events occur.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 46 (Received 0 out of 0 points)
Question: If two entities are in a 1:1 relationship that is mandatory in both
directions and they have the same primary key, then the designer should consider
__________.
Your answer: No response
Correct answer: combining them into a single relation
--------------------------------------------------------------------------------
Question 47 (Received 0 out of 0 points)
Question: The recovery method in which we undo the changes that erroneous or
partially processed transactions have made in the database is called rollback
recovery.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 48 (Received 0 out of 0 points)
Question: Database administrators must make sure that backup and recovery
techniques and procedures are operating to protect the database in case of
failure and to recover it as quickly and accurately as possible when necessary.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 49 (Received 0 out of 0 points)
Question: When attempting to delete data about one theme results in the loss of
data about another theme because the data for both themes are stored in the same
relation, it is called a(n) ____________.
Your answer: No response
Correct answer: none of the above
--------------------------------------------------------------------------------
Question 50 (Received 0 out of 0 points)
Question: The recovery technique in which the database is returned to a known
state and then all valid transactions are reapplied to the database is known as
___________.
Your answer: No response
Correct answer: rollforward
--------------------------------------------------------------------------------
Question 51 (Received 0 out of 0 points)
Question: The key for an intersection relation is always the combination of the
keys of the parent entities.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 52 (Received 0 out of 0 points)
Question: Which of the following is not true of database recovery through
reprocessing?
Your answer: No response
Correct answer: Reprocessing will always return the database to its exact
previous state.
--------------------------------------------------------------------------------
Question 53 (Received 0 out of 0 points)
Question: Losing two and possibly three themes while attempting to delete data
about one is called an insertion anomaly.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 54 (Received 0 out of 0 points)
Question: Whether a lock applies to data at the record level, page level, table
level, or database level is referred to as _________.
Your answer: No response
Correct answer: lock granularity
--------------------------------------------------------------------------------
Question 55 (Received 0 out of 0 points)
Question: With optimistic locking, locks are first issued, then the transaction
is processed, and then the locks are released.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 56 (Received 0 out of 0 points)
Question: To represent a many-to-many relationship in the relational model, a
union relation is used.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 57 (Received 0 out of 0 points)
Question: A recursive relationship is a relationship among entities of the same
class.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 58 (Received 0 out of 0 points)
Question: Ensuring that each SQL statement independently processes consistent
rows is known as _______.
Your answer: No response
Correct answer: statement level consistency
--------------------------------------------------------------------------------
Question 59 (Received 0 out of 0 points)
Question: Statement level consistency means that all statements within a
transaction will access consistent rows across the lifetime of the entire
transaction.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 60 (Received 0 out of 0 points)
Question: A dirty read is a problem with concurrent processing when a
transaction rereads data it has already read and finds modifications or
deletions caused by another transaction.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 61 (0 points possible)
Question: Given the relation EMPLOYEE (EmployeeNumber, Name, Phone, Department),
write a SQL query statement that will list all rows and columns sorted
alphabetically on the employee name.
Your answer:
No response
Correct answer:
SELECT EmployeeNumber, Name , Phone, Department
FROM EMPLOYEE
ORDER BY Name;
[alternate answer]
SELECT *
FROM EMPLOYEE
ORDER BY Name;
--------------------------------------------------------------------------------
Question 62 (0 points possible)
Question: Restaurant Meal Check
Determine the entities implied by the following, unnormalized table(s). Draw an
appropriate E-R diagram.
Meal Check(Check Number, Booth Number, Session, Date, Meal, Server Number,
Server Name, Food total, Tax, Tip, Check Total, (Seat Number, Guest Description,
(Menu Item Number, Item Name, Item Price)))
This document concerns meal check information. For a given meal check
(identified by the check number), there will be a single server assigned to a
single customer group (usually occupying a booth.) Each time a different group
occupies the booth, there is a new session number (the session numbers start
anew every day.) The server's number and name appear on the check as well as the
meal (breakfast, lunch, dinner) and date. Also, there may be several different
item orders appearing on the check for each of one or more guests (id'ed by seat
number.) For each item order that appears, the item number, name, and price will
be displayed. The price is from the current menu table.
Your answer:
No response
Correct answer:
--------------------------------------------------------------------------------
Question 63 (0 points possible)
Question: Video Rentals
a.) List the functional dependencies in the following table subject to the
specified conditions.
b.) Convert this table to an equivalent collection of tables that are in 3NF.
Rental Agreement(Agreement Number, Customer Number, Last Name, First Name,
Street, City, State, Zip Code, Agreement Date, (Video Number, Video Title, Type,
New, Charge, Due Date))
This table concerns rental agreement information. For a given agreement
(identified by the agreement number), there will be a single customer. The
customer's number, name, and address appear on the invoice as well as the
agreement date. Also, there will be one or more different videos appearing on
the agreement. For each video that appears, the video number, video title, type
(VHS or DVD), new (yes or no), charge, and due date will be displayed. The
charge is from the current master charge table list, and is based on type and
whether it is new or not. The due date is based on type and whether it is new or
not (due date is calculated by a number of days, from the master charge table
list, added to the agreement date.)
An example of the master table list follows:
type new charge days
---- --- ------ ----
DVD Y 3.00 1
DVD N 1.00 1
VHS Y 2.00 1
VHS N 1.00 3
Your answer:
No response
Correct answer:
--------------------------------------------------------------------------------
Question 64 (0 points possible)
Question: College Student
Using your knowledge of a college environment, determine the functional
dependencies that exist in the following table. After these have been
determined, convert this table to an equivalent collection of tables that are in
3NF.
Student(Student Number, Student Name, Number Credits, Advisor Number, Advisor
Name, Dept Number, Dept Name, (Course Number, Course Description, Course Term,
Grade))
Remember there are 2 parts:
a) functional dependencies, and
b) 3NF tables
Your answer:
No response
Correct answer:
Question 1 (Received 0 out of 0 points)
Question: Which of the following is not typically true about large database
systems?
Your answer: No response
Correct answer: They hide most of the development complexity with wizards.
--------------------------------------------------------------------------------
Question 2 (Received 0 out of 0 points)
Question: To create a well-formed relation through normalization, every
determinant must be a candidate key.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 3 (Received 0 out of 0 points)
Question: Databases are key components of _____.
Your answer(s):
No response
Correct answer(s):
e-commerce
Web-based applications
censuses
management decision support systems
--------------------------------------------------------------------------------
Question 4 (Received 0 out of 0 points)
Question: Candidate keys may or may not be unique.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 5 (Received 0 out of 0 points)
Question: A database is a set of one or more computer programs that serves as an
intermediary between the users and the DBMS.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 6 (Received 0 out of 0 points)
Question: Surrogate key values have no meaning to the users.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 7 (Received 0 out of 0 points)
Question: In the general division of labor between database applications and the
DBMS, the processing for forms is considered a DBMS task.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 8 (Received 0 out of 0 points)
Question: The use of surrogate keys usually complicates application programming
since most DBMS products require the application program to generate surrogate
key values.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 9 (Received 0 out of 0 points)
Question: Which of the following would not be an example of metadata?
Your answer: No response
Correct answer: All of the above are metadata.
--------------------------------------------------------------------------------
Question 10 (Received 0 out of 0 points)
Question: Which of the following is not a basic component of a database system?
Your answer: No response
Correct answer: ERD
--------------------------------------------------------------------------------
Question 11 (Received 0 out of 0 points)
Question: Databases are used in rare circumstances.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 12 (Received 0 out of 0 points)
Question: In the relational model, each row of a table contains data that
represents an attribute of the entity.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 13 (Received 0 out of 0 points)
Question: Given the functional dependency for the attributes of ENTITY1, X à (A,
B, C), X is a candidate key for the relation ENTITY1 (A, B, C, X).
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 14 (Received 0 out of 0 points)
Question: Databases are used by thousands of workgroups.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 15 (Received 0 out of 0 points)
Question: Which of the following is true about a key?
Your answer(s):
No response
Correct answer(s):
It may be unique.
It may be non-unique.
It may identify more than one row.
Both a and b.
All of the above.
--------------------------------------------------------------------------------
Question 16 (Received 0 out of 0 points)
Question: A subquery is appropriate only if the final result contains only data
from a single table.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 17 (Received 0 out of 0 points)
Question: Standard SQL does not allow built-in functions to be used in a WHERE
clause.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 18 (Received 0 out of 0 points)
Question: In the E-R Model, all instances of an entity of a given type are
grouped into __________.
Your answer: No response
Correct answer: entity classes
--------------------------------------------------------------------------------
Question 19 (Received 0 out of 0 points)
Question: When using SQL to create a table, specifying a data type of Char(10)
indicates a fixed length field of 10 characters.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 20 (Received 0 out of 0 points)
Question: In SQL, the LIKE keyword can be used to select on partial values.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 21 (Received 0 out of 0 points)
Question: In SQL, the order of the rows that result from a SELECT statement can
be set using the SORT BY phrase.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 22 (Received 0 out of 0 points)
Question: To create a primary key that is a composite key using SQL, the key
must be defined when the table is created using the CREATE TABLE statement.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 23 (Received 0 out of 0 points)
Question: When using SQL to create a table, specifying the NULL property for a
column indicates that only null values may be stored in that column.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 24 (Received 0 out of 0 points)
Question: Attribute specifications are the documentation of the attributes' data
format and properties.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 25 (Received 0 out of 0 points)
Question: System requirements as documented by use cases, business rules, forms,
reports, and queries are sufficient to design the database without using a
formal data model.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 26 (Received 0 out of 0 points)
Question: The PRODUCT entity instance is the collection of all PRODUCT entity
classes.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 27 (Received 0 out of 0 points)
Question: SQL is a data sublanguage, not a complete programming language.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 28 (Received 0 out of 0 points)
Question: The data model is a representation of the content, relationships, and
constraints of the data needed to support the system requirements.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 29 (Received 0 out of 0 points)
Question: Data from a maximum of three tables can be combined through the use of
subqueries in SQL.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 30 (Received 0 out of 0 points)
Question: There is usually only one instance of an entity in an entity class.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 31 (Received 0 out of 0 points)
Question: Business rules constrain data values and the processing of the
database.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 32 (Received 0 out of 0 points)
Question: Which of the following data types used in SQL would define a
fixed-length text field of 10 characters?
Your answer: No response
Correct answer: char(10)
--------------------------------------------------------------------------------
Question 33 (Received 0 out of 0 points)
Question: Which of the following is not a source for user requirements during
the requirements stage of developing a database system?
Your answer: No response
Correct answer: All of the above are sources for user requirements.
--------------------------------------------------------------------------------
Question 34 (Received 0 out of 0 points)
Question: Relationships with the degree 2 are often called binary relationships.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 35 (Received 0 out of 0 points)
Question: In SQL, to refer to a range in a WHERE clause, use the WITHIN keyword.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 36 (Received 0 out of 0 points)
Question: A transaction in which all steps must be completed successfully or
none of them will be completed is called a durable transaction.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 37 (Received 0 out of 0 points)
Question: An ACID transaction is one that is ___________.
Your answer(s):
No response
Correct answer(s):
atomic
consistent
isolated
durable
all of the above
--------------------------------------------------------------------------------
Question 38 (Received 0 out of 0 points)
Question: The fundamental rule of normalization can be stated as:
Your answer: No response
Correct answer: Every determinant must be a candidate key.
--------------------------------------------------------------------------------
Question 39 (Received 0 out of 0 points)
Question: From a pragmatic standpoint, the only important rule of normalization
is that the determinant of every functional dependency must be a candidate key.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 40 (Received 0 out of 0 points)
Question: Which of the following is not true of database recovery through
reprocessing?
Your answer: No response
Correct answer: Reprocessing will always return the database to its exact
previous state.
--------------------------------------------------------------------------------
Question 41 (Received 0 out of 0 points)
Question: One advantage of optimistic locking is that the lock is obtained only
after the transaction is processed.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 42 (Received 0 out of 0 points)
Question: In the relational model, many-to-many relationships cannot be directly
represented by relations.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 43 (Received 0 out of 0 points)
Question: Transactions have a growing phase, in which locks are obtained and a
shrinking phase, in which locks are released.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 44 (Received 0 out of 0 points)
Question: All recursive relationships are 1:1.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 45 (Received 0 out of 0 points)
Question: Transactions should be written to the log before they are applied to
the database itself.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 46 (Received 0 out of 0 points)
Question: Once a relation has been defined for an entity, it should be examined
according to normalization criteria.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 47 (Received 0 out of 0 points)
Question: DK/NF requires:
Your answer: No response
Correct answer: Every constraint on data values must be a logical consequence of
the definition of domains and keys.
--------------------------------------------------------------------------------
Question 48 (Received 0 out of 0 points)
Question: Given ENTITY A and ENTITY B shown in the figure, which of the
following would display the correct placement of foreign keys in the relational
model? (PK = Primary Key, FK = Foreign Key)
Your answer: No response
Correct answer: ENTITY A (Attribute1(PK), Attribute2, Attribute3); ENTITY B
(Attribute4(PK), Attribute5, Attribute6, Attribute1(FK))
--------------------------------------------------------------------------------
Question 49 (Received 0 out of 0 points)
Question: The term DBA refers to ____________.
Your answer: No response
Correct answer: database administrator
--------------------------------------------------------------------------------
Question 50 (Received 0 out of 0 points)
Question: When a change in the data concerning one theme occurs that causes many
rows of the table to be modified because the table contains data about multiple
themes, we call this characteristic a modification anomaly.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 51 (Received 0 out of 0 points)
Question: Transaction results are kept in a log, which contains records of the
data changes in chronological order.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 52 (Received 0 out of 0 points)
Question: The simplest and most feasible means of recovering a database is
through reprocessing.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 53 (Received 0 out of 0 points)
Question: DK/NF requires that all constraints on data values be logical
implications of the definitions of domains and keys.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 54 (Received 0 out of 0 points)
Question: Boyce-Codd Normal Form was created to address the problem of
multi-valued dependencies.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 55 (Received 0 out of 0 points)
Question: ASP and JSP can include instructions to read data, but may not update
or delete data.
Your answer: No response
Correct answer: False
--------------------------------------------------------------------------------
Question 56 (Received 0 out of 0 points)
Question: R. Fagin defined the domain key / normal form, and a relation in this
form has no anomalies.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 57 (Received 0 out of 0 points)
Question: The purpose of concurrency control is to ensure that one user's work
does not inappropriately influence another user's work.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 58 (Received 0 out of 0 points)
Question: What concurrent processing problem occurs when a transaction rereads
data and finds new rows that were inserted by a different transaction since the
prior read?
Your answer: No response
Correct answer: Phantom reads
--------------------------------------------------------------------------------
Question 59 (Received 0 out of 0 points)
Question: Database administrators must make sure that backup and recovery
techniques and procedures are operating to protect the database in case of
failure and to recover it as quickly and accurately as possible when necessary.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 60 (Received 0 out of 0 points)
Question: The recovery method in which we undo the changes that erroneous or
partially processed transactions have made in the database is called rollback
recovery.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 61 (0 points possible)
Question: Given the relation PROJECT(ProjectID, Name, Department, MaxHours),
write a SQL query statement that will list all rows and columns for the case in
which MaxHours is greater than 100.
Your answer:
No response
Correct answer:
SELECT ProjectID, Name, Department, MaxHours
FROM PROJECT
WHERE MaxHours > 100;
[alternate answer]
SELECT *
FROM PROJECT
WHERE MaxHours > 100;
--------------------------------------------------------------------------------
Question 62 (0 points possible)
Question: Dental Patient
Determine the entities implied by the following, unnormalized table(s). Draw an
appropriate E-R diagram.
Patient (Household Number, Household Name, Household City, Household State,
Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service
Description, Service Fee))
This is a table concerning information about patients of a dentist. Each patient
belongs to a household. The household head is responsible for paying for dental
services for all members of the household. The household head is designated in
the table by "HH" being part of the patient number.
Your answer:
No response
Correct answer:
--------------------------------------------------------------------------------
Question 63 (0 points possible)
Question: Dental Patient Record
a.) List the functional dependencies in the following table subject to the
specified conditions.
b.) Convert this table to an equivalent collection of tables that are in 3NF.
Patient (Household Number, Household Name, Household City, Household State,
Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service
Description, Service Fee))
This is a table concerning information about patients of a dentist. Each patient
belongs to a household. The household head is responsible for paying for dental
services for all members of the household. The household head is designated in
the table by "HH" being part of the patient number.
Be sure to do both parts a. and b. of this question.
Your answer:
No response
Correct answer:
--------------------------------------------------------------------------------
Question 64 (0 points possible)
Question: Legal Services
a.) List the functional dependencies in the following table subject to the
specified conditions.
b.) Convert this table to an equivalent collection of tables that are in 3NF.
Statement(Statement Number, Client Number, Last Name, First Name, Street, City,
State, Zip Code, Statement Date, Attorney Number, Attorney Last Name(Service
Code, Service Description, Service Date, Attorney Number, Hours))
This table concerns statement for legal services rendered information. For a
given statement (identified by the statement number), there will be a single
client. The client's number, name, and address appear on the statement as well
as the statement date. Each client has one specific attorney, for all services,
even though another attorneys may participate on a given service. Also, there
may be several services listed on the statement. For each service that appears,
the service code, service description, service date, and hours will be
displayed.
Your answer:
No response
Correct answer:
Question 1 (Received 0 out of 0 points)
Question: The primary (or candidate) key of a relation functionally determines
all the other attributes in the relation.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 2 (Received 0 out of 0 points)
Question: To represent a relationship in the relational model, the primary key
of one relation is placed into a second relation.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 3 (Received 0 out of 0 points)
Question: UUsually, a database table containing both rows and columns is
designed to store data for exactly two topics.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 4 (Received 0 out of 0 points)
Question: The primary key is used both to identify unique rows in a relation and
to represent rows in relationships.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 5 (Received 0 out of 0 points)
Question: Which of the following is not typically true about large database
systems?
Your answer: They support hundreds or thousands of users.
Correct answer: They hide most of the development complexity with wizards.
--------------------------------------------------------------------------------
Question 6 (Received 0 out of 0 points)
Question: Which of the following is not true about a relation?
Your answer: The cells of a relation must hold a single value.
Correct answer: A relation may have duplicate column names.
--------------------------------------------------------------------------------
Question 7 (Received 0 out of 0 points)
Question: Which of the following is true about a relation?
Your answer: A relation may have duplicate rows.
Correct answer: All entries in any column must be of the same kind.
--------------------------------------------------------------------------------
Question 8 (Received 0 out of 0 points)
Question: Databases are used in rare circumstances.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 9 (Received 0 out of 0 points)
Question: In the relational model, each row of a table contains data that
represents an attribute of the entity.
Your answer: False
Correct answer: False
--------------------------------------------------------------------------------
Question 10 (Received 0 out of 0 points)
Question: In the general division of labor between database applications and the
DBMS, the processing for forms is considered a DBMS task.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 11 (Received 0 out of 0 points)
Question: In the general division of labor between database applications and the
DBMS, the application program formats the results of a query into a report.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 12 (Received 0 out of 0 points)
Question: A table that meets the requirements of a relation is said to be in
which normal form?
Your answer: first normal form
Correct answer: first normal form
--------------------------------------------------------------------------------
Question 13 (Received 0 out of 0 points)
Question: A database is a set of one or more computer programs that serves as an
intermediary between the users and the DBMS.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 14 (Received 0 out of 0 points)
Question: The unique keys that are not chosen to be the primary key are called
composite keys.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 15 (Received 0 out of 0 points)
Question: Which of the following would not be an example of metadata?
Your answer: All of the above are metadata.
Correct answer: All of the above are metadata.
--------------------------------------------------------------------------------
Question 16 (Received 0 out of 0 points)
Question: The basic format for documenting cardinalities in UML is x..y, where x
is the maximum cardinality and y is the minimum cardinality.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 17 (Received 0 out of 0 points)
Question: Which SQL keyword is used to apply conditions to restrict groups that
appear in the results of a SELECT query that uses GROUP BY?
Your answer: WHERE
Correct answer: HAVING
--------------------------------------------------------------------------------
Question 18 (Received 0 out of 0 points)
Question: Unified Modeling Language (UML) is intended for the development of
object-oriented systems.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 19 (Received 0 out of 0 points)
Question: The number of entity classes involved in a relationship is known as
the _________ of the relationship.
Your answer: minimum cardinality
Correct answer: degree
--------------------------------------------------------------------------------
Question 20 (Received 0 out of 0 points)
Question: The representation of the content, relationships, and constraints of
the data needed to support the system requirements is the _________.
Your answer: implementation
Correct answer: data model
--------------------------------------------------------------------------------
Question 21 (Received 0 out of 0 points)
Question: Use cases are descriptions of the ways users will employ the features
and functions of the new information system.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 22 (Received 0 out of 0 points)
Question: Which of the following is the correct SQL clause to sort the results
of a SELECT query in reverse-alphabetic order using the Department field?
Your answer: SORT BY Department
Correct answer: ORDER BY Department DESC
--------------------------------------------------------------------------------
Question 23 (Received 0 out of 0 points)
Question: System requirements as documented by use cases, business rules, forms,
reports, and queries are sufficient to design the database without using a
formal data model.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 24 (Received 0 out of 0 points)
Question: In the E-R Model, all instances of an entity of a given type are
grouped into __________.
Your answer: class objects
Correct answer: entity classes
--------------------------------------------------------------------------------
Question 25 (Received 0 out of 0 points)
Question: In SQL, the LIKE keyword can be used to select on partial values.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 26 (Received 0 out of 0 points)
Question: In SQL, the order of the rows that result from a SELECT statement can
be set using the SORT BY phrase.
Your answer: False
Correct answer: False
--------------------------------------------------------------------------------
Question 27 (Received 0 out of 0 points)
Question: Which type of join, although not included in standard SQL, was created
to allow unmatched rows to appear in the result of a join operation?
Your answer: OPEN JOIN
Correct answer: OUTER JOIN
--------------------------------------------------------------------------------
Question 28 (Received 0 out of 0 points)
Question: The result for SELECT statements in SQL is a relation unless the
result is a single number.
Your answer: False
Correct answer: False
--------------------------------------------------------------------------------
Question 29 (Received 0 out of 0 points)
Question: Which SQL keyword is used to eliminate duplicate rows in the results
of a SQL SELECT query?
Your answer: ORDER BY
Correct answer: DISTINCT
--------------------------------------------------------------------------------
Question 30 (Received 0 out of 0 points)
Question: The basic idea of a join is to combine the contents of two or more
relations into a new relation.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 31 (Received 0 out of 0 points)
Question: Which of the following would not be contained in a use case?
Your answer: A prototype of the system performing a given task.
Correct answer: A prototype of the system performing a given task.
--------------------------------------------------------------------------------
Question 32 (Received 0 out of 0 points)
Question: One type of strong entity is the ID-dependent entity.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 33 (Received 0 out of 0 points)
Question: In UML-style E-R diagrams, an entity class is represented by a
rectangle with three segments.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 34 (Received 0 out of 0 points)
Question: Relationships with the degree 2 are often called binary relationships.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 35 (Received 0 out of 0 points)
Question: When developing a database system, the database is constructed during
the implementation phase.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 36 (Received 0 out of 0 points)
Question: When data about one theme cannot be entered in a relation until data
about a second theme is also available because both themes are stored in the
same relation, this is called a(n) ____________.
Your answer: creation anomaly
Correct answer: insertion anomaly
--------------------------------------------------------------------------------
Question 37 (Received 0 out of 0 points)
Question: The simplest and most feasible means of recovering a database is
through reprocessing.
Your answer: False
Correct answer: False
--------------------------------------------------------------------------------
Question 38 (Received 0 out of 0 points)
Question: A transaction in which all steps must be completed successfully or
none of them will be completed is called a durable transaction.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 39 (Received 0 out of 0 points)
Question: DK/NF requires that all constraints on data values be logical
implications of the definitions of domains and keys.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 40 (Received 0 out of 0 points)
Question: To represent a many-to-many relationship in the relational model, an
intersection relation is used.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 41 (Received 0 out of 0 points)
Question: Which of the following is true about stored procedures?
Your answer: Stored procedures cannot be passed parameters like a regular
application function.
Correct answer: Stored procedures are written in languages provided by the DBMS.
--------------------------------------------------------------------------------
Question 42 (Received 0 out of 0 points)
Question: Relationships that are 1:1 and are mandatory in both directions often
indicate that the two entities should be combined into a single entity.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 43 (Received 0 out of 0 points)
Question: Once a relation has been defined for an entity, it should be examined
according to normalization criteria.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 44 (Received 0 out of 0 points)
Question: R. Fagin defined the domain key / normal form, and a relation in this
form has no anomalies.
Your answer: No response
Correct answer: True
--------------------------------------------------------------------------------
Question 45 (Received 0 out of 0 points)
Question: One of the major tasks of the database administration is called
concurrency control, which allows multi-users to access the database
simultaneously.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 46 (Received 0 out of 0 points)
Question: Given ENTITY A and ENTITY B shown in the figure, which of the
following would display the correct placement of foreign keys in the relational
model? (PK = Primary Key, FK = Foreign Key)
Your answer: ENTITY A (Attribute1(PK), Attribute2, Attribute3, Attribute6(FK));
ENTITY B (Attribute4(PK), Attribute5, Attribute6)
Correct answer: ENTITY A (Attribute1(PK), Attribute2, Attribute3); ENTITY B
(Attribute4(PK), Attribute5, Attribute6, Attribute1(FK))
--------------------------------------------------------------------------------
Question 47 (Received 0 out of 0 points)
Question: To represent a M:N relationship in the relational model, an
intersection relation is created to represent the relationship itself.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 48 (Received 0 out of 0 points)
Question: Which of the following is the first step in representing entities
using the relational model?
Your answer: Determine identifiers
Correct answer: Define a relation for each entity
--------------------------------------------------------------------------------
Question 49 (Received 0 out of 0 points)
Question: Database administrators must make sure that backup and recovery
techniques and procedures are operating to protect the database in case of
failure and to recover it as quickly and accurately as possible when necessary.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 50 (Received 0 out of 0 points)
Question: A stored procedure is invoked automatically by the DBMS whenever
certain events occur.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 51 (Received 0 out of 0 points)
Question: When applied to 1:N relationships, the term ?parent? refers to the
many side of the relationship since a child may have many parents.
Your answer: True
Correct answer: False
--------------------------------------------------------------------------------
Question 52 (Received 0 out of 0 points)
Question: Which of the following is not true of database recovery through
reprocessing?
Your answer: Reprocessing takes the same amount of time as did processing in the
first place.
Correct answer: Reprocessing will always return the database to its exact
previous state.
--------------------------------------------------------------------------------
Question 53 (Received 0 out of 0 points)
Question: Which normal form deals with the problem of tables that can be split
apart but not correctly joined back together?
Your answer: Boyce-Codd Normal Form
Correct answer: 5NF
--------------------------------------------------------------------------------
Question 54 (Received 0 out of 0 points)
Question: Which of the following is not a means of processing databases?
Your answer(s):
Programs coded in COBOL.
Internet applications using ASP.
Processed by stored procedures and triggers.
Programs coded in Java or C#.
All of the above are means of processing a database.
Correct answer(s):
Programs coded in COBOL.
Internet applications using ASP.
Processed by stored procedures and triggers.
Programs coded in Java or C#.
All of the above are means of processing a database.
--------------------------------------------------------------------------------
Question 55 (Received 0 out of 0 points)
Question: Only large database systems have a need for database administration.
Your answer: False
Correct answer: False
--------------------------------------------------------------------------------
Question 56 (Received 0 out of 0 points)
Question: Boyce-Codd Normal Form was created to address the problem of
multi-valued dependencies.
Your answer: False
Correct answer: False
--------------------------------------------------------------------------------
Question 57 (Received 0 out of 0 points)
Question: All actions in an atomic transaction are completed successfully or
none of the actions are completed at all.
Your answer: False
Correct answer: True
--------------------------------------------------------------------------------
Question 58 (Received 0 out of 0 points)
Question: Rollback requires the use of logs, but rollforward does not.
Your answer: False
Correct answer: False
--------------------------------------------------------------------------------
Question 59 (Received 0 out of 0 points)
Question: When a change in the data concerning one theme occurs that causes many
rows of the table to be modified because the table contains data about multiple
themes, we call this characteristic a modification anomaly.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 60 (Received 0 out of 0 points)
Question: A recursive relationship is a relationship among entities of the same
class.
Your answer: True
Correct answer: True
--------------------------------------------------------------------------------
Question 61 (0 points possible)
Question: Given the relation EMPLOYEE (EmployeeNumber, Name, Phone, Department),
write a SQL query statement that will list all rows and columns for the case in
which the Employees have phone numbers beginning with ?597-?.
Your answer:
look up
Correct answer:
SELECT EmployeeNumber, Name , Phone, Department
FROM EMPLOYEE
WHERE Phone LIKE ?597-____?;
[alternate answers]
SELECT *
FROM EMPLOYEE
WHERE Phone LIKE ?597-____?;
SELECT *
FROM EMPLOYEE
WHERE Phone LIKE ?597-%?;
--------------------------------------------------------------------------------
Question 62 (0 points possible)
Question: College Student
Using your knowledge of a college environment, determine the entities implied by
the following, unnormalized table(s). Draw an appropriate E-R diagram.
Student(Student Number, Student Name, Number Credits, Advisor Number, Advisor
Name, Dept Number, Dept Name, (Course Number, Course Description, Course Term,
Grade))
Your answer:
look up
Correct answer:
--------------------------------------------------------------------------------
Question 63 (0 points possible)
Question: Restaurant Meal Check
a.) List the functional dependencies in the following document subject to the
specified conditions.
b.) Convert this document to an equivalent collection of tables that are in 3NF.
Meal Check(Check Number, Booth Number, Session, Date, Meal, Server Number,
Server Name, Food total, Tax, Tip, Check Total, (Seat Number, Guest Description,
(Menu Item Number, Item Name, Item Price)))
This document concerns meal check information. For a given meal check
(identified by the check number), there will be a single server assigned to a
single customer group (usually occupying a booth.) Each time a different group
occupies the booth, there is a new session number (the session numbers start
anew every day.) The server's number and name appear on the check as well as the
meal (breakfast, lunch, dinner) and date. Also, there may be several different
item orders appearing on the check for each of one or more guests (id'ed by seat
number.) For each item order that appears, the item number, name, and price will
be displayed. The price is from the current menu table.
Your answer:
l;ook up
Correct answer:
--------------------------------------------------------------------------------
Question 64 (0 points possible)
Question: Dental Patient Record
a.) List the functional dependencies in the following table subject to the
specified conditions.
b.) Convert this table to an equivalent collection of tables that are in 3NF.
Patient (Household Number, Household Name, Household City, Household State,
Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service
Description, Service Fee))
This is a table concerning information about patients of a dentist. Each patient
belongs to a household. The household head is responsible for paying for dental
services for all members of the household. The household head is designated in
the table by "HH" being part of the patient number.
Be sure to do both parts a. and b. of this question.
Your answer:
look up
Correct answer: