MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
A_DATA_DICTIONARY_IS_CREATED_WHEN_A____________CREATED.?$ |
| A. | Instance |
| B. | Segment |
| C. | Database |
| D. | Dictionary |
| Answer» D. Dictionary | |
| 2. |
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 |
| Answer» D. Body and segment | |
| 3. |
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 |
| Answer» D. Dictionary | |
| 4. |
________ is the smallest unit of allocation in an Oracle database. |
| A. | Database |
| B. | Instance |
| C. | Tablespace |
| D. | Database Block |
| Answer» E. | |
| 5. |
__________ 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 |
| Answer» D. Block | |
| 6. |
A tablespace is further broken down into ________ |
| A. | Tablespace |
| B. | Segments |
| C. | Extents |
| D. | Blocks |
| Answer» C. Extents | |
| 7. |
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 |
| Answer» B. Segments | |
| 8. |
___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database. |
| A. | Database |
| B. | Instance |
| C. | Tablespace |
| D. | Segment |
| Answer» C. Tablespace | |
| 9. |
Relational schemas and other metadata about relations are stored in a structure called the ____________ |
| A. | Metadata |
| B. | Catalog |
| C. | Log |
| D. | Data Dictionary |
| Answer» E. | |
| 10. |
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 |
| Answer» B. Catalog | |