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

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

What command would you use to encrypt a PL/SQL application?

1 Answers  

what is rebuild index??

2 Answers   IBM, Sapient,

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1 Answers  

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

How to start SQL Server in minimal configuration mode?

2 Answers  

how can you create a user-defined lock?

1 Answers   Oracle,

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

1 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,

What are the commands used in dcl? : sql server DBA

1 Answers  

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

For more DB Administration Interview Questions Click Here
Categories