Tag: databases

Questions Related to databases

Which of the following tool can be used to monitor the state of the DB2 environment?

  1. Task Center

  2. Command Center

  3. Health Center

  4. Control Center


Correct Option: C

DB2 Extenders can handle non-traditional data. Which of the following type of data can Extenders not handle?

  1. XML

  2. File

  3. Spatial data

  4. Music


Correct Option: B

what is the type of lock that prevents all other types of lock ?

  1. Inclusive

  2. Exclusive

  3. Read

  4. Write


Correct Option: B

What is the teradata utility that can continuously load data into tables?

  1. Fastexp

  2. Fastload

  3. Multiload

  4. Tpump


Correct Option: D

What is the teradata utility that load data into empty tables?

  1. Fastexp

  2. Fastload

  3. Multiload

  4. Bteq


Correct Option: B

What is the limit of the no of columns on a primary key in relational model?

  1. 16

  2. 32

  3. 64

  4. There is no limit on the no. of columns.


Correct Option: D

Which of the following tables could be used for a user who wants to create a small Temporary table with Spool Space?

  1. Derived Table

  2. Volatile Table

  3. Global Temporary Table

  4. None


Correct Option: A,B

Teradata runs on which architecture ?

  1. shared memory

  2. shared nothing

  3. shared everything

  4. shared all


Correct Option: B

What is the teradata utility that restricts queries based on threshold values ?

  1. Teradata Manager

  2. DBQM

  3. Queryman

  4. Teradata Warehouse builder


Correct Option: A

Teradata Company founded in..?

  1. 1981

  2. 1978

  3. 1979

  4. 1989


Correct Option: C