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?

0 Answers  

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

What is a database table in oracle?

0 Answers  

---

Name the three major set of files on disk that compose a database in Oracle?

0 Answers  

---

How to initialize variables with default values?

0 Answers  

---

what is dynamic SGA and static SGA

0 Answers   Oracle,

---

What is a connect identifier?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

What operating systems are supported by oracle database 10g xe?

0 Answers  

---

What is different types of joins?

0 Answers  

---

find out the third highest salary?

92 Answers   CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---