Answer Posted / pavani

Constraint means it is rule which you want to apply on the
table. There are two types of constraints.
1. Column Constraints: Applicable for that column only.
2. Table Constraints: Applicable for more than one column.

Column Constraints:
a. unique b. not null c. primary key d. foreign key
e.default f. check

Table constraints:
a. unique b. primary key c. foreign key d. check

What is the difference between cross join and natural join?

957

---

How to assign sql query results to pl sql variables?

988

---

Can %notfound return null after a fetch?

996

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

968

---

Which data type is a composite type?

931

---

What is parallel hint?

1217

---

what is the difference between inner and outer join? Explain with example. : Sql dba

970

---

Explain polymorphism in pl/sql.

1055

---

Explain mutating table error.

1127

---

What is user defined functions?

914

---

What are the rules to be applied to nulls whilst doing comparisons?

1270

---

What is sql catalog?

961

---

Can we use two order by clause in query?

916

---

What is the source code of a program?

1001

---

What are the different types of constraints?

1066

---