Tag: technology

Questions Related to technology

What is the size of a data page?
technology databases

  1. 5K to 10K

  2. 4K to 8K

  3. 4K to 10K

  4. 3K to 9K

Show answer
Correct Option: B

What is the maximum number of tables that can be stored on a Partitioned Table Space?
technology databases

  1. TWO

  2. ONE

  3. FIVE

  4. EIGHT

Show answer
Correct Option: B

Which is NOT a method that you can use to configure package configurations in SSIS packages?
technology

  1. SQL Server Table

  2. HKEY_LOCAL_MACHINE hive in the windows Registry

  3. XML file

  4. Environment variable

Show answer
Correct Option: B

What is the maximum number of tables that can be joined?
technology databases

  1. Twenty

  2. Eight

  3. Fifteen

  4. Six

Show answer
Correct Option: C

You are using SSIS to import a plain text file to SQL Server. You have found that some text files do not have a standard format. For example, the last field orderdate does not exist for some records. What is the best method you should use to import this file to SQL Server?
technology

  1. You cannot use SSIS to import non-standard text files

  2. Use a flat file connection and assign text file for the connection and get the data

  3. Use a flat file connection and Transformation option of the script component. The use some code get the orderdate

  4. Use fuzzy grouping and a flat file connection to get order date

Show answer
Correct Option: C

Can I use DB2 Stored Procedures with Debug Tool?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

When you COMMIT, is the cursor closed?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Is DECLARE CURSOR Executable?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Can you have more than one cursor open at any one time in a program?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

What is the Physical Storage Length of TIMESTAMP DB2 data type?
technology databases

  1. 10 Bytes

  2. 3 Bytes

  3. 8 Bytes

  4. 15 Bytes

Show answer
Correct Option: A