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
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
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
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
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
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
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
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
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
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
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.