Post New Oracle General Questions
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the usage of control file in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
What is Redo Log Buffer in Oracle?
How to define a variable of a specific record type?
How to rename a tablespace in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What are the differences between number and binary_float in oracle?
How to get maxsal , minsal, ename department wise in single query
types of indexes and the rationale behind choosing a particular index for a situation.
What is a system tablespace?
What are the differences between char and varchar2 in oracle?
What do you understand by database schema and what does it hold?
Is rowid unique in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?