PREVIOUS YEAR SOLVED PAPERS - December 2015 Paper 2
18. Which of the following provides the best description of an entity type?
- A
A specific concrete object with a defined set of processes (e.g. Jatin with diabetes)
- B
A value given to a particular attribute (e.g. height - 230 cm)
- C
A thing that we wish to collect data about zero or more, possibly real world examples of it may exist
- D
A template for a group of things with the same set of characteristics that may exist in the real world
19. Data which improves the performance and accessibility of the database are called:
- Option : A
- Explanation : Data which improves the performance and accessibility of the database are called indexes because index is a type of any data which improves the lookup table. Simply we can say that an index is a pointer to data in a table which increases the accessibility in a book or databases, we can easily access any information with the help of index. Option (A) is correct
- Option : D
- Explanation : [AD]+ = ADE. [BE]+ = BCEF. [B]+ = BC. [AF]+ = AFG. Nothing drives all the attributes, but if We add B in first key i.e. [ADB] then it will give all the attribute [ADB]+ = ABCDEFG. So, option (D) is correct.
