Explain the use of grant option in exp command.

0 Answers  

---

How many categories of data types in oracle?

0 Answers  

---

What is tns name?

0 Answers  

---

Explain the use of control file?

0 Answers  

---

What is a snapshot in oracle database?

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  

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  

---

What is the difference between alert log file and tarce file ?

0 Answers   TCS,

---

Display Odd/ Even number of records?

3 Answers  

---

Difference between join and a subquery?

8 Answers   Base Automation, NMDC,

---

Differnce between view and index

3 Answers  

---