Tag: databases

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;

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

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;

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

By using unconnected lookup how many rows can be returned?