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

Can a commit statement be executed as part of a trigger?

1034

---

What is a record in a database?

1040

---

what is log shipping? : Sql dba

1092

---

how to rename an existing column in a table? : Sql dba

999

---

Explain how to use transactions efficiently : transact sql

955

---

How do I order columns in sql?

965

---

explain the difference between myisam static and myisam dynamic. : Sql dba

925

---

What is an implicit commit?

1037

---

How to rename a table?

997

---

What is record data type?

899

---

What if we write return in procedure?

1398

---

What is the limitation on the block size of pl/sql?

972

---

What is primary key and foreign key?

946

---

How to start the command-line sql*plus?

1040

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1579

---