多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the tab

第1题：

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.

第2题：

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；

第3题：

第4题：

Which two operations can be performed on an external table（）

• A、Create a view on the table.
• B、Create an index on the table.
• C、Create a synonym on the table.
• D、Add a virtual column to the table.
• E、Update the table using the UPDATE statement.
• F、Delete rows in the table using the DELETE command.

第5题：

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

• A、UPDATE TABLE
• B、CREATE CLUSTER
• C、TRUNCATE TABLE
• D、ALTER TABLE MOVE
• E、INSERT INTO···VALUES
• F、ALTER TABLE···DROP COLUMN
• G、ALTER TABLE···DROP PARTITION

第6题：

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

• A、ALTER TABLE SPLIT PARTITION
• B、ALTER TABLE MERGE PARTITION
• C、ALTER TABLE TRUNCATE PARTITION
• D、ALTER TABLE ADD PARTITION
• E、ALTER TABLE DROP PARTITION
• F、ALTER TABLE MOVE PARTITION

第7题：

Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)

• A、It's only supported for the backups performed on the tape
• B、It is not supported for backup operations that produce image copies
• C、Duplex backups need a parallelism for the device to be equal to number of copies
• D、Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

第8题：

Which two statements are true regarding views?（）

• A、A subquery that defines a view cannot include the GROUP BY clause 
• B、A view that is created with the subquery having the DISTINCT keyword can be updated 
• C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
• D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

第9题：

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.

第10题：

Which two statements are true about the duplexing of the backups taken by RMAN？（）  

• A、 It’s only supported for the backups performed on the tape
• B、 It is not supported for backup operations that produce image copies
• C、 Duplex backups need a parallelism for the device to be equal to number of copies
• D、 Duplex backups can be performed to either disk or tape， but cannot be performed on tape and disk simultaneously