Answer Posted / prithvi

select Max(sal) from emp

This will give us 1highest sal

Select Max (sal) from where sal <(select Max(sal) from emp)

Select Max (sal) from where sal <(Select Max (sal) from
where sal <(select Max(sal) from emp))

How view is different from a table?

1032

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2117

---

What is the max number of columns in an oracle table?

999

---

How will you differentiate between varchar & varchar2?

1041

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2458

---

What is system tablespace?

1094

---

Explain implicit cursor.

1027

---

How many types of tables supported by oracle?

1075

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1015

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2290

---

What is data block in Oracle?

1116

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2263

---

How to use select statement to count the number of rows in oracle?

1042

---

How to create a new user account in oracle?

1020

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2827

---