0

databases Online Quiz - 214

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

PL/SQL raises the predefined exception NO_DATA_FOUND if a SELECT INTO statement returns no rows

  1. True

  2. False


Correct Option: A

We cannot declare the same exception in two different blocks

  1. True

  2. False


Correct Option: B
  1. ISNULL(@variable,'5')

  2. NULLIF(@variable,'5')

  3. COALESCE(@variable,'5')

  4. NONNULL(@variable,'5')


Correct Option: A,C

I want my row numbers to come up as 1,2,2,2,3 while using a ranking function. Which ranking function should I use?

  1. ROW_NUMBER()

  2. RANK()

  3. DENSE_RANK()

  4. NTILE(integer_expression)


Correct Option: C
  1. Requirement gathering

  2. Data modeling

  3. Data profiling

  4. Data mining


Correct Option: D

Process in which data from disparate, homogeneous or heterogeneous systems is cleansed, aggregated, consolidated, de-normalized and loaded into a single database or data warehouse after applying business rules is :

  1. Data Profiling

  2. Data Modelling

  3. Data Integration

  4. Data Staging


Correct Option: C

Can you convert a snowflake schema in to star schema?

  1. True

  2. False


Correct Option: A

Is Data modelling and Dimensional modelling same?

  1. True

  2. False


Correct Option: B

Which one is not the technique in ER modelling?

  1. Conceptual modelling

  2. Physical modelling

  3. Logical modelling

  4. None of the above


Correct Option: D

Another name for the EXCEPT operator is __________.

  1. INSTEAD OF

  2. NOT IN

  3. INTERSECT

  4. MINUS


Correct Option: D

Select the correct order of clauses

  1. GROUP BY, HAVING, WHERE

  2. HAVING, WHERE, GROUP BY

  3. GROUP BY, WHERE, HAVING

  4. WHERE, GROUP BY, HAVING


Correct Option: D
  1. Both the INSERTs and the UPDATE fails.

  2. The INSERTs work, but the UPDATE fails

  3. Only the first INSERT works.

  4. Only the second INSERT works


Correct Option: C

What is the displayed result of the following: SELECT 3 / 4 * 100?

  1. 0

  2. .75

  3. 75

  4. 75.00


Correct Option: A
  1. If the Join is a SELF JOIN.

  2. Only if the WHERE clause is not used.

  3. If the keyword INNER is specified.

  4. all the time.


Correct Option: C
  1. Global Temporary

  2. Permanent

  3. Derived

  4. Volatile


Correct Option: A
  1. HAVING and GROUP BY

  2. HAVING and QUALIFY

  3. QUALIFY and QUANTIFY

  4. QUALIFY and ORDER BY


Correct Option: B
  1. Minus

  2. Except

  3. Intersect

  4. Union


Correct Option: D

Which function return NULL when X = Y and X when it does not?

  1. NULLIF(X,Y)

  2. COALESCE(X,Y)

  3. ZEROIFNULL(X,Y)

  4. NULLIFZERO(X,Y)


Correct Option: A
- Hide questions