An automatic job running via DBMS_JOB has failed. Knowing
only that "it's failed", how do you approach troubleshooting
this issue?
Answer / braj123
>>First check the alert.log file for what reason the job
failed.
>>
Is This Answer Correct ? | 0 Yes | 0 No |
Explain what partitioning is and what its benefit is.
How do you resize a data file?
Which environment variables are absolutely critical in order to run the OUI?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
which background process invoke at the time of upgradation tell me???
What types of replication are supported in sql server? : sql server DBA
Give the reasoning behind using an index.
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What command would you use to encrypt a PL/SQL application?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
Name three advisory statistics you can collect.