Tag: databases

Questions Related to databases

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

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 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

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 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

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

What is the restriction on using UNION in embedded SQL ?
technology databases

  1. It has to be in a CURSOR

  2. cannot be used in Embedded SQL

  3. No restrictions

  4. None of the above

Show answer
Correct Option: A

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

A declared temporary table is used for which of the following purposes?

technology databases

  1. Backup purposes

  2. Storing intermediate results

  3. Staging area for load operations

  4. Sharing result data sets between applications

Show answer
Correct Option: B