The file organization that provides very fast access to any arbitrary record of a file is:

Related MCQs

• In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
•                          using a log record sets the data item specified in the log record to the old value.
• In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• Which collection types is also known as index-by tables, lets you look up elements Using arbitrary numbers and strings for subscript values?
• Some of the utilities of DBMS are ............. i) Transaction ii) Backup iii) File organization iv) Process Organization
• A              file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.
•                      is increasingly being used in server systems to improve performance by caching frequently used data, since it provides faster access than disk, with larger storage capacity than main memory.
• The DML provides following functional access to the database:
• Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
• After conversion of high level queries into low level commands for file access and is called compiled_____: