Oracle Scenarios Question:

Download Job Interview Questions and Answers PDF

Explain How to do the scheduled task/jobs in Unix platform?

Oracle Scenarios Interview Question
Oracle Scenarios Interview Question

Answer:

Use DBMS_JOB/DBMS_SCHEDULER and give the Job_type as EXECUTABLE and give the path name of the shell script to execute.

Download Oracle Scenarios Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is mutated trigger, is it the problem of locks. In single user mode we got mutated error, as a DBA how you will resolve it?Explain the Dual table. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get and Why?