C430 MIDTERM QUESTIONS WITH 100%
ACCURATE ANSWERS
False - Accurate answers A relation describes the structure, content, and access controls of a
physical data store or database.
True - Accurate answers A relational database management system stores data in tables.
false - Accurate answers Every table in a relational database must have a foreign key.
true - Accurate answers A foreign key is a field or set of fields stored in one table that also exists as
a primary key in another table.
false - Accurate answers Relationships in a relational database are usually represented by
embedding a foreign key in each participating table.
true - Accurate answers Classes that participate in a classification hierarchy can be represented
within a relational database as a set of tables with the primary key of the general class table replicated
in the other tables.
false - Accurate answers Classes that participate in a classification relationship can only be
represented within a relational database as a single table containing all the attributes in each class.
false - Accurate answers A relational database table is in third normal form (3NF) if it is in second
normal form (2NF) and if every non-key field is functionally dependent on the primary key.
true - Accurate answers A relational database table is in third normal form (3NF) if it is in second
normal form (2NF) and if no non-key field is functionally dependent on any other non-key field.
false - Accurate answers Problem domain modeling and database normalization are incompatible
techniques for relational database design.
true - Accurate answers One-to-many and many-to-many relationships are both represented by
foreign keys in a relational database.
true - Accurate answers Referential integrity is a consistent relational database state in which
every foreign key value also exists as a primary key value.
true - Accurate answers Every database in a DBMS consists of two separate data stores.
false - Accurate answers The domain data in a database is sometimes referred to as metadata.
false - Accurate answers A local business office with a small database which is only used by two or
three users would most probably implement a desktop DBMS.
, false - Accurate answers A phased database development and deployment (using iterative
development) is usually the safest approach to deploying the best database solution.
true - Accurate answers In an iterative approach to software development, it is usually best to
develop the database in the first few iterations.
false - Accurate answers To ensure that the database is designed correctly, an important member
of the project team is the data administrator.
true - Accurate answers Relationships between tables is usually indicated through the use of a
foreign key.
false - Accurate answers In a one-to-many association the primary key of the "many" class is placed
as a foreign key in the "one" class.
false - Accurate answers Including a total amount field as the sum of other fields in a table is a
violation of second normal form.
false - Accurate answers A write lock on a database allows other users to read the data, but they
cannot update any data.
schema - Accurate answers A(n) ____ describes the structure, content, and access controls of a
physical data store or database.
low level process management - Accurate answers Which of the following is NOT a component or
function of a typical database management system (DBMS)?
tuple - Accurate answers In a relational database, a row can be referred to as a(n) ____.
tables - Accurate answers Data elements in a relational database are organized into ____.
primary key - Accurate answers A(n) ____ is a field or set of fields used to uniquely identify each
row.
keys - Accurate answers ____ are a critical element of relational database design because they are
the bases for representing relationships among tables.
attribute - Accurate answers One column of a table in a relational database is called a(n) ____.
foreign key - Accurate answers A(n) ____ is a field or set of fields stored in one table that also
exists as a primary key in another table.
table - Accurate answers Each class on an class diagram is represented by a(n) ____ in a relational
database.
columns - Accurate answers All ____ in a table are guaranteed to be unique if the table's primary
key is guaranteed to be unique.
ACCURATE ANSWERS
False - Accurate answers A relation describes the structure, content, and access controls of a
physical data store or database.
True - Accurate answers A relational database management system stores data in tables.
false - Accurate answers Every table in a relational database must have a foreign key.
true - Accurate answers A foreign key is a field or set of fields stored in one table that also exists as
a primary key in another table.
false - Accurate answers Relationships in a relational database are usually represented by
embedding a foreign key in each participating table.
true - Accurate answers Classes that participate in a classification hierarchy can be represented
within a relational database as a set of tables with the primary key of the general class table replicated
in the other tables.
false - Accurate answers Classes that participate in a classification relationship can only be
represented within a relational database as a single table containing all the attributes in each class.
false - Accurate answers A relational database table is in third normal form (3NF) if it is in second
normal form (2NF) and if every non-key field is functionally dependent on the primary key.
true - Accurate answers A relational database table is in third normal form (3NF) if it is in second
normal form (2NF) and if no non-key field is functionally dependent on any other non-key field.
false - Accurate answers Problem domain modeling and database normalization are incompatible
techniques for relational database design.
true - Accurate answers One-to-many and many-to-many relationships are both represented by
foreign keys in a relational database.
true - Accurate answers Referential integrity is a consistent relational database state in which
every foreign key value also exists as a primary key value.
true - Accurate answers Every database in a DBMS consists of two separate data stores.
false - Accurate answers The domain data in a database is sometimes referred to as metadata.
false - Accurate answers A local business office with a small database which is only used by two or
three users would most probably implement a desktop DBMS.
, false - Accurate answers A phased database development and deployment (using iterative
development) is usually the safest approach to deploying the best database solution.
true - Accurate answers In an iterative approach to software development, it is usually best to
develop the database in the first few iterations.
false - Accurate answers To ensure that the database is designed correctly, an important member
of the project team is the data administrator.
true - Accurate answers Relationships between tables is usually indicated through the use of a
foreign key.
false - Accurate answers In a one-to-many association the primary key of the "many" class is placed
as a foreign key in the "one" class.
false - Accurate answers Including a total amount field as the sum of other fields in a table is a
violation of second normal form.
false - Accurate answers A write lock on a database allows other users to read the data, but they
cannot update any data.
schema - Accurate answers A(n) ____ describes the structure, content, and access controls of a
physical data store or database.
low level process management - Accurate answers Which of the following is NOT a component or
function of a typical database management system (DBMS)?
tuple - Accurate answers In a relational database, a row can be referred to as a(n) ____.
tables - Accurate answers Data elements in a relational database are organized into ____.
primary key - Accurate answers A(n) ____ is a field or set of fields used to uniquely identify each
row.
keys - Accurate answers ____ are a critical element of relational database design because they are
the bases for representing relationships among tables.
attribute - Accurate answers One column of a table in a relational database is called a(n) ____.
foreign key - Accurate answers A(n) ____ is a field or set of fields stored in one table that also
exists as a primary key in another table.
table - Accurate answers Each class on an class diagram is represented by a(n) ____ in a relational
database.
columns - Accurate answers All ____ in a table are guaranteed to be unique if the table's primary
key is guaranteed to be unique.
