Q2
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A.
Data Definition Language(DDL)
AnswerB.
Data Manipulation Language(DML)
C.
Both of above
D.
None
Answer: Option A
Solution
Answer: Option A
Solution:
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.