0

databases Online Quiz - 16

Description: databases Online Quiz - 16
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

What is the output of the the query: select 'Sql' from dual where null is null;

  1. No rows will be displayed

  2. Sql

  3. It throws Error

  4. None


Correct Option: B

What is the output of the below query: if table A is having 16 rows: select count(*) from A having 1=10;

  1. No rows will be displayed

  2. 0

  3. 16

  4. None


Correct Option: A

The below query can be used to get distinct sal from emp table: select unique sal from emp;

  1. True

  2. False


Correct Option: A

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

  1. Error

  2. 69

  3. 1

  4. None


Correct Option: B

Which pl/sql block gives error? A) begin null; end; B) begin return; end; C) declare begin null; return; end; D) begin end;

  1. A

  2. B

  3. C

  4. D


Correct Option: 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;

  1. A

  2. B

  3. C

  4. None


Correct Option: A,B,C

If emp table having 10 records what is the output of : select * from emp where rownum=8;

  1. It throws error

  2. it will give 8th row

  3. no rows will get displayed

  4. None


Correct Option: C

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

  1. sp_databases

  2. sp_spaceused

  3. db_dbm_space_file

  4. None of the above


Correct Option: A,B,C,D

By using unconnected lookup how many rows can be returned?

  1. 0

  2. 1

  3. 2

  4. Any Number


Correct Option: B

If the sources are comming from homogeneous databases then which transformation is required to join the sources?

  1. Joiner

  2. Lookup

  3. Source Qualifier

  4. All


Correct Option: C
  1. Connected

  2. Unconnected

  3. Active

  4. None


Correct Option: C

To check a record which is present in the target table or not. Then which transformation is required?

  1. Joiner

  2. Lookup

  3. Source Qualifier

  4. All


Correct Option: B

Data driven option is present in which transformation?

  1. Normalizer

  2. Sequence Generator

  3. Union

  4. Update strategy


Correct Option: D

which transformation filters based on more than one condition?

  1. Filter

  2. Router

  3. Lookup

  4. All


Correct Option: B

There are 4 sources.Then how many Joiner transformations required to join the sources?

  1. 1

  2. 2

  3. 3

  4. None


Correct Option: C

Stroed Procedure is --- transformation.

  1. Connected

  2. Unconnected

  3. Passive

  4. All


Correct Option: D

Sorted input is used for which transformation?

  1. Normalizer

  2. Sequence Generator

  3. Sorter

  4. Aggregator


Correct Option: D

SQL override option is present in which transformation?

  1. Filter

  2. Router

  3. Lookup

  4. Expression


Correct Option: C

wafhkALNDV

  1. AVs

  2. ASV

  3. AVS

  4. AVD


Correct Option: B

In databases, a view is which of the following?

  1. A virtual table that can be accessed via SQL commands

  2. A virtual table that cannot be accessed via SQL commands

  3. There is no difference between a view and a table

  4. None of these


Correct Option: A
- Hide questions