Answer / md mubeen

Shared pool buffers cache consists of two layer
1)Library cache (LC) 2) Data dictionary cache (DDC)
in the Library cache the parsed information data will be
stored 2)DDC contains the dictionary tables which stores
the meta data information .

What privilege is needed for a user to create tables in oracle?

0 Answers  

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

how to produce numbers from 1 to 10 using dual table

4 Answers   Genpact,

---

what is port in oracle? how is it related to database application.

0 Answers  

---

waht is referencial integrity?

2 Answers   Semantic Space,

---

---

What is a Sequence ?

3 Answers  

---

What are the database administrators utilities available?

0 Answers  

---

defination of bitmap index

0 Answers   NIIT,

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

what is the scripts in data base?

0 Answers  

---

How to use in conditions in oracle?

0 Answers  

---

what is the difference between dbms and rdbms?

3 Answers   Oracle,

---