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;

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---