Tag: databases

Questions Related to databases

Which is the component that limits queries based on set thresholds?
technology databases

  1. Teradata SQL Assistant

  2. BTEQ

  3. Teradata Manager

  4. TDQM

Show answer
Correct Option: D

Which of the following is a statement that is true regarding temporary space?
technology databases

  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.

Show answer
Correct Option: B

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

technology databases

  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.

Show answer
Correct Option: B,C

Which two of the following statements are true regarding a Primary Index are accurate?
technology databases

  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.

Show answer
Correct Option: A,B

The method of creating rows, columns and tables is governed by which two relational database concepts? (Choose two)
technology databases

  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

Show answer
Correct Option: A,B

What option can best describe Teradata’s architecture?

technology databases

  1. Shared everything

  2. Shared memory

  3. Shared nothing

  4. Shared data

Show answer
Correct Option: C

What is a feature of a row according to relational concepts?
technology databases

  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.

Show answer
Correct Option: A

Which of the following are two factual statements regarding an OLTP environment? (Choose two)
technology databases

  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

Show answer
Correct Option: A,C

Why would you choose a Non-Unique Primary Index (NUPI) instead of a Unique Primary Index (UPI)?
technology databases

  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

Show answer
Correct Option: B

Which is the query tool that lets you access not only Teradata, but other databases as well?
technology databases

  1. BTEQ

  2. Teradata SQL Assistant

  3. Teradata Manager

  4. TDQM

Show answer
Correct Option: B