Answer Posted / chaitu

If constraint is defined at the column definition(refer the below exmpls) then it is known to be column level, where as table leevel constraints is defined at the especially incase of composite primary key or composite foriegn key.

Examples
----------

CREATE TABLE CLASS ( ROOM NUMBER(10) CONSTRAINT ID CHECK (ID BETWEEN 1 AND 2000),
..........
.........
........
.........);

Table level
==================

CREATE TABLE CLASS (
ROOM NUMBER(10) ,
SUBJECT VARCHAR2(200),
CODE VARCHAR2(50) NOT NULL, /* Column level constraint*/
ID NUMBER(8,2),
CLASS_DATE DATE,
CONSTRAINT PK_1 PRIMARY KEY (ROOM)); /* table level

What is an Oracle Instance?

1086

---

How to define a sub function?

1101

---

Explain the use of show option in imp command.

1062

---

What is the difference between online and offline backups?

996

---

What is the use of oracle?

1000

---

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

1012

---

What is a nvl function? How can it be used?

972

---

Can a parameter be passed to a cursor?

1069

---

What is index in Oracle?

1026

---

How many categories of data types?

954

---

Can you create a synonym without having a table?

995

---

What is a select query statement in oracle?

917

---

Point the difference between translate and replace?

1037

---

what is IDE,DMV in sql server?

2772

---

query optmization techniques and quwry analyser+projects+ppts

2382

---