单选题Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）A A syntax error will result as you cannot specify more than one partition in the same state

第1题：

第2题：

Which is a restriction on a list partitioned table？（）

• A、You cannot create global range partitioned indexes on the table. 
• B、The optimizer will not execute partition wise joins on the table’s partitions. 
• C、You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. 
• D、Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.

第3题：

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL> EXECUTE  DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）；   You need statistics to be collected more quickly.  What can you do to achieve this？（）

• A、 Set DYNAMIC_SAMPLING to level 4
• B、 Set the STATISTICS_LEVEL parameter to BASIC
• C、 Set the INCREMENTAL value to TRUE for the partition table
• D、 Increase the value of STALE_PERCENT for the partition table

第4题：

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；

第5题：

You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）

• A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
• B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
• C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
• D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.

第6题：

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）

• A、A syntax error will result as you cannot specify more than one partition in the same statement
• B、All data in p1 and p3 partitions are removed and the table definition is changed
• C、All data in p1 and p3 partitions are removed, but the table definition remains unchanged
• D、Only the first partition (p1) will be dropped as only one can be dropped at any time

第7题：

Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）  

• A、 It executes successfully but partition pruning cannot happen for this partition key.
• B、 It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
• C、 It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 
• D、 It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You need to create a partitioned table to store historical data and you issued the following command：   CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL （NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3） （ PARTITION p1 VALUES LESS THAN（TO_DATE（’1-1-2005’， ’dd-mm-yyyy’））， PARTITION p2 VALUES LESS THAN（TO_DATE（’1-1- 2007’， ’dd-mm-yyyy’）））  AS SELECT * FROM purchases WHERE time_id < TO_DATE（’1-1-2007’，’dd-mm-yyyy’）；   What is the outcome of the above command？（）  

• A、 It returns an error because the range partitions P1 and P2 should be of the same range.
• B、 It creates two range partitions （P1， P2）. Within each range partition， it creates monthwise subpartitions.
• C、 It creates two range partitions of varying range. For data beyond ’1-1-2007，’ it creates partitions with a width of one month each.
• D、 It returns an error because the number of tablespaces （TBS1，TBS2，TBS3）specified does not match the number of range partitions （P1，P2） specified.

第14题：

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

第15题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

• A、Immediately following statement execution 
• B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
• C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
• D、After the ALTER TABLE MODIFY command is issued

第16题：

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

第17题：

Which statements are true regarding system-partitioned tables？（）  

• A、 Only a single partitioning key column can be specified.
• B、 All DML statements must use partition-extended syntax.
• C、 The same physical attributes must be specified for each partition.
• D、 Unique local indexes cannot be created on a system-partitioned table.
• E、 Traditional partition pruning and partitionwise joins are not supported on these tables.

第18题：

You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）  

• A、 The statement will fail.
• B、 The statement will be executed successfully， and the new time zone will be set for the database.
• C、 The statement will be executed successfully， but the new time zone will be set for the current session.
• D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：