Answer / Avanind Kumar Arya

"Bulk Load in Oracle is a method of loading large amounts of data into tables quickly and efficiently. It allows you to bypass the rules that normally apply during insert operations."

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

1 Answers  

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1 Answers   Microsoft,

---

How to use "out" parameter properly?

1 Answers  

---

How to define a record variable to store a table row?

1 Answers  

---

What is rich query?

1 Answers  

---

What is the maximum number of CHECK constraints that can be defined on a column ?

3 Answers  

---

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

---

primary key is foreign key for the same table?

2 Answers   Oracle,

---

Explain oracle 12c new features for developers?

1 Answers  

---

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

---

What is parameterized cursor in oracle?

1 Answers  

---