Answer Posted / anil

ANS:
COLUMN LEVEL CONSTRAINT
If we provide constraint along with column while creating the table then it is column level constraint. For column level constraint a constraint name is not mandatory.

TABLE(ROW) LEVEL CONSTRAINT
If we provide constraint after providing all the columns then it is table level constraint.For table level constraint a constraint name is mandatory.

Advantage of table level constraint:
We can create composite PK and composite FK in table level constraints but we cant create these in column level constraints.

Example:
CREATE TABLE oracle_tab
(
ord_id  NUMBER,
pid NUMBER,
qty NUMBER(2),
ord_dt DATE NOT NULL, /*column level constraint(cant be created as table level constraint)*/
price NUMBER(9,1) DEFAULT 0, /*column level constraint(cant be created as table level constraint)*/
CONSTRAINT ord_pk PRIMARY KEY(ord_id,pid), /*table level(can be created either as table level constraint or column level)*/
CONSTRAINT ord_fk FOREIGN KEY(pid) REFERENCES products(pid),/*table level(can be created either as table level constraint or column level)*/
CONSTRAINT ord_ch CHECK(qty>0) /*table level(can be created either as table level constraint or column level)*/
);

How would you convert date into julian date format?

1006

---

What is the difference between delete and truncate statement in sql?

1075

---

What is Collation Sensitivity ? What are the various type ?

954

---

What is auto increment feature in sql?

1127

---

Where is pl sql used?

957

---

What is the difference between join and natural join?

930

---

What are different joins used in sql?

1058

---

Why coalesce is used in sql?

1014

---

How many tables can a sql database have?

980

---

What is cte sql?

1002

---

What is rtm stands for?

1101

---

Can function return multiple values in sql?

1062

---

What is sql mysql pl sql oracle?

1075

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1230

---

What are the two types of periodical indexes?

940

---