Tag: mainframe

Questions Related to mainframe

If you want to maximize data concurrency without seeing uncommitted data, which isolation level should you use?
technology mainframe

  1. RR

  2. RS

  3. UR

  4. CS

Show answer
Correct Option: C

When a view is deleted, any dependent view is
technology mainframe

  1. Marked Deleted

  2. Marked Inoperative

  3. Marked Invalid

  4. Marked Cascaded

  5. None of above

Show answer
Correct Option: B

Which of the following delete rules will not allow a row to be deleted from the parent table if a row with the corresponding key value still exists in the child table?
technology mainframe

  1. DELETE

  2. CASCADE

  3. RESTRICT

  4. SET NULL

Show answer
Correct Option: C

Which of the following utilities would you run to order data and reclaim space from deleted rows in a table:
technology mainframe

  1. db2look

  2. db2move

  3. reorg

  4. runstats

Show answer
Correct Option: C

Given the Table STAFF ----------- ID LASTNAME 1 Malleswar 2 Kiran 3 Praveen 4 Yuva When issuing the query "SELECT * FROM STAFF" , the row return order will be based on which of the following?
technology mainframe

  1. An ambiguous order

  2. The primary key order

  3. The order that the rows were inserted into the table

  4. The values for the ID column, then the LASTNAME column

Show answer
Correct Option: A

Which of the following isolation levels is most likely to acquire a table level lock during an index scan?
technology mainframe

  1. Read Stability

  2. Cursor Stability

  3. Repeatable Read

  4. Uncommitted Read

Show answer
Correct Option: C

Immediately following the creation of an index on a table to improve query performance, which of the following SQL requests is adversely affected by the additional index?
technology mainframe

  1. FETCH

  2. SELECT

  3. PREPARE

  4. CONNECT

Show answer
Correct Option: C

Which of the following tools can be used to catalog a database?
technology mainframe

  1. Journal

  2. Alert Center

  3. License Center

  4. Client Configuration Assistant

Show answer
Correct Option: D

Which one of the following authorities can create a database?
technology mainframe

  1. SYSMAINT

  2. SYSCTRL

  3. DBCTRL

  4. SYSADM

Show answer
Correct Option: B

For which of the following database objects can locks NOT be obtained?
technology mainframe

  1. A row

  2. A table

  3. A column

  4. An index key

Show answer
Correct Option: C