Tag: databases

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

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

What is the output of the below query: if table A is having 16 rows: select count(*) from A having 1=10;

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

Which pl/sql block gives error? A) begin null; end; B) begin return; end; C) declare begin null; return; end; D) begin end;

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

By using unconnected lookup how many rows can be returned?