Answer Posted / sawant

Number of times processes repeatedly query the dictionary
table is called recursive hints. It is due to the data
dictionary cache is too small. By increasing the
SHARED_POOL_SIZE parameter we can optimize the size of Data
Dictionary Cache.

Explain integrity constraints?

1056

---

What is a system tablespace?

1001

---

What are oracle functions?

972

---

How to concatenate two text values in oracle?

1051

---

What is an oracle tablespace?

981

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1617

---

How do we create privileges in oracle?

990

---

Explain oracle instance.

1102

---

How to login to the server without an instance?

1102

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2066

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2198

---

How to use subqueries in the from clause in oracle?

1042

---

How to update values in a table in oracle?

957

---

Why is oracle so popular?

938

---

What is tns service name?

1069

---