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 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?
If the sources are comming from homogeneous databases then which transformation is required to join the sources?
To check a record which is present in the target table or not. Then which transformation is required?
Data driven option is present in which transformation?
which transformation filters based on more than one condition?
There are 4 sources.Then how many Joiner transformations required to join the sources?
Stroed Procedure is --- transformation.
Sorted input is used for which transformation?
SQL override option is present in which transformation?
wafhkALNDV
In databases, a view is which of the following?