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.
Which statement is not correct about Small Finance Bank (SFB)-
(A) SFB can provide savings vehicles to unbanked and under-banked public
(B...
National Bank for Agriculture and Rural Development (NABARD) was formed on the recommendations of which committee?
What is the minimum investment grade credit rating required for Housing Finance Companies (HFCs) to accept public deposits in India?
Which Section of RBI Act, 1934 provides for an empowered six-member monetary policy committee (MPC) to be constituted by the Central Government?
Financial Action Task Force (on Money Laundering) headquartered in which city?
Consider the following statement about Monetary Policy Committee (MPC):
1. The first such MPC was constituted on September 29, 2016.
2. Go...
SEBI gave its final Nod to _______for Trading in Electronic Gold Receipt?
which of the following was the last country to join the World Bank?
Who among the following National leader was not a PNB's founder?
Asian Development Bank (ADB) is a regional development bank established in which year?