πŸ“’ Too many exams? Don’t know which one suits you best? Book Your Free Expert πŸ‘‰ call Now!

  • google app store apple app store
  • βœ–

      Question

      Which of the following SQL commands is a DML (Data

      Manipulation Language) command?
      A CREATE Correct Answer Incorrect Answer
      B ALTER Correct Answer Incorrect Answer
      C INSERT Correct Answer Incorrect Answer
      D GRANT Correct Answer Incorrect Answer
      E COMMIT Correct Answer Incorrect Answer

      Solution

      DML (Data Manipulation Language) commands are used to manipulate data within tables. The INSERT command adds new records (or rows) into a table. It allows you to insert data into specific fields or columns, and it is one of the most commonly used DML commands, alongside UPDATE and DELETE . DML commands operate on the data stored in the database. Option A is incorrect because CREATE is a DDL (Data Definition Language) command used to create objects such as tables, indexes, and databases. Option B is incorrect because ALTER is also a DDL command, which modifies the structure of an existing object. Option D is incorrect because GRANT is a TCL (Transaction Control Language) command used for providing access permissions to users. Option E is incorrect because COMMIT is a TCL command that commits a transaction to the database.

      Practice Next

      Relevant for Exams:

      ask-question