0

databases Online Quiz - 44

Description: databases Online Quiz - 44
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. OLAP

  2. MOLAP

  3. ROLAP

  4. OLTP


Correct Option: A
  1. To collect statistics

  2. To select best candidate to choose for collect statistics

  3. Provide statistics of load

  4. To easy access of data


Correct Option: B

Is rowId is available in TD?

  1. True

  2. False


Correct Option: A

Which one is equivalent to PK of oracle?

  1. UPI

  2. NUSI

  3. PI

  4. USI


Correct Option: A

Which tool used for population of already populatedĀ  table?

  1. Fastload

  2. MultiLoad

  3. FastExport

  4. TPUMP


Correct Option: B

How many minimum nodes are required for MPP instastalltion?

  1. 1

  2. 2

  3. 16

  4. 32


Correct Option: B
  1. Spool space must be specified during creation of the user

  2. Spool space is used to hold the intermediate result set

  3. Spool space is permanent space.

  4. Spool space is limited to the size of the table.


Correct Option: B
  1. Based on the secondary unique index

  2. Based on the Primary key of the table

  3. Based on the Primary Index of the table

  4. Based on the partitioning columnĀ 


Correct Option: C
  1. Gateway's

  2. PE's

  3. Nodes

  4. AMP's


Correct Option: C
  1. compare performance of multiple workloads

  2. recommend secondary indexes for a table

  3. recommend primay indexes for a table

  4. compare primay and secondary indexes for a table


Correct Option: B
- Hide questions