Tag: technology

Questions Related to technology

_______________ is a substitution for the natural primary key. It is just a unique identifier or number for each row that can be used for the primary key to the table.
technology

  1. candidate key

  2. surrogate key

  3. prerrogate key

  4. identity key

Show answer
Correct Option: B

Which one of the following is an ETL tool in the Market?
technology

  1. SQL Warehouse Bulider

  2. Actuate

  3. Business Objects

  4. Data Junction

Show answer
Correct Option: D

The default cache size used is(consider for 64 bit)
technology

  1. 256MB

  2. 64MB

  3. 128MB

  4. 512MB

Show answer
Correct Option: C

Which of the following is not a passive stage
technology

  1. dynamic RDBMS

  2. dataset

  3. IPC stage

  4. None of the above

Show answer
Correct Option: D

Parallel Processing is broadly classified into 2 types. SMP and MPP. What do they stand for:
technology

  1. SMP - Symmetrical Main Processing ; MPP - Multi Parallel Processing

  2. SMP - Symmetrical Multi Processing ; MPP - Massive Parallel Processing

  3. SMP - Symmetrical Massive Processing ; MPP - Multi Parallel Processing

  4. SMP - Symmetrical Multi Processing ; MPP - Multi Parallel Processing

Show answer
Correct Option: C

Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension .This dimension is called
technology

  1. Junk dimension

  2. Degenerate Dimension

  3. Conformed dimensions

  4. Time dimension

Show answer
Correct Option: A

A dataset needs to be sorted to retain a single occurrence of multiple records that have identical sorting key values. Which sort option can be selected to achieve this
technology

  1. Stable sort must be set to true

  2. Sort group must include the sort key values

  3. Allow duplicates must be set to False

  4. Unique sort keys must be set to True

Show answer
Correct Option: C

When a sequential file is written using a Sequential file stage,the parallel engine inserts an operator to convert the data from internal format to the external format.Which operator is inserted
technology

  1. Export operator

  2. Copy operator

  3. Import operator

  4. tsort operator

Show answer
Correct Option: A

Which of the following are not server components
technology

  1. Repository

  2. Data Stage server

  3. Data Stage package installer

  4. None of the above

Show answer
Correct Option: D

For a given ServletResponse response, which retrieves an object for writing binary data?
technology web technology

  1. response.getWriter()

  2. response.getOutputStream()

  3. response.getOutputWriter()

  4. response.getWriter(Writer.OUTPUT_BINARY)

Show answer
Correct Option: B