In a DBMS, a complete description of the configuration of record types, data items and the relationships among them is known as:
A) query language
B) Subschema
C) Schema
D) DML

Question

Quizplus · Accepted Answer

The description given in the question best fits the definition of a schema in a DBMS. A schema is a comprehensive description of the organization of data in a database, including the relationships between different types of data and how they are stored and accessed.

A) Query language refers to a specific language used to interact with a database and retrieve data. It does not encompass the complete organization of the database.

B) Subschema is a subset of the overall schema that defines the way a particular user or application views the data in the database. It is not a comprehensive description of the entire database.

D) DML (Data Manipulation Language) is a set of commands used to modify the data in a database, such as inserting new records or updating existing ones. It is not a description of the organization of the data within the database.

In a DBMS, a Complete Description of the Configuration of Record