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

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

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

CREATE SET TABLE A (A Integer, B Integer) Unique Primary Index (A) INSERT INTO Table A (1, 2) INSERT INTO Table A (1, 1) UPDATE Table A SET b = b + 1 WHERE b = 1. Which statement is correct?

  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

In a Join, when is the ON clause required?

  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

What is the result of the following SQL statement? SELECT INDEX (SUBSTRING ('RALPH JOHNSON' FROM 6 FOR 5), 'OHN');

  1. 3

  2. 5

  3. 6

  4. 2


Correct Option: A

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

Which commands do the same thing?

  1. HAVING and GROUP BY

  2. HAVING and QUALIFY

  3. QUALIFY and QUANTIFY

  4. QUALIFY and ORDER BY


Correct Option: B

Which operator works like an OUTER JOIN?

  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