Tag: databases

What is the output of the the query: select 'Sql' from dual where null is null;

The below query can be used to get distinct sal from emp table: select unique sal from emp;

Output of the query if emp table is having 100 rows: select rownum from emp group by rownum having rownum = 69;

If emp table is having 10 rows, which of the below queries executes successfully without error? A) delete from emp; B) delete emp; C) delete emp where 1=1;

If emp table having 10 records what is the output of : select * from emp where rownum=8;

Select the option to find the size of the database in sql server