CIS 336 Entire Course: Devry University
For more course tutorials visit
www.cis336.com
CIS 336 Entire Course: Devry University
.......................................................................................................................................................................
CIS 336 Final Exam 1
For more course tutorials visit
www.cis336.com
1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4)
elemental
linked
hierarchical
relational
2. (TCO 1) Data constitutes the building blocks of _____________. (Points : 4)
information
processing
applications
programming
3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4)
referential
restrictive
secondary
redundant
4. (TCO 2) In a "one-to-many" relationship, which constraint is usually added to the "many" table?
(Points : 4)
UNIQUE
PRIMARY KEY
FOREIGN KEY
NOT NULL
5. (TCO 3) A ____ occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world. (Points : 4)
surrogate primary keys
time-variant data
design trap
fan trap
.......................................................................................................................................................................
CIS 336 Quiz 1
For more course tutorials visit
www.cis336.com
(TCO 9) The SQL command that lets you insert data into a table, one row at a time, is _____________.
(TCO 4) Which command is used to restore the table's contents to their default values?
(TCO 4) Which of the following SQL commands would alter the table DEVRY and add a foreign key that references the CITY table?
(TCO 4) The SQL command that lets you save your work to disk, is ___________
(TCO 9) If the INSERT INTO command is used to insert data values...