Quiz
Database Design & Implementation Mid Term Study
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (158)
1The purpose of a database is to help people keep track of things.
- ATrue
- BFalse
2In a database, each table stores data about a different type of thing.
- ATrue
- BFalse
3In every database, not just the databases discussed in this book, table names are capitalized.
- ATrue
- BFalse
4A database shows data in tables as well as the relationships among the rows in those tables.
- ATrue
- BFalse
5Databases are a key component of e-commerce order entry, billing, shipping, and customer support.
- ATrue
- BFalse
6A database management system (DBMS) creates, processes and administers databases.
- ATrue
- BFalse
7The database management system (DBMS) is responsible for enforcing referential integrity constraints.
- ATrue
- BFalse
8Integrated tables store both data and the relationships among the data.
- ATrue
- BFalse
9In an enterprise-class database system, a database application interacts with the DBMS.
- ATrue
- BFalse
10A database design may be part of a new systems development project.
- ATrue
- BFalse
11Each row in a database table is also known as a record.
- ATrue
- BFalse
12XML Web services allow database processing to be shared across the Internet.
- ATrue
- BFalse
13The NoSQL movement could also be called a NoRelational movement.
- ATrue
- BFalse
14The purpose of a database is to ________.
- AA) help people keep track of things
- BB) store data in tables
- CC) create tables of rows and columns
- DD) maintain data on different things in different tables
15A database stores ________.
- AA) data
- BB) relationships
- CC) applications
- DD) Both A and B are correct
16A Customer Resource Management (CRM) system is an example of a(n) ________.
- AA) single-user database application
- BB) multiuser database application
- CC) e-commerce database application
- DD) digital dashboard
17A program whose job is to create, process and administer databases is called a ________.
- AA) database modeling system
- BB) database management system
- CC) data business model system
- DD) relational model manager
18In database systems, the DBMS enforces rules about which data can be written in certain columns. These rules are known as ________.
- AA) data insertion control
- BB) data modification control
- CC) concurrency control
- DD) referential integrity constraints
19A database is considered self-describing because ________.
- AA) all the users' data is in one place
- BB) it reduces data duplication
- CC) it contains a description of its own structure
- DD) it contains a listing of all the programs that use it
20Which of the following statements is NOT true for primary keys in a relational database system?
- AA) They can be used to create relationships between tables.
- BB) They must contain numeric data.
- CC) They uniquely identify a row in a table.
- DD) They can be part of relational integrity constraints.
21This database component can be used as part of applications and for administration tasks.
- AA) tables
- BB) metadata
- CC) triggers
- DD) stored procedures
22Database professionals use a set of principles called ________ to guide and assess database design.
- AA) database extraction
- BB) normalization
- CC) data models
- DD) entity-relationship data modeling
23A very popular development technique used by database professionals for database design is known as ________.
- AA) database extraction
- BB) normalization
- CC) data models
- DD) entity-relationship data modeling
24SQL stands for Standard Query Language.
- ATrue
- BFalse
25SQL includes a data definition language, a data manipulation language, and SQL/Persistent stored modules.
- ATrue
- BFalse
26The American National Standards Institute (ANSI) maintains the standards for SQL.
- ATrue
- BFalse
27SQL was developed by IBM in the late 1970s.
- ATrue
- BFalse
28The SQL keyword SELECT is used to specify the columns to be listed in the query results.
- ATrue
- BFalse
29The SQL keyword FROM is used to specify the table to be used.
- ATrue
- BFalse
30SQL statements end with a colon.
- ATrue
- BFalse
31To obtain all columns, use an asterisk (*) wildcard character instead of listing all the column names.
- ATrue
- BFalse
32Sorting is specified using the SORT BY phrase.
- ATrue
- BFalse
33Columns can be sorted in descending sequence by using the DESC keyword.
- ATrue
- BFalse
34When two conditions must both be true for the rows to be selected, the conditions are separated by the SQL AND keyword.
- ATrue
- BFalse
35The condition in WHERE clauses can refer to a set of values by using the IN operator.
- ATrue
- BFalse
36The SQL keyword LIKE is used in SQL expressions to select partial string values.
- ATrue
- BFalse
37The SQL wildcard character "%" represents a series of one or more unspecified characters.
- ATrue
- BFalse
38The wildcard character "#" indicates a single, unspecified character.
- ATrue
- BFalse
39The SQL built-in function MOST obtains the largest value in a numeric column.
- ATrue
- BFalse
40The SQL built-in function COUNT computes the number of rows in a query.
- ATrue
- BFalse
41A SELECT statement used in a WHERE clause is called a subquery.
- ATrue
- BFalse
42An alternative to combining tables by a subquery is to use a join.
- ATrue
- BFalse
43The names of tables to be joined in an SQL query are listed in the FROM clause.
- ATrue
- BFalse
44The JOIN operator is used to combine two or more tables by concatenating (sticking together) the rows of one table with the rows of another table.
- ATrue
- BFalse
45The SQL syntax JOIN . . . ON can be used as an alternate way of writing an SQL join statement.
- ATrue
- BFalse
46The UNION of two relations A and B consists of all rows that are either in relation A or in relation B or both.
- ATrue
- BFalse
47In an SQL query, which SQL keyword begins the query?
- AA) EXISTS
- BB) FROM
- CC) SELECT
- DD) WHERE
48In an SQL query, which SQL keyword is used to specify the table(s) to be used?
- AA) EXISTS
- BB) FROM
- CC) SELECT
- DD) WHERE
49In an SQL query, which SQL keyword must be used to remove duplicate rows from the result table?
- AA) DELETE
- BB) DISTINCT
- CC) UNIQUE
- DD) KEY
50In an SQL query, which of the following symbols is used by ANSI SQL to represent all the columns in a single table?
- AA) _ (underscore)
- BB) ? (question mark)
- CC) * (asterisk)
- DD) % (percent)
51In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?
- AA) SET
- BB) FROM
- CC) SELECT
- DD) WHERE
52In an SQL query, which SQL keyword is used to link two conditions that both must be true for the rows to be selected?
- AA) AND
- BB) EXISTS
- CC) OR
- DD) IN
53In an SQL query, which SQL keyword is used to determine if a column value is equal to any one of a set of values?
- AA) AND
- BB) EXISTS
- CC) OR
- DD) IN
54In an SQL query, which of the following symbols is used by ANSI SQL to represent a single unspecified character?
- AA) _ (underscore)
- BB) ? (question mark)
- CC) * (asterisk)
- DD) % (percent)
55In an SQL query, which SQL keyword is used to sort the result table by the values in one or more columns?
- AA) GROUP BY
- BB) ORDER BY
- CC) SELECT
- DD) SORT BY
56Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter "S" using Microsoft Access?
- AA) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S']; - BB) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S'; - CC) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S*'; - DD) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
- AA) SELECT *
57In an SQL query, which built-in function is used to total numeric columns?
- AA) AVG
- BB) COUNT
- CC) MAX
- DD) SUM
58In an SQL query, which built-in function is used to compute the average value of numeric columns?
- AA) AVG
- BB) MEAN
- CC) AVERAGE
- DD) SUM
59In an SQL query, which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column or columns?
- AA) GROUP BY
- BB) ORDER BY
- CC) SELECT
- DD) SORT BY
60Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following is not a valid ANSI SQL command?
- AA) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%'; - BB) SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000; - CC) SELECT HireDate, COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate; - DD) SELECT HireDate, COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
- AA) SELECT *
61When one SQL query is embedded in another SQL query, this is referred to as a ________.
- AA) subquery
- BB) join
- CC) WHERE Query
- DD) subset query
62In an SQL query of two tables, which SQL keyword indicates that we want data from all the rows of one table to be included in the result, even if the row does not correspond to any data in the other table?
- AA) LEFT JOIN
- BB) RIGHT JOIN
- CC) INCLUDE
- DD) Both A and B are correct
63Suppose tables EMPLOYEE and CUSTOMER both store address information, and you want to send a letter to all employees and customers of your company to make a major announcement. Which SQL keyword would you most likely use here?
- AA) INTERSECT
- BB) UNION
- CC) UNION ALL
- DD) JOIN
64Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables. If you want to find all employees who are also customers, which SQL keyword would you most likely use?
- AA) INTERSECT
- BB) UNION
- CC) EXCEPT
- DD) UNION ALL
65 A characteristic of a relation is that the cells of the relation hold a single value.
- ATrue
- BFalse
66A relation is a table composed of columns and rows.
- ATrue
- BFalse
67In relational terms as defined by E.F. Codd, a row is called a tuple.
- ATrue
- BFalse
68In relational terms as defined by E.F. Codd, a column is called an attribute.
- ATrue
- BFalse
69The columns of a relation are sometimes called tuples.
- ATrue
- BFalse
70A functional dependency is a relationship between attributes such that if we know the value of one attribute, we can determine the value of the other attribute.
- ATrue
- BFalse
71If by knowing the value of A we can find the value of B, then we would say that B is functionally dependent on A.
- ATrue
- BFalse
72Attribute Y is functionally dependent on attribute X if the value of attribute X determines the value of Y.
- ATrue
- BFalse
73The functional dependency noted as A → B means that the value of A can be determined from the value of B.
- ATrue
- BFalse
74In the functional dependency shown as A → B, B is the determinant.
- ATrue
- BFalse
75Given the functional dependency (A, B) → C, the attributes (A, B) are referred to as a composite determinant.
- ATrue
- BFalse
76Given the functional dependency (A, B) → C, then it is true that A → C and B → C.
- ATrue
- BFalse
77Given the functional dependency A → B, then it is necessarily true that B → A.
- ATrue
- BFalse
78A determinant of a functional dependency may or may not be unique in a relation.
- ATrue
- BFalse
79A key is a combination of one or more columns that is used to identify particular rows in a relation.
- ATrue
- BFalse
80A row can be uniquely identified by a key.
- ATrue
- BFalse
81A candidate key is one of a group of keys that may serve as the primary key in a relation.
- ATrue
- BFalse
82A primary key is a candidate key that has been selected to uniquely identify rows in a relation.
- ATrue
- BFalse
83A surrogate key is an artificial column that is added to a relation to be its primary key.
- ATrue
- BFalse
84A referential integrity constraint is used to make sure the values of a foreign key match a valid value of a primary key.
- ATrue
- BFalse
85Relations are classified into normal forms based on the types of modification anomalies that they are vulnerable to.
- ATrue
- BFalse
86Any table that meets the definition of a relation is said to be in first normal form (1NF).
- ATrue
- BFalse
87A relation is in 2NF if and only if it is in 1NF, and all non-key attributes are determined by the entire primary key.
- ATrue
- BFalse
88A relation is in 3NF if and only if it is in 2NF, and there are no non-key attributes determined by another non-key attribute.
- ATrue
- BFalse
89A relation is in Boyce-Codd Normal Form (BCNF) if and only if it is in 3NF and every determinant is a candidate key.
- ATrue
- BFalse
90The essence of normalization is taking a relation that is not in BCNF and breaking it into multiple relations such that each one is in BCNF.
- ATrue
- BFalse
91The multivalued dependency noted as A → → B, means that the value of A determines a set of values of B.
- ATrue
- BFalse
92Which of the following is NOT true about a relation?
- AA) Has rows containing data about an entity
- BB) Has columns containing data about attributes of the entity
- CC) Has cells that hold only a single value
- DD) Can have two identical rows
93Which of the following is true for a relation?
- AA) Entities in a column vary as to kind.
- BB) The order of the columns is important.
- CC) The order of the rows is unimportant.
- DD) More than one column can use the same name.
94A relation is also known as a(n) ________.
- AA) table
- BB) tuple
- CC) relationship
- DD) attribute
95A tuple is also known as a ________.
- AA) table
- BB) relation
- CC) row
- DD) field
96An attribute is also known as a ________.
- AA) table
- BB) relation
- CC) row
- DD) column
97Given the functional dependency A → (B, C), A is a(n) ________.
- AA) independent variable
- BB) dependent variable
- CC) determinant
- DD) composite determinant
98Given the functional dependency (A, B) → C, then ________.
- AA) A and B together → C
- BB) A → C
- CC) B → A
- DD) Both A and B are correct
99Which of the following is NOT true about the functional dependency A → (X, Y)?
- AA) X is functionally dependent on A.
- BB) A determines Y.
- CC) X and Y together determine A.
- DD) X and Y are functionally dependent on A.
100The only reason(s) for having relations is to ________.
- AA) store instances of functional dependencies
- BB) store equation components
- CC) store equation results
- DD) Both B and C are correct
101A combination of one or more columns used to identify rows in a relation is a ________.
- AA) record
- BB) field
- CC) key
- DD) tuple
102A combination of two or more columns used to identify rows in a relation is a ________.
- AA) record
- BB) composite key
- CC) foreign key
- DD) surrogate key
103A determinant that determines all the other columns in a relation is a ________.
- AA) record
- BB) surrogate key
- CC) foreign key
- DD) candidate key
104When designing a database, one of the candidate keys in a relation is selected as the ________.
- AA) composite key
- BB) primary key
- CC) foreign key
- DD) surrogate key
105An artificial column added to a relation to serve as the primary key is a ________.
- AA) composite key
- BB) candidate key
- CC) foreign key
- DD) surrogate key
106A key consisting of one or more columns that is a primary key in another relation is a ________.
- AA) composite key
- BB) candidate key
- CC) foreign key
- DD) surrogate key
107A ________ is used to limit the possible values of a foreign key.
- AA) composite key
- BB) surrogate key
- CC) functional dependency
- DD) referential integrity constraint
108If the removal of facts about one entity results in the unintentional loss of data about another entity, this is referred to as a(n) ________.
- AA) normalization anomaly
- BB) insertion anomaly
- CC) update anomaly
- DD) deletion anomaly
109A table that meets the definition of a relation is in ________.
- AA) First Normal Form
- BB) Second Normal Form
- CC) Third Normal Form
- DD) Boyce-Codd Normal Form
110A relation is in second normal form (2NF) if and only if it is in 1NF and ________.
- AA) all non-key attributes are determined by the entire primary key
- BB) there are no non-key attributes determined by another non-key attribute
- CC) every attribute is a candidate key
- DD) every candidate key is a determinant
111A relation is in third normal form (3NF) if and only if it is in 2NF and ________.
- AA) all non-key attributes are determined by the entire primary key
- BB) there are no non-key attributes determined by another non-key attribute
- CC) every attribute is a candidate key
- DD) every candidate key is a determinant
112A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and ________.
- AA) all non-key attributes are determined by the entire primary key
- BB) there are no non-key attributes determined by another non-key attribute
- CC) every attribute is a candidate key
- DD) every determinant is a candidate key
113If a table is designed so that every determinant is a candidate key, then that relation is in ________.
- AA) First Normal Form
- BB) Second Normal Form
- CC) Third Normal Form
- DD) Boyce-Codd Normal Form
114If a relation is in BCNF, and each multivalued dependency has been moved to a relation of its own, then the first relation is in ________.
- AA) Third Normal Form
- BB) Boyce-Codd Normal Form
- CC) Fourth Normal Form
- DD) Domain/key normal form
115A relation is in fourth normal form if it is in BCNF and it has no ________.
- AA) transitive dependencies
- BB) multivalued dependencies
- CC) partial dependencies
- DD) deletion dependencies
116When you are given a set of tables and asked to create a database to store their data, the first step is to assess the tables' structure and content.
- ATrue
- BFalse
117The first step in assessing table structure is to count rows and examine columns.
- ATrue
- BFalse
118To limit the number of rows retrieved from a table, use the TOP keyword.
- ATrue
- BFalse
119When examining data values as a part of assessing table structure, you should determine two types of dependencies: functional dependencies and multivalued dependencies.
- ATrue
- BFalse
120When examining data values as a part of assessing table structure, determine three types of keys: the primary key, any candidate keys, and any foreign keys.
- ATrue
- BFalse
121The second step in assessing table structure is to examine data values and determine dependencies and keys.
- ATrue
- BFalse
122When examining data values as a part of assessing table structure, determine multivalued dependencies.
- ATrue
- BFalse
123When examining data values as a part of assessing table structure, determine the table's primary key.
- ATrue
- BFalse
124When examining data values as a part of assessing table structure, there is no need to determine candidate keys other than the table's primary key.
- ATrue
- BFalse
125The third step in assessing table structure is to check the validity of presumed referential integrity constraints.
- ATrue
- BFalse
126The elimination of modification anomalies and the reduction of duplicated data are advantages of normalization.
- ATrue
- BFalse
127The presence of one or more foreign keys in a relation means that we cannot eliminate duplicated data in that table.
- ATrue
- BFalse
128Normalization requires applications to use more complex SQL since they will need to write subqueries and joins to recombine data stored in separate relations.
- ATrue
- BFalse
129Relations in BCNF have no modification anomalies regarding functional dependencies.
- ATrue
- BFalse
130The INSERT statement can be used to populate normalized tables.
- ATrue
- BFalse
131The DELETE TABLE statement can be used to remove unneeded tables after the normalized tables are created and populated.
- ATrue
- BFalse
132Multivalued dependencies create anomalies that must always be eliminated.
- ATrue
- BFalse
133Read-only databases are often updated.
- ATrue
- BFalse
134Normalization is an advantage for a read-only database.
- ATrue
- BFalse
135Denormalization reduces the complexity of the SQL statements needed in an application to read required data.
- ATrue
- BFalse
136Multivalued dependencies show up under a different name as the multivalued, multicolumn problem.
- ATrue
- BFalse
137A missing value is called a null value.
- ATrue
- BFalse
138A null value in a column may indicate that there is an appropriate value for that attribute, but it is unknown.
- ATrue
- BFalse
139General-purpose remarks columns rarely contain important data.
- ATrue
- BFalse
140When you are given a set of tables and asked to create a database to store their data, the first step is to ________.
- AA) assess the existing tables' structure and content
- BB) design the database structure
- CC) create one or more new tables
- DD) move the data into the new database
141The second step in assessing table structure includes ________.
- AA) counting rows
- BB) examining columns
- CC) examining data values
- DD) A and B
142During the second step of assessing table structure, you are trying to determine ________.
- AA) multivalued dependencies
- BB) data types
- CC) missing values
- DD) subqueries
143During the second step of assessing table structure, you are trying to determine ________.
- AA) relationships
- BB) candidate keys
- CC) updatability
- DD) efficiency
144To count the number of rows in a table, use the SQL construct ________.
- AA) SELECT *
- BB) SELECT TOP n *
- CC) SELECT COUNT(TOP n)
- DD) SELECT COUNT(*)
145To limit the number of rows retrieved from a table, use ________.
- AA) SELECT *
- BB) SELECT TOP n *
- CC) SELECT COUNT(TOP n)
- DD) SELECT COUNT(*)
146The TOP keyword ________.
- AA) limits the number of columns retrieved from a table
- BB) limits the number of rows retrieved from a table
- CC) limits the number of tables retrieved from a database
- DD) A and C
147The advantages of normalization include ________.
- AA) the elimination of modification anomalies
- BB) the elimination of duplicated data
- CC) more complex SQL for multitable subqueries and joins
- DD) simpler SQL queries
148Practical problems in designing databases from existing data include all of the following except ____________.
- AA) The multivalue, multicolumn problem
- BB) functional dependencies
- CC) Inconsistent values
- DD) Missing values
149Unlike the anomalies from functional dependencies, the anomalies from ________ are so serious that they should always be eliminated.
- AA) general purpose remarks columns
- BB) sales orders and line items
- CC) association patterns
- DD) multivalued dependencies
150Read-only databases are used for ________.
- AA) updating
- BB) querying
- CC) data entry
- DD) user account management
151For a number of reasons, ________ is not often an advantage for a read-only database.
- AA) updating
- BB) normalization
- CC) denormalization
- DD) Both A and B are correct
152________ is the process of joining two or more tables and storing the result as a single table.
- AA) Querying
- BB) Normalization
- CC) Denormalization
- DD) Updating
153An advantage of denormalization is ________.
- AA) faster updating
- BB) faster querying
- CC) faster copying of data
- DD) faster design
154When a table is created using existing data from multiple sources, you are likely to find that the different sources code data in slightly different ways. This is an example of ________.
- AA) the multivalued, multicolumn problem
- BB) the inconsistent values problem
- CC) the missing values problem
- DD) the general-purpose remarks column problem
155A missing value is called a(n) ________.
- AA) empty value
- BB) null value
- CC) missing value
- DD) deleted value
156A null value can indicate which of the following conditions?
- AA) The value is incorrect.
- BB) The value is appropriate but unknown.
- CC) The value has been updated.
- DD) The value can never be changed.
157To check for null values in a column in a table, use the ________ phrase.
- AA) IS
- BB) IS NOT
- CC) IS NULL
- DD) COUNT(NULL)
158You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity constraint:
SALE.CustomerNumber must exist in CUSTOMER.CustomerNumber
You run the following SQL query:
SELECT CustomerNumber
FROM SALE
WHERE CustomerNumber NOT IN
(SELECT CustomerNumber
FROM CUSTOMER);
What is shown in the results of this query?- AA) All values of CustomerNumber that match the constraint.
- BB) All values of CustomerNumber that violate the constraint.
- CC) All values of CustomerNumber where
SALE.CustomerNumber = CUSTOMER.CustomerNumber. - DD) All values of Customer number that are in CUSTOMER but not in SALE.
Information
- Description
- Quiz on Database Design & Implementation Mid Term Study, created by TouChee Moua on 08/10/2021.
- Author
- TouChee Moua
- Language
- English
- Views
- 13
- Rating
- No ratings yet Rate this quiz