In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LO

第1题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key.  So what action should you perform to achieve this goal？（）  

• A、You should drop the XML index on the table. Modify the primary key. Recreate the XML index 
• B、You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. 
• C、You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. 
• D、You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.

第2题：

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

• A、A check constraint on the EMPLOYEE table
• B、A unique constraint on the EMPLOYEE table WORKDEPT column
• C、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
• D、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

第3题：

A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）

• A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
• B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.
• C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
• D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

第4题：

You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）

• A、Drop the table.
• B、Partition the table
• C、Truncate the table.
• D、Add a column to the table.
• E、Rename a column in the table.

第5题：

You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

• A、MERGE
• B、SELECT …CROSS JOIN
• C、INSERT ALL …SELECT
• D、CREATE VIEW …CONSTRAINT

第6题：

You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）

• A、a table name which has 100s of records
• B、a table name which has 10s of records
• C、a table name which has empty records
• D、a table name which has 1000s of records
• E、never use a table name

第7题：

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

• A、CHECK
• B、UNIQUE
• C、NOT NULL
• D、PRIMARY KEY
• E、FOREIGN KEY

第8题：

You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）

• A、 column sizes
• B、 column data types
• C、 PCTFREE
• D、 projected number of row
• E、 PCTUSED

第9题：

第10题：

第11题：

第12题：

第13题：

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）

• A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.
• B、Create a CHECK constraint.
• C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
• D、Create a DML AFTER trigger that writes the failed records to a file or table.

第14题：

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data

第15题：

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.

第16题：

In which case would you use a FULL OUTER JOIN?（）

• A、Both tables have NULL values.
• B、You want all unmatched data from one table.
• C、You want all matched data from both tables.
• D、You want all unmatched data from both tables.
• E、One of the tables has more data than the other.
• F、You want all matched and unmatched data from only one table.

第17题：

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

• A、 Drop the table.
• B、 Partition the table.
• C、 Truncate the table.
• D、 Add a column to the table.
• E、 Rename a column in the table.

第18题：

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data.

第19题：

You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

• A、use the external table population
• B、use the Oracle Data Pump export and import utility
• C、use the conventional path data load of SQL*Loader utility
• D、use the direct path data load of Oracle export and import utility

第20题：

第21题：

第22题：

第23题：