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.
पशु- पांशु-पण ' का क्रमशः सही अर्थ प्रकट करने वाला शब्द ...
इनमें से किस शब्द की वर्तनी अशुद्ध है ?
संधि कितने प्रकार की होती है।
अनुचित वाक्य छाँटिए—
'परिश्रमी' किस प्रकार का विशेषण है?
संधि पूर्ण करें -
जलद का अर्थ ___________ है।
'हुताशन' पर्यायवाची है-
'पीतांबर' में कौन-सा समास है?
वर्तनी की दृष्टि से शुद्ध शब्द है -
स्वर ए - ऐ का उच्चारण स्थान कौन सा है ?