Answer / mathavan

Indexes are used for faster access of required data in a
large table.

Answer / rajesh naidu

INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA

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  

---

how can you record information about current session?

0 Answers   Oracle,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

Explain the use of table functions.

1 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---