ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

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

Answer & Solution
Correct Answer: Option A
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

8 Comments
Bhawna Wadhwa
Bhawna Wadhwa 2 years ago
aNSWER SHOULD BE dml

pLZ cHECK aNSWERS & cORRECT
Anil Sidar
Anil Sidar 2 years ago
The____ statement cause the stetment to undo all the updates performed on the transaction
Rupam Gupta
Rupam Gupta 5 years ago
Yes if DML is for manipulation then what is DDL for 🤣
IDK why other sites have made the same mistakes
Examveda
Examveda 9 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
Subhankar Patra 10 years ago
But it is database structure manipulation, means schema, database properties, table properties etc... option "A" is correct
Nivedita Batra
Nivedita Batra 10 years ago
For data manipulation, it should be DML. DDL is for the definition of data. The answer should be DML.
NavNee Saini
NavNee Saini 11 years ago
Yes your discussion is right but for manipulation we need DML......not DDL
Shaktiman Power
Shaktiman Power 11 years ago
why option C is not the answer?