Explain the concept of the DUAL table.

Question Posted / narmada kumari

3 Answers
6137 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain the concept of the DUAL table...

Answer / sweta

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

Is This Answer Correct ?

5 Yes

0 No

Explain the concept of the DUAL table...

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.

Is This Answer Correct ?

2 Yes

1 No

Explain the concept of the DUAL table...

Answer / vijay

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

select sysdate from dual;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB Administration Interview Questions

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers DELL, TCS,

Explain what partitioning is and what its benefit is.

2 Answers

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers

Why would you call update statistics? : sql server DBA

0 Answers

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers FA, GE, Wipro,

How to start SQL Server in minimal configuration mode?

1 Answers

how can you schedule a job in database?

0 Answers Oracle,

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

2 Answers

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers

what is the differnce between process and thread ?

1 Answers IBM,

For more DB Administration Interview Questions Click Here