databases Online Quiz - 16
Description: databases Online Quiz - 16 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
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;
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 having 10 records what is the output of : select * from emp where rownum=8;
If the sources are comming from homogeneous databases then which transformation is required to join the sources?
Stroed Procedure is --- transformation.
wafhkALNDV
In databases, a view is which of the following?