Engineering Questions with Answers - Multiple Choice Questions
Database MCQ – Data-Dictionary Storage
1 - Question
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
Answer: a
Explanation: Each side of a platter of a disk has a read–write head that moves across the platter to access different tracks.
2 - Question
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
Answer: d
Explanation: Data dictionary is also called as system catalog.
3 - Question
___________ 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
Answer: b
Explanation: Instance is a snapshot of database at any point of time.
4 - Question
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
Answer: a
Explanation: A tablespace is a storage location where the actual data underlying database objects can be kept.
5 - Question
A tablespace is further broken down into ________
a) Tablespace
b) Segments
c) Extents
d) Blocks
View Answer
Answer: b
Explanation: Segment names are used in create table and create index commands to place tables or indexes on specific database devices.
6 - Question
_________ 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
Answer: c
Explanation: An extent is a set of contiguous blocks allocated in a database.
7 - Question
_______ is the smallest unit of allocation in an Oracle database.
a) Database
b) Instance
c) Tablespace
d) Database Block
View Answer
Answer: d
Explanation: Data block is a form of database space allocation.
8 - Question
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
Answer: c
Explanation: Data dictionary is also called as system catalog.
9 - Question
A data dictionary is created when a __________ created.
a) Instance
b) Segment
c) Database
d) Dictionary
View Answer
Answer: c
Explanation: Data dictionary is also called as system catalog.
10 - Question
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
Answer: c
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.