SAP/ABAP interview questions
- Type of table?
- Events of module pool?
- Events of interactive report?
- Filters & idoc and segments?
- Types of enhancements?
- Type of partner profile?
- What is RFC? What is its purpose?
- Steps of LSMW?
- Types of BDC? How u proceed BDC(call transaction) without recording?
- What is message type in idoc?
- What is a dialog program?
- What is debugging? How do you proceed the steps in your reports?
- What are the parameters passed to fieldcatalog?
- What are all the tools used for debugging and run time analysis?
Interview Questions for Oracle Database Administrator
- Differentiate between TRUNCATE and DELETE
- What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
- Can you use a commit statement within a database trigger?
- What is an UTL_FILE.What are different procedures and functions associated with it?
- Difference between database triggers and form triggers?
- What is OCI. What are its uses?
- What are ORACLE PRECOMPILERS?
- What is syntax for dropping a procedure and a function? Are these operations possible?
- Can a function take OUT parameters. If not why?
- Can the default values be assigned to actual parameters?
Oracle Interview Questions
- What is an oracle instance?
- What is a view?
- What is referential integrity?
- Name the data dictionary that stores user-defined constraints?
- What is a collection of privileges?
- What is a snapshot?
- What is a synonym?
- What is a cursor?
- What is a sequence?
- What is a trigger?
- What is an exception?
- What is a partition of table?
- What are pseudo-columns in SQL? Provide examples.
- What are the Data Control statements?
- What is a schema?
- What is a type?
- What is a data model?
SAS Interview Questions
- What SAS statements would you code to read an external raw data file to a DATA step?
- How do you read in the variables that you need?
- Are you familiar with special input delimiters? How are they used?
- 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?
- What is the difference between an informat and a format? Name three informats or formats.
- Name and describe three SAS functions that you have used, if any?
Data warehouse interview questions
- What is source qualifier?
- Difference between DSS & OLTP?
- Explain grouped cross tab?
- Hierarchy of DWH?
- How many repositories can we create in Informatica?
- What is surrogate key?
- What is difference between Mapplet and reusable transformation?
- What is aggregate awareness?
- Explain reference cursor?
- What are parallel querys and query hints?
- DWH architecture?
- What are cursors?
- Advantages of de normalized data?
- What is operational data source (ODS)?
- What is meta data and system catalog?
- What is factless fact schema?
- What is confirmed dimension?