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 do you understand by a database object?

1051

---

What is the difference between translate and replace?

1053

---

How to delete a column in an existing table?

1070

---

How many types of tables are there in oracle?

1052

---

Can we connect to ORACLE db using Windows Authentication?

1238

---

What are the limitations of check constraint?

1021

---

What happens to the data files if a tablespace is dropped?

1053

---

What is the difference between "as" and "is" in an oracle stored procedure?

985

---

How to run the anonymous block again?

1122

---

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

1018

---

What is a snapshot in oracle database?

1016

---

Explain the use of full option in exp command.

1109

---

Explain the different normalization forms?

1070

---

Explain the use of rows option in imp command.

1078

---

Explain overloading. Can functions be overloaded?

974

---