1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Explain the concept of the DUAL table.

Question Posted / narmada kumari

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 can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

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,

What does coalescing a tablespace do?

1 Answers  

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

1 Answers   Cap Gemini, iGate,

Give the reasoning behind using an index.

2 Answers  




when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

Give two examples of referential integrity constraints.

2 Answers  

What is the difference between online backup & offline backup?

3 Answers   CSC,

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

For more DB Administration Interview Questions Click Here
Categories