Question
Which SQL command is used to remove only specific rows
from a table while preserving the structure and other rows?Solution
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.
Which sport is associated with the term 'Penalty Corner'?
What does receiving a 'red card' signify in a football match?
Where on a squash court is the 'tin' located?
Who has become the CEO of Indian Olympic Association (IOC)?
Hockey Men’s world cup 2018 is going to be hosted by ___________.Â
The Kho-Kho Federation of India (KKFI) recently launched the logo and tagline for the first-ever Kho-Kho World Cup. Where will the tournament be held?
Which sport made its debut at the Khelo India Youth Games (KIYG) 2024?
Which country will host the Asian Rifle/Pistol Cup 2026?
D Gukesh became the youngest World Chess Champion by winning the FIDE World Chess Championship 2024 at the age of:Â
With which of the following game is ‘Naidu Trophy’ associated?