单选题The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate gr

第1题：

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.

第2题：

The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）

• A、Temporary tables 
• B、Index-organized tables 
• C、Cluster tables 
• D、Standard Oracle tables 

第3题：

第4题：

You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）

• A、It may advise the use of online table redefinition for tables in dictionary managed tablespace.
• B、It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
• C、It may advise the use of online table redefinition for tables in locally managed tablespaces
• D、It will detect and advise about chained rows.
• E、It may advise the use of segment shrink for free list managed tables.

第5题：

The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.

• A、user tables
• B、view segment
• C、table segment
• D、data dictionary
• E、object segment
• F、performance tables

第6题：

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

第7题：

As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）

• A、Coalesce the application tables at a regular interval.
• B、Export and Import the application tables a regular interval.
• C、Drop and recreate the application tables at a regular interval.
• D、Move the application tables to a tablespace with less space usage.
• E、Distribute the application tables across multiple tablespaces depending on usage.
• F、Move the application tables to automatic segment space management tablespace.

第8题：

Which four actions are possible during an Online Data file Move operation?（）

• A、Creating and dropping tables in the data file being moved
• B、Performing file shrink of the data file being moved
• C、Querying tables in the data file being moved
• D、Performing Block Media Recovery for a data block in the data file being moved
• E、Flashing back the database
• F、Executing DML statements on objects stored in the data file being moved

第9题：

In which scenario will you create a sorted hash cluster？ （）

• A、 if the application uses queries joining tables only occasionally
• B、 if the full table scan is executed often on only one table of the clustered tables
• C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
• D、 when you want the data to be returned automatically in the chronological order

第10题：

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

• A、Upgrade the hardware/memory to accommodate the data.
• B、Load the data into your database by using the PARALLEL clause.
• C、Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.
• D、Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.