Is Data modelling and Dimensional modelling same?
True
False
Which one is not the technique in ER modelling?
Conceptual modelling
Physical modelling
Logical modelling
None of the above
Another name for the EXCEPT operator is __________.
INSTEAD OF
NOT IN
INTERSECT
MINUS
Select the correct order of clauses
GROUP BY, HAVING, WHERE
HAVING, WHERE, GROUP BY
GROUP BY, WHERE, HAVING
WHERE, GROUP BY, HAVING
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?
Both the INSERTs and the UPDATE fails.
The INSERTs work, but the UPDATE fails
Only the first INSERT works.
Only the second INSERT works
What is the displayed result of the following: SELECT 3 / 4 * 100?
0
.75
75
75.00
In a Join, when is the ON clause required?
If the Join is a SELF JOIN.
Only if the WHERE clause is not used.
If the keyword INNER is specified.
all the time.
What is the result of the following SQL statement? SELECT INDEX (SUBSTRING ('RALPH JOHNSON' FROM 6 FOR 5), 'OHN');
3
5
6
2
Which type of table provides the DDL, but does not share the data
Global Temporary
Permanent
Derived
Volatile
Which commands do the same thing?
HAVING and GROUP BY
HAVING and QUALIFY
QUALIFY and QUANTIFY
QUALIFY and ORDER BY