Answer Posted / l meher

select max(rownum) from table_name;

What does desc stand for?

588

---

List the different type of joins?

566

---

how is myisam table stored? : Sql dba

603

---

How subquery works in sql?

537

---

What is record data type?

510

---

---

what are the advantages of using stored procedures? : Sql dba

611

---

What are different types of keys?

519

---

how to convert dates to character strings? : Sql dba

533

---

Explain mutating table error.

641

---

Explain the working of foreign key?

540

---

How does cross join work?

498

---

What is the requirement of self-join?

537

---

What is optimistic concurrency control? : Transact sql

544

---

What is indexing in sql and its types?

537

---

Can one improve the performance of sql*loader? : aql loader

581

---