• databases Online Quiz - 149
Back
0

databases Online Quiz - 149

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

For GSAM databases, which status code will be issued if the input data set was not present and a get call was tried?
technology databases

  1. AI

  2. AM

  3. AO

  4. NI

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following statements are true.

technology databases

  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

Show answer
Correct Option: A,D

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

  1. DSN9025I

  2. DSN9024I

  3. DSN9023I

  4. DSN9022I

Show answer
Correct Option: D

TEMPLATE utility control statement is used for REPAIR UTILITY.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

which utility is used for preformatting the active log?
technology databases

  1. DSNJLOGF

  2. DSN1LOGP

  3. DSNJU003

  4. DSNJU004

Show answer
Correct Option: A

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

  1. DRAIN WRITERS

  2. DRAIN ALL

  3. DRAIN CLAIMERS

  4. DRAIN *

Show answer
Correct Option: B

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

  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

Show answer
Correct Option: A,B,C

You cannot run QUISCE on a table space that is in
technology databases

  1. CHECK PENDING

  2. COPY PENDING

  3. RECOVER PENDING

  4. NONE

Show answer
Correct Option: A,B,C

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

  1. True

  2. False

Show answer
Correct Option: A

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?
technology databases

  1. LF

  2. HG

  3. HNG

  4. CMP

Show answer
Correct Option: A

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

  1. sp_exec_os_cmd

  2. xp_cmdshell

  3. xp_ksh

  4. sp_cmdshell

Show answer
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.

technology databases

  1. True

  2. False

Show answer
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?

technology databases

  1. html file

  2. iqmsg file

  3. iqplan file

  4. log file

Show answer
Correct Option: B

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

  1. Longevity

  2. Selectivity

  3. Productivity

  4. Usefulness

Show answer
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.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. Catalog store

  2. IQ Temporary store

  3. IQ store

  4. Metadata store

Show answer
Correct Option: A,B,C

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

  1. True

  2. False

Show answer
Correct Option: B

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

  1. Currency

  2. Calender

  3. Accounting Field Structure and Calender

  4. Currency, Calender and Accounting Field Structure

Show answer
Correct Option: D

Below entity has been used to partition data into logical units
technology databases

  1. Application

  2. Set of Books

  3. Organization

  4. Set Of Books

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1124 Quizzes
12955 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions