Tag: databases

Questions Related to databases

Primary Index is used for

technology databases

  1. Access the rows

  2. Distribution of the rows

  3. Both a and b

  4. Only for distribution of rows to particular AMPs

Show answer
Correct Option: C

Fastload will not support

technology databases

  1. USI

  2. NUSI

  3. Both a and b

  4. Neither a nor b

Show answer
Correct Option: C

Primary index value can be changed

technology databases

  1. At a cost of row redistribution

  2. At a cost of table recreation

  3. When the table is empty

  4. None of the above

Show answer
Correct Option: A

Reading the rows using Non-Unique Secondary index is

technology databases

  1. One or Two AMP operation

  2. All AMP operation

  3. Many AMP operation

  4. Full table scan

Show answer
Correct Option: B

For PPI table, rows are first sorted by ------ at each AMPs

technology databases

  1. Hash Value

  2. Partition Number

  3. First column of the table

  4. Both a and b

Show answer
Correct Option: B

Reading the rows using Non-Unique Primary index is one AMP operation

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Teradata table will have ------ Primary Index

technology databases

  1. Many

  2. Two

  3. One

  4. 64

Show answer
Correct Option: C

Reading the rows using Unique Secondary index is

technology databases

  1. One or Two AMP operation depends on the base row location

  2. Always two AMP operation irrespective of the base row location

  3. Many AMP operation

  4. All AMP operation

Show answer
Correct Option: A

Views can be specified in a trigger statement

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Two functions can be used with the same name in a PL/SQL block

technology databases

  1. True

  2. False

Show answer
Correct Option: A