Answer Posted / adinarayana

COLUMN LEVEL
1.Column level constraints can be defined along with the
columns.
2.NOT NULL constraints can be defined at this level(to only
one column).
3.Composite keys can't be defined at this level

TABLE LEVEL
1.Table level constraints can be defined after defining the
all columns
2.NOT NULL constraints can't be defined at this level.
3.Composite key can be defined at this level

Can we commit inside a function in oracle?

917

---

How to create an oracle database?

976

---

What exactly do quotation marks around the table name do?

916

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1020

---

What is the disadvantage of User defind function?

2238

---

How to define an anonymous block?

1072

---

What is a table in oracle?

926

---

what is port in oracle? how is it related to database application.

1893

---

Explain the use of indexes option in imp command.

1085

---

material view and view disadvantages?

1017

---

How can I see all tables in oracle?

950

---

Name the three major set of files on disk that compose a database in Oracle?

1063

---

What is the use of file param in imp command?

1115

---

How do I find the database name in oracle?

979

---

How would you go about verifying the network name that the local_listener is currently using?

1994

---