Question
To remove all rows from a table without logging individual row deletions and without firing triggers, which command would you typically use?
Solution
`TRUNCATE TABLE table_name;`
More IT DBMS Questions
- HTTPS ensures which of the following?
- Examine the following Java-like code: ```java class Parent { String name = "Parent"; public void display() { Syst...
- Which of the following matches the definition given below: It is an artificial key that aims to uniquely identify each record.
- In a relational schema, which normal form eliminates transitive dependencies (i.e., non-prime attribute depends on another non-prime attribute)?
- A PL/SQL `TRIGGER` is a stored program that automatically executes in response to:
- What will re.findall(r'\d+', 'abc123def45ghi') return?
- A data warehouse is primarily characterized by which of the following properties?
- Which of the following is not part of the process control block (PCB)?
- Query optimization heuristic that “pushes selections down” improves:
- Which normal form ensures that every determinant is a candidate key?