Question:medium
Describe about any two DML commands of SQL.
Describe about any two DML commands of SQL.
Show Hint
DML commands help modify the data stored in a database, ensuring the records are up-to-date and accurate.
Updated On: Mar 14, 2026
Show Solution
Solution and Explanation
Was this answer helpful?
0
Top Questions on SQL
- Briefly explain about any two column constraints used in SQL.
- Given the table facts: \[ \text{facts (D1, D2, val)} \] with the following data:
Consider the following SQL query:
What is the total number of rows produced? On a relation named Loan of a bank:
- Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute. Suppose attribute D1 takes 3 values and D2 takes 2 values, and all combinations of these values are present in the table Facts. How many tuples are there in the result of the following query? \[ \text{SELECT D1, D2, sum(val)} \] \[ \text{FROM Facts} \] \[ \text{GROUP BY CUBE (D1, D2);} \]
- Want to practice more? Try solving extra ecology questions todayView All Questions