Interview Q&A

• what is a synonym ?

  A synonym is an alternative name for tables,views,procedures and other database objects generally when we have more than one schema and we wish to access an object of a different schema then we create synonyms for that object in the schema...

• What is referential integrity?

  Rules governing the relationships between primary keys and foreign keys of tables within a relational database that determine data consistency. Referential integrity requires that the value of every foreign key in every table be matched...

• What is a view?

  A view is a tailored presentation of the data contained in one or more tables (or other views). Unlike a table, a view is not allocated any storage space, nor does a view actually contain data; rather, a view is defined by a query that e...

• What is an Oracle instance?

  Oracle associates the instance with the specified database. This is called mounting the database. The database is then ready to be opened, which makes it accessible to authorized users. Multiple instances can execute concurrently on th...

• What is DNS and how it works?

  DNS stands for Domain name system and it translates (converts) the host name into the IP address and IP address into to the host name. Every domain and the computer on the internet is assigned a unique IP address. The communication on the i...

• What is a Router?

  A router routes the traffic to its destination based on the source and destination IP addresses, which are placed in the routing software known as routing table.

• What is Wi Max Technology?

  Wi Max is a wireless broadband technology and it is a advance shape of the Wi Fi (which was a base band technology). Wi Max supports data, video and audio communication at the same time at a very high speed up to 70 Mbps.

• Define Network Gateway

  Network Gateway can be software or a hardware. A gateway is usually a joining point in a network i.e. it connects two networks. A computer with two LAN cards can act as a gateway.

• What is WAN?

  WAN stands for wide area network and it covers the broader geographical area. Basically there are three types of a computer network LAN (Local Area Network), MAN (Metropolitan Area Network) and WAN (Wide Area Network). The communication in...

• What is a Firewall??

  Firewall is a protective boundary for a network and it prevents the unauthorized access to a network. Most of the Windows operating system such as Windows XP Professional has built-in firewall utilities. There are the large number of the th...

• what is Incremental integration testing?

  continuous testing of an application as new functionality is added; requires that various aspects of an application’s functionality be independent enough to work separately before all parts of the program are completed, or that test drivers...

• what is Unit testing?

  he most ‘micro’ scale of testing; to test particular functions or code modules. Typically done by the programmer and not by testers, as it requires detailed knowledge of the internal program design and code. Not always easily done unless th...

• what is White box testing?

  based on knowledge of the internal logic of an application’s code. Tests are based on coverage of code statements, branches, paths, conditions.

• what is Black box testing?

  not based on any knowledge of internal design or code. Tests are based on requirements and functionality.

• How to handle the exceptions using recovery scenario manager in QTP?

  here are 4 trigger events during which a recovery scenario should be activated. A pop up window appears in an opened application during the test run: A property of an object changes its state or value, A step in the test does not run succes...

• What are the Features & Benefits of Quick Test Pro (QTP 8.0)?

  Operates stand-alone, or integrated into Mercury Business Process Testing and Mercury Quality Center. Introduces next-generation zero-configuration Keyword Driven testing technology in Quick Test Professional 8.0 allowing for fast test crea...

• What is Performance testing?

  Timing for both read and update transactions should be gathered to determine whether system functions are being performed in an acceptable timeframe. This should be done standalone and then in a multi user environment to determine the effec...

• What is load testing?

  Load testing is to test that if the application works fine with the loads that result from large number of simultaneous users, transactions and to determine weather it can handle peak usage periods.

• Explain WinRunner testing process?

  WinRunner testing process involves six main stages * Create GUI Map File so that WinRunner can recognize the GUI objects in the application being tested * Create test scripts by recording, programming, or a combination of both....

• CRM Software

  Sales Force Automation - Contact management Contact management software stores, tracks and manages contacts, leads of an enterprise. - Lead management Enterprise Lead management software enables an organization to manage, track and for...

• What is Business Process Management - BPM?

  Business Process Management or BPM, is the practice of improving the efficiency and effectiveness of any organization by automating the organization's business processes. BPM used to be also know as Business Process Reengineering (BPR). M...

• Advantages of CRM

  Using CRM, a business can: - Provide better customer service - Increase customer revenues - Discover new customers - Cross sell/Up Sell products more effectively - Help sales staff close deals faster - Make call centers more eff...

• How is CRM and R/3 differ from each other?

  R/3 is an integration of different application suits. It has its own architecture and way fo functioning. CRM is all about maintaining the relationship with a customer. It is supposed to enhance the profit of the company or organisation si...

• What is the function of pipeline and pipeline interface in

  The Internet Communication Framework (ICF): enables you to use HTTP, HTTPS or SMTP to communicate with other systems from an SAP system.

• difference between business system and business service

  Business service refers to any business applications where as the business system is defined in SLD(System Landscape Directory)

• what is realtime proecss of sap xi in projects.

  SAP XI is an integration infrastructure to transfer data from any legacy system to any legacy system.

• why no need to create the communication channels for

  In SAP XI we have Two stacks, they are ABAP and JAVA stack. HTTP and Idoc adapters are reside at ABAP stack.So no need to create seperately communication channel for HTTP and Idoc. So directly they will interact with the Integration...

• what is sld

  SLD means System Landscape Directory, what it means is that after the Launch of Netweaver, where all the systems are are defined in One Landscape. so we use SLD to register the other systems in the Landscape.

• What are the other modules integrated with OM?

  OM contains all the modules to be integrated, depending client requirement it is done. As OM-PA, OM -RECT, OM-BENEFITS, OM-TRAINING & EVENT MGMT, OM - PD AND OTHERS. CHECK THIS BY GOING TO IMG --> CTRL F AND GIVE INTEGRATION WITH OM )...

• How is Time managment and payroll is integrated?

  TM MGMT and Payroll are integrated in ways are time data is collected from the info type 0007 and these hours are taken in basic as Number of hours worked or utilizwed, and even with time evaluation and last with schemas integration. X0...

• How to group employees for their allowances in payroll?

  Go to basic salary of india in Payroll india and group the employee first depending on the allowances to be paid and this is applied for even differantiating the employees into groups depending on their pay structures.

• What is the role of a administrator in PA ?

  To restrict access to Personnel administration based on PA/PSA.

• What is REPORT VARIANT FOR OFF CYCLE ACTIVITIES, what do we do in this step ?

  Variant is to save all input field parameters. once you saved as a variant , you can use the same for future purposes.

• What is the purpose of creating symbolic a/c, what is transaction code for same ? Can we assign one symbolic a/c to multiple wage types ?

  It depends upon your payrol requirement to create salary head like expense account etc.

• What is controlling area, what does it do, and how were is it assigned ?

  Controlling area is under of FI person which helps to set for costing purposes also based on thses fiscal variant is set.

• What are problems generally faced while posting result to FICO ?

  Normally mismatching of amount get posted.

• What is internal recruitment ?

  Internal recruitment is search for internal applicants. when you integrate with personal development, you can use profile match up which help to search for resources internally.

• What is the difference between the Availability check 01 (Daily requirement) and 02 (Individual Requirement) in material master?

  01 and 02 are the checking group. Availability check is carried out with the help of these checking group and checking rule. Checking group 01 and 02 are maintained on the material master.

• What is purpose of maintaining common distribution channels and common divisions

  Common Distribution Channel and Common Division are maintained so that if any master data like customer or material maintained with respect to one distribution channel can be used in other DCh. It prevents the multiplication of master recor...

• What and where types of copy controls we change

  opy Control: is basically meant so that Data is copied from preceding Document to subsequent one. What subsequent Document is required is to some extent determined by Customer Requirements as well as Document Types. e.g. In general case of...

• What is the purpose of shipping point determination not menu path

  So that Shipping Point is determined automatically once the settings for the same are done.

• What do you do really in pricing determination, and what are the main deifferences between pricing procedures?

  Pricing is determined by combination of Sales Organization, Distribution Channel, Division, Customer Pricing Procedure and Document Pricing Procedure.

• What is meant by transfer of data from legacy code to sap Legacy Code ?

  t should be legacy data to SAP. What it means is you want to transfer all the customer and materials and all other information from Older (legacy system) to new SAP system. You can do it using many tools, most noticeably MDMs.

• What are the five imp fields to be maintained in account determination

  Account Determination: Sales View, Sales Organization, Distribution Chanel, Chart of Accounts, Account Assignment Group for Customer and Material and Account Keys.

• Where the schedule margin key is customized?

  You define the order float in the scheduling margin key, The scheduling margin key is copied from the material master. The float before production or float after production and the release period are defined in the scheduling margin key...

• What is the use of Tables in MM. i.e. How the tables get created?

  Through SE11 you can create a new Table. In MM if you create a Material Master MARA, MARM, MARC,MARD, MBEW & MVKE will updated. In Vendor Master LFA1, LFB1 & LFM1 will be updated. The same applies to EKKO,EKPO for P.O, MSEG & MKPF for MIGO...

• How to delete a material completely?

  Try MMDE transaction but be careful this will remove all material from Client.

• Tell me what is *make to order*?

  Make-to-order production is a process in which a product is individually manufactured for a particular customer. In contrast to mass production for an unspecified market where a material is manufactured many times, in make-to-order producti...

• What is the function of OBYC?

  Function of the OBYC stand for Configure Automatic Postings. In this step, you enter the system settings for Inventory Management and Invoice Verification transactions for automatic postings to G/L accounts. Postings are made to G/L acc...

• What is XI3.0 ? EXPLAIN XI = Exchange Infrastructure - Part of Netweaver 2004.

  SAP Exchange Infrastructure (SAP XI) is SAP's enterprise application integration (EAI) software, a component of the NetWeaver product group used to facilitate the exchange of information among a company's internal software and systems and t...