11 votes 11 votes For secondary key processing which of the following file organizations is preferred? Give a one line justification: Indexed sequential file organization. Two-way linked list. Inverted file organization. Sequential file organization. Databases gate1989 normal databases indexing descriptive + – makhdoom ghaya asked Nov 30, 2016 retagged Apr 16, 2021 by Lakshman Bhaiya makhdoom ghaya 7.1k views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply UltraRadiantX commented Dec 29, 2020 reply Follow Share Is inverted file organization topic out of syllabus? 0 votes 0 votes shashankrustagi commented Jan 20, 2021 reply Follow Share no , it is in syllabus 1 votes 1 votes Psy Duck commented Aug 15, 2023 reply Follow Share @Deepak Poonia Sir can u give some strong explaination regarding this question 1 votes 1 votes Please log in or register to add a comment.
4 votes 4 votes Inverted File organization Because of the following reasons An index for each secondary key. · An index entry for each distinct value of the secondary key. It exhibits better inquiry performance Neeraj7375 answered Oct 4, 2017 Neeraj7375 comment Share Follow See all 2 Comments See all 2 2 Comments reply Akash Papnai commented Dec 25, 2019 reply Follow Share I think the answer is incomplete: With respect to given 4 options, in terms of efficiency, Indexed sequential file organization > Inverted file organization > Two way linked list > Sequential file organization (due to sorting). Now, we may use Indexed or inverted but we'll prefer inverted so that we can save some space(as Indexed will surely take some space to store the index. 5 votes 5 votes o commented Nov 25, 2021 reply Follow Share Why would inverted save more space than indexed? Also isn’t the reason for preferring inverted that it is applied on the secondary key because the database is stored according to the primary key? Please help 0 votes 0 votes Please log in or register to add a comment.