单选题Identify the logical structure that will never have more than one data segment created for it.（）A external tableB partitioned tableC partitioned indexD nonclustered tableE global temporary table

第1题：

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.

第2题：

Which of the following are not BGRP data structures？ （Choose all that apply.）（）

• A、EIGRP database table
• B、EIGRP CEF table
• C、EIGRP neighbor table
• D、EIGRP adjacency table
• E、EIGRP interface table
• F、EIGRP topology table

第3题：

You executed the following code：   SQL> CERATE TABLE COUNTRY   （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，   COUNTRY_NAME VARCHAR2（20），   CURRENCY_NAME VARCHAR2（20），   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））   ORGANIZATION INDEX；   Which types of tables will be created automatically？（）

• A、 journal table
• B、 clustered table
• C、 mapping table
• D、 partitioned table

第4题：

Which  statements are correct about temporary tables（）

• A、Indexes and views can be created on temporary tables.
• B、Both the data and the structure of temporary tables can be exported.
• C、Temporary tables are always created in a user’s temporary tablespace.
• D、The data inserted into a temporary table in a session is available to other sessions.
• E、Data manipulation language （DML） locks are never acquired on the data of temporary tables

第5题：

A data manipulation language statement （）.

• A、completes a transaction on a table
• B、modifies the structure and data in a table
• C、modifies the data but not the structure of a table
• D、modifies the structure but not the data of a table

第6题：

While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

• A、the CREATE TABLE .. command
• B、sorting of the SYSTEM tablespace’s data
• C、sorting of data required by recursive SQL statements
• D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
• E、sorting of data if the users have not been allocated temporary tablespace explicitly
• F、sorting of data if the users have been allocated temporary tablespace explicitly

第7题：

Which three statements are true regarding the logical structure of the Oracle database？（）

• A、Each segment contains one or more extents.
• B、Multiple tablespaces can share single data file.
• C、A data block is the smallest unit of I/O for data files.
• D、It is possible to have tablespaces of different block sizes in a database.
• E、Each data block in the database always corresponds to one OS block.

第8题：

You are designing an application that will use Windows Azure Table storage to store millions of data points each day.  The application must retain each day’s data for only one week.   You need to recommend an approach for minimizing storage transactions.  What should you recommend？（）

• A、 Use a separate table for each date.  Delete eachtable when it is one week old.
• B、 Use a separate table for each week.  Delete each table when it is one week old.
• C、 Use a single table， partitioned by date.  Use Entity Group Transactions to delete data when it is one week old.
• D、 Use a single table， partitioned by week.  Use Entity Group Transactions to delete data when it is one week old.

第9题：

第10题：

第11题：

第12题：

第13题：

In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

• A、heap table
• B、object table
• C、external table
• D、clustered table
• E、global temporary table
• F、index­organized table （IOT）

第14题：

In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

• A、export and import the mapping table
• B、drop and re­create the mapping table
• C、truncate the mapping table and reinsert the values
• D、use the ALTER TABLE .. REBUILD command to defragment the mapping table

第15题：

In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

• A、heap table
• B、object table
• C、external table
• D、clustered table
• E、global temporary table
• F、index-organized table （IOT）

第16题：

Identify the logical structure that will never have more than one data segment created for it.（）

• A、external table
• B、partitioned table
• C、partitioned index
• D、nonclustered table
• E、global temporary table

第17题：

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

第18题：

Which three statements are correct about temporary tables？（）

• A、Indexes and views can be created on temporary tables.
• B、Both the data and the structure of temporary tables can be exported.
• C、Temporary tables are always created in a user’s temporary tablespace.
• D、The data inserted into a temporary table in a session is available to other sessions.
• E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.

第19题：

Which three operations can be performed as multipartition operations in Oracle?（）

• A、Merge partitions of a list partitioned table
• B、Drop partitions of a list partitioned table
• C、Coalesce partitions of a hash-partitioned global index.
• D、Move partitions of a range-partitioned table
• E、Rename partitions of a range partitioned table
• F、Merge partitions of a reference partitioned index

第20题：

第21题：

第22题：

第23题：

第24题：