Tag: technology

Questions Related to technology

A new table has been created in the employee. There are no rows in the table.What would be the output of the following query?select count(*) from employee
technology databases

  1. Error

  2. 1

  3. No data Found

  4. 0

Show answer
Correct Option: D

Which of the query will print the output as 'TCS' (single quotes should come in the output of the query)

technology databases

  1. select '''||'TCS'||''' from dual

  2. select 'TCS' from dual

  3. select '''TCS''' from dual

  4. select "TCS" from dual

Show answer
Correct Option: A

What's the output select to_Date('2009-may-25','yyyymmdd') from dual

technology databases

  1. 2009-may-25

  2. Error

  3. may-2009-25

  4. 200925may

Show answer
Correct Option: B

Which of the query will print the output as 'TCS' (single quotes should come in the output)

technology databases

  1. select '''||'TCS ||''' from dual

  2. select '''TCS''' from dual

  3. select "TCS" from dual

  4. select 'TCS' from dual

Show answer
Correct Option: B

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