An automatic job running via DBMS_JOB has failedKnowing only
that its failed, how do you approach troubleshooting this issue?
what is the difference between no rows returned and null returned?
What is a synonym? What are its various types?
What is Database Buffers ?
What is java oracle used for?
What is the difference between substr and instr?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
Can we save images in a database and if yes, how?
What are a collation and state the different types of collation sensitivity?
What is translate in oracle?
Explain temporal data types in oracle
Why do we need integrity constraints in a database?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?