• mainframe Online Quiz - 108
Back
0

mainframe Online Quiz - 108

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

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

  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

Show answer
Correct Option: D

The following commands are used to split a line
technology mainframe

  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

Show answer
Correct Option: A,C

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

  1. scrolls down 10,000 lines

  2. Scrolls 10,000 columns

  3. Invalid Scroll Amount

  4. We cannot issue such command

Show answer
Correct Option: C

Among the following which is not a valid scroll amount?
technology mainframe

  1. Half

  2. Data

  3. Full

  4. Page

Show answer
Correct Option: C

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

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?
technology mainframe

  1. Z

  2. X

  3. S

  4. U

Show answer
Correct Option: B

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

  1. Net.Data

  2. Net Search

  3. DB2 AVI Extenders

  4. DB2 XML Extenders

  5. DB2 Text Extenders

Show answer
Correct Option: C

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

  1. SELECT UNIQUE * FROM t1

  2. SELECT DISTINCT * FROM t1

  3. SELECT UNIQUE (*) FROM t1

  4. SELECT DISTINCT (*) FROM t1

  5. None of above

Show answer
Correct Option: B

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

  1. Memory usage is reduced

  2. Query compilation time is reduced

  3. Data access time is increased

  4. Data access control is increased

Show answer
Correct Option: D

We cannot restart the program that is loading a GSAM

technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

RSA (Key feed back area) stands for

technology mainframe

  1. Record Segment Argument

  2. Record Setting Argument

  3. Record Selection Argument

  4. Record Specifying Argument

Show answer
Correct Option: A
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions