In which two cases would you use

第1题：

In which three cases would you use the USING clause?（）

• A、You want to create a nonequijoin.
• B、The tables to be joined have multiple NULL columns.
• C、The tables to be joined have columns of the same name and different data types.
• D、The tables to be joined have columns with the same name and compatible data types.
• E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

第2题：

You have two NTP servers 10.1.1.1 & 10.1.1.2 and want to configure a router to use 10.1.1.2 as its NTP server before falling back to 10.1.1.1. Which command will you use？

第3题：

第4题：

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

• A、 use DBMS_IJOB package
• B、 use Oracle Scheduler
• C、 use DBMS_JOB package
• D、 use Oracle Data Pump Export and Import

第5题：

You are designing an n-tier Java EE application. You have already decided that some of your JSPs willneed to get data from a Customer entity bean. You are trying to decide whether to use a Customer stubobject or a Transfer Object. Which two statements are true？（）

• A、The stub will increase network traffic.
• B、The Transfer Object will decrease data staleness.
• C、The stub will increase the logic necessary in the JSPs.
• D、In both cases， the JSPs can use EL expressions to get data.
• E、Only the Transfer Object will need to use a Business Delegate.

第6题：

In which two cases would you use an outer join? （）

• A、The tables being joined have NOT NULL columns.
• B、The tables being joined have only matched data.
• C、The columns being joined have NULL values.
• D、The tables being joined have only unmatched data.
• E、The tables being joined have both matched and unmatched data.
• F、Only when the tables have a primary key-foreign key relationship.

第7题：

Which command （without options） would you use to display how much space is available on all mounted partitions？（）

第8题：

第9题：

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）

• A、ONLINE
• B、REVERSE
• C、PARALLEL
• D、COMPRESS
• E、NOLOGGING
• F、COMPUTE STATISTICS

第10题：

You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

• A、use enterprise manager
• B、use DBMS_SQL package
• C、use DBMS_AWR package
• D、use PRVT_WORKLOAD package
• E、query the AWR snapshot repository objects
• F、use DBMS_WORKLOAD_REPOSITORY package