Which term describes the structure or schema of a database?

Which term describes the structure or schema of a database?

• A. Cursor
• B. Cookie
• C. Database
• D. DDL

Answer: (D)

Understanding how a database’s organization is defined is the focus here. The structure, or schema, of a database is specified by the Data Definition Language, the portion of SQL used to create and modify the objects that make up the database. When you issue commands like CREATE TABLE or ALTER TABLE, you’re defining the schema—setting up tables, their columns and data types, constraints, and how they relate to one another. This is why DDL best captures the idea of the database’s structure. In contrast, a cursor is just a tool for traversing query results; a cookie is data stored by a web browser; and a database is the actual repository of data, not the blueprint that defines its structure.

Understanding how a database’s organization is defined is the focus here. The structure, or schema, of a database is specified by the Data Definition Language, the portion of SQL used to create and modify the objects that make up the database. When you issue commands like CREATE TABLE or ALTER TABLE, you’re defining the schema—setting up tables, their columns and data types, constraints, and how they relate to one another. This is why DDL best captures the idea of the database’s structure. In contrast, a cursor is just a tool for traversing query results; a cookie is data stored by a web browser; and a database is the actual repository of data, not the blueprint that defines its structure.