多选题You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true? ()AThe member jobs would get dropped when the job class is dropped.BBoth the jobs would be executed concurrently.CThe member jobs would get disabled when the job class is dropped.DThe attributes defined at the class level would be applied to both the jobs.EJobs in the job class must have been assigned the same priority.
多选题
You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true? ()
A
The member jobs would get dropped when the job class is dropped.
B
Both the jobs would be executed concurrently.
C
The member jobs would get disabled when the job class is dropped.
D
The attributes defined at the class level would be applied to both the jobs.
E
Jobs in the job class must have been assigned the same priority.
参考解析
解析:
暂无解析
相关考题:
You have recently created a serializable class named Vehicle.The class is shown below:[Serializable]public class Vehicle{public string VIN;public string Make;public string Model;public string Year;}You are planning to create a custom formatter class to control the formatting of Vehicle objects when they are serialized.You need to ensure that is achieved with as little development effort as possible.What should you do?()A.B.C.D.
Use a specific resume if ( )A. you have one particular job in mindB. you don't know which market you're enteringC. you are applying for a variety of jobs
Which two statements are true about a job chain?() A. A job chain can contain a nested chain of jobs.B. The jobs in a job chain cannot have more than one dependency.C. A job of the CHAIN type can be run using event-based or time-based schedules.D. The jobs in a job chain can be executed only by using the events generated by the 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
While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.
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?()A、 Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B、 Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.C、 Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.D、 Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
While designing your database, you have created the EMPLOYEES table as an index-organized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?() A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.
Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A、 use DBMS_IJOB packageB、 use Oracle SchedulerC、 use DBMS_JOB packageD、 use Oracle Data Pump Export and Import
Which two statements are true about a job chain? ()(Choose two.)A、A job chain can contain a nested chain of jobs.B、The jobs in a job chain cannot have more than one dependency.C、A job of the CHAIN type can be run using event-based or time-based schedules.D、The jobs in a job chain can be executed only by using the events generated by the Scheduler
You are creating a job class. You have issued the following command to create the job class: SQL BEGIN DBMS_SCHEDULER.CREATE_JOB_CLASS( JOB_CLASS_NAME = ’LOW_PRIORITY_CLASS’, RESOURCE_CONSUMER_GROUP = ’LOW_GROUP’, LOGGING_LEVEL = DBMS_SCHEDULER.LOGGING_FULL, LOG_HISTORY = 1200, COMMENTS = ’LOW JOB PRIORITY CLASS’); END; SQL / What will be the result of the above command?()A、 The command will be executed successfully.B、 The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.C、 The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.D、 The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.E、 The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
Identify four uses of the Oracle Scheduler.()A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentB、 enables Oracle database to do patches according to a DBA-defined scheduleC、 enables you to schedule the execution of jobs based on timeD、 enables you to execute jobs in a clustered environmentE、 enables you to periodically execute operating systemscript files located on the same server as the databaseF、 enables you to create a job that makes use of saved programs and schedulesG、 enables you to automate the management of the jobs that are created using the DBMS_JOB package
You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true? ()A、 The member jobs would get dropped when the job class is dropped.B、 Both the jobs would be executed concurrently.C、 The member jobs would get disabled when the job class is dropped.D、 The attributes defined at the class level would be applied to both the jobs.E、 Jobs in the job class must have been assigned the same priority.
Which two statements are true about a job chain?()A、 A job chain can contain a nested chain of jobsB、 The jobs in a job chain cannot have more than one dependencyC、 A job of the CHAIN type can be run using event-based or time-based schedulesD、 The jobs in a job chain can be executed only by using the events generated by the Scheduler
Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()A、 A window must have been created with the WEEKEND_PLAN resource plan.B、 A program must have been created with the WEEKEND_PLAN resource plan.C、 A job class must have been created with the WEEKEND_PLAN resource plan.D、 A windows group must have been created with the WEEKEND_PLAN resource plan.
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 as an application developer at Certkiller .com. You have recently created a custom collection class named ShoppingList for a local supermarket. This custom class will include ShoppinItem objects that have the public properties listed below. * Name * AisleNumber * OnDiscount You are required to enable users of your class to iterate through the ShoppingList collection, and to list each product name and aisle number using the foreach statement.You need to achieve this by declaring the appropriate code.What code should you use?()A、 public class ShoppingList : ICollection {// Class implementation }B、 public class ShoppingList : IEnumerator, IEnumerable {// Class implementation }C、 public class ShoppingList : Ilist {// Class implementation }D、 public class ShoppingList : Enum {// Class implementation }
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? () A、You should create a cached data collection B、You should create an on-demand non-cached data collection C、You should create a scheduled non-cached data collection. D、You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.
单选题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?()A Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.C Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.D Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
单选题Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A use DBMS_IJOB packageB use Oracle SchedulerC use DBMS_JOB packageD use Oracle Data Pump Export and Import
多选题Which two statements are true about a job chain? ()(Choose two.)AA job chain can contain a nested chain of jobs.BThe jobs in a job chain cannot have more than one dependency.CA job of the CHAIN type can be run using event-based or time-based schedules.DThe jobs in a job chain can be executed only by using the events generated by the Scheduler
单选题While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()AA primary key must have been created.BA mapping table must have been created.CAn overflow tablespace must have been specified.DThe PCTTHRESHOLD option must have been specified.
单选题Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()A A window must have been created with the WEEKEND_PLAN resource plan.B A program must have been created with the WEEKEND_PLAN resource plan.C A job class must have been created with the WEEKEND_PLAN resource plan.D A windows group must have been created with the WEEKEND_PLAN resource plan.
多选题Identify four uses of the Oracle Scheduler.()Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package
多选题Which two statements are true about a job chain?()AA job chain can contain a nested chain of jobs.BThe jobs in a job chain cannot have more than one dependency.CA job of the CHAIN type can be run using event-based or time-based schedules.DThe jobs in a job chain can be executed only by using the events generated by the Scheduler
单选题You work as an application developer at Certkiller .com. You have recently created a custom collection class named ShoppingList for a local supermarket. This custom class will include ShoppinItem objects that have the public properties listed below. * Name * AisleNumber * OnDiscount You are required to enable users of your class to iterate through the ShoppingList collection, and to list each product name and aisle number using the foreach statement.You need to achieve this by declaring the appropriate code.What code should you use?()A public class ShoppingList : ICollection {// Class implementation }B public class ShoppingList : IEnumerator, IEnumerable {// Class implementation }C public class ShoppingList : Ilist {// Class implementation }D public class ShoppingList : Enum {// Class implementation }
多选题Which two statements are true about a job chain?()AA job chain can contain a nested chain of jobsBThe jobs in a job chain cannot have more than one dependencyCA job of the CHAIN type can be run using event-based or time-based schedulesDThe jobs in a job chain can be executed only by using the events generated by the 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?()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