What is normalization? – Well a relational database is basically composed of tables that contain related data. So the Process of organizing this data into tables is actually referred to as normalization. What is a Stored Procedure? – Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. [...]

• 0 Comments

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? [...]

• 0 Comments

Tell us about yourself, your background. What are the three major characteristics that you bring to this company? What version of Oracle were you running? How many databases did the organization have and what sizes? What motivates you to do a good job? What two or three things are most important to you at work? [...]

• 0 Comments

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 [...]

• 0 Comments