单选题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

题目

单选题

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）

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.

更多“单选题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 ”相关问题

第1题

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）A、Restore the backup control file and open the database with RESETLOGS option.B、Perform point-in-time recovery because flashback cannot be performed again on this tableC、Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D、Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

点击查看答案
第2题

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

点击查看答案
第3题

You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.

点击查看答案
第4题

What does the TRUNCATE statement do?（）A、Removes the tableB、Removes all rows from a tableC、Shortens the table to 10 rowsD、Removes all columns from a tableE、Removes foreign keys from a table

点击查看答案
第5题

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

点击查看答案
第6题

You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that： a） No other user data in the database is affected. b） The operation takes the minimum possible time. Which option would you choose？（）A、use the ROLLBACK command with SCN 663571B、perform Flashback Transaction Query with SCN 663571C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

点击查看答案
第7题

User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A、It fails to delete the records because the records are locked in SHARE mode.B、It deletes the rows successfully because the table is locked in SHARE modeC、It fails to delete the records because the table is locked in EXCLUSIVE mode.D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

点击查看答案

单选题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

题目

更多“单选题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 ”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容