Answer / sweta

Dual is like a dummy table which contains 1 column and 1 row
in this.

Answer / dave

The dual table is a dummy table with one row and one column. Functions that do not require any table data can be evaluated by SELECTing from the dual table. For example,

SELECT SYSDATE FROM DUAL

returns the system time and date. The DUAL table is needed to get around the fact that the SELECT command in Oracle requires a FROM clause. For example, "SELECT SYSDATE" would fail because no tables were specified.

Answer / vijay

Dual is like a dummy table which consists of one row and one column

select sysdate from dual;

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

Explain an ORA-01555

2 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---