The corresponding indexes for the table are also truncated.
Delete triggers on the table are fired during the execution of the TRUNCATE command.
The child table is truncated when the TRUNCATE command is applied on the parent table.
The high-water mark （HWM） is set to point to the first usable data block in the table segment.
No undo or very little undo data is generated during the execution of the TRUNCATE command
第1题：
A. It releases the storage space used by the table.
B. It does not release the storage space used by the table.
C. You can roll back the deletion of rows after the statement executes.
D. You can NOT roll back the deletion of rows after the statement executes.
E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
第2题：
关于Truncate table, 以下（）描述是错误的。
第3题：
View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）
A. An error is produced.
B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
第4题：
You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）
第5题：
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）
第6题：
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
C. VPD policies are copied from the original table to the new table during online redefinition.
D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
第7题：
关于Truncatetable，以下（）描述是正确的。
第8题：
A. Drop the table.
B. Partition the table
C. Truncate the table.
D. Add a column to the table.
E. Rename a column in the table.
第9题：
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）
第10题：
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）