a) Instance and body b) Segment and blocks c) ...
View QuestionA data dictionary is created when a __________ created.
a) Instance b) Segment c) Database d) ...
View QuestionAn 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 Answer: c Explanation: Data ...
View Question________ is the smallest unit of allocation in an Oracle database.
a) Database b) Instance c) Tablespace d) Database Block
View 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) ...
View QuestionA tablespace is further broken down into ________
a) Tablespace b) Segments c) Extents d) ...
View QuestionA ________ 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 Answer: a Explanation: ...
View 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 QuestionRelational schemas and other metadata about relations are stored in a structure called the ____________
a) Metadata b) Catalog c) Log d) ...
View QuestionA 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 Answer: ...
View Question