databases Online Quiz - 238

Description: databases Online Quiz - 238
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

It is impossible to have skewed data when employing a Non-Unique Primary Index value?

  1. True

  2. False

Correct Option: B
  1. Creates an output map to aid in redistributing data

  2. Data distribution is automatic

  3. Creates a reconfig map to help the DBA repartition data

  4. None of the above

Correct Option: B
  1. The uniqueness value is a component of the row hash value.

  2. In a table that has a NUPI, all rows with the same NUPI value are distributed to the same AMP.

  3. Two Primary Index values that hash to the same row hash value are called hash synonyms.

  4. The output of the hashing algorithm is called the hash map

Correct Option: B,C
  1. AMP's

  2. Parser

  3. Dispatcher

  4. Bynet

  5. Optimiser

Correct Option: B,C,E

Each AMP Corresponds to a particular Vdisk.

  1. True

  2. False

Correct Option: A
  1. Multiple

  2. One

  3. Two

  4. All of the above

Correct Option: B

Features of Primary Key are:

  1. Unique

  2. Non Unique

  3. Null

  4. Not Null

  5. All of the above

Correct Option: A,D
  1. Fastload

  2. Multiload

  3. BTEQ

  4. TPump

  5. Teradata warehouse builder

Correct Option: B,C,E
  1. Can populate Single table

  2. Can load populated tables

  3. Tables with SI and referential integrity can be loaded

  4. Very fast if target table is empty

  5. Table loaded can be accesed while fastload runs.

Correct Option: A,D
  1. BTEQ




  5. TPUMP

Correct Option: B,C,E
  1. having clause

  2. where clause

  3. order by clause

  4. group by clause

Correct Option: C

The standard EMP table contains 14 records corresponding to the employess of the corporation.One of those records has a NULL value stored in the MGR column.If Issue the following command on the table:select count(mgr) from emp;which of the following choice indentifies the result oracle will return

  1. <14

  2. >14

  3. 14

  4. 0

Correct Option: A
- Hide questions