Login / Signup

Question

Truncate command in SQL

A TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes, and so on remain.

B The working of truncate command is similar to the working of Delete command without a where clause.

C TRUNCATE TABLE tablename;

D Both 1 and 2 are correct

E All are correct

Practice Next

More Basics of Computers Questions

The important aspect of data warehouse environment is that data found within the data warehouse is
In Black Box Testing, which of the following is the primary focus?
Which of the following conditions is NOT required for a deadlock to occur?
Which is/are correct w.r.t Passive attacks
What is the primary advantage of using localStorage in HTML5 over cookies?
Which of the following is an example of Polymorphism in Object-Oriented Programming?
Which firewall type inspects packets at all layers of the OSI model to ensure complete protection?
Graph Traversal algorithms
Which of the following is not a method of inter-process communication (IPC) in modern operating systems?
Which of the following virtualization types allows multiple operating systems to run concurrently on a single physical machine, but does not require a hype...

Hey! Ask a query

ask-question