Start learning 50% faster. Sign in now
The TRUNCATE operation in SQL is used to remove all rows from a table without affecting the table structure. Unlike the DELETE operation, which removes rows one at a time and can be rolled back if used with a transaction, TRUNCATE is a more efficient way to delete all records in a table because it does not generate individual row delete statements. TRUNCATE resets any identity columns and typically cannot be rolled back in most database management systems unless within a transaction. Option 1 (DELETE) removes rows from a table but allows for specific conditions (such as WHERE clauses) to filter which rows to delete. Unlike TRUNCATE, DELETE can be rolled back if wrapped in a transaction. Option 2 (DROP) removes the entire table from the database, including its structure, and is more drastic than TRUNCATE. Option 4 (REMOVE) is not a valid SQL operation. Option 5 (ALTER) is used to modify the structure of a table, such as adding or deleting columns, but it does not remove data from the table.
As per the India BioEconomy Report 2024, what was the estimated value of India’s bioeconomy?
Consider the following statement/s about Digital Lending Apps/Platforms (DLAs):
1. Mobile and web-based applications with user interface that fac...
Who issues the Sovereign Gold Bonds (SGBs) in India?
Which bank became the first public sector bank to extend the facility of execution of on-line locker agreement through Digital Document Execution (DDE) ...
Government has raised status of Power Finance Corporation Ltd. (P. F. C.L) from 'Navratna' to 'Maharatna' psu ion which year?
Which of the following is considered a "safe-haven" asset during economic uncertainty?
Which organisation has launched the Talent Connect portal to bridge the gap between recruiters and digitally skilled and certified candidates & to con...
What is the maximum tenor for LongTerm Capital Gains (LTCG) on listed securities in India?
Securities Appellate Tribunal (SAT) established in which of the following year?
Which of the following is a monetary policy tool which allows banks to borrow money through repurchase agreements that is primerily used by the Reserve ...