databases Online Quiz - 95

Description: databases Online Quiz - 95
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  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
  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 export data of reports into other format like in world doc etc?

  1. True

  2. False

Correct Option: A
  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
  1. Page Header

  2. Page Footer

  3. Report Header

  4. Report Footer

  5. all of the above

Correct Option: E
  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
  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

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 SQL statement is used to insert new column in a table with an alter statement?

  1. ADD

  2. ADD 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