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 ( 5 )
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
Which of the following query is correct for using comparison operators in SQL?
A. SELECT name, course_name FROM student WHERE age>50 and <80;
B. SELECT name, course_name FROM student WHERE age>50 and age <80;
C. SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;
D. None of these
Find the name of cities with all entries whose temperature is in the range of 71 and 89
A. SELECT * FROM weather WHERE temperature NOT IN (71 to 89);
B. SELECT * FROM weather WHERE temperature NOT IN (71 and 89);
C. SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;
D. SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
The command to remove rows from a table 'CUSTOMER' is:
A. DROP FROM CUSTOMER ...
B. UPDATE FROM CUSTOMER ...
C. REMOVE FROM CUSTOMER ...
D. DELETE FROM CUSTOMER WHERE ...
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.
But it is database structure manipulation, means schema, database properties, table properties etc... option "A" is correct
For data manipulation, it should be DML. DDL is for the definition of data. The answer should be DML.
Yes your discussion is right but for manipulation we need DML......not DDL
why option C is not the answer?