Tag: databases

Questions Related to databases

  1. Teradata SQL Assistant

  2. BTEQ

  3. Teradata Manager

  4. TDQM


Correct Option: D
  1. Temporary space is spool space currently not used

  2. Temporary space is permanent space currently not used.

  3. Temporary space is subtracted from SysAdmin

  4. Temporary space is assigned at the table level.


Correct Option: B

Of the following, which two are attributes of a Teradata warehouse? (Choose two)

  1. Customer applications drive the processes.

  2. Relational databases are more flexible than other types.

  3. Businesses are able to quickly respond to changing conditions

  4. It is built to reflect business application models.


Correct Option: B,C
  1. A primary Index is a physical mechanism.

  2. There is a limit to the number of columns in a Primary Index.

  3. A Primary Index requires uniqueness

  4. A Primary Index value can not be null.


Correct Option: A,B
  1. The order of rows in a table is arbitrary

  2. A table can contain only one row formats

  3. The order of rows in a table is keyed to Primary Index.

  4. A table can contain multiple row formats


Correct Option: A,B

What option can best describe Teradata’s architecture?

  1. Shared everything

  2. Shared memory

  3. Shared nothing

  4. Shared data


Correct Option: C
  1. A row is one instance of all columns.

  2. Row sequence is specified.

  3. Duplicate rows are allowed in a table.

  4. Rows can have different formats.


Correct Option: A
  1. Transactions are write intensive

  2. The number rows per transaction is large

  3. Transactions typically occur within seconds, not minutes

  4. The number of rows per transaction is small


Correct Option: A,C
  1. A NUPI requires less disk space to store the data row.

  2. A NUPI may be more effective for query access and joins.

  3. A NUPI query amplifies the optimization process in the PE.

  4. A NUPI provides better data distribution


Correct Option: B