Which is the subset of SQL commands used to manipulate Oracle...

Home / SQL / Sql Miscellaneous / Question

Examveda

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)

The Data Definition Language (DDL) is used to manage table and index structure.
CREATE, ALTER, RENAME, DROP and TRUNCATE statements are the names of few data definition elements.

Join The Discussion

Comments ( 6 )

Rupam Gupta :

1 year ago

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

5 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.
Subhankar Patra :

6 years ago

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

6 years ago

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

6 years ago

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

7 years ago

why option C is not the answer?