Answer Posted / saraswathi muthuraman

Oracle will have a default table called 'DUAL'.
Dual table will have only one column "DUMMY". U cann't
insert values into dual table. By default, a row will
existing in dual table.

SQL> desc dual;
DUMMY varchar2(1)

SQL> select * from dual;

X

1 row selected.

SQL> insert into dual values (10);
insert into dual values (10)
*
ERROR at line 1:
ORA-01031: insufficient privileges


U can create you own table with the name of dual.

SQL> create table dual(xy number,zz number);

Table created.

SQL> desc dual;
xy number
zz number

u can insert values in you own dual table.

What do you mean by redo log file mirroring?

1034

---

What is the exact use of Collections?

2143

---

Explain the importance of .pll extension in oracle?

1013

---

What is not equal to in oracle?

1003

---

What is the disadvantage of User defind function?

2295

---

Which are the five query types available in oracle?

949

---

What is the data pump import utility?

1038

---

What are privileges and grants?

1067

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2397

---

What is meant by recursive hints in oracle?

1089

---

How can I see all tables in oracle?

1011

---

What is primefaces used for?

1049

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2906

---

Please explain joins in oracle?

1062

---

What is format trigger?

2075

---