what is the output of the the query: select 'Sql' from dual where null = null;
No rows will be displayed
Sql
It throws Error
None
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;
0
16
The below query can be used to get distinct sal from emp table: select unique sal from emp;
True
False
Output of the query if emp table is having 100 rows: select rownum from emp group by rownum having rownum = 69;
Error
69
1
Which pl/sql block gives error? A) begin null; end; B) begin return; end; C) declare begin null; return; end; D) begin end;
A
B
C
D
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;
It throws error
it will give 8th row
no rows will get displayed
Select the option to find the size of the database in sql server
sp_databases
sp_spaceused
db_dbm_space_file
None of the above
By using unconnected lookup how many rows can be returned?
2
Any Number