网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? ()
A. SET_ATTRIBUTE_NULL
B. ALTER_JOB
C. ALTER_JOB_PARAMETERS
D. ALTER
E. SET_ATTRIBUTE
参考答案
更多 “ Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? () A. SET_ATTRIBUTE_NULLB. ALTER_JOBC. ALTER_JOB_PARAMETERSD. ALTERE. SET_ATTRIBUTE ” 相关考题
考题
To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()
A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAME
考题
Which DBMS_SCHEDULER procedures can be used to enable a program?()
A. ENABLE启用B. ENABLE_PROGRAMC. VALIDATE_PROGRAMD. SET_ATTRIBUTE设置属性E. SET_ENABLED
考题
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 notice that the elapsed time for an important database scheduler Job is unacceptably long.The job belongs to a scheduler job class and window.Which two actions would reduce the job‘s elapsed time?（）A. Increasing the priority of the job class to which the job belongsB. Increasing the job‘s relative priority within the Job class to which it belongsC. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler windowD. Moving the job to an existing higher priority scheduler window with the same schedule and durationE. Increasing the value of the JOB_QUEUE_PROCESSES parameterF. Increasing the priority of the scheduler window to which the job belongs
考题
It's said that he's looking for a new job, one_________ he can get more free time.
A．when
B．where
C．that
D．which
考题
Which statement is true about the SDM QoS wizard and its ability to enable a QoS policy on router interfaces？（）A、QoS can be enabled on interfaces used for Easy VPN clientsB、QoS can be enabled on IPsec VPN interfaces and tunnelsC、QoS can be enabled on interfaces with an existing QoS policyD、the QoS policy can be enabled for incoming and outgoing traffic on the interface
考题
What is the use of work assets on safety plans？ （）A、 The work asset determines to which assets and locations a safety plan can be applied.B、 Only safety plans with associated work assets can be used in combination with job plans. C、 The safety plan can only be applied to work orders with the same asset or location associated.D、 The work assets combined with the work on a job plan dictate which safety information is required.
考题
Which command is used to open the database after an incomplete recovery？（）A、 alter database openB、 alter database open repairlogC、 alter database open resetlogsD、 alter database open resetlogE、 alter database resetlogs open
考题
Which three are true?（）A、A MERGE statement is used to merge the data of one table with data from another.B、A MERGE statement replaces the data of one table with that of another.C、A MERGE statement can be used to insert new rows into a table.D、A MERGE statement can be used to update existing rows in a table.
考题
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?（）A、It can be used to allow the access privilege settings for users but not roles.B、It can be used to allow the access privilege settings for users as well as roles.C、It can be used to control the time interval for which the access privilege is available to a user.D、It can be used to selectively restrict the access for each user in a database to different host computers.E、It can be used to selectively restrict a user's access to different applications in a specific host computer.
考题
Which DBMS_SCHEDULER procedures can be used to enable a program？（）A、 ENABLEB、 ENABLE_PROGRAMC、 VALIDATE_PROGRAMD、 SET_ATTRIBUTEE、 SET_ENABLED
考题
Which DBMS_SCHEDULER procedure（s） can be used to alter an existing job？（）A、 SET_ATTRIBUTE_NULLB、 ALTER_JOBC、 ALTER_JOB_PARAMETERSD、 ALTERE、 SET_ATTRIBUTE
考题
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 usageB、define the warning threshold for the tablespace at 75% in Database ControlC、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 intervalsE、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
考题
To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）A、 LOG_HISTORYB、 JOB_LOG_RETENTIONC、 WINDOW_LOG_RETENTIOND、 WHICH_LOGE、 LOG_NAME
考题
Which DBMS_SCHEDULER procedures can be used to enable a program?（）A、ENABLE启用B、ENABLE_PROGRAMC、VALIDATE_PROGRAMD、SET_ATTRIBUTE设置属性E、SET_ENABLED
考题
Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A、 By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.B、 By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.C、 By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.D、 By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.E、 By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.
考题
You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）A、Increasing the priority of the job class to which the job belongsB、Increasing the job's relative priority within the Job class to which it belongsC、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowD、Moving the job to an existing higher priority scheduler window with the same schedule and durationE、Increasing the value of the JOB_QUEUE_PROCESSES parameterF、Increasing the priority of the scheduler window to which the job belongs
考题
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 categoryB、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
考题
单选题Your business has departmental reports that are generated every day. Each department must use the same set of queries， but accesses a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed; currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A
by having each user run the report generation procedure at the scheduled time， supplying the necessary input variablesB
by creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOBC
by having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the reportD
by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the reportE
by creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER
考题
多选题Which DBMS_SCHEDULER procedures can be used to enable a program?（）AENABLE启用BENABLE_PROGRAMCVALIDATE_PROGRAMDSET_ATTRIBUTE设置属性ESET_ENABLED
考题
多选题Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? （）ASET_ATTRIBUTE_NULLBALTER_JOBCALTER_JOB_PARAMETERSDALTERESET_ATTRIBUTE
考题
多选题You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）AIncreasing the priority of the job class to which the job belongsBIncreasing the job's relative priority within the Job class to which it belongsCIncreasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowDMoving the job to an existing higher priority scheduler window with the same schedule and durationEIncreasing the value of the JOB_QUEUE_PROCESSES parameterFIncreasing the priority of the scheduler window to which the job belongs
考题
问答题Psychological techniques used to lessen the effort involved in a given job include a detailed study of the motion required to do the job, the equipment used, and the conditions under which the job is performed.
考题
多选题Which three are true? （）AA MERGE statement is used to merge the data of one table with data from another.BA MERGE statement replaces the data of one table with that of another.CA MERGE statement can be used to insert new rows into a table.DA MERGE statement can be used to update existing rows in a table.
考题
多选题Which DBMS_SCHEDULER procedures can be used to enable a program？（）AENABLEBENABLE_PROGRAMCVALIDATE_PROGRAMDSET_ATTRIBUTEESET_ENABLED
考题
多选题To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）ALOG_HISTORYBJOB_LOG_RETENTIONCWINDOW_LOG_RETENTIONDWHICH_LOGELOG_NAME
考题
单选题Which procedure(s) shall be used to determine risk of collision? （）A
Watching the compass bearing of an approaching vesselB
Systematic observation of objects detected by radarC
Long-range radar scanningD
All of the above
热门标签
最新试卷