Which two operations can be flashed back using the Flashback

第1题：

第2题：

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）

• A、An upper limit on how far you can flash back the database, depending on the information in the redo logs
• B、An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
• C、The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
• D、The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space

第3题：

第4题：

On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）

• A、 by using Oracle Enterprise Manager
• B、 by issuing the FLASHBACK TABLE statement at the RMAN prompt
• C、 by issuing the FLASHBACK TABLE statement at the SQL prompt
• D、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

第5题：

You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）

• A、 RESETLOGS
• B、 TO TIMESTAMP
• C、 TO BEFORE DROP
• D、 RENAME TO
• E、 TO SCN

第6题：

Which two client requests are captured during database replay Capture?（）

• A、Flashback queries
• B、Shared server requests
• C、Login and logoff activities of sessions
• D、Direct path load of data from external files by using utilities such as SQL *loader
• E、Data definition language (DDL) and data manipulation language (DML) operations

第7题：

Which three tasks can be performed using regular expression support in Oracle Database 10g？（）

• A、 it can be used to concatenate two strings.
• B、 it can be used to find out the total length of the string.
• C、 it can be used for string manipulation and searching operations.
• D、 it can be used to format the output for a column or expression having string data.
• E、 it can be used to find and replace operations for a column or expression having string data.

第8题：

第9题：

Which three statements are true about using flashback database in a multitenant container database(CDB)?（）

• A、The root container can be flashed back without flashing back the pluggable databases (PDBs).
• B、To enable flashback database, the CDB must be mounted.
• C、Individual PDBs can be flashed back without flashing back the entire cdb.
• D、The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
• E、A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

第10题：

Which two operations can be flashed back using the Flashback technology？（）

• A、DROP USER SMITH；
• B、DROP TABLE EMPLOYEES；
• C、DROP TABLESPACE USERS；
• D、ALTER TABLE SALES_REP DROP PARTITION P1；
• E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；