By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） 

第1题：

You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）

• A、The FLASHBACK TABLE statement will not be written to the alert log file.
• B、The changes made to the EMP table since the specified time will be undone.
• C、The EMP table that was dropped by mistake from the database will be restored.
• D、The FLASHBACK TABLE statement will be executed within a single transaction.
• E、The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. 
• F、The list of transactions that have modified the EMP table since the specified time will be displayed.

第2题：

Which two statements are correct regarding the Flashback Versions Query feature？（）

• A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
• B、 You can use this feature to identify the versions of V$ views.
• C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
• D、 You can use this feature for a table only if row movement is enabled for the table.
• E、 You can use this feature to identify the versions of external and fixed tables.

第3题：

You executed this command to create a temporary table：  SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS；  Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction （）

• A、The rows stay in the table only until session termination.
• B、The rows stay in the table only until the next transaction starts on the table.
• C、The rows are visible to all current sessions after the transaction is committed.
• D、The rows stay available for subsequent sessions after the transaction is committed

第4题：

In which scenario will you use the Flashback Version Query feature？（）

• A、 when you want to restore a table that has been dropped from the Recycle Bin
• B、 when you want to identify the transaction ID of the transaction that deleted some important records from a table
• C、 when you want to recover the schema of a dropped user
• D、when you want to restore a dropped tablespace

第5题：

By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） A list of changes made along with the transaction identifier of each change.  b） The necessary SQL statements to undo the erroneous changes.  Which option would you choose？（）

• A、 RMAN only.
• B、 Flashback Table only.
• C、 Flashback Version Query only.
• D、 Flashback Database and Flashback Transaction Query.
• E、 Flashback Version Query and Flashback Transaction Query.

第6题：

At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）

• A、 DBA_PENDING_TRANSACTIONS
• B、 DBA_AUDIT_STATEMENT
• C、 V$FLASHBACK_DATABASE_STATS
• D、 FLASHBACK_TRANSACTION_QUERY

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）

• A、Because row IDs may change during the flashback operation
• B、Because the object number changes after the flashback operation
• C、Because the rows are retrieved from the recycle bin during the flashback operation
• D、Because the table is moved forward and back to a temporary during the flashback opertion

第14题：

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）

• A、ALTER TABLE commercials MODIFY (description CHAR2(2000));
• B、ALTER TABLE commercials CHANGE (description CHAR2(2000));
• C、ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));
• D、ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));
• E、You cannot increase the size of a column if the table has rows.

第15题：

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

• A、 To recover a dropped table.
• B、 To recover a dropped schema.
• C、 To recover data from a truncated table.
• D、 To view changes made by all the transactions during a given period of time.
• E、 To view changes made by a single transaction during a given period of time.

第16题：

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 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

第17题：

You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）

• A、The rows stay in the table only until session termination.
• B、The rows stay in the table only until the next transaction starts on the table.
• C、The rows are visible to all current sessions after the transaction is committed.
• D、The rows stay available for subsequent sessions after the transaction is committed

第18题：

You create a Web application. The Web application enables users to change fields in their personal profiles. Some of the changes are not persisting in the database. You need to raise a custom event to track each change that is made to a user profile so that you can locate the error. Which event should you use?（）

• A、WebAuditEvent
• B、WebEventManager
• C、WebBaseEvent
• D、WebRequestEvent

第19题：

第20题：

第21题：

第22题：

第23题：