Answer Posted / smita

Hi,
No , we cant create pk eithout unique index it
implicitelygenerater by oracle.
I want to clear that pk can b on one or more col but only
one pk.
While unique constraint can b one or more col and can b one
or morn unique key in a table

what are the type of locks ? : Sql dba

1007

---

What is the purpose of design view?

1073

---

Can a key be both primary and foreign?

1053

---

Explain the methods used to protect source code of pl/sql.

1070

---

How can we solve sql error: ora-00904: invalid identifier?

1292

---

What are the different types of sql commands?

1175

---

Is sql harder than python?

1156

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1131

---

How do I filter in sql profiler?

1048

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2194

---

What is sap sql?

1028

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1046

---

What are the dml statements?

1195

---

What is the difference between left join and right join?

986

---

How do you rank data in sql?

1066

---