Tag: databases

Questions Related to databases

Can 2 functions have same name & input parameters but differ only by return data type?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which figure represents Terabyte

technology databases

  1. 10^3

  2. 10^10

  3. 10^9

  4. 10^12

Show answer
Correct Option: D

Teradata considered as fastest OLAP based RDBMS because of
technology databases

  1. Parall architecture

  2. Serial architecture

  3. Scalability

  4. Performacnce

Show answer
Correct Option: A

Which OS does not support teradata RDBMS installation

technology databases

  1. UNIX-MPRAS

  2. UNIX-LINUX

  3. UNIX-AIX

  4. UNIX-HP-UX

Show answer
Correct Option: C,D

Which is not a member of TTU(teradata tools and utilizes)?
technology databases

  1. Fastload

  2. Multiload

  3. FastExport

  4. Datastage

Show answer
Correct Option: D

What is the latest version of Teradata RDBMS available in market?
technology databases

  1. V2R5

  2. V2R6

  3. V2R12

  4. V2R13

Show answer
Correct Option: D

which table supports duplicate rows insertion?
technology databases

  1. Set

  2. Multiset

  3. Volatile

  4. Temporary

Show answer
Correct Option: B

which one is used to monitor performance of teradata processes?
technology databases

  1. SQL assistant

  2. BTEQ

  3. PMON

  4. Statistics wizard

Show answer
Correct Option: C

How many codd rules are applied in Teradata?
technology databases

  1. 7

  2. 8

  3. 12

  4. 10

Show answer
Correct Option: C

How many sessions can be handled in single session?

technology databases

  1. 60

  2. 120

  3. 80

  4. 30

Show answer
Correct Option: B