单选题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的DML包括的语句有（）。

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

第2题：

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.

第3题：

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

第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题：

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.

第6题：

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：  SQL> SELECT job FROM emp  2  WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）

• A、LOCK TABLE emp IN SHARE MODE;
• B、LOCK TABLE emp IN EXCLUSIVE MODE;
• C、DELETE FROM emp WHERE job=’MANAGER’;
• D、INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;
• E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

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;

第16题：

Which of the following Oracle features utilize the undo tablespace？（） 

• A、 Flashback Query
• B、 Flashback Drop
• C、 Flashback Table
• D、 Flashback Database
• E、 Transaction Processing
• F、 Recycle Bin

第17题：

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

第18题：

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;

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：