Question

Short Answer Questions:
1. Name DML commands.
2. What is the purpose of using queries?
3. Which clause of Select statement helps to display specific
data?
4. Differentiate between Where and Orderby clause of SQL
statements.
5. State the purpose of Update Command with the help of an
example.

Answer 1

Answer:

SELECT – retrieve data from the a database.

INSERT – insert data into a table.

UPDATE – updates existing data within a table.

DELETE – deletes all records from a table, the space for the records remain.

MERGE – UPSERT operation (insert or update)

CALL – call a PL/SQL or Java subprogram.

(1)

Explanation:

A query is a request for data results, and for action on data. You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data