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

题目

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’）；

参考答案和解析

正确答案:D

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 1：

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.

点击查看答案
相关问题 2：

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’）；

点击查看答案
相关问题 3：

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

点击查看答案
相关问题 4：

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

点击查看答案
相关问题 5：

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.

点击查看答案
相关问题 6：

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

点击查看答案
相关问题 7：

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.

点击查看答案

Oracle认证考试

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：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容