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

In which scenario would para virtualization be preferred over full virtualization?
What is the primary advantage of using a stack in recursive algorithms?
What is the primary purpose of Regression Testing?
Which type of software testing ensures that integrated modules of an application work together as expected?
In an operating system, which of the following scheduling algorithms minimizes the average waiting time for all processes?
In the OSI model, which layer is responsible for the establishment, maintenance, and termination of communication sessions?
Which topology offers the highest fault tolerance and redundancy?
Which of the following page replacement algorithms might lead to Belady’s anomaly, where increasing the number of page frames increases the number of page ...
In software engineering, what is the primary purpose of the software development life cycle (SDLC)?
What will be the output of the following code when printList is called with a linked list containing the values 1 -> 2 -> 3? class Node: def __init__(s...

Hey! Ask a query

ask-question