| 1. | A Relation is a |
| a. | Subset of a Cartesian product of a list of attributes |
| b. | Subset of a Cartesian product of a list of domains |
| c. | Subset of a Cartesian product of a list of tuple |
| d. | Subset of a Cartesian product of a list of relations |
| View Answer Report Discuss Too Difficult! |
|
Answer: (b).Subset of a Cartesian product of a list of domains
|
| 2. | In mathematical term Table is referred as |
| a. | Relation |
| b. | Attribute |
| c. | Tuple |
| d. | Domain |
| View Answer Report Discuss Too Difficult! |
|
Answer: (a).Relation
|
| 3. | In mathematical term Row is referred as |
| a. | Relation |
| b. | Attribute |
| c. | Tuple |
| d. | Domain |
| View Answer Report Discuss Too Difficult! |
|
Answer: (c).Tuple
|
| 4. | _______ allow us to identify uniquely a tuple in the relation. |
| a. | Superkey |
| b. | Domain |
| c. | Attribute |
| d. | Schema |
| View Answer Report Discuss Too Difficult! |
|
Answer: (a).Superkey
|
| 5. | Minimal Superkeys are called |
| a. | Schema keys |
| b. | Candidate keys |
| c. | Domain keys |
| d. | Attribute keys |
| View Answer Report Discuss Too Difficult! |
|
Answer: (b).Candidate keys
|
| 6. | Who proposed the relational model? |
| a. | Bill Gates |
| b. | E.F. Codd |
| c. | Herman Hollerith |
| d. | Charles Babbage |
| View Answer Report Discuss Too Difficult! |
|
Answer: (b).E.F. Codd
|
| 7. | Data Manipulation Language (DML) is not to |
| a. | Create information table in the Database |
| b. | Insertion of new information into the Database |
| c. | Deletion of information in the Database |
| d. | Modification of information in the Database |
| View Answer Report Discuss Too Difficult! |
|
Answer: (a).Create information table in the Database
|
| 8. | Which of the following in true regarding Referential Integrity? |
| a. | Every primary-key value must match a primary-key value in an associated table |
| b. | Every primary-key value must match a foreign-key value in an associated table |
| c. | Every foreign-key value must match a primary-key value in an associated table |
| d. | Every foreign-key value must match a foreign-key value in an associated table |
| View Answer Report Discuss Too Difficult! |
|
Answer: (c).Every foreign-key value must match a primary-key value in an associated table
|
| 9. | How many types of keys in Database Design? |
| a. | Candidate key |
| b. | Primary key |
| c. | Foreign key |
| d. | All of these |
| View Answer Report Discuss Too Difficult! |
|
Answer: (d).All of these
|
| 10. | The minimal set of super key is called |
| a. | Primary key |
| b. | Secondary key |
| c. | Candidate key |
| d. | Foreign key |
| View Answer Report Discuss Too Difficult! |
|
Answer: (c).Candidate key
|
