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.

Which message is displayed for the normal completion of a DB2 utility command ?

TEMPLATE utility control statement is used for REPAIR UTILITY.

which utility is used for preformatting the active log?

To prevent time outs or deadlocks when you use REORG with SHRLEVEL CHANGE option, run the REORG with the

What are the advantages of column-oriented architecture over traditional row-oriented architecture? (Choose 3)

You cannot run QUISCE on a table space that is in

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?

For a Sybase IQ running in UNIX, which Sybase IQ stored procedure can be used to execute the UNIX shell commands?

In Sybase IQ 12.6, when a table is being written to by a process, if another process tries to update a row in the same table, the latter will fail.

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?

When Sybase IQ generates a query plan, what are the two important values to be checked for each search argument?

When a raw file is loaded into Sybase IQ, the loaded table occupies lesser space than the raw file did in the OS.

Each IQ database that you create includes at least three DBspaces. What are they?

Sybase IQ is the only column-oriented database out there in the market.

Two Oraganization has been defined. For both the organization to use same set of books, they have to share atleast

Below entity has been used to partition data into logical units