Organization of Records in Files

Question 1
Marks : +2 | -2
Pass Ratio : 100%
What is hashing file organization?
Any record can be placed wherever there is a space for the record
Records are stored in a sequential order according to a search key
A hash function is computed on some attribute and that decides the block
None of the mentioned
Explanation:
Hashing file organization means that a hash function is computed on some attribute and that decides the block. The result of the hash function specifies which block of the file the record should be placed in.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
Which of the following need to be stored in the data dictionary?
Name of the relation
Domains and lengths of attributes
Integrity constraints
All of the mentioned
Explanation:
Name of the relation, Domains and lengths of attributes and Integrity constraints all must be stored in the data dictionary.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
What is sequential file organization?
Any record can be placed wherever there is a space for the record
Records are stored in a sequential order according to a search key
A hash function is computed on some attribute and that decides the block
None of the mentioned
Explanation:
Sequential file organization means that Records are stored in a sequential order according to a search key. The records are ordered.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
What is a multitable clustering file organization?
It stores related records of two or more relations in each block
It stores related data about the relations in each block
It links each and every block by introducing an external attribute
None of the mentioned
Explanation:
A multitable clustering file organization stores the related records of two or more relations in each block. This allows us to read records that satisfy a join condition by using one block read.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
The subsystem responsible for the allocation of buffer space is called as _______
Buffer allocator
Buffer manager
Buffer enhancer
Buffer intermediary
Explanation:
The subsystem responsible for the allocation of buffer space is called as buffer manager. Programs on the database make requests to the buffer manager and it in in turn allocates the buffer space.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
What is heap file organization?
Any record can be placed wherever there is a space for the record
Records are stored in a sequential order according to a search key
A hash function is computed on some attribute and that decides the block
None of the mentioned
Explanation:
Heap file organization means that any record can be placed wherever there is space for that record. There is no ordering of records. Typically there is a single file for each relation.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
Data dictionary is also called as ________
Data log
System log
System catalog
System database log
Explanation:
Data dictionary is also called as System Catalog.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
Metadata about the relations are stored in ________
File header
Data dictionary
Data query
Data analyser
Explanation:
A relational schema needs to maintain data about the data called as metadata. Metadata about the relations is stored in the Data dictionary.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
What is the full form of LRU (in buffer replacement strategy)?
Least Reactive User
Least Recently Used
Least Read URL
Lowest Reading User
Explanation:
The full form of LRU is Least Recently Used. In this, the least recently used program is substituted by the new request.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
What is a search key in sequential file organization?
A number assigned to each record
Necessarily the primary key
Any attribute or a set of attributes
None of the mentioned
Explanation:
A search key in sequential file organization is any attribute or a set of attributes that need not be a primary key or even a superkey.