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

You are defining the operational process of your RDBMS. Referring to the scenario above, which one of the following is a valid ongoing "operational process?"

  1. OS requirement

  2. User analysis

  3. Performance monitoring

  4. Data dictionary specification

  5. System requirement


Correct Option: C

You have been asked to construct a query in the company's RDBMS. You have deployed a Right Outer Join operation. Referring to the scenario above, what will happen to the final results when there is NO match between the tables?

  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

Which operators can be used to produce summary totals in the result sets of SQL 2008.

  1. GROUPING

  2. WITH ROLL UP

  3. WITH CUBE

  4. WITH SUMMARY


Correct Option: B,C

UNION ALL is faster than a UNION

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: A
  1. STDDEV

  2. VARIANCE

  3. ROUND

  4. COUNT


Correct Option: C

which of this Operator Precedence is correct??

    • , + (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

What is the default display length of the DATE datatype column?

  1. 8

  2. 9

  3. 6

  4. 16


Correct Option: B
- Hide questions