0

databases Online Quiz - 59

Description: databases Online Quiz - 59
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Physical machines on which PowerCenter services are installed

  2. Logical ETL environment

  3. ETL and metadata services

  4. House keeping the ETL environment


Correct Option: A
  1. Mapplets

  2. Sessions

  3. Transformations

  4. Workflows


Correct Option: C

Which of the following is not a part of Designer Interface

  1. Source Analyzer

  2. Target Designer

  3. Workflow Monitor

  4. Mapplet Designer


Correct Option: C
  1. Transformation Developer

  2. Source Analyzer

  3. Target Designer

  4. Mapping Designer


Correct Option: A,D

A mapplet is a combination of reusable mappings

  1. True

  2. False


Correct Option: A
  1. Source/Table Name

  2. Database Name

  3. Source/Table Structure

  4. All of the above


Correct Option: D

How can a source defination created in Informatica?

  1. Import from database

  2. By draging a target defination

  3. By using create option in Sources tag

  4. All of the above


Correct Option: A,C
  1. SELECT [all] FROM Persons ;

  2. SELECT *. FROM Persons ;

  3. SELECT *.Persons ;

  4. SELECT * FROM Persons ;


Correct Option: D
  1. SELECT [all] FROM Persons WHERE FirstName='Peter' ;

  2. SELECT * FROM Persons WHERE FirstName='Peter' ;

  3. SELECT * FROM Persons WHERE FirstName LIKE 'Peter' ;

  4. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter' ;


Correct Option: B
  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
  1. SELECT * FROM Persons SORT 'FirstName' DESC ;

  2. SELECT * FROM Persons ORDER BY FirstName DESC;

  3. SELECT * FROM Persons ORDER FirstName DESC ;

  4. SELECT * FROM Persons SORT BY 'FirstName' DESC ;


Correct Option: B
  1. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen';

  2. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen ;

  3. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen' ;

  4. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen' ;


Correct Option: A
  1. DELETE FROM Persons WHERE FirstName = 'Peter' ;

  2. DELETE FirstName='Peter' FROM Persons;

  3. DELETE ROW FirstName='Peter' FROM Persons ;

  4. TRUNCATE FROM Persons WHERE FirstName='Peter'


Correct Option: A
  1. SELECT COLUMNS(*) FROM Persons ;

  2. SELECT COUNT() FROM Persons;

  3. SELECT COUNT(*) FROM Persons;

  4. SELECT COLUMNS() FROM Persons;


Correct Option: C
- Hide questions