Database Reference
In-Depth Information
REVIEW QUESTION
Short Answer type Questions
1. Every relation in a database must have a unique name (True / False)
2. Every column in a relation must have a unique name within the relation (True / False)
3. A primary key is used to uniquely identify a record in a table.
4. Table-level integrity also known as entity integrity.
5. Referential Integrity support cascade operations
6. The tables used to compose a view, are called
……………..
7. RDBMS stands for
……………..
8. CCK stands for
……………..
9. CAK stands for
……………..
10.
……………..
operator can be considered a 'horizontal slicer'.
11.
……………..
operator is a 'vertical slicer'
12. Examples of an entity are
a. A customer
c. A customer order
d. An employee's paycheck
e. A customer's name
13. Examples of an attribute are
a. An employee
b. An employee's name
d. An alphabetical listing of employees
e. An employee's birth date
Long Answer type Questions
1. What does a null represent?
2. What is a null's major disadvantage?
3. What is a view?
(True / False) (True / False) (True / False)
4. What are the three types of relationships that can exist between a pair of tables?
5. What are the three ways in which you can characterize a relationship?
6. What is a field specification?
7. What is data integrity?
8. Name the four types of data integrity.
