databases Online Quiz - 214
|Description: databases Online Quiz - 214|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
PL/SQL raises the predefined exception NO_DATA_FOUND if a SELECT INTO statement returns no rows
We cannot declare the same exception in two different blocks
which statement(s) does the following If @variable is NULL return '5', else return @variable
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?
Below is not in the steps to build the Dataware House :
Is Data modelling and Dimensional modelling same?
Which one is not the technique in ER modelling?
Select the correct order of clauses
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?
What is the displayed result of the following: SELECT 3 / 4 * 100?
What is the result of the following SQL statement? SELECT INDEX (SUBSTRING ('RALPH JOHNSON' FROM 6 FOR 5), 'OHN');
Which commands do the same thing?
Which operator works like an OUTER JOIN?
Which function return NULL when X = Y and X when it does not?