Explain the concept of the DUAL table.

Question Posted / narmada kumari

3 Answers
6260 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

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers IBM,

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

When a user process fails, what background process cleans up after it?

1 Answers

What is the default fill factor value? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here