Question 1

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

technology databases

True
False

Answer

Correct Option: A

Question 2

We cannot declare the same exception in two different blocks

technology databases

True
False

Answer

Correct Option: B

Question 3

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

technology databases

ISNULL(@variable,'5')
NULLIF(@variable,'5')
COALESCE(@variable,'5')
NONNULL(@variable,'5')

Answer

Correct Option: A,C

Question 4

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

ROW_NUMBER()
RANK()
DENSE_RANK()
NTILE(integer_expression)

Answer

Correct Option: C

Question 5

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

technology databases

rem
ls
rm -R
del

Answer

Correct Option: C

Question 6

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

technology databases

Requirement gathering
Data modeling
Data profiling
Data mining

Answer

Correct Option: D

Question 7

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

Data Profiling
Data Modelling
Data Integration
Data Staging

Answer

Correct Option: C

Question 8

Can you convert a snowflake schema in to star schema?

technology databases

True
False

Answer

Correct Option: A

Question 9

Is Data modelling and Dimensional modelling same?

technology databases

True
False

Answer

Correct Option: B

Question 10

Which one is not the technique in ER modelling?

technology databases

Conceptual modelling
Physical modelling
Logical modelling
None of the above

Answer

Correct Option: D

Question 11

Another name for the EXCEPT operator is __________.

technology databases

INSTEAD OF
NOT IN
INTERSECT
MINUS

Answer

Correct Option: D

Question 12

Select the correct order of clauses

technology databases

GROUP BY, HAVING, WHERE
HAVING, WHERE, GROUP BY
GROUP BY, WHERE, HAVING
WHERE, GROUP BY, HAVING

Answer

Correct Option: D

Question 13

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?

technology databases

Both the INSERTs and the UPDATE fails.
The INSERTs work, but the UPDATE fails
Only the first INSERT works.
Only the second INSERT works

Answer

Correct Option: C

Question 14

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

technology databases

0
.75
75
75.00

Answer

Correct Option: A

Question 15

In a Join, when is the ON clause required?

technology databases

If the Join is a SELF JOIN.
Only if the WHERE clause is not used.
If the keyword INNER is specified.
all the time.

Answer

Correct Option: C

Question 16

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

technology databases

3
5
6
2

Answer

Correct Option: A

Question 17

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

technology databases

Global Temporary
Permanent
Derived
Volatile

Answer

Correct Option: A

Question 18

Which commands do the same thing?

technology databases

HAVING and GROUP BY
HAVING and QUALIFY
QUALIFY and QUANTIFY
QUALIFY and ORDER BY

Answer

Correct Option: B

Question 19

Which operator works like an OUTER JOIN?

technology databases

Minus
Except
Intersect
Union

Answer

Correct Option: D

Question 20

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

technology databases

NULLIF(X,Y)
COALESCE(X,Y)
ZEROIFNULL(X,Y)
NULLIFZERO(X,Y)

Answer

Correct Option: A

Description: databases Online Quiz - 214
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 214

Find more quizzes from top tags