Which of the following SQL*Loader parameters enables you to 

第1题：

You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

• A、The Automatic Memory Manager (AMM)
• B、The SQL Tuning Advisor
• C、The Segment Advisor
• D、The SQL Access Advisor SQL

第2题：

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

• A、’SQL ALTER DATABASE OPEN’；
• B、SQL ALTER DATABASE ’OPEN’；
• C、OPEN DATABASE；
• D、DATABASE OPEN

第3题：

第4题：

To enable resumable space allocation for the instance， which of the following initialization parameters should you set to a nonzero value？（）

• A、 RESUMABLE_SPACE_TIME
• B、 RESUMABLE_SPACE
• C、 RESUMABLE_TIME
• D、 RESUMABLE_TIMEOUT
• E、 TIME_RESUMABLE

第5题：

You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

• A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
• B、 executing a long query that involves a sort operation and the statement runs out of temporary space
• C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
• D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

第6题：

SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）

• A、direct-path load
• B、conventional path load

第7题：

Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）

• A、An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
• B、The SQL* Loader data file myfile1.dat has the column names for the EMP table.
• C、The SQL* Loader operation fails because no record terminators are specified.
• D、Field names should be the first line in the both the SQL* Loader data files.
• E、The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

第8题：

第9题：

Identify four uses of the Oracle Scheduler.（）

• A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
• B、 enables Oracle database to do patches according to a DBA-defined schedule
• C、 enables you to schedule the execution of jobs based on time
• D、 enables you to execute jobs in a clustered environment
• E、 enables you to periodically execute operating systemscript files located on the same server as the database
• F、 enables you to create a job that makes use of saved programs and schedules
• G、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

第10题：

Which two SQL*Loader instructions are used to assemble logical records？（）

• A、WHEN
• B、INFILE
• C、CONTINUEIF
• D、CONCATENATE
• E、TRAILING NULLCOLS