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

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1086

---

How show all rows in sql?

1060

---

how many groups of data types? : Sql dba

1078

---

What is not equal in sql?

1196

---

How to check if a column is nullable before setting to nullable?

1188

---

Why cross join is used?

1139

---

Why do we need databases?

1093

---

discuss about myisam key cache. : Sql dba

1072

---

What are all the different types of indexes?

1198

---

Is sql the best database?

1030

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1117

---

Why is sql better than hql?

1065

---

What is sql rowcount?

1073

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

1121

---

Why stored procedures are faster than query?

1079

---