Answer Posted / akilis.org@hotmail.com

Let us assume that
Table Name:salary
Coloumn Name:maxsal(int)
select * from salary order by maxsal desc limit 1,1;

What information is needed to connect sql*plus an oracle server?

588

---

Is sql a dbms?

536

---

Is sql a programming?

547

---

What are the 3 modes of parameter?

681

---

Does asenumerable execute the query?

605

---

---

What is a unique constraint?

610

---

Can you do multiple joins in sql?

548

---

What is db journal file?

520

---

Which query operators in sql is used for pattern matching?

546

---

What is over () in sql?

528

---

How is data stored in sql?

551

---

Could you please provide oca (oracle 10g) dumps for my certification ?

4513

---

what are all different types of collation sensitivity? : Sql dba

525

---

What sql does db2 use?

544

---

What is the syntax to add a record to a table?

577

---