A query accessing a file has recently suffered a significant performance degradation.

What recommended action is required on the file?

Exhibit:

What would you do to enhance performance of the following query?

Which information is provided by TRA?

Which RDF global parameter should be set to allow monitoring of an Updater’s lag time?

Scenario: The Marketing Group is asking for a new feature to be added to the retail OLTP
application. They would like to have an online query that would list the last 30 days of purchases
for a given customer (credit card number). The file that currently contains this information is KeySequenced and it is updated every time a purchase is finalized. The primary key for this file is
system generated, the remaining data elements are: timestamp, credit card number, the part
number of the item being purchased, the price and the quantity purchased.
You have been asked to recommend the optimal way to access this data. Select ONE.

Which method contributes to increased memory usage?

What is the benefit of distributing processes across processors?

Parallelism is a major performance feature exploited by

Which Pathway server class attribute directly controls the request queue?

During interpretation of a SCREEN COBOL program, the TCP is responsible for dynamically
allocating and deallocating memory space for terminal and server I/O buffers. Which TCP
attributes define the total space available for these buffers? Select TWO.