MCQOPTIONS
Bookmark
Saved Bookmarks
→
Oracle (MCQ) questions and answers
→
Administering and Managing an Oracle Database
→
Which is the correct parameter used for CREATE_PRO...
1.
Which is the correct parameter used for CREATE_PROGRAM?
A.
program_type
B.
schedule_name
C.
start_date
D.
program_name
Answer» B. schedule_name
Show Answer
Discussion
No Comment Found
Post Comment
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?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies