Answer Posted / avinav

By using the rank function we can get the 2nd highest
salary from the emp table

What is the difference between drop and truncate commands?

1110

---

What is forward declaration in pl sql?

1139

---

List and explain the different types of join clauses supported in ansi-standard sql?

1400

---

What is a unique key?

1103

---

How do I save a stored procedure?

1067

---

What is a schema? How is it useful in sql servers?

1174

---

How many scalar data types are supported in pl/sql?

1103

---

Is sql the best database?

1022

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1392

---

What is keys and its types?

1121

---

What is substitution variable?

1095

---

what is a field in a database ? : Sql dba

1096

---

Define select, insert, create, delete, update, drop keywords

1094

---

What is a data manipulation language?

1073

---

What is difference between hql and native sql?

1236

---