Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/23

Click to flip

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