What are the four Oracle system processes that must always be up and running for the database to be useable?
1023Post New Oracle General Questions
How to generate query output in html format?
Why do we use coalesce function in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Explain the use of indexes option in exp command.
What are the execution control statements in oracle?
What happens to the current transaction if the session is ended?
Explain the blob datatype?
How to use existing values in update statements using oracle?
What do you mean by a deadlock?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is oracle and what are its different editions?
What is rowid and rownum in oracle?
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.
How to create a single index for multiple columns?
What are the ways tablespaces can be managed and how do they differ?