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 are sql queries used for?

1022

---

What is a sql instance vs database?

1108

---

What is the difference between view and stored procedure?

959

---

What is over () in sql?

946

---

How to get list of all tables from a database?

1149

---

What are sql functions? Describe in brief different types of sql functions?

1097

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

978

---

What is cascade in sql?

958

---

What is a natural join sql?

963

---

What is the difference between join and natural join?

924

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1338

---

What program will open a mdb file?

958

---

What is null in pl/sql?

1061

---

What is a database trigger?

1063

---

What are types of exception?

916

---