Ab Initio Latest Quiz

30 Questions | Total Attempts: 1457

SettingsSettingsSettings
Please wait...
Database Management System Quizzes & Trivia

This is your description.


Questions and Answers
  • 1. 
    How to deploy the script?
    • A. 

      GDE

    • B. 

      COMMAND LINE

    • C. 

      AIR COMMAND

    • D. 

      NONE

  • 2. 
    Why do we have a phase in a graph?
    • A. 

      Divide the graph

    • B. 

      Easy to understand

    • C. 

      Resource utilization

    • D. 

      None

  • 3. 
    What are the data quality functions in abinitio?
    • A. 

      Force_error

    • B. 

      Abort

    • C. 

      Is_valid

    • D. 

      Is_null

  • 4. 
    How do you perform the manual rollback of a job?
    • A. 

      Rm

    • B. 

      M_rollback

    • C. 

      M_delete

    • D. 

      None

  • 5. 
    What type of flow buffering is enabled for a graph by default?
    • A. 

      Manual

    • B. 

      Automatic

    • C. 

      Both of the above

    • D. 

      None

  • 6. 
    How do you create the summary tracking report?
    • A. 

      M_report

    • B. 

      AB_REPORT="summary"

    • C. 

      AB_SUMMARY

    • D. 

      None

  • 7. 
    Which are the following components used to filter the data?
    • A. 

      FILTER BY EXPRESS

    • B. 

      REDIFINE

    • C. 

      REFORMAT

    • D. 

      NONE

  • 8. 
    How do you implement the sequence numbers for records?
    • A. 

      Next_in_sequence

    • B. 

      Surrogate key

    • C. 

      Leading records

    • D. 

      None

  • 9. 
    What is reject-threshold?
    • A. 

      No.of records to be processed successfully

    • B. 

      How many rejected records are allowed

    • C. 

      Abort the graph

    • D. 

      None

  • 10. 
    What is best fit for the tuning of the graph
    • A. 

      Database functions to be defined in SQL

    • B. 

      Drop the fields that are not required

    • C. 

      Filter out what is not needed

    • D. 

      None

  • 11. 
    What is max-core?
    • A. 

      Swap memory

    • B. 

      Amount of memory required for a component

    • C. 

      Physical memory

    • D. 

      None

  • 12. 
    Can join component be used to remove the duplicates?
    • A. 

      True

    • B. 

      False

  • 13. 
    What is a layout?
    • A. 

      Directory

    • B. 

      Defines program component where to run

    • C. 

      Logical directory

    • D. 

      None

  • 14. 
    Where will be the GDE temporary files [ not job related files ] created?
    • A. 

      Mp directory

    • B. 

      Run directory

    • C. 

      Host directory

    • D. 

      None

  • 15. 
    When program components execute simultaneously on different branches of a graph is?
    • A. 

      Pipeline parallelism

    • B. 

      Data parallelism

    • C. 

      Component parallelism

    • D. 

      None

  • 16. 
    An adhoc multifile is?
    • A. 

      Parallel dataset with data partitions with set of serial files

    • B. 

      Parallel files

    • C. 

      Multi-files

    • D. 

      None

  • 17. 
    Can SORT component used to implement pipeline parallelism?
    • A. 

      True

    • B. 

      False

  • 18. 
    Can we have function fields in a dml?
    • A. 

      True

    • B. 

      False

  • 19. 
    Dependency analysis is meant for?
    • A. 

      Code flexibility

    • B. 

      Data lineage

    • C. 

      Storage of the graphs

    • D. 

      None

  • 20. 
    What is the abInitio's default source control system
    • A. 

      Veritas

    • B. 

      EME

    • C. 

      Control-M

    • D. 

      None

  • 21. 
    Can a private project accesses the objects of the other private project?
    • A. 

      True

    • B. 

      False

  • 22. 
    Can we have 2 or more co->systems pointing to the latest version of the EME?
    • A. 

      True

    • B. 

      False

  • 23. 
    What is the extended ASCII range
    • A. 

      0-127

    • B. 

      128-255

    • C. 

      0-1

    • D. 

      All of the above

  • 24. 
    Which type of DML is faster in processing the data sets?
    • A. 

      Variable Length DML

    • B. 

      Fixed Length DML

    • C. 

      Conditional DML

    • D. 

      All of the above

  • 25. 
    What is AB_LOCAL() construct in ab initio?
    • A. 

      Abinitio local variable

    • B. 

      Parse grammer in complex SQL statements

    • C. 

      Function in abinitio

    • D. 

      All of the above

Related Topics
Back to Top Back to top