Computer Science, asked by Anonymous, 4 months ago

Write the Commands of DDL and DML​

Answers

Answered by deep200593
5

Answer:

Your answer is in the picture

Hope it is clear...

Please mark it as the brainliest

PLEASE

Attachments:
Answered by PeeyushVerma
23

\huge\star{\underline{\mathcal{\purple{An}\pink{Sw}\blue{Er}}}}⋆

Examples of DDL commands:

  • CREATE – is used to create the database or its objects (like table, index, function, views, store procedure and triggers).
  • DROP – is used to delete objects from the database.
  • ALTER-is used to alter the structure of the database.

Some commands of DML are:

  • 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.
Similar questions