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.
What is the percentage stake acquired by Bank of India in CCIL IFSC?
What is the minimum number of members required to be incorporated as a Nidhi company?
Provision for Bad Debts is required to be maintained in the books as per which principle?
ABC Ltd has made purchases of Rs.100,000 during the year. The balance sheet shows an average accounts payable balance of Rs12,000. ABC Ltd payable payme...
An option that can be exercised only at expiration is called ____
People who score high in openness to experience are generally what?
Manish is a manager who is out of town on a business trip. He needs to get some data to a member of his staff rather quickly so a presentation can be up...
Conscientiousness measures what aspect of a person's personality?
As per Partnership Act, in which of the following cases partners have the duty to indemnify the loss caused to the firm?
In July 2024, which economic indicator was recorded as the lowest in the last 59 months?