Explain the concept of the DUAL table.

Answer Posted / sweta

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

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between clustered and non-clustered index? : sql server DBA

545


what are the differences of where and if in SAS?

1662


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1969


What are statistics, under what circumstances they go out of date, how do you update them?

1804


What is transparent data encryption? : sql server DBA

562






What are the different types of database compression introduced in sql server 2008? : sql server DBA

564


when does an alert gets signaled?

578


How would you extract DDL of a table without using a GUI tool?

2046


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

546


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1653


how can you connect from 10g user to 11g user??

1681


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

3940


What the different types of replication and why are they used? : sql server DBA

558


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1976


how can you get actual data change values from previous transactions in oracle?

609