Tag: databases

Questions Related to databases

Which of the following is NOT a valid method of authentication that can be used by DB2 9?
technology databases

  1. SERVER

  2. CLIENT

  3. DCS

  4. SERVER_ENCRYPT

Show answer
Correct Option: C

Which authority or privilege is granted by the DB2 Database Manager configuration file?
technology databases

  1. CONNECT

  2. CONTROL

  3. SYSMAINT

  4. EXECUTE

Show answer
Correct Option: C

Which of the following tools can NOT be used to catalog a database?
technology databases

  1. Control Center

  2. SQL Assist

  3. Configuration Assistant

  4. Command Line Processor

Show answer
Correct Option: B

Which type of key is defined on the child table to implement a referential constraint?
technology databases

  1. Primary key

  2. Unique key

  3. Foreign key

  4. Composite key

Show answer
Correct Option: A

Which of the following DB2 data types does NOT have a fixed length?
technology databases

  1. INT

  2. CHAR

  3. XML

  4. DOUBLE

Show answer
Correct Option: C

Which of the following DB2 data types can be used to store 1000MB of single-byte character data?
technology databases

  1. BLOB

  2. CLOB

  3. DBCLOB

  4. GRAPHIC

Show answer
Correct Option: B

Which of the following isolation levels will lock all rows scanned to build a result data set?
technology databases

  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read

Show answer
Correct Option: D

Q1
technology databases

  1. Enterprise reverse planning

  2. Enterprise revenue Planning

  3. Effective resource planning

  4. Enterprise resource planning

Show answer
Correct Option: D

Q2
technology databases

  1. It is a KeyFlex field used to store different segment values.

  2. It will store attribute values that will be used to track future requirements.

  3. knowledge Flex Field

  4. It is containing of one segment

Show answer
Correct Option: A

Q6
technology databases

  1. True

  2. False

Show answer
Correct Option: B