Tag: databases

Questions Related to databases

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

When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?
technology databases

  1. Yes

  2. No

  3. It Depends

  4. None of the above

Show answer
Correct Option: B

Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?
technology databases

  1. The cursor is moved to another row

  2. The row the cursor is on is deleted by the application

  3. The row the cursor is on is deleted by another application

  4. The row the cursor is on needs to be updated by another application

Show answer
Correct Option: B

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