Top 50+ Solved FIle Structure and Organization MCQ Questions Answer
Q. 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
Q. Which of the following hardware component is the most important to the operation of adatabase management system?
a. High resolution video display
b. Printer
c. High speed, large capacity disk
d. Mouse
Q. 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
Q. The information about data in a database is called _______
a. Metadata
b. Hyper data
c. Tera data
d. None of the mentioned
Q. 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
Q. A relational database system needs to maintain data about the relations, such as theschema of the relations. This is called
a. Metadata
b. Catalog
c. Log
d. Dictionary
Q. Relational schemas and other metadata about relations are stored in a structure calledthe ____________
a. Metadata
b. Catalog
c. Log
d. Data Dictionary
Q. ___________ is the collection of memory structures and Oracle background processesthat operates against an Oracle database.
a. Database
b. Instance
c. Tablespace
d. Segment
Q. 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
Q. __________ 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
Q. ________ is the smallest unit of allocation in an Oracle database.
a. Database
b. Instance
c. Tablespace
d. Database Block
Q. An Oracle __________ is a set of tables and views that are used as a read-onlyreference about the database.
a. Database dictionary
b. Dictionary table
c. Data dictionary
d. Dictionary
Q. A data dictionary is created when a __________ created.
a. Instance
b. Segment
c. Database
d. Dictionary