Answer Posted / rajan sharma

Column level are those constraints that are inserted after
the declaration of the data typeot

Syntax :

CREATE TABLE table_name
(Column_name Datatype NOT NULL )

Example : Not null,pimary key,foreign key, unique and check.

Table level constraints are those that are inserted at the
end of the table.

Example : pimary key,foreign key, unique and check.

Thanks

What is the disadvantage of User defind function?

2290

---

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

1123

---

What is a snapshot log?

1003

---

Why does for update in oracle 8 cause an ora-01002 error?

1003

---

Why is oracle so popular?

995

---

What is coalesce function?

1069

---

How to shutdown your 10g xe server?

1147

---

Is it possible to insert comments into sql statements return in the data model editor ?

2557

---

what is reindexing?

1674

---

What are the uses of Database Trigger ?

1719

---

Point out the difference between user tables and data dictionary?

981

---

How to create a table index?

1147

---

What are the general rules on data consistency?

1009

---

Is there any function in oracle similar like group_concat of mysql?

1053

---

Why packages are used in oracle?

1066

---