单选题What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）AIt fails with the ORA-665610 Invalid DDL statement on history-tracked messageBThe rows in the table are truncated without being archived.CThe rows in the table are archived, and then truncated.DThe 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 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.
参考解析
解析：
暂无解析
相关考题：
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;What is the outcome of executing the above statement?() A.A syntax error will result as you cannot specify more than one partition in the same statementB.All data in p1 and p3 partitions are removed and the table definition is changedC.All data in p1 and p3 partitions are removed, but the table definition remains unchangedD.Only the first partition (p1) will be dropped as only one can be dropped at any time
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 rows in the table are archived, and then truncated.D. The rows in both the table and the archive are truncated.
关于Truncate table, 以下（）描述是错误的。A、Truncate table 可跟Where从句，根据条件进行删除B、Truncate table 用来删除表中所有数据C、触发器对Truncate table无效D、delete 比Truncate table速度快
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
关于Truncatetable，以下（）描述是正确的。A、Truncate table 可跟Where从句，根据条件进行删除B、Truncate table 用来删除表中所有数据C、触发器对Truncate table无效D、delete 比Truncate table速度快
What command with all options and/or parameter will send the signal USR1 to any executing process of program apache2？（）
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 rows in the table are archived, and then truncated.D、The rows in both the table and the archive are truncated.
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
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
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
You previously secured your listener with an encrypted password. However， you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility？（）A、 executing the SET PASSWORD command and then the SAVE_CONFIG commandB、 executing the CHANGE_PASSWORD command and then the SAVE_CONFIG commandC、 executing the CHANGE_PASSWORD command and then the SET PASSWORD commandD、 executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the SAVE_CONFIG command
多选题关于Truncate table, 以下（）描述是错误的。ATruncate table 可跟Where从句，根据条件进行删除BTruncate table 用来删除表中所有数据C触发器对Truncate table无效Ddelete 比Truncate table速度快
多选题关于Truncatetable，以下（）描述是正确的。ATruncate table 可跟Where从句，根据条件进行删除BTruncate table 用来删除表中所有数据C触发器对Truncate table无效Ddelete 比Truncate table速度快
单选题You previously secured your listener with an encrypted password. However， you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility？（）A executing the SET PASSWORD command and then the SAVE_CONFIG commandB executing the CHANGE_PASSWORD command and then the SAVE_CONFIG commandC executing the CHANGE_PASSWORD command and then the SET PASSWORD commandD executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the SAVE_CONFIG command
填空题What command with all options and/or parameter will send the signal USR1 to any executing process of program apache2？（）
多选题Evaluate the SQL statement: TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）AIt releases the storage space used by the table.BIt does not release the storage space used by the table.CYou can roll back the deletion of rows after the statement executes.DYou can NOT roll back the deletion of rows after the statement executes.EAn attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.FYou must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.
单选题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？（）Ause the ROLLBACK command with SCN 663571Bperform Flashback Transaction Query with SCN 663571Cexecute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571Dexecute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
单选题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?（）ARestore the backup control file and open the database with RESETLOGS option.BPerform point-in-time recovery because flashback cannot be performed again on this tableCExecute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571DExecute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
多选题You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?（）AAll data along with the table structure is deletedBThe pending transaction in the session is committedCAll indexes on the table will remain but they are invalidatedDAll views and synonyms will remain but they are invalidatedEAll data in the table are deleted but the table structure will remain
单选题You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）AThe database instance is not available.BThe ALTER TABLE command does not have WAIT optionCThe table or a row in the table is currently locked by another user session.DThe database instance is busy processing other user sessions commands.EThe CUSTOMERS table has no long running query active at the time when this request is made.FThe server process executing the ALTER TABLE command is busy with another command execution
单选题What does the TRUNCATE statement do?（）ARemoves the tableBRemoves all rows from a tableCShortens the table to 10 rowsDRemoves all columns from a tableERemoves foreign keys from a table
单选题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?（）AOne of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.BOne of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.CBoth the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.DNone of the tables are recovered from the Recycle Bin, and the statement returns an error.
单选题Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）AA syntax error will result as you cannot specify more than one partition in the same statementBAll data in p1 and p3 partitions are removed and the table definition is changedCAll data in p1 and p3 partitions are removed, but the table definition remains unchangedDOnly the first partition (p1) will be dropped as only one can be dropped at any time
单选题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 ROLLBACK command with SCN 663571.B Perform Flashback Transaction Query with SCN 663571.C Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.D Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table（）AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table is truncated when the TRUNCATE command is applied on the parent table.DThe high-water mark （HWM） is set to point to the first usable data block in the table segment.ENo undo or very little undo data is generated during the execution of the TRUNCATE command