CIS4365: Database Applications
Fall, 2017

Relational DBMS On-line Quiz

Make Sure you submit this form by the due date (Check the Course Schedule).

You Can submit either a Short/answer Problem Question (with the Answer) or a Multiple Choice Question (with the Answer).

The easiest way to do this is probably to 'Cut-and-Paste'. Prepare your answers using a word processor or Text editor and then Copy the answers and paste it in the space provided.

Enter Your PSEUDONYM:          

Question 1:    An RDBMS is:

                       
 an approach intended to readily deal with M:M relationships
                          an approach which logically views data as a collection of tables
                          an approach which is based on relational algebra
                          A and B
                          B and C

Question 2:   A table consists of __.

                       
 records and relationships
                          records and fields
                          records and pointers
                          records and identifiers
                          records and descriptors

IQuestion 3:   A relationship is a(n) __.
"

                       
 logical association
                          physical association between two tables
                          semantic association between two fields
                          named two dimensional table of data
                          hierarchical structure of associations

Question 4:    Which of the following is NOT a restriction/convention in RDBMS?

                       
 Each field name in the database must be unique
                          Each relation must have a unique name
                          Each column in the table must have the same data type
                          Each column in the table must be of the same length
                          Each column name in a table must be unique

Question 5:    A primary key is __.

                       
 an attribute that uniquely identifies each row in a relation
                          an attribute in a row that is identified by other attributes
                          an attribute that is related to attributes in another relation
                          an attribute that is functionally dependent on other keys
                          an attribute that is used in conjunction with other keys to form an identifier.

Question 6:    A foreign key is __.

                       
 an attribute that uniquely identifies each row in a relation
                          an attribute in a row that is identified by other attributes
                          an attribute that is related to attributes in another relation
                          an attribute that is functionally dependent on other keys
                          an attribute that is used in conjunction with other keys to form an identifier.

Question 7:    Functional dependence implies:

                       
 One attribute can be determined by another
                          One attributes functions only if another attribute is present
                          One attribute can not exist without the other
                          No two records can be related to the same attribute
                          No two attributes can be related to another attribute

Question 8:   A candidate key is:

                       
 a single attribute that could become a primary key
                          a composite key that could become a primary key
                          a foreign key that could become a primary key
                          A and B
                          ALL of the above

Question 9:   Entity integrity insures that:

                       
 Null values can not be entered.
                          All entries must be unique
                          Foreign keys are includede
                          All entries have composite keys
                          Non-key attributes are excluded

Question 10In order for an RDBMS to be relationally complete, it must:

                       
 Support entity and referential integrity
                          Support all relational algebra functions
                          Support only SELECT, PROJECT and JOIN functions
                          A and B
                          A and C

 

Note: The Date and Time Submitted will be saved on the form

 

This page was last updated on 08/20/03.