Answer Posted / ashwin kumar

yes, a table may have more than 1 primary keys but, of them
we only choose 1 column as identifiable column called
primary key. The other columns are called surrogate keys or
candidate key.

What is sorting in sql?

898

---

Explain commit, rollback and savepoint.

933

---

What do we need to check in database testing?

966

---

List the different type of joins?

1004

---

What is the difference between rollback and rollback to statements?

1015

---

What is coalesce in sql?

975

---

What is basic structure of pl sql?

990

---

How do I upgrade sql?

949

---

what is a composite key ? : Sql dba

995

---

How delete a row in sql?

929

---

Differentiate between syntax and runtime errors.

1120

---

how to use 'mysql' to run sql statements? : Sql dba

986

---

Mention what does the hierarchical profiler does?

1023

---

How do you use join?

890

---

What is int identity in sql?

1064

---