SAP/ABAP interview questions

  1. Type of table?
  2. Events of module pool?
  3. Events of interactive report?
  4. Filters & idoc and segments?
  5. Types of enhancements?
  6. Type of partner profile?
  7. What is RFC? What is its purpose?
  8. Steps of LSMW?
  9. Types of BDC? How u proceed BDC(call transaction) without recording?
  10. What is message type in idoc?
  11. What is a dialog program?
  12. What is debugging? How do you proceed the steps in your reports?
  13. What are the parameters passed to fieldcatalog?
  14. What are all the tools used for debugging and run time analysis?

Interview Questions for Oracle Database Administrator

  1. Differentiate between TRUNCATE and DELETE
  2. What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
  3. Can you use a commit statement within a database trigger?
  4. What is an UTL_FILE.What are different procedures and functions associated with it?
  5. Difference between database triggers and form triggers?
  6. What is OCI. What are its uses?
  7. What are ORACLE PRECOMPILERS?
  8. What is syntax for dropping a procedure and a function? Are these operations possible?
  9. Can a function take OUT parameters. If not why?
  10. Can the default values be assigned to actual parameters?

Oracle Interview Questions

  1. What is an oracle instance?
  2. What is a view?
  3. What is referential integrity?
  4. Name the data dictionary that stores user-defined constraints?
  5. What is a collection of privileges?
  6. What is a snapshot?
  7. What is a synonym?
  8. What is a cursor?
  9. What is a sequence?
  10. What is a trigger?
  11. What is an exception?
  12. What is a partition of table?
  13. What are pseudo-columns in SQL? Provide examples.
  14. What are the Data Control statements?
  15. What is a schema?
  16. What is a type?
  17. What is a data model?

SAS Interview Questions

  1. What SAS statements would you code to read an external raw data file to a DATA step?
  2. How do you read in the variables that you need?
  3. Are you familiar with special input delimiters? How are they used?
  4. If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
  5. What is the difference between an informat and a format? Name three informats or formats.
  6. Name and describe three SAS functions that you have used, if any?

Data warehouse interview questions

  1. What is source qualifier?
  2. Difference between DSS & OLTP?
  3. Explain grouped cross tab?
  4. Hierarchy of DWH?
  5. How many repositories can we create in Informatica?
  6. What is surrogate key?
  7. What is difference between Mapplet and reusable transformation?
  8. What is aggregate awareness?
  9. Explain reference cursor?
  10. What are parallel querys and query hints?
  11. DWH architecture?
  12. What are cursors?
  13. Advantages of de normalized data?
  14. What is operational data source (ODS)?
  15. What is meta data and system catalog?
  16. What is factless fact schema?
  17. What is confirmed dimension?

Pages (98): « First ... « 85 86 87 [88] 89 90 91 » ... Last »