COP 4703 Midterm Exam Rated A+
1. A relational database handles entities, attributes, and relationships by storing each
entity in its own table. - ANSWER-TRUE
1. A table that is in first normal form is better than one that is in second normal form. -
ANSWER-False,
a table in 2NF will be better than a table in 1NF
1. Redundancy wastes space because you are storing different types of data in the
same place. - ANSWER-False.
Redundancy is data stored in different places not in the same place.
1. SQL uses commands to create tables, update tables, and retrieve data from tables. -
ANSWER-TRUE
1. The information-level design methodology involves representing the individual user
view as a collection of tables, refining them to eliminate any problems, and then
merging them into a cumulative design. - ANSWER-true
1. Views cannot be used to examine table data. - ANSWER-False
10. Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the
database directly, rather than having to access it through the DBMS. - ANSWER-False
Only the DBMS actually access the database
10. QBE is a visual approach to writing queries. - ANSWER-TRUE
10. Tables that are in second normal form do not contain problems. - ANSWER-False,
tables in 2NF may still have determinants that are not candidate keys.
10. The following command will enable Jones to retrieve data from the Customer table,
but not to take any other action: GRANT SELECT ON Customer Jones ; - ANSWER-
FALSE
Correct command is GRANT SELECT ON Customer TO Jones;)
10. When you connect simple conditions using the AND operator, all the simple
conditions must be false for the compound condition to be true. - ANSWER-False,
all the simple conditions must be true .
10. You create a many-to-many relationship by creating a new table whose primary key
is the combination of the primary keys of the original tables. - ANSWER-true
,11. Access automatically adds double quotation marks around values in the design grid
that are formatted as Short Text fields when you run the query or move the insertion
point to another cell in the design grid. - ANSWER-TRUE
11. Preceding a condition by the NOT operator reverses the truth or falsity of the
original condition. - ANSWER-TRUE
11. Referential integrity is specified using the FOREIGN KEY clause in the SELECT
command. - ANSWER-False
either the CREATE TABLE or ALTER TABLE command)
11. The most recent definition of third normal form is referred to as the Boyce-Codd
normal form. - ANSWER-true
11. There are two types of primary keys that you can use in your database design. -
ANSWER-False
There are three types of primary keys that you can use in your database design
11. To create forms to use with a database you must write a program. - ANSWER-
FALSE
12. A foreign key is a column or collection of columns in one table that is required to
match the value of the primary key for some row in another table, or be null. -
ANSWER-true
12. Legal-values integrity is the property that states that no record can exist in the
database with a value in the field other than one of the legal values. - ANSWER-TRUE
12. Sharing data is one advantage of database processing. - ANSWER-TRUE
12. The BETWEEN operator is an essential feature of SQL. - ANSWER-False,
the between operator is not an essential feature
12. The comparison operators are +, *, %, and /. - ANSWER-FALSE
The comparison operators are =,>,<,>=,<=, and NOT.
12. The primary key in a table will be a determinant. - ANSWER-True,
the primary key determines all other columns in the table.
13. An advantage of using the database approach to processing is that it facilitates
consistency. - ANSWER-TRUE
13. Converting to third normal form always avoids the problems related to
dependencies. - ANSWER-False,
a table in 3NF may still hold multivalued dependencies.
, 13. In DBDL, you represent a table by listing all columns and then underlining the
primary key. - ANSWER-true
13. Information about tables in the database is kept in the system catalog. - ANSWER-
TRUE
13. The comparison operators are also known as relational operators. - ANSWER-
TRUE
13. You can combine values in character fields - ANSWER-TRUE
14. A DBA can assign passwords to prevent unauthorized users from accessing the
data. - ANSWER-TRUE
14. A stored procedure is placed on a client computer. - ANSWER-FALSE
14. In an AND criterion, the overall criterion is true if either of the individual criteria is
true. - ANSWER-FALSE
In an AND criterion, both criteria must be true for the compound criterion to be true
14. In an entity-relationship diagram, rectangles represent foreign keys. - ANSWER-
False
in an E-R diagram, rectangles represent the entities (tables)
14. The IN operator provides a concise way of phrasing certain conditions. - ANSWER-
TRUE
14. The normalization process used to convert a relation or collection of relations to an
equivalent collection of third normal form tables is a crucial part of the database design
process. - ANSWER-True,
the normalization process enables you to find the existence of update anomalies in the
design of a database.
15. Access supports stored procedures - ANSWER-FALSE
15. By splitting relations to achieve third normal form tables, you create the need to
express interrelation constraints. - ANSWER-True,
these constraints make sure that certain values in one table cannot be inputed if they
do not meet the values in a second table. These are handled with foreign keys.
15. The concept of grouping means that statistics will be calculated for individual
records. - ANSWER-False
grouping means creating groups of records that share some common
characteristic.
1. A relational database handles entities, attributes, and relationships by storing each
entity in its own table. - ANSWER-TRUE
1. A table that is in first normal form is better than one that is in second normal form. -
ANSWER-False,
a table in 2NF will be better than a table in 1NF
1. Redundancy wastes space because you are storing different types of data in the
same place. - ANSWER-False.
Redundancy is data stored in different places not in the same place.
1. SQL uses commands to create tables, update tables, and retrieve data from tables. -
ANSWER-TRUE
1. The information-level design methodology involves representing the individual user
view as a collection of tables, refining them to eliminate any problems, and then
merging them into a cumulative design. - ANSWER-true
1. Views cannot be used to examine table data. - ANSWER-False
10. Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the
database directly, rather than having to access it through the DBMS. - ANSWER-False
Only the DBMS actually access the database
10. QBE is a visual approach to writing queries. - ANSWER-TRUE
10. Tables that are in second normal form do not contain problems. - ANSWER-False,
tables in 2NF may still have determinants that are not candidate keys.
10. The following command will enable Jones to retrieve data from the Customer table,
but not to take any other action: GRANT SELECT ON Customer Jones ; - ANSWER-
FALSE
Correct command is GRANT SELECT ON Customer TO Jones;)
10. When you connect simple conditions using the AND operator, all the simple
conditions must be false for the compound condition to be true. - ANSWER-False,
all the simple conditions must be true .
10. You create a many-to-many relationship by creating a new table whose primary key
is the combination of the primary keys of the original tables. - ANSWER-true
,11. Access automatically adds double quotation marks around values in the design grid
that are formatted as Short Text fields when you run the query or move the insertion
point to another cell in the design grid. - ANSWER-TRUE
11. Preceding a condition by the NOT operator reverses the truth or falsity of the
original condition. - ANSWER-TRUE
11. Referential integrity is specified using the FOREIGN KEY clause in the SELECT
command. - ANSWER-False
either the CREATE TABLE or ALTER TABLE command)
11. The most recent definition of third normal form is referred to as the Boyce-Codd
normal form. - ANSWER-true
11. There are two types of primary keys that you can use in your database design. -
ANSWER-False
There are three types of primary keys that you can use in your database design
11. To create forms to use with a database you must write a program. - ANSWER-
FALSE
12. A foreign key is a column or collection of columns in one table that is required to
match the value of the primary key for some row in another table, or be null. -
ANSWER-true
12. Legal-values integrity is the property that states that no record can exist in the
database with a value in the field other than one of the legal values. - ANSWER-TRUE
12. Sharing data is one advantage of database processing. - ANSWER-TRUE
12. The BETWEEN operator is an essential feature of SQL. - ANSWER-False,
the between operator is not an essential feature
12. The comparison operators are +, *, %, and /. - ANSWER-FALSE
The comparison operators are =,>,<,>=,<=, and NOT.
12. The primary key in a table will be a determinant. - ANSWER-True,
the primary key determines all other columns in the table.
13. An advantage of using the database approach to processing is that it facilitates
consistency. - ANSWER-TRUE
13. Converting to third normal form always avoids the problems related to
dependencies. - ANSWER-False,
a table in 3NF may still hold multivalued dependencies.
, 13. In DBDL, you represent a table by listing all columns and then underlining the
primary key. - ANSWER-true
13. Information about tables in the database is kept in the system catalog. - ANSWER-
TRUE
13. The comparison operators are also known as relational operators. - ANSWER-
TRUE
13. You can combine values in character fields - ANSWER-TRUE
14. A DBA can assign passwords to prevent unauthorized users from accessing the
data. - ANSWER-TRUE
14. A stored procedure is placed on a client computer. - ANSWER-FALSE
14. In an AND criterion, the overall criterion is true if either of the individual criteria is
true. - ANSWER-FALSE
In an AND criterion, both criteria must be true for the compound criterion to be true
14. In an entity-relationship diagram, rectangles represent foreign keys. - ANSWER-
False
in an E-R diagram, rectangles represent the entities (tables)
14. The IN operator provides a concise way of phrasing certain conditions. - ANSWER-
TRUE
14. The normalization process used to convert a relation or collection of relations to an
equivalent collection of third normal form tables is a crucial part of the database design
process. - ANSWER-True,
the normalization process enables you to find the existence of update anomalies in the
design of a database.
15. Access supports stored procedures - ANSWER-FALSE
15. By splitting relations to achieve third normal form tables, you create the need to
express interrelation constraints. - ANSWER-True,
these constraints make sure that certain values in one table cannot be inputed if they
do not meet the values in a second table. These are handled with foreign keys.
15. The concept of grouping means that statistics will be calculated for individual
records. - ANSWER-False
grouping means creating groups of records that share some common
characteristic.
