Answer Posted / gurupatham

Column Level Constraints refers Only One Column .Which does
not have the column name at declaration time .
Ex : Create table emp
( empno number primary Key,
--,
--);

Table Level constraints refers one or more than one column .
Which does have column name at declaration time.
Ex: Create table emp
( empno number ,
--,
--,
Constraints pk_con primary Key(empno));

All constraints can be created as Column and Table level
expect Not Null constraints .
Not Null constraints can only be created as column level
constraints . Does not have constraints name.

What do you mean by merge in oracle and how can you merge two tables?

1001

---

How to use "in" parameter properly?

1112

---

What is the simplest tool to run commands on oracle servers?

1052

---

Difference between open_form and call_form in oracle.

1217

---

When system tablespace is created?

1086

---

What is user managed backup in Oracle?

1200

---

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

1039

---

Can we create database in oracle using command line ?

1127

---

Explain an exception and its types?

1134

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2036

---

Explain implicit cursor.

1069

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2435

---

Is oracle the best database?

1004

---

What is Reduced List of Values?

2240

---

What is a select query statement in oracle?

1024

---