Which one of the following is a type of Data Manipulation Command?a)Cr...
In data manipulation language, the command like select, insert, update, and delete is used to manipulate the information (or data, records), for example create a table, update table delete table, etc. Therefore the correct answer is C.
Which one of the following is a type of Data Manipulation Command?a)Cr...
Data Manipulation Commands are used to manipulate and modify the data stored in a database. They allow users to perform various operations such as inserting, updating, deleting, and retrieving data. Among the given options, the correct answer is option 'C' - Delete.
Deletion is a type of Data Manipulation Command that allows users to remove specific rows or records from a database table. It is commonly used to remove outdated, duplicate, or irrelevant data from the database. The DELETE command is used to perform this operation.
Below is a detailed explanation of the given options and their relevance to Data Manipulation Commands:
a) Create:
The CREATE command is not a Data Manipulation Command but a Data Definition Language (DDL) command. It is used to create database objects such as tables, indexes, views, and procedures. The CREATE command does not manipulate or modify existing data; instead, it is used to define the structure and properties of the database.
b) Alter:
The ALTER command is also a Data Definition Language (DDL) command and not a Data Manipulation Command. It is used to modify the structure or properties of an existing database object. For example, the ALTER TABLE command is used to add, modify, or delete columns in a table. The ALTER command does not directly manipulate the data stored in the database.
c) Delete:
The DELETE command is a Data Manipulation Command that allows users to remove specific rows or records from a database table. It is used to delete unwanted or outdated data from the database. The DELETE command can be used with or without conditions to delete either all rows or specific rows based on certain criteria.
In conclusion, among the given options, the only type of Data Manipulation Command is option 'C' - Delete. The CREATE and ALTER commands are Data Definition Language (DDL) commands used for creating and modifying the structure of the database objects, respectively.
To make sure you are not studying endlessly, EduRev has designed Humanities/Arts study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in Humanities/Arts.