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