Answer Posted / samir kumar sahoo

SELECT DISTINCT salary FROM (SELECT DISTINCT salary,ROWNUM
rn FROM employee ORDER BY salary desc) WHERE rn=1;

why dont we assign not null constraint as table level constraint.

2797

---

What is an oracle database?

1108

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2367

---

What privilege is needed for a user to delete rows from tables in another schema?

1134

---

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

1047

---

How to bring a tablespace offline?

1113

---

Explain the use of grant option in exp command.

1108

---

What is the maximum limit on the number of columns in a table?

1152

---

What is object data modeling?

1017

---

How to use subqueries with the exists operator in oracle?

1070

---

What do you understand by a database object?

1107

---

Please explain compound trigger in oracle?

1110

---

How to add a new column to an existing table with a default value?

1056

---

What is the usage of save points in oracle database?

1011

---

What privilege is needed for a user to create tables in oracle?

991

---