CMS专题
单选题What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）A It fails with the ORA-665610 Invalid DDL statement on history-tracked messageB The rows in the table are truncated without being archived.C The
题目
It fails with the ORA-665610 Invalid DDL statement on history-tracked message
The rows in the table are truncated without being archived.
The rows in the table are archived, and then truncated.
The rows in both the table and the archive are truncated.
相似问题和答案
第1题：
关于Truncate table, 以下（）描述是错误的。
- A、Truncate table 可跟Where从句，根据条件进行删除
- B、Truncate table 用来删除表中所有数据
- C、触发器对Truncate table无效
- D、delete 比Truncate table速度快
正确答案:A,D
第2题：
关于Truncatetable，以下（）描述是正确的。
- A、Truncate table 可跟Where从句，根据条件进行删除
- B、Truncate table 用来删除表中所有数据
- C、触发器对Truncate table无效
- D、delete 比Truncate table速度快
正确答案:B,C
第3题：
A.A syntax error will result as you cannot specify more than one partition in the same statement
B.All data in p1 and p3 partitions are removed and the table definition is changed
C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D.Only the first partition (p1) will be dropped as only one can be dropped at any time
第4题：
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
- A、All data along with the table structure is deleted
- B、The pending transaction in the session is committed
- C、All indexes on the table will remain but they are invalidated
- D、All views and synonyms will remain but they are invalidated
- E、All data in the table are deleted but the table structure will remain
正确答案:A,B,D
第5题：
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）
- A、It fails with the ORA-665610 Invalid DDL statement on history-tracked message
- B、The rows in the table are truncated without being archived.
- C、The rows in the table are archived, and then truncated.
- D、The rows in both the table and the archive are truncated.
正确答案:A
第6题：
What does the TRUNCATE statement do?（）
- A、Removes the table
- B、Removes all rows from a table
- C、Shortens the table to 10 rows
- D、Removes all columns from a table
- E、Removes foreign keys from a table
正确答案:B
第7题：
What command with all options and/or parameter will send the signal USR1 to any executing process of program apache2？（）
正确答案:KILLALL-SUSR1APACHE2
第8题：
A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message
B. The rows in the table are truncated without being archived.
C. The rows in the table are archived, and then truncated.
D. The rows in both the table and the archive are truncated.
第9题：
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
- 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
正确答案:A,D,F
第10题：
Which three descriptions are correct about the effects of the TRUNCATE command on a table（）
- A、The corresponding indexes for the table are also truncated.
- B、Delete triggers on the table are fired during the execution of the TRUNCATE command.
- C、The child table is truncated when the TRUNCATE command is applied on the parent table.
- D、The high-water mark （HWM） is set to point to the first usable data block in the table segment.
- E、No undo or very little undo data is generated during the execution of the TRUNCATE command
正确答案:A,D,E