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 are the types of join and explain each?

989

---

Is not equal in sql?

960

---

What is indexing oracle sql?

1026

---

What is meant by temporal data?

910

---

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

987

---

What are schema-level triggers?

1047

---

How do I enable sql encryption?

969

---

Can we use join in subquery?

1023

---

what is a composite key ? : Sql dba

995

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1161

---

What is on delete set null?

1039

---

what is meant by nl2br()? : Sql dba

975

---

Can we use views in stored procedure?

972

---

Explain normalization and what are the advantages of it?

892

---

What is the use of function in sql?

1029

---