When importing a table into a database，the import process performs these tasks：  1. Triggers are imported.  2. Data is imported.  3. New tables are created.  4. Indexes are built.  5. Any bitmap， functional， and/or domain indexes are built.  6. Integrity

第1题：

Given classes defined in two different files：  1. package util；  2. public class BitUtils {  3. private static void process（byte[] b） { }  4. }  1. package app；  2. public class SomeApp {  3. public static void main（String[] args） {  4. byte[] bytes = new byte[256]；  5. // insert code here  6. }  7. }  What is required at line 5 in class SomeApp to use the process method of BitUtils？（） 

• A、 process（bytes）；
• B、 BitUtils.process（bytes）；
• C、 app.BitUtils.process（bytes）；
• D、 util.BitUtils.process（bytes）；
• E、 import util.BitUtils. *； process（bytes）；
• F、 SomeApp cannot use the process method in BitUtils.

第2题：

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）

• A、Oracle Data Pump.
• B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
• C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
• D、Online Table Redefinition.
• E、Edition-Based Table Redefinition.

第3题：

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

第4题：

Case 1：  1. Shut down the database and perform a backup.  2. Restore all the data files.  3. Mount the database.  4. Recover the database.  5. Without applying all the redo log files， open the database using the RESETLOGS option.  6. Back up the database.  Case 2：  1. Shut down the database and perform a backup.  2. Restore only the data files of the tablespace where user error damaged the data.  3. Mount the database. 4. Recover the database.  5. Open the database with the RESETLOGS option.  6. Back up the database.  Case 3：  1. Shut down the database.  2. Restore the data files.  3. Open the database.  4. Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）

• A、 Only case 1
• B、 Only case 2
• C、 Only case 3
• D、 Case 1 and 2
• E、 Case 2 and 3
• F、 Case 1 and 3
• G、 All cases， case 1， case 2， case 3

第5题：

You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

• A、 The index tablespace contains bitmap indexes.
• B、 The index tablespace contains more than one data file.
• C、 The index tablespace supports only complete recovery.
• D、 The index tablespace is not a dictionary-managed tablespace.
• E、 There is a dependency relationship between a table and its indexes.

第6题：

On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）

• A、Only the ORD_CUSTOMER_IX1 index created.
• B、Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
• C、Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
• D、The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
• E、Both the indexes are created and used by the optimizer for queries on the ORDERS table.
• F、Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

第7题：

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.

第8题：

A bitmap join index is defined as（）.

• A、An index used to join two bitmap indexes on a table.
• B、A bitmap index created for the join of two or more tables.
• C、A bitmap index created on the join of two or more indexes.
• D、A bitmap index created on the join of two or more indexed-organized tables.

第9题：

What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）

• A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. 
• B、You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. 
• C、Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. 
• D、Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.

第10题：

第11题：

第12题：

第13题：

Given classes defined in two different files：  1. package util；  2. public class BitUtils {  3. public static void process（byte[]） { /* more code here */ }  4. }  1. package app；  2. public class SomeApp {  3. public static void main（String[] args） {  4. byte[] bytes = new byte[256]；  5. // insert code here  6. }  7. }  What is required at line 5 in class SomeApp to use the process method of BitUtils？（） 

• A、 process（bytes）；
• B、 BitUtils.process（bytes）；
• C、 util.BitUtils.process（bytes）；
• D、 SomeApp cannot use methods in BitUtils.
• E、 import util.BitUtils.*； process（bytes）；

第14题：

Online index rebuild functionality has been extended to include which four index structures？（）

• A、Bitmap indexes.
• B、Reverse key indexes.
• C、Function-based indexes.
• D、Key-compressed indexes on regular tables.
• E、Key-compressed indexes on IOT （including secondary indexes）

第15题：

You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）

• A、It exports tables with the most indexes first to assist with import speeds
• B、It ensures that unique indexes have no conflicts when the data is dumped
• C、It orders by primary key to assist in speeding up importing to InnoDB tables
• D、It must be specified so index data is dumped correctly when  –on-create-info is used

第16题：

You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime recovery on the index tablespace. What could be the reason for this？（）

• A、The index tablespace contains bitmap indexes.
• B、The index tablespace contains more than one data file.
• C、The index tablespace supports only complete recovery.
• D、The index tablespace is not a dictionary­managed tablespace.
• E、There is a dependency relationship between a table and its indexes.

第17题：

Which three descriptions are correct about the effects of the TRUNCATE command on a table（）

• A、The corresponding indexes for the table are also truncated.
• B、Delete triggers on the table are fired during the execution of the TRUNCATE command.
• C、The child table is truncated when the TRUNCATE command is applied on the parent table.
• D、The high-water mark （HWM） is set to point to the first usable data block in the table segment.
• E、No undo or very little undo data is generated during the execution of the TRUNCATE command

第18题：

You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it.  What action is required for dependent objects when you perform online table redefinition？（）  

• A、 The dependent materialized view should have a complete refresh performed after the online table redefinition process.
• B、 Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
• C、 Referential integrity constraints must be manually enabled after the online table redefinition process.
• D、 The materialized log should be dropped before the online table redefinition process.

第19题：

Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）

• A、INDEXES
• B、SKIP_INDEXES_MAINTENANCE
• C、SKIP_UNUSABLE_INDEXES
• D、RESUMABLE
• E、INDEXES_UNUSABLE

第20题：

A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）

• A、 Create a database view to retrieve the data.
• B、 Use a clustered index on the SQL Azure database tables.
• C、 Open a new database connection when an operation times out.
• D、 Create SQL Azure database table indexes basedon application queries

第21题：

第22题：

第23题：