Database Questions and Answers – Data-Dictionary Storage

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Data-Dictionary Storage”.

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

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
View Answer

Answer: a
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
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.
Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

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
View Answer

Answer: c
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
View Answer

Answer: d
Explanation: Data block is a form of database space allocation.
advertisement

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
View Answer

Answer: c
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
View Answer

Answer: c
Explanation: Data dictionary is also called as system catalog.
advertisement

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

Sanfoundry Global Education & Learning Series – Database Management System.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.