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

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2195

---

if you ctreate table identity

2115

---

What is a view and how is it different from a table?

731

---

What is oracle datasource?

746

---

Explain the types of exception?

863

---

How do I spool to a csv formatted file using sqlplus?

713

---

Explain how you would restore a database using RMAN to Point in Time?

1878

---

What is the parameter mode that can be passed to a procedure?

796

---

Explain a data segment?

835

---

What do you know about normalization? Explain in detail?

665

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1477

---

What is a cursor and what are the steps need to be taken?

788

---

WHAT IS ecc 6.0

1909

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1885

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2697

---