Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
89 Cards in this Set
- Front
- Back
|
1) When 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. |
Answer: TRUE
|
|
|
2) The first step in assessing table structure is to count rows and examine columns.
|
Answer: TRUE |
|
|
3) To count the number of rows in a table, use the SQL construct COUNT(ROWS). |
Answer: FALSE |
|
|
4) To determine the number and type of columns in a table, use the SQL construct COUNT(*).
|
Answer: FALSE
|
|
|
5) To limit the number of rows retrieved from a table, use the SQL TOP keyword.
|
Answer: TRUE
|
|
|
6) When examining data values as a part of assessing table structure, you should try to determine two types of dependencies: functional dependencies and functional dependencies.
|
Answer: TRUE
|
|
|
7) When examining data values as a part of assessing table structure, you should try to determine three types of keys: the primary key, any candidate keys and any foreign keys.
|
Answer: TRUE
|
|
|
8) The second step in assessing table structure is to examine data values and determine dependencies and keys.
|
Answer: TRUE
|
|
|
9) When examining data values as a part of assessing table structure, you should try to determine functional dependencies.
|
Answer: TRUE
|
|
|
10) When examining data values as a part of assessing table structure, you should try to determine multivalued dependencies.
|
Answer: TRUE
|
|
|
11) When examining data values as a part of assessing table structure, you should try to determine the table's primary key.
|
Answer: TRUE
|
|
|
12) When examining data values as a part of assessing table structure, there is no need to try to determine candidate keys other than the table's primary key.
|
Answer: FALSE
|
|
|
13) When examining data values as a part of assessing table structure, there is no need to try to determine foreign keys.
|
Answer: FALSE
|
|
|
14) The third step in assessing table structure is to check the validity of presumed referential integrity constraints.
|
Answer: TRUE
|
|
|
15) The elimination of modification anomalies and the reduction of duplicated data are advantages of normalization.
|
Answer: TRUE
|
|
|
16) Database design varies depending on whether you're building an updatable database or a read-only database.
|
Answer: TRUE
|
|
|
17) Normalization eliminates modification anomalies and data duplication.
|
Answer: FALSE
|
|
|
18) The presence of one or more foreign keys in a relation means that we cannot eliminate duplicated data in that table.
|
Answer: TRUE
|
|
|
19) Normalization requires applications to use more complex SQL since they will need to write subqueries and joins to recombine data stored in separate relations.
|
Answer: TRUE
|
|
|
20) Relations are sometimes left unnormalized to improve performance.
|
Answer: TRUE
|
|
|
21) Relations in BCNF have no modification anomalies in regard to functional dependencies.
|
Answer: TRUE
|
|
|
22) A defining requirement for BCNF is that every determinant must be a candidate key.
|
Answer: TRUE
|
|
|
23) The SQL INSERT statement can be used to populate normalized tables.
|
Answer: TRUE
|
|
|
24) The SQL DELETE TABLE statement can be used to remove unneeded tables after the normalized tables are created and populated.
|
Answer: FALSE
|
|
|
25) SQL statements that can be used to create referential integrity statements for normalized tables are created during the normalization process.
|
Answer: TRUE
|
|
|
26) The standard sales order/line item pattern is a classic example of unneeded normalization.
|
Answer: FALSE
|
|
|
27) Multivalued dependencies create anomalies so serious that multivalued dependencies must always be eliminated.
|
Answer: TRUE
|
|
|
28) Writing SQL subqueries and joins against normalized tables is simple compared to the code that must be written to handle anomalies from multivalued dependencies.
|
Answer: TRUE
|
|
|
29) To eliminate multivalued dependencies, normalize your tables so that they are all in BCNF.
|
Answer: FALSE
|
|
|
30) Creating a read-only database is a job often given to beginning database professionals.
|
Answer: TRUE
|
|
|
31) Read-only databases are often updated.
|
Answer: FALSE
|
|
|
32) Design guidelines and priorities are the same whether you're working with an updatable database or a read-only database.
|
Answer: FALSE
|
|
|
33) Normalization is an advantage for a read-only database.
|
Answer: FALSE
|
|
|
34) Denormalization is the process of joining previously normalized tables back together.
|
Answer: TRUE
|
|
|
35) Denormalization reduces the complexity of the SQL statements needed in an application to read required data.
|
Answer: TRUE
|
|
|
36) Denormalization is simple—join the data together and store it in a table.
|
Answer: TRUE
|
|
|
37) Read-only databases seldom use more than one copy of a set of same data.
|
Answer: FALSE
|
|
|
38) Read-only databases often use several copies of a set of the same data, where each copy is modified for a specific use.
|
Answer: TRUE
|
|
|
39) Multivalued dependencies show up under a different name as the multivalued, multicolumn problem.
|
Answer: TRUE
|
|
|
40) The multivalued, multicolumn problem occurs when a set of columns are used to store data that should actually be in one column.
|
Answer: TRUE
|
|
|
41) One situation created by the multivalued, multicolumn problem is that the maximum number of data values for an attribute is limited.
|
Answer: TRUE
|
|
|
42) If you have a table with a set of columns named "Child01", "Child02" and "Child03", the table has the multivalued, multicolumn problem.
|
Answer: TRUE
|
|
|
43) When you are creating a database from existing data, you will have only minor problems with inconsistent values.
|
Answer: FALSE
|
|
|
44) An inconsistent values problem is created when different users have coded the same data entries differently.
|
Answer: TRUE
|
|
|
45) The problem of misspelled data entries is an entirely different problem than the inconsistent values problem.
|
Answer: FALSE
|
|
|
46) You are creating a BOAT table using existing data from multiple sources, and you find that you have "power boat blue", "boat, power, blue" and "blue power boat" as data values for the same column. This is an example of the inconsistent values problem.
|
Answer: TRUE
|
|
|
47) A missing value is called a null value.
|
Answer: TRUE
|
|
|
48) Null values are a problem because they are ambiguous.
|
Answer: TRUE
|
|
|
49) A null value in a column may indicate that there is no appropriate value for that attribute.
|
Answer: TRUE
|
|
|
50) A null value in a column may indicate that there is an appropriate value for that attribute, but it is unknown.
|
Answer: TRUE
|
|
|
51) A null value in a column may indicate that there is an appropriate value for that attribute, and although the value is known no one has entered the value into the database.
|
Answer: TRUE
|
|
|
52) Most DBMS products will let you define a primary key on a column that contains null values.
|
Answer: FALSE
|
|
|
53) The SQL IS NULL keyword can be used to count the number of nulls in a column.
|
Answer: TRUE
|
|
|
54) General-purpose remarks columns rarely contain important data.
|
Answer: FALSE
|
|
|
55) The problem with a general-purpose remarks column is that the data it contains are likely to be verbal, inconsistent and stored in a verbose manner.
|
Answer: TRUE
|
|
|
56) If you see a column name Notes, it is likely that this is a general-purpose remarks column.
|
Answer: TRUE
|
|
|
57) When you are given a set of tables and asked to create a database to store their data, the first step is to ________.
A) assess the existing tables' structure and content B) design the database structure C) create one or more new tables D) move the data into the new database E) design the applications that will use the database |
Answer: A
|
|
|
58) The first step in assessing table structure includes ________.
A) counting rows B) examining columns C) examining data values D) A and B E) B and C |
Answer: D
|
|
|
59) The second step in assessing table structure includes ________.
A) counting rows B) examining columns C) examining data values D) A and B E) B and C |
Answer: C
|
|
|
60) During the second step of assessing table structure, you are trying to determine ________.
A) multivalued dependencies B) functional dependencies C) foreign keys D) A and B E) A, B, and C |
Answer: E
|
|
|
61) During the second step of assessing table structure, you are trying to determine ________.
A) primary keys B) candidate keys C) foreign keys D) A and B E) A, B, and C |
Answer: E
|
|
|
62) To count the number of rows in a table, use the SQL construct ________.
A) SELECT * B) SELECT TOP n * C) SELECT COUNT(TOP n) D) SELECT COUNT(*) E) SELECT COUNT * |
Answer: D
|
|
|
63) The SQL function COUNT ________.
A) counts the number of columns in a table B) counts the number of rows in a table C) counts the number of tables in a database D) A and C E) B and C |
Answer: B
|
|
|
64) To limit the number of rows retrieved from a table, use the SQL construct ________.
A) SELECT * B) SELECT TOP n * C) SELECT COUNT(TOP n) D) SELECT COUNT(*) E) SELECT COUNT * |
Answer: B
|
|
|
65) The SQL keyword TOP ________.
A) limits the number of columns retrieved from a table B) limits the number of rows retrieved from a table C) limits the number of tables retrieved from a database D) A and C E) B and C |
Answer: B
|
|
|
67) The advantages of normalization include ________. A) the elimination of modification anomalies B) the elimination of duplicated data C) more complex SQL for multitable subqueries and joins D) A and B E) A, B, and C |
Answer: A
|
|
|
68) The disadvantages of normalization include ________.
A) the elimination of modification anomalies B) the elimination of duplicated data C) more complex SQL for multitable subqueries and joins D) A and B E) A, B, and C |
Answer: C
|
|
|
69) The presence of one or more foreign keys in a relation prevents ________.
A) the elimination of modification anomalies B) the elimination of duplicated data C) more complex SQL for multitable subqueries and joins D) A and B E) A, B, and C |
Answer: B
|
|
|
70) Anomalies caused by functional dependencies can be eliminated by putting tables into ________.
A) 1NF B) 2NF C) 3NF D) BCNF E) 4NF |
Answer: D
|
|
|
71) The defining characteristic of BCNF is that a table is in BCNF if ________.
A) all rows are unique B) all columns are consistent C) the primary key is a candidate key D) all determinants are candidate keys E) all candidate keys are determinants |
Answer: D
|
|
|
72) A classic example of unneeded normalization is when we are dealing with ________.
A) ZIP codes B) sales orders and line items C) association patterns D) multivalued dependencies E) general purpose remarks columns |
Answer: A
|
|
|
73) Unlike the anomalies from functional dependencies, the anomalies from ________ are so serious that they should always be eliminated.
A) ZIP codes B) sales orders and line items C) association patterns D) multivalued dependencies E) general purpose remarks columns |
Answer: D
|
|
|
74) Read-only databases are used for ________.
A) updating B) querying C) reporting D) A and B E) B and C |
Answer: E
|
|
|
75) For a number of reasons, ________ is not often an advantage for a read-only database.
A) updating B) normalization C) denormalization D) A and B E) B and C |
Answer: B
|
|
|
76) ________ is the process of joining two or more tables and storing the result as a single table.
A) Querying B) Normalization C) Denormalization D) A and B E) B and C |
Answer: C
|
|
|
77) An advantage of denormalization is ________.
A) faster updating B) faster querying C) less complex SQL in application code D) A and B E) B and C |
Answer: E
|
|
|
78) A table designed to store PhoneNumber01, PhoneNumber02 and PhoneNumber03 contains ________.
A) the multivalued, multicolumn problem B) the inconsistent values problem C) the missing values problem D) the general-purpose remarks column problem E) None of the above is correct. |
Answer: A
|
|
|
79) A form of multivalued dependency is found in ________.
A) the multivalued, multicolumn problem B) the inconsistent values problem C) the missing values problem D) the general-purpose remarks column problem E) None of the above is correct. |
Answer: A
|
|
|
80) When 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 ________.
A) the multivalued, multicolumn problem B) the inconsistent values problem C) the missing values problem D) the general-purpose remarks column problem E) None of the above is correct. |
Answer: B
|
|
|
81) You are creating a PRODUCT table using existing data from multiple sources. Examining the data, you find that you have "large red hat", "large hat, red", "red hat large" and "hat, large, red." This is an example of ________.
A) the multivalue, multicolumn problem B) the inconsistent values problem C) the missing values problem D) the general-purpose remarks column problem E) None of the above is correct. |
Answer: B
|
|
|
82) The problem of misspelled data entries is really the same as ________.
A) the multivalue, multicolumn problem B) the inconsistent values problem C) the missing values problem D) the general-purpose remarks column problem E) None of the above is correct. |
Answer: B
|
|
|
83) When a table is created using existing data from multiple sources, you are likely to find that some data values have never been provided. This is an example of ________. A) the multivalued, multicolumn problem B) the inconsistent values problem C) the missing values problem D) the general-purpose remarks column problem E) None of the above is correct. |
Answer: C
|
|
|
84) When a table is created using existing data from multiple sources, you are likely to find that some data values have never been provided. This is an example of ________.
A) the multivalued, multicolumn problem B) the inconsistent values problem C) the missing values problem D) the general-purpose remarks column problem E) None of the above is correct. |
Answer: C
|
|
|
85) Reviewing the work done on a table that was created using existing data from multiple sources, you are likely to find that some data values that were provided were never entered into the table. This is an example of ________.
A) the multivalued, multicolumn problem B) the inconsistent values problem C) the missing values problem D) the general-purpose remarks column problem E) None of the above is correct. |
Answer: C
|
|
|
86) A missing value is called a(n) ________.
A) empty value B) null value C) missing value D) Any of A, B, or C can be used. E) None of the above is correct. |
Answer: B
|
|
|
87) A null value can indicate which of the following conditions?
A) The value is inappropriate. B) The value is appropriate but unknown. C) The value is appropriate and known, but not entered into the database. D) A, B, and C E) None of the above is correct. |
Answer: D
|
|
|
88) To check for null values in a column in a table, use the SQL phrase ________.
A) IS B) IS NOT C) IS NULL D) COUNT(IS NOT) E) COUNT(IS NULL) |
Answer: C
|
|
|
89) The SQL keyword IS NULL can be used to ________.
A) count the number of columns in a table B) count the number of rows in a table C) count the number of null values in a column D) A and C E) B and C |
Answer: C
|
|
|
90) Reviewing the work done on a table that was created using existing data from multiple sources, you find that a column name Remarks has been included, and it is populated with inconsistent and verbose verbal data. This is an example of ________.
A) the multivalued, multicolumn problem B) the inconsistent values problem C) the missing values problem D) the general-purpose remarks column problem E) None of the above is correct. |
Answer: D |
