FIle Structure and Organization Set 1
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
On This Page
This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on FIle Structure and Organization Set 1
Q1 | __________ is a contiguous group of blocks allocated for use as part of a table, index,and so forth.
- Tablespace
- Segment
- Extent
- Block
Q2 | ________ is the smallest unit of allocation in an Oracle database.
- Database
- Instance
- Tablespace
- Database Block
Q3 | An Oracle __________ is a set of tables and views that are used as a read-onlyreference about the database.
- Database dictionary
- Dictionary table
- Data dictionary
- Dictionary
Q4 | A data dictionary is created when a __________ created.
- Instance
- Segment
- Database
- Dictionary
Q5 | An Oracle object type has two parts the _________ and__________
- Instance and body
- Segment and blocks
- Specification and body
- Body and segment
Q6 | A(n) _________ can be used to preserve the integrity of a document or a message.
- Message digest
- Message summary
- Encrypted message
- None of the mentioned
Q7 | A hash function must meet ________ criteriA:)
- Two
- Three
- Four
- None of the mentioned
Q8 | What is the main limitation of Hierarchical Databases?
- Limited capacity (unable to hold much datA:)
- Limited flexibility in accessing data
- Overhead associated with maintaining indexes
- The performance of the database is poor
Q9 | The property (or set of properties) that uniquely defines each row in a table is called the:
- Identifier
- Index
- Primary key
- Symmetric key
Q10 | The separation of the data definition from the program is known as:
- Data dictionary
- Data independence
- Data integrity
- Referential integrity
Q11 | The traditional storage of data that is organized by customer, stored in separate foldersin filing cabinets is an example of what type of ‘database’ system?
- Hierarchical
- Network
- Object oriented
- Relational
Q12 | The database design that consists of multiple tables that are linked together throughmatching data stored in each table is called
- Hierarchical database
- Network database
- Object oriented database
- Relational database
Q13 | The association role defines:
- How tables are related in the database
- The relationship between the class diagram and the tables in the database
- The tables that each attribute is contained
- Which attribute is the table’s primary key
Q14 | The purpose of an N-Ary association is:
- To capture a parent-child relationship
- To deal with one to many relationships
- To deal with relationships that involve more than two tables
- To represent an inheritance relationship
Q15 | In ordered indices the file containing the records is sequentially ordered, a___________ is an index whose search key also defines the sequential order of the file.
- Clustered index
- Structured index
- Unstructured index
- Nonclustered index
Q16 | Indices whose search key specifies an order different from the sequential order of thefile are called ___________ indices.
- Nonclustered
- Secondary
- All of the mentioned
- None of the mentioned
Q17 | An ____________ consists of a search-key value and pointers to one or more recordswith that value as their search-key value.
- Index entry
- Index hash
- Index cluster
- Index map
Q18 | In a _______ clustering index, the index record contains the search-key value and apointer to the first data record with that search-key value and the rest of the records will be inthe sequential pointers.
- Dense
- Sparse
- Straight
- Continuous
Q19 | In a __________ index, an index entry appears for only some of the search-key values.
- Dense
- Sparse
- Straight
- Continuous
Q20 | Incase the indices values are larger, index is created for these values of the index. Thisis called
- Pointed index
- Sequential index
- Multilevel index
- Multiple index
Q21 | A search key containing more than one attribute is referred to as a _________ searchkey.
- Simple
- Composite
- Compound
- Secondary
Q22 | Insertion of a large number of entries at a time into an index is referred to as__________ of the index.
- Loading
- Bulk insertion
- Bulk loading
- Increase insertion
Q23 | While inserting the record into the index, if the search-key value does not appear in theindex.
- The system adds a pointer to the new record in the index entry
- The system places the record being inserted after the other records with the same searchkey values
- The system inserts an index entry with the search-key value in the index at the appropriate position
- None of the mentioned
Q24 | A collection of data designed to be used by different people is called a/an
- Organization
- Database
- Relationship
- Schema
Q25 | Which of the following is the oldest database model?
- Relational
- Deductive
- Physical
- Network