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;
23 Cards in this Set
- Front
- Back
In a real sense, information systems and organizations do not just influence each other, but rather they create each other. (T/F)
|
True
|
|
In the database redesign process, it is often useful to test whether certain conditions or assumptions are valid before proceeding with the redesign. (T/F)
|
True
|
|
In a correlated subquery, the DBMS can run the lower SELECT statement by itself and then send the results to the upper SELECT statement. (T/F)
|
False
|
|
The EXISTS keyword will be true if any row in the subquery meets the condition. (T/F)
|
True
|
|
The process of reading an actual database schema and producing a data model from that schema is called reverse engineering. (T/F)
|
True
|
|
A means must be created to recover all test databases to their original state during the redesign testing process. (T/F)
|
True
|
|
If a DEFAULT constraint is included when a new column is added to a table, the default value is only applied to new rows and not to the existing rows at the time the new column is added. (T/F)
|
True
|
|
When increasing cardinalities from 1:N to N:M, we basically create a new intersection table, fill it with data and drop the old foreign key. (T/F)
|
True
|
|
Deleting tables and relationships is basically a matter of dropping foreign key constraints and then dropping the tables. (T/F)
|
True
|
|
The process of reading an actual database schema and producing a data model from that schema is called _____.
a) data modeling b) data engineering c) reverse engineering d) schema modeling e) schema engineering |
c) reverse engineering
|
|
To add a NULL column to a table, we ______.
a) use the REVISE TABLE command b) use the ALTER TABLE command c) use the MODIFY TABLE command d) create a new table with the NULL column, move the other data, and drop the old table e) none of the above is the correct way to add a NULL column |
b) use the ALTER TABLE command
|
|
To add a NOT NULL column to a table, we ______.
a) use the REVISE TABLE command b) use the ALTER TABLE command c) use the MODIFY TABLE d) create a new NULL column, insert data values into every row, and change the NULL constraint to NOT NULL e) none of the above is the correct way to add a NOT NULL column to the table |
d) create a new NULL column, insert data values into every row, and change the NULL constraint to NOT NULL
|
|
When changing the minimum cardinality on the parent side of the relationship from zero to one, the foreign key ______.
a) must be changed from NULL to NOT NULL b) must be changed from NOT NULL to NULL c) must be changed to a composite key d) must be changed to a surrogate key e) does not change |
a) must be changed from NULL to NOT NULL
|
|
When decreasing cardinalitites, there will always be ____.
a) relationship loss b) foreign key loss c) data loss d) a and b e) a,b and c |
c) data loss
|
|
In the database redesign process, before proceeding with the redesign it is often useful to ______.
a) check whether certain conditions or assumptions about the data are valid b) find out why the design was not done properly the first time c) stop information systems and users from influencing each other d) set standards for user behavior e) all of the above |
a) check whether certain conditions or assumptions about the data are valid
|
|
In the SQL statments
SELECT C1.CustName, C1.SalesRepNo FROM CUSTOMER C1; the "C1" is called a(n) ________. a) term b) alias c) convention d) phrase e) label |
b) alias
|
|
When running a correlated subquery, the DBMS always uses _________.
a) regular processing b) nested processing c) "quick and dirty" processing d) SQL-92 processing e) a form of processing that is specific to the DBMS product |
b) nested processing
|
|
The EXISTS keyword will be true if ___ row in the subquery _____ the condition.
|
any, meets
|
|
Because of the need to know the functional dependencies in a database, it is a good idea to create a(n) _______.
|
dependency graph
|
|
There is _____ SQL-92 command that can be used to change table names.
|
no
|
|
To drop a primary key column from a table, the primary key constraint must first be dropped, which requires that ______ also be dropped.
|
related foreign
|
|
When decreasing cardinalities, there will always be _____.
|
data loss
|
|
In a real sense, information systems and organizations do not just influence each other, but rather they ______ each other.
|
create
|