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?

2036

What is the usage of control file in oracle?

1141

What is the difference between Delete, Truncate and Drop in Oracle?

1179

What is Redo Log Buffer in Oracle?

1276

How to define a variable of a specific record type?

1112

How to rename a tablespace in oracle?

1123

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1062

What are the differences between number and binary_float in oracle?

1143

How to get maxsal , minsal, ename department wise in single query

1599

types of indexes and the rationale behind choosing a particular index for a situation.

2558

What is a system tablespace?

1128

What are the differences between char and varchar2 in oracle?

1242

What do you understand by database schema and what does it hold?

1296

Is rowid unique in oracle?

1041

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?

2870