0

databases Online Quiz - 95

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

What is a Data Provider?

  1. Table that contains data.

  2. Object of a Class

  3. Java program used in BO

  4. Query on Universes and Stored Procedures and Free-hand SQL


Correct Option: D

What is an alerter?

  1. Highlighting data in the report based on some condition

  2. Giving an email notification when a report comes into our BO inbox.

  3. Error message

  4. is a rule to be followed in Universe design


Correct Option: A

what are the limitations in crystal reports?

  1. If database is having field whose length is more than 255 characters,

  2. While exporting data formatting is lost.

  3. a&b

  4. only b


Correct Option: C

What are the sections that we have in Crystal reports?

  1. Page Header

  2. Page Footer

  3. Report Header

  4. Report Footer

  5. all of the above


Correct Option: E

Does Crystal Report support all the functions that we have in Oracle?

  1. True

  2. False


Correct Option: B
  1. Workflow manager

  2. Workflow Monitor

  3. Designer

  4. Repository Manager


Correct Option: A,B

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

  1. Standalone Repository and Global Repository

  2. Local Repository and Versioned Repository

  3. Neither A nor B

  4. Both A and B


Correct Option: D

Which of the following is not a part of designer?

  1. Source Analyzer

  2. Mapplet Manager

  3. Workflow Manager

  4. Target Designer

  5. Mapping Designer


Correct Option: B,C

Join condition in a joiner transformation is not mandatory.

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: B

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

  1. Materialized Views

  2. Tables and Views

  3. Facts and Dimesions

  4. Logical database objects


Correct Option: C

What type of data is stored in the repository

  1. Objects

  2. Mappings and mapping data

  3. Tables,Schema,Mapping

  4. Metadata definitions


Correct Option: D

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

  1. Union

  2. Match Merge

  3. Table Function

  4. Router


Correct Option: A,D

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

  1. ADD

  2. ADD NEW

  3. INSERT

  4. INSERT NEW


Correct Option: A
  1. SELECT * FROM Persons WHERE FirstName LIKE '%a'

  2. SELECT * FROM Persons WHERE FirstName ='a'

  3. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

  4. SELECT * FROM Persons WHERE FirstName='%a%'


Correct Option: C
- Hide questions