Start learning 50% faster. Sign in now
The DELETE command in SQL is used to remove specific rows from a table based on a WHERE clause condition. Unlike DROP or TRUNCATE, which impact the entire table, DELETE operates on a more granular level, enabling selective removal of data while preserving the table structure and any other rows. For example: DELETE FROM employees WHERE department = 'Sales'; This query removes only the rows from the employees table where the department is 'Sales', leaving all other rows intact. Additionally, the DELETE command logs each deleted row, making it possible to rollback transactions if the database supports it (e.g., in databases using transaction control). This makes DELETE particularly useful for scenarios where precision and rollback capabilities are required. Explanation of Incorrect Options: A) DROP : The DROP command is used to completely remove a table or database, including its structure. It is not selective and deletes the entire object. B) TRUNCATE : While TRUNCATE removes all rows from a table, it does not allow selective deletion. Furthermore, TRUNCATE is faster but does not log individual row deletions, making rollback impossible in most cases. D) REMOVE : This is not a valid SQL command. E) UPDATE : The UPDATE command is used to modify existing data, not to delete it.
Select the option that is related to the fifth term in the same way as the second term is related to the first term and fourth term is related to the th...
Which of the following state in located The Lakhwar dam ?
As per the Performance Grading Index for Districts (PGI-D), which is the highest achievable grade?
Which of the following districts of Uttarakhand has the highest apple production?
Which chemical element with atomic number 35 has a dark reddish-brown liquid with a burning pungent odour?
The World’s largest/biggest airport King Fahd International Airport is situated in which of these countries?
Which of the following has/have been added by the 92nd Amendment Act of 2003 as Scheduled Languages in the 8th Schedule of the Constitution of India? <...
Which one of the following recommended that the public health expenditure of the Union and State Governments together should be increased in a progressi...
NABARD has launched an agroecology-based programme named ‘JIVA programme’. The objective of the programme is to promote ______________.
Who can make recommendations regarding the division of the net proceeds of taxes between the Union and the states?