mainframe Online Quiz - 108
Description: mainframe Online Quiz - 108 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: mainframe |
What are the differences between ')' and '>' shift operators?
The following commands are used to split a line
'10000' on command line and pressing F8. What happens
Among the following which is not a valid scroll amount?
If you want to maximize data concurrency without seeing uncommitted data, which isolation level should you use?
When a view is deleted, any dependent view is
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?
Which of the following utilities would you run to order data and reclaim space from deleted rows in a table:
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?
Which of the following isolation levels is most likely to acquire a table level lock during an index scan?
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?
Which of the following tools can be used to catalog a database?
Which one of the following authorities can create a database?
For which of the following database objects can locks NOT be obtained?
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?
Which of the following products can be used to store image data in a DB2 database?
Which of the following statements eliminates all but one of each set of duplicate rows in the final result table?
Which of the following will occur when a view is created on a DB2 table?
We cannot restart the program that is loading a GSAM
RSA (Key feed back area) stands for