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

Which one of the following is NOT a characteristic of metadata?

  1. Data about data

  2. Describes a data dictionary

  3. Self-describing

  4. Includes user data

  5. Supports its own structure


Correct Option: D

Which one of the following capabilities do you expect to see in a majority of RDBMS extensions to ANSI SQL-92?

  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

For performance, you denormalize your database design and create some redundant columns. Referring to the scenario above, what RDBMS construct can you use to automatically prevent the repeated columns from getting out of sync?

  1. Cursors

  2. Constraints

  3. Views

  4. Stored procedures

  5. Trigger


Correct Option: E

The query performance increases by using NOT operator.

  1. True

  2. False


Correct Option: B

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

The query performance increases by using NOT operator.

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: A

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

When you try to save 34567.2255 into a column defined as NUMBER(7,2) what value is actually saved?

  1. 34567.00

  2. 34567.22

  3. 34567.23

  4. 3456.22


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