databases Online Quiz - 95 Online Test

Back

databases Online Quiz - 95

Description: databases Online Quiz - 95
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

Start the Quiz

What is a Data Provider?

technology databases

Table that contains data.
Object of a Class
Java program used in BO
Query on Universes and Stored Procedures and Free-hand SQL

What is an alerter?

technology databases

Highlighting data in the report based on some condition
Giving an email notification when a report comes into our BO inbox.
Error message
is a rule to be followed in Universe design

Can we create report using more than one database?

technology databases

True
False

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

technology databases

True
False

what are the limitations in crystal reports?

technology databases

If database is having field whose length is more than 255 characters,
While exporting data formatting is lost.
a&b
only b

What are the sections that we have in Crystal reports?

technology databases

Page Header
Page Footer
Report Header
Report Footer
all of the above

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

technology databases

True
False

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

technology databases

Workflow manager
Workflow Monitor
Designer
Repository Manager

What is the default port for running admin console?

technology databases

5001
5050
6010
6001

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

technology databases

Standalone Repository and Global Repository
Local Repository and Versioned Repository
Neither A nor B
Both A and B

Which of the following is not a part of designer?

technology databases

Source Analyzer
Mapplet Manager
Workflow Manager
Target Designer
Mapping Designer

Join condition in a joiner transformation is not mandatory.

technology databases

True
False

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

technology databases

True
False

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

technology databases

True
False

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

technology databases

Materialized Views
Tables and Views
Facts and Dimesions
Logical database objects

What type of data is stored in the repository

technology databases

Objects
Mappings and mapping data
Tables,Schema,Mapping
Metadata definitions

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

technology databases

Union
Match Merge
Table Function
Router

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

technology databases

ADD
ADD NEW
INSERT
INSERT NEW

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"?

technology databases

SELECT * FROM Persons WHERE FirstName LIKE '%a'
SELECT * FROM Persons WHERE FirstName ='a'
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
SELECT * FROM Persons WHERE FirstName='%a%'

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

technology databases

INSTR
SUBSTRING
SUBSTR
POS

- Hide questions

databases Online Quiz - 95

Find more quizzes from top tags