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

Which of the following is not a method of inter-process communication (IPC) in modern operating systems?
What kind of attack involves an overwhelming number of requests sent to a server to disrupt its normal operations?
Abstract Class in Java
Which of the following best describes supervised learning in machine learning?
Which CPU scheduling algorithm is considered optimal for minimizing the average waiting time in cases where process execution times are known in advance?
Which component of a Management Information System (MIS) focuses on long-term strategic planning?
Which of the following best describes the ACID properties in the context of transactions in a database?
Recursion uses
Which of the following types of networks is most suitable for securely connecting geographically distant branches of a multinational company, while ensurin...
What is the main advantage of using Classless Inter-Domain Routing (CIDR) over traditional class-based IP addressing?

Hey! Ask a query

ask-question