It is the job of （）to drop off the pilot...

第1题

[单选题] An operator notices that a job on the system is causing poor performance. The job is a root process and the administrator has concluded it is not important and can be stopped. Shortly after stopping the process, it starts again. Which of the following commands will list repeating scheduled tasks?（）

A、at -l B、jobs -l C、sched -l D、crontab -l

点击查看答案

第2题

[多选题] When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）

A、The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE B、The job will only be disabled if the value of the AUTO_DROP attribute is FALSE C、The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE D、All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE E、The STATE column of the job table will be set to COMPLETED for the job

点击查看答案

第3题

[] Examine the data in the EMPLOYEES table. On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: Why does the DELETE statement fail when you execute it?（） Examine the data in the EMPLOYEES table. On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: Why does the DELETE statement fail when you execute it?（）

A、A. There is no row with dept_id 90 in the EMPLOYEES table. B、B. You cannot delete the JOB_ID column because it is a NOT NULL column. C、C. You cannot specify column names in the DELETE clause of the DELETE statement. D、D. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

点击查看答案

第4题

[单选题] Click the Exhibit button and examine the data in the EMPLOYEES table. On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: DELETE employee_id, salary, job_id FROM employees WHERE dept_id = 90; Why does the DELETE statement fail when you execute it?（）

A、There is no row with dept_id 90 in the EMPLOYEES table. B、You cannot delete the JOB_ID column because it is a NOT NULL column. C、You cannot specify column names in the DELETE clause of the DELETE statement. D、You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

点击查看答案

第5题

[单选题] It is the job of the （）Department to take care of the cargo.

A、Deck B、Engine C、Service D、above all

点击查看答案

第6题

[单选题] What is the danger associated with stopping a running job by using the STOP_JOB procedure?（）

A、The job will need to be reenabled before it will execute again. B、The job may hold locks on objects referenced within it. C、All jobs within the job group will also be stopped. D、The job may leave data in an inconsistent state. E、There is no danger in using the STOP_JOB procedure.

点击查看答案

第7题

[多选题] 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 belongs B、Increasing the job's relative priority within the Job class to which it belongs C、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window D、Moving the job to an existing higher priority scheduler window with the same schedule and duration E、Increasing the value of the JOB_QUEUE_PROCESSES parameter F、Increasing the priority of the scheduler window to which the job belongs

点击查看答案

第8题

[多选题] Which three statements are true about persistent configuration?（）

A、A user cannot set privileges on the persistent lightweight jobs B、Persistent lightweight jobs generate a large amount of metadata C、It is possible to create fully self-contained persistent lightweight jobs D、The use of a template is mandatory to create persistent lightweight jobs E、Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

点击查看答案

第9题

[多选题] Which three statements are true about persistent configuration?（） (Choose three.)

A、A user cannot set privileges on the persistent lightweight jobs B、Persistent lightweight jobs generate a large amount of metadata C、It is possible to create fully self-contained persistent lightweight jobs D、The use of a template is mandatory to create persistent lightweight jobs E、Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

点击查看答案

第10题

[单选题] Examine the data in the EMPLOYEES table. EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD.ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EK_DIR 8000 120 Revi 20 110 SA_DIR 6500 On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: DELETE employee_id, salary, job_id FROM employees WHERE dept_id = 90; Why does the DELETE statement fail when you execute it?（）

A、There is no row with dept_id 90 in the EMPLOYEES table. B、You cannot delete the JOB_ID column because it is a NOT NULL column. C、You cannot specify column names in the DELETE clause of the DELETE statement. D、You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

点击查看答案

It is the job of （）to drop off the pilot.

请使用微信扫码支付