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