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

功能最强也是最复杂的SQL语句是（）。

• A、Insert语句
• B、Select语句
• C、Update语句
• D、Delete语句

第2题：

SQL的DML包括的语句有（）。

• A、ROLLBACK，COMMIT
• B、CREATE，DROP，ALTER
• C、GRANT，REVOKE
• D、SELECT，INSERT，DELETE，UPDATE

第3题：

正确答案：D

第4题：

Which object privileges can be granted on a view? （）

• A、none
• B、DELETE, INSERT,SELECT
• C、ALTER, DELETE, INSERT, SELECT
• D、DELETE, INSERT, SELECT, UPDATE

第5题：

You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

• A、 It would return information regarding only the last committed transaction.
• B、 It would return only the active transactions in all the undo segments in the database.
• C、 It would return only the committed transactions in all the undo segments in the database.
• D、 It would return both active and committed transactions in all the undo segments in the database.
• E、 It would return information regarding the transactions that began and were committed in the last 30 minutes.

第6题：

A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled.  What are the twoeffects of this command（）

• A、It fails if any existing row violates the constraint.
• B、It does not validate the existing data in the table.
• C、It enables the constraint to be enforced at the end of each transaction.
• D、It prevents insert， update， and delete operations on the table while the constraint is in the process of beingenabled

第7题：

Which of the following is the correct procedure to update the BIOS on LS42 blades without using the AMM?（）

• A、Insert the Update eXpress Service Pack Installer (UXSPI) CD, boot the LS42 blade and follow the prompts 
• B、Boot the blade to the Bootable Media Creator (BoMC) CD and follow the prompts 
• C、Press F1 when the LS42 system is booting, select Update BIOS, insert the diskette into the diskette drive, and select OK 
• D、Use the Remote Supervisor Adapter virtual disk

第8题：

第9题：

Which two operations require undo data？（）

• A、committing a transaction
• B、rolling back a transaction
• C、recovering from failed transactions
• D、recording a transaction to redo log files
• E、rolling forward during instance recovery

第10题：

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 manager
• B、GRANT select, insert, update ON student_grades TO ROLE manager
• C、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;