Answer Posted / pradeep

Create database database_name;

What is varray?

811

---

How to list all indexes in your schema?

810

---

What is partitioned table in Oracle?

852

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

770

---

How to use "out" parameter properly?

846

---

How to assign a table row to a record variable?

774

---

How to install oracle odbc drivers?

865

---

Why oracle is used?

806

---

Explain what are the type of synonyms?

859

---

How to create id with auto_increment on oracle?

769

---

Please explain drop constraint oracle?

834

---

What is the data type of dual table?

710

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

784

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

777

---

Can we write insert statement in function in oracle?

839

---