databases Online Quiz - 16
|Description: databases Online Quiz - 16|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
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;
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?
which transformation filters based on more than one condition?
Stroed Procedure is --- transformation.
In databases, a view is which of the following?