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

第1题：

第2题：

You are the administrator of a Windows 2000 network. You use a user account named Hans1 to log on to a Windows 2000 Professional computer named Company1 that is used by different students in a classroom. Hans1 is a user with administrative rights. Another administrator has created a command file named AddUsers.cmd that automatically adds student user accounts. You have scheduled a task on Company1 to run AddUsers.cmd later in the evening. The next day you find that the job did not run. There are no errors reported in the Event Log. You want to schedule a task to successfully run AddUsers.cmd.  What should you do? （）

• A、Configure the Task Scheduler service to run under an Administrative account.
• B、Log on by using the local Administrator account. Then schedule the task to run under Hans1. 
• C、Take ownership of AddUsers.cmd. Then schedule the task to run under Hans1.
• D、Grant Hans1 Read & Execute permission for AddUsers.cmd. Then schedule the task to run under Hans1.

第3题：

You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）  

• A、 Data Pump Export and Import
• B、 conventional export and import
• C、 the CONVERT command of RMAN
• D、 the BACKUP AS COPY. command of RMAN

第4题：

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

第5题：

You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）

• A、 DBA_SCHEDULER_JOB_RUN_DETAILS
• B、 DBA_SCHEDULER_RUNNING_JOBS
• C、 DBA_SCHEDULER_JOBS
• D、 DBA_SCHEDULER_JOB_LOG

第6题：

You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）

• A、 Window
• B、 Program
• C、 Job class
• D、 Window group

第7题：

You are the administrator of your company's network. You are preparing to deploy 20 new Windows 2000 Professional computers on your network. You want to be able to recover from disk failures and corrupt system files on the new computers. You want to configure the computers to automatically update their system configuration and emergency repair files on a scheduled bases.   What should you do?（）

• A、Use the at command to schedule a weekly job to back up the boot partition.
• B、Use the at command to schedule a weekly job to run the system file checker.
• C、Use Windows backup to schedule a backup of the System State Data.
• D、Use Windows backup to schedule a backup of the system partition and the boot partition.

第8题：

You are the network administrator for You manage a Windows Server 2003 computer named TestKing1. There are multiple scheduled tasks configure on TestKing1. One task is a scheduled backup job. You need to temporarily disable the backup job from running so that you can troubleshoot a problem. You must not interfere with any other scheduled tasks. You need to disable the scheduled backup job. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）

• A、Pause the Task Scheduler service.
• B、Delete the scheduled backup job. Re-create the backup after you finish troubleshooting.
• C、Modify the properties of the scheduled backup job and clear the Enabled check box.
• D、Run the ntbackup /p command on the server.

第9题：

第10题：

第11题：

第12题：

第13题：

In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）

• A、Window
• B、Program
• C、Job class
• D、Window group

第14题：

You issued the following command：        SQL> DROP TABLE MYTABLE；        SQL> SHOW RECYCLEBIN  The following output is returned：        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13：20：11：31  You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）

• A、 DROP TABLE MYTABLE PURGE；
• B、 PURGE RECYCLEBIN；
• C、 PURGE TABLE MYTABLE；
• D、 PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

第15题：

You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?（）

• A、Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
• B、Execute the PURGE BINARY LOGE NOT USED command
• C、Remove all of the binary log files that have a modification date earlier than today
• D、Edit the .index file to remove the files you want to delete
• E、Ensure that none of the attached slaves are using any of the binary logs you want to delete

第16题：

You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）

• A、2，1，4，3，5，6
• B、1，4，3，2，6，5
• C、1，4，2，6，3，5
• D、3，2，1，4，5，6

第17题：

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

第18题：

You are the administrator of a Windows 2000 network. You use a user account named User1 to log on to a Windows 2000 Professional computer. Different students in a classroom use this Computer. User does not have administrative rights. However， you prefer to use this account for most of your daily activities， because it is not a security breach if you fail to log off. You want to schedule a task to run a command file named AddUsers.cmd that automatically adds six more student user accounts. What should you do？（）

• A、Schedule the task to run under an Administrative account
• B、Log on by using the local Administrator account. Then schedule the task to run under User1
• C、Take the ownership of Addusers.cmd file. Then schedule the task to run under User1
• D、Grant User1 Read & Execute permission for AddUsers.cmd. Then schedule the task to run  under User1.

第19题：

You are a network administrator for ExamSheet.net's Windows 2000 network.  You use a user account named User1 to log on tot a Windows 2000 Professional computer. The computer is used by different students in a classroom. User1 does not have administrative rights. However, you prefer to use this account for your daily activities. Using the Task Scheduler you schedule a task to run a command file named AddUsers.cmd that automatically adds six more student user accounts. You configure the task to run as the administrator account.  After the task was scheduled to have run you open the Task Scheduler and discover a status of "Could not start" for the task. You also discover account logon failure audit events in the computer's Security log.You want the scheduled task to successfully run AddUsers.cmd. You want to accomplish this with the least amount of administrative effort.  What should you do?（）

• A、Schedule the task using theATcommand.
• B、Reenter the password for the administrator account using the Task Scheduler.
• C、Log on with an administrative account and reschedule the task.
• D、Log on by using the local Administrator account. Then schedule the task to run under User1.

第20题：

第21题：

第22题：

第23题：