using the Hyperbolic Viewer
opening the Impact view and displaying the successors
opening the Job Stream Instance editor for its Job Stream Instance
opening the Dependencies window and drilling down to the successors
第1题:
How can a Job with EXEC as Internal Status be stopped in the Job Scheduling Console?()
第2题:
Using the Tivoli Dynamic Workload Console, what are two ways to change the priority of a job?()
第3题:
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?()
第4题:
Which two statements are true about a job chain?()
第5题:
Which two statements are true about a job chain?()
第6题:
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?()
第7题:
A job chain can contain a nested chain of jobs
The jobs in a job chain cannot have more than one dependency
A job of the CHAIN type can be run using event-based or time-based schedules
The jobs in a job chain can be executed only by using the events generated by the Scheduler
第8题:
select Kill from the menu
select Release from the menu
select Cancel Job from the menu
select Cancel Pending from the menu
第9题:
第10题:
Detailed information regarding the first run of each job in the class will be written in the job log, and every operation performed on the job class will be logged.
Detailed information regarding each run of only the first job in the class will be written in the job log, and every operation performed on the job class will be logged.
Detailed information regarding each run of each job in the class will be written in the job log, and every operation performed on the job class will be logged.
Detailed information regarding each run of each job in the class will be written in the job log, but operations performed on the job class will not be logged.
第11题:
using the Hyperbolic Viewer
opening the Impact view and displaying the successors
opening the Job Stream Instance editor for its Job Stream Instance
opening the Dependencies window and drilling down to the successors
第12题:
Create both jobs by using events raised by the scheduler
Create both jobs by using events raised by the application
Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application
第13题:
While creating a job class using the DBMS_SCHEDULER package, you set the logging level to LOGGING_RUNS. What would be the impact of this setting?()
第14题:
Using Job Scheduling Console, how can the external successor chain be viewed when a job needs to be canceled?()
第15题:
What is the danger associated with stopping a running job by using the STOP_JOB procedure?()
第16题:
Which two statements are true about a job chain? ()(Choose two.)
第17题:
Which three elements can a job chain process involve?()
第18题:
William is creating a job class. William specifies the LOGGING_FULL setting for the LOGGING_LEVEL attribute at the time of job class creation. What is the impact of using this setting?()
第19题:
by having each user run the report generation procedure at the scheduled time, supplying the necessary input variables
by creating a program using DBMS_JOB that accepts one or more variables, and creating a job that calls this program using DBMS_JOB
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
by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report
by creating a program using DBMS_SCHEDULER that accepts one or more variables, and creating a job that calls this program using DBMS_SCHEDULER
第20题:
Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.
Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.
Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.
Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
第21题:
The job will need to be reenabled before it will execute again.
The job may hold locks on objects referenced within it.
All jobs within the job group will also be stopped.
The job may leave data in an inconsistent state.
There is no danger in using the STOP_JOB procedure.
第22题:
Create both jobs by using events raised by the scheduler
Create both jobs by using events raised by the application
Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application
第23题:
By having each user run the report generation procedure at the scheduled time, supplying the necessary input variables.
By creating a program using DBMS_JOB that accepts one or more variables, and creating a job that calls this program using DBMS_JOB.
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.
By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
By creating a program using DBMS_SCHEDULER that accepts one or more variables, and creating a job that calls this program using DBMS_SCHEDULER.
第24题:
a job description and a job specification
what is taught and how it is taught
learning about skills and training in using them
the savings in time and the savings in cost