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

What does a node refers to in terms of ETL concepts?

  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

Which SQL statement is used to update data in a database?

  1. SAVE

  2. MODIFY

  3. UPDATE

  4. SAVE AS


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

  2. SELECT *. FROM Persons ;

  3. SELECT *.Persons ;

  4. SELECT * FROM Persons ;


Correct Option: D

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

  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