Which term represents the data dictionary created by the DBMS?

Which term represents the data dictionary created by the DBMS?

• A. View Materialized
• B. Authentication
• C. Encryption
• D. Catalog

Answer: (D)

The data dictionary is a metadata repository that describes the structure and organization of the database—things like tables, columns, data types, constraints, users, and privileges. The term catalog is the common label for that on-line metadata store in many DBMS. The catalog (often synonymous with the system catalog or data dictionary) is what the DBMS consults to understand what exists, how objects are defined, and how they relate to each other, which in turn helps with query planning, integrity enforcement, and access control. The other options point to different concepts: a materialized view is a stored query result, not metadata about the database itself; authentication deals with verifying identities; encryption concerns protecting data confidentiality.

The data dictionary is a metadata repository that describes the structure and organization of the database—things like tables, columns, data types, constraints, users, and privileges. The term catalog is the common label for that on-line metadata store in many DBMS. The catalog (often synonymous with the system catalog or data dictionary) is what the DBMS consults to understand what exists, how objects are defined, and how they relate to each other, which in turn helps with query planning, integrity enforcement, and access control.

The other options point to different concepts: a materialized view is a stored query result, not metadata about the database itself; authentication deals with verifying identities; encryption concerns protecting data confidentiality.