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
How would you determine the time zone under which a database was operating?
How would you go about generating an EXPLAIN plan?
What is a system database and what is a user database? : sql server DBA
What are the recovery models for a database? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Query processing is slow(eg select query)how will u solve that
how will u see whether the dabase is in archive log mode or not?
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
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?
How do you trace the traffic hitting a sql server? : sql server DBA
how can you find out if a table can be redefined?
What is blocking and how would you troubleshoot it?