databases Online Quiz - 149
|Description: databases Online Quiz - 149|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
For GSAM databases, which status code will be issued if the input data set was not present and a get call was tried?
When CMPAT=YES is specified in a PSB, IMS provides PCBs to the application as if it were executing in a batch processing region
Which of the following statements are true.
TEMPLATE utility control statement is used for REPAIR UTILITY.
To prevent time outs or deadlocks when you use REORG with SHRLEVEL CHANGE option, run the REORG with the
In Sybase IQ, every column is treated as an index.
I have a Sybase IQ table with about 1 million rows. To improve performance, I need to add an index on the primary key which has over 900 distinct values. Which index type would I choose?
Sybase IQ query optimizer generates a query plan for every query. When I set the QUERY_PLAN option ON, where is the query plan sent to?
Each IQ database that you create includes at least three DBspaces. What are they?
Below entity has been used to partition data into logical units