Tag: databases

Questions Related to databases

What are the different types of Merges
technology databases

  1. Trivial

  2. Non-Trivial

  3. Automatic

  4. All the above

Show answer
Correct Option: D

Following files cannot be merged
technology databases

  1. Html

  2. Java

  3. Binary

  4. Ascii

Show answer
Correct Option: C

What is a view config spec
technology databases

  1. It specifies which versions of the element should appear in the view

  2. It specifies what type of branching logic used.

  3. All the above

  4. None of the above

Show answer
Correct Option: A

What are the key products of IBM ClearCase Family
technology databases

  1. ClearCase LT

  2. ClearCase

  3. ClearCase MultiSite

  4. All the above

Show answer
Correct Option: D

What are the different clear case Roles
technology databases

  1. Configuration Manager

  2. Administrator

  3. Tester

  4. a & b

Show answer
Correct Option: D

What are the responsilibities of a Developer
technology databases

  1. Sets up workspace

  2. Integrates changes

  3. Creates baseline

  4. a & b

Show answer
Correct Option: D

What is the Lost and Found Directory
technology databases

  1. Contains orphaned elements, which are no longer catalogued in any version of any directory

  2. All the deleted elements will be stored

  3. It the meta directory of the ClearCase

  4. None

Show answer
Correct Option: A

Given the following scenario: Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in col-umn COL1. Which of the following would be the most appropriate DB2 data type to use for column COL1?

technology databases

  1. INTEGER

  2. REAL

  3. NUMERIC (7,3)

  4. DECIMAL(10,3)

Show answer
Correct Option: D

An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?
technology databases

  1. The application must release the row-level Share lock it holds and acquire an Update lock on the row

  2. The application must release the row-level Share lock it holds and acquire an Update lock on the table

  3. The row-level Share lock will automatically be converted to a row-level Up-date lock

  4. The row-level Share lock will automatically be escalated to a table-level Up-date lock

Show answer
Correct Option: C

Which of the following is a NOT a valid reason for defining a view on a table?

technology databases

  1. Restrict users' access to a subset of table data

  2. Ensure that rows inserted remain within the scope of a definition

  3. Produce an action as a result of a change to a table

  4. Provide users with an alternate view of table data

Show answer
Correct Option: C