单选题When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）A SET_JOB_ARGUMENT_VALUEB SET_JOB_VALUE_ANYDATAC SET_JOB_ANYDATA_VALUED SET_SPECIAL_JOB_VALUEE SET_JOB_ANYTYPE_

第1题：

You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）  

• A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；
• B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；
• C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；
• D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；

第2题：

The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）

• A、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';
• B、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
• C、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "/";
• D、SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

第3题：

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

第4题：

When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）

• A、SET_JOB_ARGUMENT_VALUE
• B、SET_JOB_VALUE_ANYDATA
• C、SET_JOB_ANYDATA_VALUE
• D、SET_SPECIAL_JOB_VALUE
• E、SET_JOB_ANYTYPE_VALUE

第5题：

You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）

• A、 LOGGING_OFF
• B、 LOGGING_RUNS
• C、 LOGGING_FULL
• D、 LOGGING_NULL

第6题：

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 stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed.  What should you do？ （）

• A、You should create a job which is assigned to the Database Maintenance category
• B、You should create an Alert which will run another to delete the maintenance job.
• C、You should create a job. You schedule the job to run only once.
• D、You should create a job. The job uses the Automatically delete job option

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are setting up a Junos Pulse Access Control Service. You cannot obtain a device certificate from an external certificate authority.Which tool should you use to generate a device certificate?（）

• A、OpenSSL
• B、OpenSSH
• C、OpenLDAP
• D、OpenRADIUS

第14题：

In which scenario do you use the Flashback Database feature？（）

• A、 when a table is dropped and you restore it from the Recycle Bin
• B、 when a user’s schema is dropped and you recover the user’s schema
• C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
• D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

第15题：

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

• A、run a procedure to check the tablespace space usage
• B、define the warning threshold for the tablespace at 75% in Database Control
• C、create a trigger to be executed when tablespace space usage reaches 75%
• D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
• E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

第16题：

How are messages displayed when you use the SRW.MESSAGE packaged procedure? （）

• A、Dialogue box that implicitly determines report execution. 
• B、Message line that implicitly determines report execution. 
• C、Message line that suppresses the default oracle message. 
• D、Dialogue box that does not terminate report execution. 
• E、Dialogue box that suppresses the default oracle message.

第17题：

You work in a company which is named Wiikigo Corp. The company 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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

• A、You should use local Service account
• B、You should use network Service account
• C、You should use domain account
• D、You should use local System account

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：