What is NOCOPY?

6 Answers   DELL,

---

How to add new employee details in an employee_details table with the following details

0 Answers  

---

What is sql profiling in oracle?

0 Answers  

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

---

What are all types of user defined functions?

0 Answers  

---

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

---

cursor types? explain with example programs?

1 Answers   HP,

---

Explain how exception handling is done in advance pl/sql?

0 Answers  

---