×

Multiple-Choice Questions

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Management MCQs

More

DBMS Data Dictionary Storage MCQs

DBMS Data Dictionary Storage MCQs: This section contains multiple-choice questions and answers on Data Dictionary Storage in DBMS.
Submitted by Anushree Goswami, on May 06, 2022

1. ___ is a structure that stores relational schemas and other metadata about the relations.

  1. Data Dictionary
  2. System Catalog
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

Data Dictionary or System Catalog is a structure that stores relational schemas and other metadata about the relations.

Discuss this Question


2. In relational databases, a data dictionary is similar to the ___ index for every relation that makes up the database.

  1. A-I
  2. A-G
  3. A-U
  4. A-Z

Answer: D) A-Z

Explanation:

In relational databases, a data dictionary is similar to the A-Z index for every relation that makes up the database.

Discuss this Question


3. What are the types of information a system must store?

  1. Relations Names
  2. Each relations attributes names
  3. Attributes domains and lengths
  4. All of the above

Answer: D) All of the above

Explanation:

The types of information a system must store -

  1. Relations Names
  2. Each relations attributes names
  3. Attributes domains and lengths

Discuss this Question


4. Accordingly, the following data is also kept by the system based on users:

  1. Authorized users name
  2. Information about users' accounts and authorizations.
  3. Information relating to user authentication, such as passwords.
  4. All of the above

Answer: D) All of the above

Explanation:

Accordingly, the following data is also kept by the system based on users:

  1. Authorized users name
  2. Information about users' accounts and authorizations.
  3. Information relating to user authentication, such as passwords.

Discuss this Question


5. ___ data about the relationships may also be stored in the system.

  1. Statistical
  2. Descriptive
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

Statistical and descriptive data about the relationships may also be stored in the system.

Discuss this Question


6. Storage organization may also be stored in a system, be it ___.

  1. Sequential
  2. Hash
  3. Heap
  4. All of the above

Answer: D) All of the above

Explanation:

Storage organization may also be stored in a system, be it sequential, hash, or heap.

Discuss this Question


7. The data ____ stores the names of files that contain relations if they are stored in the files of the operating system.

  1. Dictionary
  2. Independency
  3. Storage
  4. System

Answer: A) Dictionary

Explanation:

The data dictionary stores the names of files that contain relations if they are stored in the files of the operating system.

Discuss this Question


8. In the case where the database stores all the relationships in a single file, the data dictionary notes each record in a/an ____ and stores the blocks containing the records in a data structure similar to that.

  1. Array
  2. Linked List
  3. Stack
  4. Queue

Answer: B) Linked List

Explanation:

In the case where the database stores all the relationships in a single file, the data dictionary notes each record in a linked list and stores the blocks containing the records in a data structure similar to that.

Discuss this Question


9. The information about the ___ of the relations is also stored in data dictionary.

  1. Array
  2. Logs
  3. Indexes
  4. None

Answer: C) Indexes

Explanation:

The information about the indexes of the relations is also stored in data dictionary.

Discuss this Question


10. Underlines are used in data dictionary fields to indicate that they contain ____ keys.

  1. Primary
  2. Foreign
  3. Alternate
  4. Composite

Answer: A) Primary

Explanation:

Underlines are used in data dictionary fields to indicate that they contain primary keys.

Discuss this Question





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.