Answer Posted / fahad sami

1

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1436

---

How to add, remove, modify users using sql?

1032

---

how do you tune the slow running queries in oracle db , explain the methodology

2726

---

What is output spooling in sql*plus?

1030

---

What are synonyms in sql?

969

---

Which function is used to return remainder in a division operator in sql?

1136

---

What is the difference between left join and right join?

942

---

How to avoid using cursors?

1118

---

What is a primary key? Explain

972

---

Is a secondary key the same as a foreign key?

1034

---

What is count * in sql?

993

---

Can we rename a column in the output of sql query?

993

---

What are the parts of a basic sql query?

966

---

Explain normalization and what are the advantages of it?

951

---

Explain the rollback statement?

1005

---