Jobs are database objects, and can therefore accumulate and take up too much space. To avoid this, job objects are automatically dropped by default after completion. This behavior is controlled by which job attribute?

Jobs are database objects, and can therefore accumulate and take up to

1.	Jobs are database objects, and can therefore accumulate and take up too much space. To avoid this, job objects are automatically dropped by default after completion. This behavior is controlled by which job attribute?
A.	auto_view
B.	auto_drop
C.	auto_cancel
D.	drop
Answer» C. auto_cancel

Discussion

No Comment Found

Related MCQs

In defining Application Services for Oracle Database 10g which Services describe applications, application functions, and data ranges as either functional services or data-dependent services?
In viewing information about the SGA which view Displays information about the amount of SGA memory available for future dynamic SGA resize operations?
Which is the correct parameter used for CREATE_PROGRAM?
What is used to execute STARTUP and SHUTDOWN commands while starting up a database?
Which attribute enables you to control the amount of logging in the Scheduler performs for setting the scheduler attribute?
In the platform-specific default location, Oracle Database locates your initialization parameter file by examining filenames in which of the following order?
What kind of an eventis raised when the Scheduler reacts to the event by starting a job and you can even create a schedule that references an event instead of containing date, time, and recurrence information?
Based on the existing program which way is used to CREATE_JOB?BEGINDBMS_SCHEDULER.CREATE_JOB (job_name => 'my_new_job3',program_name => 'my_saved_program1',schedule_name => 'my_saved_schedule1');END;
When a job is picked for processing, select the correct order in which job executes.1. Starts a database session as the owner of the job, starts a transaction, and then starts executing the job.2. Gathers all the metadata needed to run the job. As an example, arguments of the program and privilege information.3. Once the job is complete, the slave commits and ends the transaction.4. Closes the session
Which is the location of the Oracle Database that can store and manage files related to backup and recovery?

Jobs are database objects, and can therefore accumulate and take up too much space. To avoid this, job objects are automatically dropped by default after completion. This behavior is controlled by which job attribute?

Discussion

No Comment Found

Related MCQs

Reply to Comment