0 votes
in Oracle by

Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:

(a) TRUNCATE command

(b) Create command

(c) Drop table command

(d) Alter table command

1 Answer

0 votes
by

Right choice is (a) TRUNCATE command

Easy explanation: The SQL TRUNCATE TABLE command is used to delete complete data from an existing table.You can also use DROP TABLE command to delete complete table but it would remove complete table structure form the database and you would need to re-create this table once again if you wish you store some data.

Related questions

0 votes
asked Nov 25, 2021 in Oracle by DavidAnderson
0 votes
asked Nov 25, 2021 in Oracle by DavidAnderson
...