Assuming today is Monday, how would you use the DBMS_JOB
package to schedule the execution of a given procedure owned
by SCOTT to start Wednesday at 9AM and to run subsequently
every other day at 2AM.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

How would you determine the time zone under which a database was operating?

2 Answers  


How would you go about generating an EXPLAIN plan?

2 Answers  


What is a system database and what is a user database? : sql server DBA

0 Answers  


What are the recovery models for a database? : sql server DBA

0 Answers  


What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  






Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,


how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,


How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  


how can you find out if a table can be redefined?

0 Answers   Oracle,


What is blocking and how would you troubleshoot it?

1 Answers  


Categories