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;

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

1 Answers   STC,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

what are the differences of where and if in SAS?

0 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

what is a crs resource?

0 Answers   Oracle,

---