قواعد الشابتر 2

is a descriptive language for defining and constructing the database.

• Database Transaction Language (DTL)
• Database Manipulation Language (DML)
• Database Definition Language (DDL)
• Database Query Language (DQL)

Allows users to specify the data types and structures and the constraints on the data to be stored in the DB.

• Database Index
• Data Model
• DDL

• Data Warehouse

generates the meta-data that is stored in the data dictionary.

• Data Warehouse
• File System
• Application Server
• DDL compiler

is a language for retrieving and updating (insert, delete, & modify) the data in the DB.

• HTML
• SQL
• CSS
• DML

Types of DML

• MERGE
• TRUNCATE
• High level or Nonprocedural Language

• Low level or Procedural Language

Nonprocedural Language

• Low level

• High level

Procedural Language

• Low level

• High level

user specifies what data is required and how to get those data.

• High level or Nonprocedural Language

• Low level or Procedural Language

user specifies what data is required without specifying how to get those data.

• High level or Nonprocedural Language

• Low level or Procedural Language

Both DDL and DML are usually not considered distinct languages.

• True

• False