0

databases Online Quiz - 149

Description: databases Online Quiz - 149
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

When CMPAT=YES is specified in a PSB, IMS provides PCBs to the application as if it were executing in a batch processing region

  1. True

  2. False


Correct Option: B

Which of the following statements are true.

  1. The name of the PSB and its associated application program must be the same in a telecommunications system

  2. The name of the PSB and its associated application program must not be the same in a telecommunications system

  3. The name of the PSB and its associated application program must be the same in an IMS Batch environment

  4. The name of the PSB and its associated application program need not be the same in an IMS Batch environment


Correct Option: A,D

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

  1. DSN9025I

  2. DSN9024I

  3. DSN9023I

  4. DSN9022I


Correct Option: D

which utility is used for preformatting the active log?

  1. DSNJLOGF

  2. DSN1LOGP

  3. DSNJU003

  4. DSNJU004


Correct Option: A

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

  1. DRAIN WRITERS

  2. DRAIN ALL

  3. DRAIN CLAIMERS

  4. DRAIN *


Correct Option: B

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

  1. Better data compression

  2. Less I/O

  3. Faster performance for decision support queries that involve only a few columns

  4. Best suited for OLTP


Correct Option: A,B,C

You cannot run QUISCE on a table space that is in

  1. CHECK PENDING

  2. COPY PENDING

  3. RECOVER PENDING

  4. NONE


Correct Option: A,B,C

In Sybase IQ, every column is treated as an index.

  1. True

  2. False


Correct Option: A

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

  1. sp_exec_os_cmd

  2. xp_cmdshell

  3. xp_ksh

  4. sp_cmdshell


Correct Option: B

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.

  1. True

  2. False


Correct Option: A

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?

  1. html file

  2. iqmsg file

  3. iqplan file

  4. log file


Correct Option: B

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

  1. Longevity

  2. Selectivity

  3. Productivity

  4. Usefulness


Correct Option: B,D

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

  1. True

  2. False


Correct Option: A

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

  1. Catalog store

  2. IQ Temporary store

  3. IQ store

  4. Metadata store


Correct Option: A,B,C

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

  1. True

  2. False


Correct Option: B

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

  1. Currency

  2. Calender

  3. Accounting Field Structure and Calender

  4. Currency, Calender and Accounting Field Structure


Correct Option: D
  1. Application

  2. Set of Books

  3. Organization

  4. Set Of Books


Correct Option: B
- Hide questions