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

Can we create report using more than one database?

  1. True

  2. False

Correct Option: A

Can we export data of reports into other format like in world doc etc?

  1. True

  2. False

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

Which of the Power Center tools communicate with the integration service?

  1. Workflow manager

  2. Workflow Monitor

  3. Designer

  4. Repository Manager

Correct Option: A,B

What is the default port for running admin console?

  1. 5001

  2. 5050

  3. 6010

  4. 6001

Correct Option: D

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



Correct Option: A

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "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

Which character function can be used to return a specified portion of a character string?

  1. INSTR



  4. POS

Correct Option: C
- Hide questions