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

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
- Hide questions