Answer Posted / sowmya

Hi
A table can have only one primary key.but a primary key can
have two column fields
Ex i have a employee table.and i have fields eno,ename,esal
i can declare primarykey(esal,ename)

let me know if i am wrong

What is the difference between subquery and correlated query?

1069

---

Are subqueries faster than joins?

1024

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1080

---

What is meant by cursor in sql?

1007

---

Is sql workbench free?

1005

---

What are different types of queries in sql?

1122

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1085

---

What is numeric function sql?

1068

---

Explain lock escalation? : Transact sql

1206

---

How we can update the view?

1054

---

What is procedure in pl sql?

1050

---

What is varchar data type in sql?

1088

---

How do you clear the screen in sql?

1076

---

what is the difference between primary key and unique key? : Sql dba

1042

---

Is it possible to read/write files to-and-from PL/SQL?

1106

---