Answer Posted / paridhi

select top 1 salary from
(select top 1 salary from employee order by
salary desc) a
order by salary

Explain the use of analyse option in exp command.

1128

---

What is oracle host variable?

1061

---

List the parts of a database trigger.

1050

---

What is literal?

1004

---

How do we represent comments in oracle?

1048

---

State and explain the different types of data models?

944

---

How to update a table row with a record?

1009

---

What are privileges and grants?

1067

---

Can a formula column be obtained through a select statement ?

2324

---

Who developed oracle & when?

1003

---

What is Data Dictionary Cache in Oracle?

1163

---

What is dual table oracle?

984

---

How many categories of data types in oracle?

1029

---

What is the relationship among database, tablespace and data file?

989

---

What are ddl statements in oracle?

1075

---