Answer / nishi

A table is the basic unit of data storage in an Oracle database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

What is hash cluster in oracle?

1 Answers  

---

Difference between hot backup vs. Cold backup?

1 Answers  

---

Can you use a commit statement within a database trigger?

4 Answers  

---

what is host string in sql plus? how does it related to database?

1 Answers  

---

Please explain oracle data types with examples?

1 Answers  

---

How to use subqueries with the in operator using oracle?

1 Answers  

---

What is the difference between formal parameters and actual parameters?

1 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

Which are the five query types available in oracle?

1 Answers  

---

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

3 Answers   Satyam,

---

What is the scope of a local variable?

1 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1 Answers  

---