Tag: databases

Questions Related to databases

What is the default port for running admin console?
technology databases

  1. 5001

  2. 5050

  3. 6010

  4. 6001

Show answer
Correct Option: D

What type of repositories can be created using Informatica Repository Manager?

technology databases

  1. Standalone Repository and Global Repository

  2. Local Repository and Versioned Repository

  3. Neither A nor B

  4. Both A and B

Show answer
Correct Option: D

Which of the following is not a part of designer?

technology databases

  1. Source Analyzer

  2. Mapplet Manager

  3. Workflow Manager

  4. Target Designer

  5. Mapping Designer

Show answer
Correct Option: B,C

Join condition in a joiner transformation is not mandatory.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Any change in existing source and target systems can be made available to OWB
technology databases

  1. True

  2. False

Show answer
Correct Option: A

OWB does not allow you to import PL/SQL code into repository
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which one of the following OLAP construct can be designed in OWB
technology databases

  1. Materialized Views

  2. Tables and Views

  3. Facts and Dimesions

  4. Logical database objects

Show answer
Correct Option: C

What type of data is stored in the repository
technology databases

  1. Objects

  2. Mappings and mapping data

  3. Tables,Schema,Mapping

  4. Metadata definitions

Show answer
Correct Option: D

Which of the following transformations are not present in OWB tool?
technology databases

  1. Union

  2. Match Merge

  3. Table Function

  4. Router

Show answer
Correct Option: A,D

Which SQL statement is used to insert new column in a table with an alter statement?

technology databases

  1. ADD

  2. ADD NEW

  3. INSERT

  4. INSERT NEW

Show answer
Correct Option: A