0

databases Online Quiz - 115

Description: databases Online Quiz - 115
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. The right table will return ALL rows.

  2. The right table will return NULL.

  3. Both tables will return NULL.

  4. The left table will return ALL rows.

  5. The left table will return NULL.


Correct Option: D
  1. Structure

  2. Design issue

  3. Data source

  4. Storage issue

  5. Operational process


Correct Option: B
  1. Data about data

  2. Describes a data dictionary

  3. Self-describing

  4. Includes user data

  5. Supports its own structure


Correct Option: D
  1. Encryption key management

  2. Graphical User Interface Widgets

  3. Thread creation, execution, & coordination

  4. Network socket creation/operation

  5. If/Then, for, do/while statements


Correct Option: E
  1. More entities are needed.

  2. The model should be denormalized.

  3. The tables are not properly indexed.

  4. The model cannot be implemented physically.

  5. More attributes are needed.


Correct Option: E

If there are 3 persons with last names JOHN, J and JAMES how many of them are included in the result set of the query "SELECT LAST_NAME FROM STAFF WHERE LAST_NAME BETWEEN 'A' AND 'J'"

  1. 3

  2. 2

  3. 1

  4. 0


Correct Option: C

NULL values are ingnored for all SQ: 2008 aggregate functions.

  1. True

  2. False


Correct Option: A

UNION ALL is faster than a UNION

  1. True

  2. False


Correct Option: A

The query performance increases by using NOT operator.

  1. True

  2. False


Correct Option: B

Which one is single-row function

  1. STDDEV

  2. VARIANCE

  3. ROUND

  4. COUNT


Correct Option: C
    • , + (Unary operators, negation)
    • , / (Multiplication, division)
  1. +, - , || (Addition, subtraction, concatenation)

  2. NONE of these


Correct Option: A,B,C

Which of these is NOT a inequality symbol ??

  1. !=

  2. <>

  3. =^

  4. ^=


Correct Option: C
- Hide questions