Answer Posted / kamal kishore kashyap

display all the table which are currently in the schema.

What does over partition by mean in sql?

535

---

Is primary key an index?

538

---

What is the purpose of a secondary key?

513

---

What are the possible values that can be stored in a boolean data field?

517

---

What does the acronym acid stand for in database management?

547

---

---

how do you login to mysql using unix shell? : Sql dba

568

---

What is indexing oracle sql?

566

---

How does cross join work?

504

---

What are the various restrictions imposed on view in terms of dml?

524

---

What are the types of queries in sql?

524

---

Write a sql select query that only returns each name only once from a table?

572

---

What is sqlca in db2?

536

---

what is the difference between char and varchar data types? : Sql dba

543

---

Explain exception handling in pl/sql?

535

---

What does pl sql stand for?

659

---