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’）；
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’）；
相关考题：
You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.What should you do?A．Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails.B．Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails.C．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.D．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.
Youwanttopurgejobentriesolderthan5daysfromthejoblog.Youdonotwanttopurgewindowlogentries.Whichcommandwillyouusetoaccomplishthistask?() A.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，job_name=’JOB1’）；B.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，job_name=’JOB_LOG’）；C.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，which_log=’JOB1’）；D.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，which_log=’JOB_LOG’）；
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 filesB.Execute the PURGE BINARY LOGE NOT USED commandC.Remove all of the binary log files that have a modification date earlier than todayD.Edit the .index file to remove the files you want to deleteE.Ensure that none of the attached slaves are using any of the binary logs you want to delete
Another aspect of C that's worth mentioning here is that it is, to put it bluntly, a bit dangerous. C does not, in general, try hard to protect a programmer from mistakes. If you write a piece of(66)which will(through some oversight of yours)do something wildly different from what you intended it to do, up to and including(67)your(68)or trashing your(69), and if it is possible for the(70)to compile it, it generally will. You wont get warnings of the form. "Do you really mean to... ?" or "Are you sure you really want to... ?". C is often compared to a sharp knife :' it can do a surgically precise job on some exacting task you have in mind, but it can also do a surgically precise job of cutting off your finger. It's up to you to use it carefully.A．wordB．codeC．sentenceD．character
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?A．Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.B．Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.C．Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system accountD．Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
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、WindowB、ProgramC、Job classD、Window group
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.
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；
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 ImportB、 conventional export and importC、 the CONVERT command of RMAND、 the BACKUP AS COPY. command of RMAN
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 filesB、Execute the PURGE BINARY LOGE NOT USED commandC、Remove all of the binary log files that have a modification date earlier than todayD、Edit the .index file to remove the files you want to deleteE、Ensure that none of the attached slaves are using any of the binary logs you want to delete
Identify four uses of the Oracle Scheduler.（）A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentB、 enables Oracle database to do patches according to a DBA-defined scheduleC、 enables you to schedule the execution of jobs based on timeD、 enables you to execute jobs in a clustered environmentE、 enables you to periodically execute operating systemscript files located on the same server as the databaseF、 enables you to create a job that makes use of saved programs and schedulesG、 enables you to automate the management of the jobs that are created using the DBMS_JOB package
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，6B、1，4，3，2，6，5C、1，4，2，6，3，5D、3，2，1，4，5，6
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_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
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_OFFB、 LOGGING_RUNSC、 LOGGING_FULLD、 LOGGING_NULL
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、 WindowB、 ProgramC、 Job classD、 Window group
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 accountB、Log on by using the local Administrator account. Then schedule the task to run under User1C、Take the ownership of Addusers.cmd file. Then schedule the task to run under User1D、Grant User1 Read Execute permission for AddUsers.cmd. Then schedule the task to run under User1.
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.
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.
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.
单选题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? （）AConfigure the Task Scheduler service to run under an Administrative account.BLog on by using the local Administrator account. Then schedule the task to run under Hans1. CTake ownership of AddUsers.cmd. Then schedule the task to run under Hans1.DGrant Hans1 Read Execute permission for AddUsers.cmd. Then schedule the task to run under Hans1.
单选题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’）；
多选题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？（）ADROP TABLE MYTABLE PURGE；BPURGE RECYCLEBIN；CPURGE TABLE MYTABLE；DPURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；
单选题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?（）APause the Task Scheduler service.BDelete the scheduled backup job. Re-create the backup after you finish troubleshooting.CModify the properties of the scheduled backup job and clear the Enabled check box.DRun the ntbackup /p command on the server.
单选题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 WindowB ProgramC Job classD Window group
多选题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?（）AUse the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused filesBExecute the PURGE BINARY LOGE NOT USED commandCRemove all of the binary log files that have a modification date earlier than todayDEdit the .index file to remove the files you want to deleteEEnsure that none of the attached slaves are using any of the binary logs you want to delete
单选题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 ImportB conventional export and importC the CONVERT command of RMAND the BACKUP AS COPY. command of RMAN
多选题Identify four uses of the Oracle Scheduler.（）Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package