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

AI Explanation

To answer this question, we need to understand what a B37 abend is and its possible causes.

A B37 abend is an error that occurs in IBM's Mainframe environment, specifically in the Job Control Language (JCL) when executing a job or a utility like SPUFI (SQL Processor Using File Input). It indicates that there is insufficient space available to complete the job or utility.

Given this information, let's go through each option to understand why it is correct or incorrect:

Option A) Space Issues - This option is correct because a B37 abend is indeed caused by insufficient space. When executing SPUFI, if there is not enough space allocated for the job or utility, it will result in a B37 abend.

Option B) Data Issues - This option is incorrect. While data issues can cause errors in SPUFI or other utilities, a B37 abend specifically relates to space issues and not data issues.

Option C) No records found while querying the table - This option is incorrect. A B37 abend does not occur due to a lack of records found while querying a table. It is solely related to space issues.

Option D) Both a & b - This option is incorrect. A B37 abend is only due to space issues and not data issues.

Therefore, the correct answer is A) Space Issues. This option is correct because a B37 abend during SPUFI is indeed caused by insufficient space.

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