Tag: databases

Questions Related to databases

Run-time errors arise from
technology databases

  1. Hardware failures

  2. Design faults

  3. Coding mistakes

  4. None of the above

  5. All of the above

Show answer
Correct Option: E

___ exception is raised ___ whenever your PL/SQL program violates an Oracle rule or exceeds a system-dependent limit
technology databases

  1. internal, explicitly

  2. internal, implicitly

  3. user-defined, explicitly

  4. user-defined, implicitly

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: A

We cannot declare the same exception in two different blocks
technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

  1. ISNULL(@variable,'5')

  2. NULLIF(@variable,'5')

  3. COALESCE(@variable,'5')

  4. NONNULL(@variable,'5')

Show answer
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?

technology databases

  1. ROW_NUMBER()

  2. RANK()

  3. DENSE_RANK()

  4. NTILE(integer_expression)

Show answer
Correct Option: C

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

technology databases

  1. rem

  2. ls

  3. rm -R

  4. del

Show answer
Correct Option: C

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

technology databases

  1. Requirement gathering

  2. Data modeling

  3. Data profiling

  4. Data mining

Show answer
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 :
technology databases

  1. Data Profiling

  2. Data Modelling

  3. Data Integration

  4. Data Staging

Show answer
Correct Option: C

Can you convert a snowflake schema in to star schema?
technology databases

  1. True

  2. False

Show answer
Correct Option: A