0

mainframe Online Quiz - 108

Description: mainframe Online Quiz - 108
Number of Questions: 20
Created by:
Tags: mainframe
Attempted 0/20 Correct 0 Score 0

What are the differences between ')' and '>' shift operators?

  1. ')' shifts columns left and '>' shift data left

  2. ')' shifts columns and '>' shift data

  3. ')' shifts columns and '>' shift data to the right

  4. both B and C


Correct Option: D

The following commands are used to split a line

  1. :TS on command line and pressing enter by placing the cursor on desired split position of the line

  2. SPLIT on command prompt

  3. TS as line command and pressing enter by placing the cursor on desired split position of the line

  4. Break on Command prompt


Correct Option: A,C

'10000' on command line and pressing F8. What happens

  1. scrolls down 10,000 lines

  2. Scrolls 10,000 columns

  3. Invalid Scroll Amount

  4. We cannot issue such command


Correct Option: C

Among the following which is not a valid scroll amount?

  1. Half

  2. Data

  3. Full

  4. Page


Correct Option: C

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

  1. RR

  2. RS

  3. UR

  4. CS


Correct Option: C

When a view is deleted, any dependent view is

  1. Marked Deleted

  2. Marked Inoperative

  3. Marked Invalid

  4. Marked Cascaded

  5. None of above


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?

  1. DELETE

  2. CASCADE

  3. RESTRICT

  4. SET NULL


Correct Option: C

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

  1. db2look

  2. db2move

  3. reorg

  4. runstats


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?

  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


Correct Option: A

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

  1. Read Stability

  2. Cursor Stability

  3. Repeatable Read

  4. Uncommitted Read


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?

  1. FETCH

  2. SELECT

  3. PREPARE

  4. CONNECT


Correct Option: C

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

  1. Journal

  2. Alert Center

  3. License Center

  4. Client Configuration Assistant


Correct Option: D

Which one of the following authorities can create a database?

  1. SYSMAINT

  2. SYSCTRL

  3. DBCTRL

  4. SYSADM


Correct Option: B

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

  1. A row

  2. A table

  3. A column

  4. An index key


Correct Option: C

Which of the following table locks will prevent concurrent applications (except for the lock owner) from having any access to the table, except read access by applications using UR isolation level?

  1. Z

  2. X

  3. S

  4. U


Correct Option: B

Which of the following products can be used to store image data in a DB2 database?

  1. Net.Data

  2. Net Search

  3. DB2 AVI Extenders

  4. DB2 XML Extenders

  5. DB2 Text Extenders


Correct Option: C

Which of the following statements eliminates all but one of each set of duplicate rows in the final result table?

  1. SELECT UNIQUE * FROM t1

  2. SELECT DISTINCT * FROM t1

  3. SELECT UNIQUE (*) FROM t1

  4. SELECT DISTINCT (*) FROM t1

  5. None of above


Correct Option: B

Which of the following will occur when a view is created on a DB2 table?

  1. Memory usage is reduced

  2. Query compilation time is reduced

  3. Data access time is increased

  4. Data access control is increased


Correct Option: D

RSA (Key feed back area) stands for

  1. Record Segment Argument

  2. Record Setting Argument

  3. Record Selection Argument

  4. Record Specifying Argument


Correct Option: A
- Hide questions