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

which statement(s) does the following If @variable is NULL return '5', else return @variable

  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

What is UNIX equalent of deltree (MS-DOS) command.

  1. rem

  2. ls

  3. rm -R

  4. del


Correct Option: C

Below is not in the steps to build the Dataware House :

  1. Requirement gathering

  2. Data modeling

  3. Data profiling

  4. Data mining


Correct Option: D
  1. Conceptual modelling

  2. Physical modelling

  3. Logical modelling

  4. None of the above


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

Which type of table provides the DDL, but does not share the data

  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
  1. NULLIF(X,Y)

  2. COALESCE(X,Y)

  3. ZEROIFNULL(X,Y)

  4. NULLIFZERO(X,Y)


Correct Option: A
- Hide questions