| 1. | Which of the following is true ? |
|
Answer: (a).A relation in BCNF is always in 3NF
|
| 2. | In DML, RECONNECT command cannot be used with |
|
Answer: (b).FIXED Set
|
| 3. | A hash function f defined as f (key) = key mod 13, with linear probing is used to insert keys 55, 58, 68, 91, 27, 145. What will be the location of 79 ? |
|
Answer: (d).5
|
| 4. | The User Work Area (UWA) is a set of Program variables declared in the host program to communicate the contents of individual records between |
|
Answer: (c).Host program and DBMS
|
| 5. | Given a Relation POSITION (Posting-No, Skill), then query to retrieve all distinct pairs of posting-nos requiring skill is |
|
Answer: (c).Select p1.posting-No, p2.posting-No from position p1, position p2 where p1.skill = p2.skill and p1.posting-No < p2.posting-No
|
| 6. | If a relation with a Schema R is decomposed into two relations R1 and R2 such that (R1 ∪ R2) = R1 then which one of the following is to be satisfied for a lossless joint decomposition (---> indicates functional dependency) |
|
Answer: (a).(R1 ∩ R2) --> R1 or R1 ∩ R2 ---> R2
|
| 7. | Which level of Abstraction describes how data are stored in the data base ? |
|
Answer: (a).Physical level
|
| 8. | Third normal form is based on the concept of ______. |
|
Answer: (b).Transitive Dependency
|
| 9. | The student. marks should not be greater than 100. This is |
|
Answer: (a).Integrity constraint
|
| 10. | GO BOTTOM and SKIP-3 commands are given one after another in a database file of 30 records. It shifts the control to |
|
Answer: (b).27th record
|
