Tag: technology

Multiple choice technology databases

select avg(dummy) from dual; o/p:

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

select min(dummy) from dual union all select max(dummy) from dual group by dummy; o/p: ??

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

select min(dummy) from dual order by dummy union all select max(dummy) from dual; O/p:

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

select connect from dual; o/p:

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

select rowid from dual;

It will show one row but no column, no value, not even a NULL value.
1
0
NULL
One row with one column containing the ROWID of DUAL's single row (an 18-character rowid string, e.g. AAAADeAABAAAAgiAAA).

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

select rownum from dual;

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

select level from dual connect by level between 0 and 50; o/p:

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

select level from dual connect by level between 1 and 50 minus select level from dual connect by level between 2 and 50; o/p:

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

select level from dual connect by level between 3 and 50; o/p:

Reveal answer Fill a bubble to check yourself

Multiple choice technology

A LAN:

Reveal answer Fill a bubble to check yourself