Tag: databases

Questions Related to databases

What is the physical storage length of DB2 data types-DATE,TIME,TIMESTAMP?
technology databases

  1. 8 bytes, 6 bytes, 26 bytes

  2. 4 bytes, 3 bytes, 13 bytes

  3. 4 bytes, 3 bytes, 10 bytes

  4. 10 bytes, 8 bytes, 26 bytes

Show answer
Correct Option: D

How do you eliminate duplicate values in DB2 SELECT?
technology databases

  1. Use SELECT UNION(*)...in db2 query

  2. Use SELECT DISTINCT...in db2 query

  3. Use SELECT UNION ALL(...)...in db2 query

  4. Use SELECT DISTINCT ALL(*)...in db2 query

Show answer
Correct Option: B

DB2 is a relational database
technology databases

  1. True

  2. False

Show answer
Correct Option: A

One table can have more than one tablespace
technology databases

  1. True

  2. False

Show answer
Correct Option: A

SSIS uses connection managers to integrate different data sources into packages. IS Analysis Services Connection Manager is available?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

To Connect to Oracle database from SSIS OLE DB Connection Manager is not used.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Execute Process Task is Control Flow Item .
technology databases

  1. True

  2. False

Show answer
Correct Option: A

It is not Possible to Send Mail directly From SSIS Packages using
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Script component is used in both Control Flow as well as Data Flow.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

SSIS have the concept of Parent and Child Package.
technology databases

  1. True

  2. False

Show answer
Correct Option: A