Question
Which command removes all rows but keeps table
structure?Solution
TRUNCATE clears rows but keeps structure. DROP removes table entirely.
More SQL Questions
What is referential integrity?
Which deadlock prevention scheme allows older transactions to preempt younger ones?
In an E-R Diagram, entities are typically represented by:
In PL/SQL, a `CURSOR` is used to:
A system is in a safe state when:
Which database model represents data in a tree-like structure, where each child record has only one parent?
A "diamond" shape in an E-R Diagram typically represents a:
Distributed transactions typically use which protocol for atomicity?
Which normal form ensures no partial dependency of non-prime attributes on a candidate key?
Which of the following is a non-relational database?
