Tag: databases

Questions Related to databases

When the program name is not in the plan, we get
technology databases

  1. -810

  2. -801

  3. -805

  4. -825

Show answer
Correct Option: C

B37 abend during SPUFI is due to
technology databases

  1. Space Issues

  2. Data Issues

  3. No records found while querying the table

  4. Both a & b

Show answer
Correct Option: A

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 used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?

technology databases

  1. Check constraint

  2. Default constraint

  3. Unique constraint

  4. Informational constraint

Show answer
Correct Option: C

What authority is required to create a table?
technology databases

  1. ADMIN Privileges

  2. CREATETAB Privileges

  3. No Privileges

  4. USERTAB Privileges

Show answer
Correct Option: B

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

Which of the following tools can be used to automate table reorganization Operations ?

technology databases

  1. Control Center

  2. Command Center

  3. Command Line Processor

  4. Task Center

Show answer
Correct Option: D

How do you find the total number of rows in a table ?

technology databases

  1. SELECT COUNT *

  2. SELECT COUNT(*)

  3. SELECT COUNT[*]

  4. SELECT COUNT(ALL)

Show answer
Correct Option: B

Given the following statement: CREATE TABLE t1 col1  SMALLINT NOT NULL PRIMARY KEY, col2  VARCHAR(200) NOT NULL WITH DEFAULT NONE, col3  DECIMAL(5,2) CHECK (col3 >= 100.00), col4  DATE NOT NULL WITH DEFAULT) Which of the following definitions will cause the CREATE TABLE statement to fail?

technology databases

  1. COL1

  2. COL2

  3. COL3

  4. COL4

Show answer
Correct Option: B

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