Tag: databases

Questions Related to databases

Is Data modelling and Dimensional modelling same?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which one is not the technique in ER modelling?
technology databases

  1. Conceptual modelling

  2. Physical modelling

  3. Logical modelling

  4. None of the above

Show answer
Correct Option: D

Another name for the EXCEPT operator is __________.

technology databases

  1. INSTEAD OF

  2. NOT IN

  3. INTERSECT

  4. MINUS

Show answer
Correct Option: D

Select the correct order of clauses
technology databases

  1. GROUP BY, HAVING, WHERE

  2. HAVING, WHERE, GROUP BY

  3. GROUP BY, WHERE, HAVING

  4. WHERE, GROUP BY, HAVING

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

  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

Show answer
Correct Option: C

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

technology databases

  1. 0

  2. .75

  3. 75

  4. 75.00

Show answer
Correct Option: A

In a Join, when is the ON clause required?

technology databases

  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.

Show answer
Correct Option: C

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

technology databases

  1. 3

  2. 5

  3. 6

  4. 2

Show answer
Correct Option: A

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

  1. Global Temporary

  2. Permanent

  3. Derived

  4. Volatile

Show answer
Correct Option: A

Which commands do the same thing?
technology databases

  1. HAVING and GROUP BY

  2. HAVING and QUALIFY

  3. QUALIFY and QUANTIFY

  4. QUALIFY and ORDER BY

Show answer
Correct Option: B