Examine this command:
TRUNCATE TABLE test;
Table truncated.
Which two are true? (Choose two.)
Examine this command:
TRUNCATE TABLE test;
Table truncated.
Which two are true? (Choose two.)
When you execute the TRUNCATE TABLE command, all rows in the table are removed, and the action cannot be undone using the ROLLBACK command. The table structure, including indexes and constraints, remains intact.
DE should be the correct answer
D y E son correctas.
DE ARE CORRECT
DE are correct
DE are correct
DE are correct.
https://docs.oracle.com/database/121/SQLRF/statements_10007.htm#SQLRF01707 DE is correct answer
DE is correct A. The structure of the TEST table is removed. wrong, only content will get removed B. All the indexes on the TEST table are dropped. indexes will stay C. All the constraints on the TEST table are dropped. wrong D. Removed rows can not be recovered using the ROLLBACK command. true E. All the rows in the TEST table are removed. true
DE are correct
The structure of the TEST table is still available. It is dropped only when drop the table
I think instead of TRUNCATE command DROP should be use to get option A and C as answers
DE is the answer
D and E are the correct answers.
"D" and "E" are correct.
DE Correct Answer
DE is correct
DE is correct