Answer / manoj

SELECT employee_id, employee_name, salary FROM employees
where rownum < 6 ORDER BY
salary DESC
group by department_id;

Answer / lakshya

SELECT salary FROM employee where rownum < 6 ORDER BY
salary DESC
group by dept;

Explain the use of grant option in imp command.

0 Answers  

---

How to use subqueries with the in operator using oracle?

0 Answers  

---

defination of bitmap index

0 Answers   NIIT,

---

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  

---

Can we store pictures in the database and if so, how it can be done?

0 Answers  

---

How to check the oracle tns settings?

0 Answers  

---

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

1 Answers   Polaris,

---

How to define default values for formal parameters?

0 Answers  

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  

---

What are the types of partitions in oracle?

0 Answers  

---

What is user managed backup in Oracle?

0 Answers   MCN Solutions,

---

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

---