This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Data-Dictionary Storage”.
1. 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
View Answer
Explanation: Each side of a platter of a disk has a read–write head that moves across the platter to access different tracks.
2. Relational schemas and other metadata about relations are stored in a structure called the ____________
a) Metadata
b) Catalog
c) Log
d) Data Dictionary
View Answer
Explanation: Data dictionary is also called as system catalog.
3. ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.
a) Database
b) Instance
c) Tablespace
d) Segment
View Answer
Explanation: Instance is a snapshot of database at any point of time.
4. 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
View Answer
Explanation: A tablespace is a storage location where the actual data underlying database objects can be kept.
5. A tablespace is further broken down into ________
a) Tablespace
b) Segments
c) Extents
d) Blocks
View Answer
Explanation: Segment names are used in create table and create index commands to place tables or indexes on specific database devices.
6. __________ 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
View Answer
Explanation: An extent is a set of contiguous blocks allocated in a database.
7. ________ is the smallest unit of allocation in an Oracle database.
a) Database
b) Instance
c) Tablespace
d) Database Block
View Answer
Explanation: Data block is a form of database space allocation.
8. 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
View Answer
Explanation: Data dictionary is also called as system catalog.
9. A data dictionary is created when a __________ created.
a) Instance
b) Segment
c) Database
d) Dictionary
View Answer
Explanation: Data dictionary is also called as system catalog.
10. 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
View Answer
Explanation: Segment names are used in create table and create index commands to place tables or indexes on specific database devices. An extent is a set of contiguous blocks allocated in a database.
Sanfoundry Global Education & Learning Series – Database Management System.
- Practice RDBMS MCQ
- Check Computer Science Books
- Practice Computer Science MCQs
- Apply for Computer Science Internship
- Check DBMS Books