单选题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’）；
参考解析
解析：
暂无解析
相关考题：
What are you recommended to answer the question tell me about yourself, if you are seeking for your first job?A.Speak much about how that job appeals to you and caused you to apply for it.B.Speak much about how your enthusiasm about an area has driven you to want that job.C.Speak much about how a book you’ve read or a person you’ve known motivated you to get that job.D.Speak much about how your past experiences made you decide to compete for that job.
Before sending your resume to prospective employersor scheduling any interviews , you need to analyze the job market. Analyzing the job market involves determining actual jobopenings and gathering information about organizations for which you want to work.
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’）；
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_VALUE
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
下面哪些句子正确表达"你为什么辞去上一份工作?"() A、Why did you quit your last job?B、Why did you do your last job? C.Why did you resign from your last job?D、Why did you give up your last job?
Why did you leave your last job? (or: why do you want to leave your present job?)你为什么辞去了前一份工作？（或你为什么想辞去现在的工作？）
列出EMP表中,从事每个工种(JOB)的员工人数() A.select job from emp;B.select job,count(*) from emp;C.select distinct job,count(*) from emp;D.select job,count(*) from emp group by job;E.select job,sum(empno) from emp group by job;
If you want ___________ you have to get the fund somewhere.A.that the job is doneB.the job doneC.to have done the jobD.the job that is done
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’）；
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_VALUE
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
列出EMP表中，从事每个工种（JOB）的员工人数（）A、select job from emp;B、select job,count(*) from emp;C、select distinct job,count(*) from emp;D、select job,count(*) from emp group by job;E、select job,sum(empno) from emp group by job;
多选题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
问答题Practice 2 Read the job advertisement below from a newspaper and suppose you want to apply for the job. Write a letter of application, giving all the necessary personal information. You should write approximately 100 words. Do not sign your own name at the end of your letter. Use “Wang Lin” instead.
单选题When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）ASET_JOB_ARGUMENT_VALUEBSET_JOB_VALUE_ANYDATACSET_JOB_ANYDATA_VALUEDSET_SPECIAL_JOB_VALUEESET_JOB_ANYTYPE_VALUE
单选题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_VALUE
单选题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 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 which contains multiple Agent jobs. The jobs run each job on each day of the week by using seven shared schedules. You must make sure that a job named Job4 doesn'；t run Wednesday. So what action should you perform to achieve this goal？（）AYou should remove the schedule for Wednesday from Job5. BYou should add a new Job5 schedule for Wednesday and disable it. CYou should delete the schedule for Wednesday. DYou should disable the schedule for Wednesday.
单选题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?（）ASELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';BSELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';CSELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;DSELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
单选题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 are the network administrator for TestKing. You manage a Windows Server 2003 computer named TestKing4 that functions as an application server. TestKing4 will be used for development during the next 30 days. You need to back up all data on TestKing4 every day for the next 30 days. You need to automate the backups of TestKing4 to meet these business requirements. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）ACreate a scheduled backup job as a normal backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.BCreate a scheduled backup job as a daily backup. Set the start date of the job for today, and set the end date for 30 days from today.CCreate a scheduled backup job as a copy backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.DCreate a scheduled backup job as a normal backup. Set the start date of the job for today, and set the end date for 30 days from today.
单选题It is the ability to do the job _____ matters, not where you come from or what you are.AoneBthatCwhatDif
单选题If you want a job of taking care of children, which ad will you answer?ALOST AND FOUNDBROOMMATESCFOR SALEDHELP WANTED
单选题列出EMP表中，从事每个工种（JOB）的员工人数（）Aselect job from emp;Bselect job,count(*) from emp;Cselect distinct job,count(*) from emp;Dselect job,count(*) from emp group by job;Eselect job,sum(empno) from emp group by job;