Chapter:

40+ FIle Structure and Organization Solved MCQs

in DataBase Management System (DBMS)

These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: 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) .

Chapters

Take a Test

1.	If a piece of data is stored in two places in the database, then
A.	Storage space is wasted
B.	Changing the data in one spot will cause data inconsistency
C.	In can be more easily accessed
D.	Storage space is wasted & Changing the data in one spot will cause data inconsistency
Answer» D. Storage space is wasted & Changing the data in one spot will cause data inconsistency

2.	An audit trail ___________
A.	Is used to make backup copies
B.	Is the recorded history of operations performed on a file
C.	Can be used to restore lost information
D.	None of the mentioned
Answer» B. Is the recorded history of operations performed on a file

3.	Large collection of files are called ____________
A.	Fields
B.	Records
C.	Database
D.	Sectors
Answer» C. Database

4.	Which of the following hardware component is the most important to the operation of a database management system?
A.	High resolution video display
B.	Printer
C.	High speed, large capacity disk
D.	Mouse
Answer» C. High speed, large capacity disk

5.	Which of the following is not true of the traditional approach to information processing
A.	There is common sharing of data among the various applications
B.	It is file oriented
C.	Programs are dependent on the file
D.	It is inflexible
Answer» A. There is common sharing of data among the various applications

6.	The information about data in a database is called _______
A.	Metadata
B.	Hyper data
C.	Tera data
D.	None of the mentioned
Answer» A. Metadata

7.	A data dictionary is a special file that contains?
A.	The names of all fields in all files
B.	The data types of all fields in all files
C.	The widths of all fields in all files
D.	All of the mentioned
Answer» D. All of the mentioned

8.	A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
A.	Metadata
B.	Catalog
C.	Log
D.	Dictionary
Answer» A. Metadata

9.	Relational schemas and other metadata about relations are stored in a structure called the ____________
A.	Metadata
B.	Catalog
C.	Log
D.	Data Dictionary
Answer» D. Data Dictionary

10.	___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.
A.	Database
B.	Instance
C.	Tablespace
D.	Segment
Answer» B. Instance

11.	A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
A.	Tablespace
B.	Segments
C.	Extents
D.	Blocks
Answer» A. Tablespace

13.	__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.
A.	Tablespace
B.	Segment
C.	Extent
D.	Block
Answer» C. Extent

17.	An Oracle object type has two parts the _________ and__________
A.	Instance and body
B.	Segment and blocks
C.	Specification and body
D.	Body and segment
Answer» C. Specification and body

18.	A(n) _________ can be used to preserve the integrity of a document or a message.
A.	Message digest
B.	Message summary
C.	Encrypted message
D.	None of the mentioned
Answer» A. Message digest

19.	A hash function must meet ________ criteriA:)
A.	Two
B.	Three
C.	Four
D.	None of the mentioned
Answer» B. Three

12.	A tablespace is further broken down into ________
A.	Tablespace
B.	Segments
C.	Extents
D.	Blocks
Answer» B. Segments

14.	________ is the smallest unit of allocation in an Oracle database.
A.	Database
B.	Instance
C.	Tablespace
D.	Database Block
Answer» D. Database Block

15.	An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.
A.	Database dictionary
B.	Dictionary table
C.	Data dictionary
D.	Dictionary
Answer» C. Data dictionary

16.	A data dictionary is created when a __________ created.
A.	Instance
B.	Segment
C.	Database
D.	Dictionary
Answer» C. Database

20.	What is the main limitation of Hierarchical Databases?
A.	Limited capacity (unable to hold much datA:)
B.	Limited flexibility in accessing data
C.	Overhead associated with maintaining indexes
D.	The performance of the database is poor
Answer» B. Limited flexibility in accessing data

21.	The property (or set of properties) that uniquely defines each row in a table is called the:
A.	Identifier
B.	Index
C.	Primary key
D.	Symmetric key
Answer» C. Primary key

22.	The separation of the data definition from the program is known as:
A.	Data dictionary
B.	Data independence
C.	Data integrity
D.	Referential integrity
Answer» B. Data independence

23.	The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?
A.	Hierarchical
B.	Network
C.	Object oriented
D.	Relational
Answer» A. Hierarchical

24.	The database design that consists of multiple tables that are linked together through matching data stored in each table is called
A.	Hierarchical database
B.	Network database
C.	Object oriented database
D.	Relational database
Answer» D. Relational database

25.	The association role defines:
A.	How tables are related in the database
B.	The relationship between the class diagram and the tables in the database
C.	The tables that each attribute is contained
D.	Which attribute is the table’s primary key
Answer» A. How tables are related in the database

40+ FIle Structure and Organization Solved MCQs

If a piece of data is stored in two places in the database, then

An audit trail ___________

Large collection of files are called ____________

Which of the following hardware component is the most important to the operation of a database management system?

Which of the following is not true of the traditional approach to information processing

The information about data in a database is called _______

A data dictionary is a special file that contains?

A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called

Relational schemas and other metadata about relations are stored in a structure called the ____________

___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.

A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

A tablespace is further broken down into ________

__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

________ is the smallest unit of allocation in an Oracle database.

An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.

A data dictionary is created when a __________ created.

An Oracle object type has two parts the _________ and__________

A(n) _________ can be used to preserve the integrity of a document or a message.

A hash function must meet ________ criteriA:)

What is the main limitation of Hierarchical Databases?

The property (or set of properties) that uniquely defines each row in a table is called the:

The separation of the data definition from the program is known as:

The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?

The database design that consists of multiple tables that are linked together through matching data stored in each table is called

The association role defines:

The purpose of an N-Ary association is:

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.

Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.

An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key 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.

In a __________ index, an index entry appears for only some of the search-key values.

Incase the indices values are larger, index is created for these values of the index. This is called

A search key containing more than one attribute is referred to as a _________ search key.

Insertion of a large number of entries at a time into an index is referred to as __________ of the index.

While inserting the record into the index, if the search-key value does not appear in the index.

A collection of data designed to be used by different people is called a/an

Which of the following is the oldest database model?

Which of the following schemas does define a view or views of the database for particular users?

Which of the following are the process of selecting the data storage and data access characteristics of the database?

Which of the following terms does refer to the correctness and completeness of the data in a database?

A table can be logically connected to another table by defining a

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

Ensuring isolation property is the responsibility of the

An Oracle object type has two parts the _ and__

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.

26.	The purpose of an N-Ary association is:
A.	To capture a parent-child relationship
B.	To deal with one to many relationships
C.	To deal with relationships that involve more than two tables
D.	To represent an inheritance relationship
Answer» C. To deal with relationships that involve more than two tables

27.	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.
A.	Clustered index
B.	Structured index
C.	Unstructured index
D.	Nonclustered index
Answer» A. Clustered index

28.	Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.
A.	Nonclustered
B.	Secondary
C.	All of the mentioned
D.	None of the mentioned
Answer» C. All of the mentioned

29.	An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
A.	Index entry
B.	Index hash
C.	Index cluster
D.	Index map
Answer» A. Index entry

30.	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.
A.	Dense
B.	Sparse
C.	Straight
D.	Continuous
Answer» A. Dense

32.	Incase the indices values are larger, index is created for these values of the index. This is called
A.	Pointed index
B.	Sequential index
C.	Multilevel index
D.	Multiple index
Answer» C. Multilevel index

33.	A search key containing more than one attribute is referred to as a _________ search key.
A.	Simple
B.	Composite
C.	Compound
D.	Secondary
Answer» B. Composite

34.	Insertion of a large number of entries at a time into an index is referred to as __________ of the index.
A.	Loading
B.	Bulk insertion
C.	Bulk loading
D.	Increase insertion
Answer» C. Bulk loading

35.	While inserting the record into the index, if the search-key value does not appear in the index.
A.	The system adds a pointer to the new record in the index entry
B.	The system places the record being inserted after the other records with the same searchkey values
C.	The system inserts an index entry with the search-key value in the index at the appropriate position
D.	None of the mentioned
Answer» C. The system inserts an index entry with the search-key value in the index at the appropriate position

36.	A collection of data designed to be used by different people is called a/an
A.	Organization
B.	Database
C.	Relationship
D.	Schema
Answer» B. Database