Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 352
|
These are five records in a database:
Name Age Occupation Category Raman 27 CON A Akbar 22 ENG B Janifar 28 DOC C Maya 32 SER D Deva 24 MUS E
There is an index file associated with this and it contains the values 1, 3, 2, 5, 4. Which one of the fields is the index built form?
|
Age
|
|
|
Name
|
|
|
Occupation
|
|
|
Category
|
Question 352 Explanation:
Occupation is the field from which the index is built from, taking first letter into consideration which is ordered as they are alphabetically ordered..
First CON-Starts with C
Second DOC-Starts with D
Third ENG-Starts with E
Fourth MUS-starts with M
Fifth SER-Strats with S
First CON-Starts with C
Second DOC-Starts with D
Third ENG-Starts with E
Fourth MUS-starts with M
Fifth SER-Strats with S
Correct Answer: C
Question 352 Explanation:
Occupation is the field from which the index is built from, taking first letter into consideration which is ordered as they are alphabetically ordered..
First CON-Starts with C
Second DOC-Starts with D
Third ENG-Starts with E
Fourth MUS-starts with M
Fifth SER-Strats with S
First CON-Starts with C
Second DOC-Starts with D
Third ENG-Starts with E
Fourth MUS-starts with M
Fifth SER-Strats with S