Answer Posted / abhisudipta

select d.dept_name,e.emp_nm,max(e.sal) as salary
from dept d, emp e
where d.dept_no=e.dept_no and e.emp_nm = (select emp_nm from
emp where sal=(select max(sal) from emp where
dept_no=d.dept_no))
group by d.dept_name,e.emp_nm;

State the various uses of dbcc command?

1104

---

How does oracle handle read consistency?

1151

---

How to name query output columns in oracle?

1240

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1124

---

Why should I use oracle database?

1043

---

How to assign query results to variables?

1096

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2383

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1951

---

What are the different types of record groups in oracle? Explain each of them

1069

---

List the parts of a database trigger.

1108

---

How do we represent comments in oracle?

1096

---

What is concurrency in oracle?

1057

---

What is an oracle and why it is used?

1212

---

Can a formula column be obtained through a select statement ?

2380

---

What is columnar storage what is the advantage?

1120

---