Computer Science
Assertion. DDL and DML both are part of SQL.
Reason. Both DDL and DML are interchangeable.
Answer
(c)
Assertion is true but Reason is false.
Explanation
DDL and DML are two subcategories of SQL. Data definition language (DDL) commands in SQL are used to define a database, including creating, altering, and dropping tables whereas Data manipulation language (DML) statements are used to retrieve, insert, update, and delete data in a database. Hence, DDL and DML are two different commands and are not interchangeable.
Related Questions
Assertion. Both WHERE and HAVING clauses are used to specify conditions.
Reason. The WHERE and HAVING clauses are interchangeable.
Assertion. DDL and DML are not the same.
Reason. DDL and DML are two subcategories of SQL where DDL creates the objects and DML manipulates the data.
Assertion. Both BETWEEN and IN operators can choose from a list of values.
Reason. The value ranges and a list of values are interpreted in the same way in SQL.
Write a query to display EName and Sal of employees whose salary is greater than or equal to 2200 from table Empl.