Tag: databases

Questions Related to databases

Session Handling is done by which part of teradata system?
technology databases

  1. AMP

  2. PE

  3. BYNET

  4. CLIQUE

Show answer
Correct Option: B

TERADATA is Shared _________ architecture.
technology databases

  1. Nothing

  2. Everything

  3. Disk

  4. Processor

Show answer
Correct Option: A

Maximum no. of secondry indexes allowed on single table
technology databases

  1. 64

  2. 32

  3. 128

  4. 256

Show answer
Correct Option: B

Clique is a
technology databases

  1. Group of nodes that share a common set of disk arrays.

  2. Group of AMP's that share a common set of VDisk

  3. Group of PE's used for fault tolerance.

  4. Group of teradata systems.

Show answer
Correct Option: A

The rows of every table are distributed among all AMPs
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Each row in teradata system is identified using
technology databases

  1. Row hash

  2. Row id

  3. Hash map

  4. Hash value

Show answer
Correct Option: B

Teradata Basic concepts dictate that a Primary Key can be NULL
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which two statements about the Transient Journal are true?
technology databases

  1. It permits successful rollback to the last archive

  2. After the transaction is committed, the Before Images are discarded

  3. Transient Journal operation is automatic

  4. Before Images are kept until manually purged

Show answer
Correct Option: B,C

what can be the possible value for the data type number(4,3)?
technology databases

  1. 25.358

  2. 1254.663

  3. 1.1242

  4. 2.425

Show answer
Correct Option: D

Which among these are pseudo columns
technology databases

  1. rowid

  2. sysdate

  3. rownum

  4. all of the above

Show answer
Correct Option: D