Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

A. Data Definition Language(DDL)

B. Data Manipulation Language(DML)

C. Both of above

D. None

Answer: Option A

Solution(By Examveda Team)

Data Definition Language, represented by DDL, is the subset of SQL commands used to manipulate Oracle Database structures, including tables. DDL commands are responsible for defining, modifying, and deleting the structure of a database, such as creating and altering tables, defining constraints, and managing indexes. They do not deal with the actual data within the tables, which is the primary function of Data Manipulation Language (DML) commands. So, Option A is the correct answer.

CREATE, ALTER, RENAME, DROP and TRUNCATE statements are the names of few data definition elements.

This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Comments ( 6 )

  1. Rupam Gupta
    Rupam Gupta :
    3 years ago

    Yes if DML is for manipulation then what is DDL for 🤣
    IDK why other sites have made the same mistakes

  2. Examveda
    Examveda :
    6 years ago

    DML is short name of Data Manipulation Language which deals with data manipulation and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in a database not manipulate database structure.

  3. Subhankar Patra
    Subhankar Patra :
    7 years ago

    But it is database structure manipulation, means schema, database properties, table properties etc... option "A" is correct

  4. Nivedita Batra
    Nivedita Batra :
    8 years ago

    For data manipulation, it should be DML. DDL is for the definition of data. The answer should be DML.

  5. NavNee Saini
    NavNee Saini :
    8 years ago

    Yes your discussion is right but for manipulation we need DML......not DDL

  6. Shaktiman Power
    Shaktiman Power :
    8 years ago

    why option C is not the answer?

Related Questions on Sql Miscellaneous