单选题Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）A INSERT B SELECT C UPDATE D DELETE

题目

单选题

Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）

INSERT

SELECT

UPDATE

DELETE

更多“单选题Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）A INSERT B SELECT C UPDATE D DELETE”相关问题

第1题

Which two operations require undo data？（）A、committing a transactionB、rolling back a transactionC、recovering from failed transactionsD、recording a transaction to redo log filesE、rolling forward during instance recovery

点击查看答案
第2题

Which object privileges can be granted on a view? （）A、noneB、DELETE, INSERT,SELECTC、ALTER, DELETE, INSERT, SELECTD、DELETE, INSERT, SELECT, UPDATE

点击查看答案
第3题

You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? （）A、GRANT select, insert, update ON student_grades TO managerB、GRANT select, insert, update ON student_grades TO ROLE managerC、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION; F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;

点击查看答案
第4题

Which two statements are true regarding transactions in an Oracle database（）A、Multiple transactions can use the same undo segment.B、A transaction is assigned an undo segment when it is started.C、More than one transaction cannot share the same extent in the undo tablespace.D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

点击查看答案
第5题

Which of the following Oracle features utilize the undo tablespace？（） A、 Flashback QueryB、 Flashback DropC、 Flashback TableD、 Flashback DatabaseE、 Transaction ProcessingF、 Recycle Bin

点击查看答案
第6题

You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）A、Set the UNDO_RETENTION parameter to 900 or more.B、Create an initial undo segment in the undo tablespace.C、Enable the retention guarantee for the undo tablespace.D、Set the UNDO_TABLESPACE parameter to UNDO_TBS1.E、Set the UNDO_MANAGEMENT initialization parameter to AUTO.

点击查看答案
第7题

Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）A、INSERT B、SELECT C、UPDATE D、DELETE

点击查看答案

单选题Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）A INSERT B SELECT C UPDATE D DELETE

题目

更多“单选题Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）A INSERT B SELECT C UPDATE D DELETE”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容