Databases and database systems questions.
Find Databases and database systems university examination questions in acaproso.com
| # | Question |
|---|---|
| 1 | A relation that has no partial functional dependencies is in 2NF. True OR False |
| 2 | A relation in 1NF suffers from insertion, deletion and update anomalies. True OR False |
| 3 | A table with insertion, deletion and update anomalies has to be broken down into two to remove the anomalies. True OR False |
| 4 | A relationship is an association between two or more tables in an E-R model. True OR False |
| 5 | We use a surrogate key when no field can be unique for each entity instance. True OR False |
| 6 | The entity integrity rule states that the primary key must be unique. True OR False |
| 7 | A composite key consists of two or more candidate keys. True OR False |
| 8 | All many-to-many relationships are of least second degree. True OR False |
| 9 | A foreign key and its corresponding primary key must be of the same data type. True OR False |
| 10 | E-R modeling is part of conceptual database design. True OR False |
Acaproso Login