Thursday, January 31, 2008

WinRunner Interview Questions

How you used WinRunner in your project? –

Yes, I have been using WinRunner for creating automated scripts for GUI, functional and regression testing of the AUT.
Explain WinRunner testing process? –

WinRunner testing process involves six main stagesCreate GUI Map File so that WinRunner can recognize the GUI objects in the application being testedCreate test scripts by recording, programming, or a combination of both. While recording tests, insert checkpoints where you want to check the response of the application being tested.Debug Test: run tests in Debug mode to make sure they run smoothlyRun Tests: run tests in Verify mode to test your application.View Results: determines the success or failure of the tests.Report Defects: If a test run fails due to a defect in the application being tested, you can report information about the defect directly from the Test Results window.
What is contained in the GUI map? –

WinRunner stores information it learns about a window or object in a GUI Map. When WinRunner runs a test, it uses the GUI map to locate objects. It reads an object’s description in the GUI map and then looks for an object with the same properties in the application being tested. Each of these objects in the GUI Map file will be having a logical name and a physical description. There are 2 types of GUI Map files. Global GUI Map file: a single GUI Map file for the entire application. GUI Map File per Test: WinRunner automatically creates a GUI Map file for each test created.
How does WinRunner recognize objects on the application? -

WinRunner uses the GUI Map file to recognize objects on the application. When WinRunner runs a test, it uses the GUI map to locate objects. It reads an object’s description in the GUI map and then looks for an object with the same properties in the application being tested.
Have you created test scripts and what is contained in the test scripts? –

Yes I have created test scripts. It contains the statement in Mercury Interactive’s Test Script Language (TSL). These statements appear as a test script in a test window. You can then enhance your recorded test script, either by typing in additional TSL functions and programming elements or by using WinRunner’s visual programming tool, the Function Generator.
How does WinRunner evaluate test results?

Following each test run, WinRunner displays the results in a report. The report details all the major events that occurred during the run, such as checkpoints, error messages, system messages, or user messages. If mismatches are detected at checkpoints during the test run, you can view the expected results and the actual results from the Test Results window.
Have you performed debugging of the scripts? –

Yes, I have performed debugging of scripts. We can debug the script by executing the script in the debug mode. We can also debug script using the Step, Step Into, Step out functionalities provided by the WinRunner.
How do you run your test scripts?

- We run tests in Verify mode to test your application. Each time WinRunner encounters a checkpoint in the test script, it compares the current data of the application being tested to the expected data captured earlier. If any mismatches are found, WinRunner captures them as actual results.
How do you analyze results and report the defects?

Following each test run, WinRunner displays the results in a report. The report details all the major events that occurred during the run, such as checkpoints, error messages, system messages, or user messages. If mismatches are detected at checkpoints during the test run, you can view the expected results and the actual results from the Test Results window. If a test run fails due to a defect in the application being tested, you can report information about the defect directly from the Test Results window. This information is sent via e-mail to the quality assurance manager, who tracks the defect until it is fixed.
What is the use of Test Director software? –

TestDirector is Mercury Interactive’s software test management tool. It helps quality assurance personnel plan and organize the testing process. With TestDirector you can create a database of manual and automated tests, build test cycles, run tests, and report and track defects. You can also create reports and graphs to help review the progress of planning tests, running tests, and tracking defects before a software release.
Have you integrated your automated scripts from TestDirector?

- When you work with WinRunner, you can choose to save your tests directly to your TestDirector database or while creating a test case in the TestDirector we can specify whether the script in automated or manual. And if it is automated script then TestDirector will build a skeleton for the script that can be later modified into one which could be used to test the AUT.What are the different modes of recording? - There are two type of recording in WinRunner. Context Sensitive recording records the operations you perform on your application by identifying Graphical User Interface (GUI) objects. Analog recording records keyboard input, mouse clicks, and the precise x- and y-coordinates traveled by the mouse pointer across the screen.
-
What is the purpose of loading WinRunner Add-Ins?

- Add-Ins are used in WinRunner to load functions specific to the particular add-in to the memory. While creating a script only those functions in the add-in selected will be listed in the function generator and while executing the script only those functions in the loaded add-in will be executed else WinRunner will give an error message saying it does not recognize the function.
What are the reasons that WinRunner fails to identify an object on the GUI? –
-
WinRunner fails to identify an object in a GUI due to various reasons. The object is not a standard windows object. If the browser used is not compatible with the WinRunner version, GUI Map Editor will not be able to learn any of the objects displayed in the browser window.
What is meant by the logical name of the object? –

An object’s logical name is determined by its class. In most cases, the logical name is the label that appears on an object.If the object does not have a name then what will be the logical name? - If the object does not have a name then the logical name could be the attached text.

What is the different between GUI map and GUI map files?

- The GUI map is actually the sum of one or more GUI map files. There are two modes for organizing GUI map files. Global GUI Map file: a single GUI Map file for the entire application. GUI Map File per Test: WinRunner automatically creates a GUI Map file for each test created. GUI Map file is a file which contains the windows and the objects learned by the WinRunner with its logical name and their physical description.


- How do you view the contents of the GUI map? –
-
- GUI Map editor displays the content of a GUI Map. We can invoke GUI Map Editor from the Tools Menu in WinRunner. The GUI Map Editor displays the various GUI Map files created and the windows and objects learned in to them with their logical name and physical description.
-
- When you create GUI map do you record all the objects of specific objects? –
-
- If we are learning a window then WinRunner automatically learns all the objects in the window else we will we identifying those object, which are to be learned in a window, since we will be working with only those objects while creating scripts.



Winrunner Faq, Winrunner Interview Questions, Winrunner Questions, Winrunner Scripts, Winrunner Testing, Winrunner Tutorial, Winrunner Versions

Tuesday, January 29, 2008

9 SAP Interview Questions asked during my Interview

1) 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.
Also In recruitment it is represented by ‘P’ as Person and ‘AP” as external person.
2) What are problems generally faced while posting result to FICO […]

SAP-ABAP Interview Questions-1

1. How data is stored in cluster table?

Each field of cluster table behaves as tables which contains the no. of entries.

2. What are client dependant objects in abap/sap?

SAP Script layout, text element, and some DDIC objects.

3. On which even we can validate the input fields in module programs?

In PAI (Write field statement on field you want to validate, if you want to validate group of fields put in chain and End chain statement.)

4. In selection screen I have three fields, plant mat no and material group. If I input plant how do I get the mat no and material group based on plant dynamically?

AT SELECTION-SCREEN ON VALUE-REQUEST FOR MATERIAL. CALL FUNCTION ‘F4IF_INT_TABLE_VALUE_REQUEST’ to get material and material group for the plant.

5. How do you get output from IDOC?

Data in IDOc is stored in segments, the output from Idoc is obtained by reading the data stored in its respective segments.

6. When top of the page event is triggered?

After executing first write statement in start-of-selection event.

7. Can we create field without data element and how?

In SE11 one option is available above the fields strip. Data element/ direct type.

8. How do we debug sapscript?

Go to SE71 give lay set name , go to utilities select debugger mode on.

9. Which transaction code can I used to analyze the performance of ABAP program.

TCode AL21.

10. How can I copy a standard table to make my own z_table.

Go to transaction SE11. Then there is one option to copy table. Press that button. Enter the name of the standard table and in the Target table enter Z table name and press enter.

11. What is the use of ‘outerjoin’

Ans. With the use of outer join you can join the tables even there is no entry in all the tables used in the view. In case of inner join there should be an entry in al the tables use in the view.

12. When to use logical database?

Ans. Advantage of Logical databases: less coding s required to retrieve data compared to normal internal tables. Tables used LDB are in hierarchical structure.

13. What is the use of ‘table index’?

Ans .Index is used for faster access of data base tables.

14. What is the use of ‘FOR ALL ENTRIES’?

Ans. To avoid nested select statements we use SELECT FOR ALL ENTRIES statement. If there r more than 10000 records SELECT FOR ALL ENTRIES is used. Performance wise SELECT FOR ALL ENTRIES is better to use.

15. Can you set up background processing using CALL TRANSACTION?

Yes,Using No Screen Mode.

16. What are table buffers?

Table buffers reside locally on each application server in the system. The data of buffered tables can thus be accessed directly from the buffer of the application server. This avoids the time-consuming process of accessing the database. Buffering is useful if table needs to be accessed more no. of times in a program.

17. How do I set a flag for a field in any table?

Create a char field of length 1. for example field STAS-LKENZ is Deletion Indicator. It means that if the value in the field is ‘X’ then that record has been deleted.

18. Can I execute user exits? If yes, how?

Yes you can. after finding the user exit, you need to use, goto CMOD add ur user-exit to your project. Then activate the FM which you require. Now go into that function module there will be a Include program wit name ZX* . Double click on it, it will ask to create an object, answer it Yes and then write your code in it.

19. How do I find the output type of a table or a program?

Table TNAPR / NAST

Note: Above interview questions are same if your are looking for Sap Abap Interview Question, Sap Abap Interview Questions, Sap Bw Interview Questions, SAP Interview Question, Sap Interview Questions, Sap Pp Interview Questions, Sap R 3 Interview Questions, Abap Interview, Abap Interview Question and Abap Interview Questions.

Interview Questions On SAP ABAP

1) What is runtime analysis? Have you used this?

It’s checks program execution time in microseconds. When you go to se30.if you give desired program name in performance file. It will take you to below screen. You can get how much past is your program.

2) What is meant by performance analysis? Have done
3) How to transfer the objects? Have you transferred any objects?
4) How did you test the developed objects?

I was testing a developed object. There are two types of testing - Negative testing - Positive testing In negative testing we will give negative data in input and we check any errors occurs. In positive testing we will give positive data in input for checking errors.

5) What is the difference between SAP Memory and ABAP Memory?
6) In order to upload Purchase order details, how you handle multiple values for a single field?

Eg: Item field may contain no. of values for a record

7) What is the procedure you followed to upload the data?
8) How did you handle errors in Call Transaction?

We can create a internal table like ‘bsgmcgcoll’. All the messages will go to internal table. We can get errors in this internal table. Below messages are go to internal table. when you run the call transaction.
- Message type
- Message id
- Message Number
- Variable1
- Variable2
- Variable3

9) Among the Call Transaction and Session Method, which is faster?

Call transaction is faster then session method. But usually we use session method in real time…because we can transfer large amount of data from internal table to database and if any errors in a session. Process will not complete until session get correct.

10) What are the difference between Interactive and Drill Down Reports?

ABAP/4 provides some interactive events on lists such as AT LINE-SELECTION (double click) or AT USER-COMMAND (pressing a button). You can use these events to move through layers of information about individual items in a list.
Drill down report is nothing but interactive report…drilldown means above paragraph only.

11) How to pass the variables to forms?
12) What is the table, which contain the details of all the name of the programs and forms?

Table contains vertical and horizontal lines. We can store the data in table as blocks. We can scroll depends upon your wish. And these all are stored in database (data dictionary).

13.Which contain the details of all the name of the programs and forms? (I don’t know).
14) How did you test the form u developed? How did you taken print?
15) What are Standard Texts?
16) What is the difference between Clustered Tables and Pooled Tables?

A pooled table is used to combine several logical tables in the ABAP/4 dictionary. Pooled tables are logical tables that must be assigned to a table pool when they are defined.
Cluster table are logical tables that must be assigned to a table cluster when they are defined.
Cluster table can be used to store control data they can also used to store temporary data or text such as documentation.

17) What is pf-status?

Pf status is used in interactive report for enhancing the functionality. If we go to se41, we can get menus, items and different function keys, which we are using for secondary list in interactive report.

18) Among “Move” and “Move Corresponding”, which is efficient one?

I guess, ‘move corresponding’ is very efficient then ‘move’ statement. Because usually we use this stamtent for internal table fields only…so if we give move corresponding. Those fields only moving to other place (what ever you want).

19) What are the output type and Tcodes?
20) Where we use Chain and End chain?
21) Do you use select statement in loop end loop, how will be the performance? To improve the performance?


Note: Above interview questions are same if your are looking for Sap Abap Interview Question, Sap Abap Interview Questions, Sap Bw Interview Questions, SAP Interview Question, Sap Interview Questions, Sap Pp Interview Questions, Sap R 3 Interview Questions, Abap Interview, Abap Interview Question and Abap Interview Questions.

SAP Interview Questions Part3

1. How data is stored in cluster table?

Each field of cluster table behaves as tables which contains the no. of entries.

2. What are client dependant objects in abap/sap?

SAP Script layout, text element, and some DDIC objects.

3. On which even we can validate the input fields in module programs?

In PAI (Write field statement on field you want to validate, if you want to validate group of fields put in chain and End chain statement.)

4. In selection screen I have three fields, plant mat no and material group. If I input plant how do I get the mat no and material group based on plant dynamically?

AT SELECTION-SCREEN ON VALUE-REQUEST FOR MATERIAL. CALL FUNCTION ‘F4IF_INT_TABLE_VALUE_REQUEST’ to get material and material group for the plant.

5. How do you get output from IDOC?

Data in IDOc is stored in segments, the output from Idoc is obtained by reading the data stored in its respective segments.

6. When top of the page event is triggered?

After executing first write statement in start-of-selection event.

7. Can we create field without data element and how?

In SE11 one option is available above the fields strip. Data element/ direct type.

8. How do we debug sapscript?

Go to SE71 give lay set name , go to utilities select debugger mode on.

9. Which transaction code can I used to analyze the performance of ABAP program.

TCode AL21.

10. How can I copy a standard table to make my own z_table.

Go to transaction SE11. Then there is one option to copy table. Press that button. Enter the name of the standard table and in the Target table enter Z table name and press enter.

11. What is the use of ‘outerjoin’

Ans. With the use of outer join you can join the tables even there is no entry in all the tables used in the view. In case of inner join there should be an entry in al the tables use in the view.

12. When to use logical database?

Ans. Advantage of Logical databases: less coding s required to retrieve data compared to normal internal tables. Tables used LDB are in hierarchical structure.

13. What is the use of ‘table index’?

Ans .Index is used for faster access of data base tables.

14. What is the use of ‘FOR ALL ENTRIES’?

Ans. To avoid nested select statements we use SELECT FOR ALL ENTRIES statement. If there r more than 10000 records SELECT FOR ALL ENTRIES is used. Performance wise SELECT FOR ALL ENTRIES is better to use.

15. Can you set up background processing using CALL TRANSACTION?

Yes,Using No Screen Mode.

16. What are table buffers?

Table buffers reside locally on each application server in the system. The data of buffered tables can thus be accessed directly from the buffer of the application server. This avoids the time-consuming process of accessing the database. Buffering is useful if table needs to be accessed more no. of times in a program.

17. How do I set a flag for a field in any table?

Create a char field of length 1. for example field STAS-LKENZ is Deletion Indicator. It means that if the value in the field is ‘X’ then that record has been deleted.

18. Can I execute user exits? If yes, how?

Yes you can. after finding the user exit, you need to use, goto CMOD add ur user-exit to your project. Then activate the FM which you require. Now go into that function module there will be a Include program wit name ZX* . Double click on it, it will ask to create an object, answer it Yes and then write your code in it.

19. How do I find the output type of a table or a program?

Table TNAPR / NAST


Note: Above interview questions are same if your are looking for Sap Abap Interview Question, Sap Abap Interview Questions, Sap Bw Interview Questions, SAP Interview Question, Sap Interview Questions, Sap Pp Interview Questions, Sap R 3 Interview Questions, Abap Interview, Abap Interview Question and Abap Interview Questions.

SAP Interview Questions Part5

22. What are variables?

Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacement Path.

23. What is AWB?. What is its purpose?

AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information warehousing.

24. What is the significance of ODS in BIW?

An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.

25. What are the different types of source system?

SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.

26. What is Extractor?

Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.

27.What are internal tables ? How do you get the number of lines in an internal table ? How to use a specific number occurs statement ?

28.How do you take care of performance issues in your ABAP programs ?

29.What are datasets ?

30.How to find the return code of a statement in ABAP programs?

31.What are interface/conversion programs in SAP?

32.Have you used SAP supplied programs to load master data?

33.What are the techniques involved in using SAP supplied programs? Do you prefer to write your own programs to load master data? Why?

34.What are logical databases? What are the advantages/disadvantages of logical databases?

35.What specific statements do you use when writing a drill-down report ?

36.What are different tools to report data in SAP? What all have you used?

37.What are the advantages and disadvantages of ABAP/4 query tools?

38.What are the functional areas ? User groups ? How does ABAP/4 work in relation to these?

39.How do you validate the selection criteria of a report?

40.What are selection texts?

41.What is CTS and what do you know about it ?

42.When a program is created and need to be transported to production, does selection texts always go with it ? if not, how do you make sure ? Can you change the CTS entries ? How do you do it ?

43.What is the client concept in SAP?What is the meaning of client independent?

44.Are programs client dependent?

45.Name a few system global variables you can use in ABAP programs?



Note: Above interview questions are same if your are looking for Sap Abap Interview Question, Sap Abap Interview Questions, Sap Bw Interview Questions, SAP Interview Question, Sap Interview Questions, Sap Pp Interview Questions, Sap R 3 Interview Questions, Abap Interview, Abap Interview Question and Abap Interview Questions.

SAP Interview Questions Part4

12. Explain open SQL vs native SQL?

ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.

13. What are datasets?

The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.

14. What are internal tables check table, value table, and transparent table?

Internal table: It is a standard data type object, which exists only during the runtime of the program. Check table: Check table will be at field level checking. Value table: Value table will be at domain level checking ex: scarr table is check table for carrid. Transparent table: - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.

15. What are the major benefits of reporting with BW over R/3? Would it be sufficient just to Web-enable R/3 Reports?

Performance — Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end — now imagine that occurring even more frequently. Data analysis — BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW.

16. How can an ERP such as SAP help a business owner learn more about how business operates?

In order to use an ERP system, a business person must understand the business processes and how they work together from one functional area to the other. This knowledge gives the student a much deeper understanding of how a business operates. Using SAP as a tool to learn about ERP systems will require that the people understand the business processes and how they integrate.

17. What is the difference between OLAP and Data Mining?

OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-clicking, a user can run any number of canned or user-designed reports without having to know anything of SQL or the schema. Because of that prior configuration, the OLAP engine “builds” and executes the appropriate SQL. Mining is to build the application to specifically look at detailed analyses, often algorithmic; even more often misappropriate called “reporting.

18. What is Extended Star Schema and how did it emerge?

The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the characteristics in the dimension table(s). These separate tables for master data is termed as the Extended Star Schema.

19. Define Meta data, Master data and Transaction data

Meta Data: Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data. Master Data: Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. Characteristics can bear master data in BW. With master data you are dealing with attributes, texts or hierarchies. Transaction data: Data relating to the day-to-day transactions is the Transaction data.

20. Name some drawbacks of SAP

Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.

21. What is Bex?

Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.



Note: Above interview questions are same if your are looking for Sap Abap Interview Question, Sap Abap Interview Questions, Sap Bw Interview Questions, SAP Interview Question, Sap Interview Questions, Sap Pp Interview Questions, Sap R 3 Interview Questions, Abap Interview, Abap Interview Question and Abap Interview Questions.

SAP Interview Questions Part2

1. Where can I get the mySAP Business Suite on Linux?

You can order the mySAP Business Suite on Linux just like mySAP software on any other platform. If you are a SAP customer already, there will be no additional charges. From Release 4.6 onwards, the mySAP Business Suite on Linux is part of the standard delivery.

2. Where can I get Linux for mySAP Business Suite?

Linux distributors like Debian, Mandrake, Red Hat or SUSE offer Linux together with a set of other software packages, installation routines, documentation and support. Whereas there is a de facto standard for the Linux kernel itself, the distributions differ in other areas, especially in the administration area.

3. Will pricing be changed for mySAP Business Suite on Linux?

Standard pricing for mySAP Business Suite applies also to mySAP Business Suite on Linux.

4. What are the main reasons for SAP customers choosing Linux?

Each SAP customer has a unique set of reasons for running SAP on Linux, depending on the very specific customer’s SAP scenario. Among many reasons customers decide for Linux as the operating system of choice, because they seek increased Flexibility , Scalability with different sized commodity, or even large former Unix or mainframe systems , Freedom of choice for technology vendors , Replacing larger Unix-based SAP servers ,

5. Where do I get support?

Support of SAP solutions on Linux meets the same high standards as for any other platforms. SAP is offering installation and migration tools and paths, and support staff trained for SAP on Linux matters. For porting and highly technical issues, SAP has the SAP LinuxLab, where hardware and software partners are working closely together to “bring you the best SAP on Linux experience”. Standard SAP support covers SAP related problems as on other platforms too. During message processing, if the problem turns out to be caused by a non-SAP part of the installation/system, it might become necessary to envolve further expertise, as of the hardware- or software partner and its support organisation. Therefore it is strongly recommended for SAP customers, running SAP software on the Linux platform, to maintain a support contract for both, hardware and operating system, so a seamless support process chain can be ensured. Support for the operating system can either be covered directly by the vendor itself, like Red Hat or Novell/SUSE, or by a 3rd party company offering equivalent support, like all our Linux hardware partners do in combination with their products. Our Linux hardware and our database partners provide the same degree of support for Linux with their products as they already do for the respective Unix - if the necessary support contracts are given. Red Hat and SUSE offer direct operating system support contracts as well. Please get in contact with your hardware or software vendor for more information. This practice helps all involved parties to solve any possibly arising problem as fast as possible. If the support coverage is incomplete, it can lead to avoidable delayments in problem solving - and please keep in mind: extraordinary expenses by SAP or our partners, caused by missing support coverage, may get billed to the customer afterwards!

6. Which releases of mySAP Business Suite are supported on Linux?

mySAP Business Suite on Linux is generally available for use in a productive environment starting with release 4.0B.

7. Which databases are supported for mySAP Business Suite on Linux?

Supported databases for mySAP Business Suite on Linux are IBM DB2/UDB, Informix, Oracle and SAP DB/MaxDB.

8. Will a customer get support when recompiling the Linux kernel or using 3rd-party software that modifies it?

Usually there should be no need for recompiling the Linux kernel when using SAP software on Linux, since the supported Linux distributors are shipping optimized kernels for the respective hardware architectures with revised and tested drivers. Any modification to the tested environment would furthermore make it nearly impossible for the Linux distributor to track a problem down. The same applies to 3rd party software that modifies the Linux kernel and is distributed only in a closed, binary-only, way. Therefore the following can’t be supported: Recompiling the Linux kernel, with or without source modifications Loading of 3rd party binary Linux kernel modules which have not been shipped by the Linux distributors Loading of any unsupported Linux kernel modules Loading of any closed source drivers drivers

9. Which server configurations of mySAP Business Suite will be supported on Linux?

SAP supports mySAP Business Suite on Linux for database and application servers in homogeneous and heterogeneous environments. Please get in contact with your hardware partner for system sizing and similar.

10. Is Linux supported as a frontend platform?

The “SAPGUI for the Java Environment” can be downloaded from the SAP ftp servers. This project (formerly known as PlatinGUI - platform independent GUI) started in spring 1998 with the following objectives: build one GUI for all platforms (MacOS, Linux, OS/2, Win32, AIX, HP/UX, Solaris, Tru64 …) provide Control-Enabling with Java Beans create a new, flexible GUI-architecture support web browser integration



Note: Above interview questions are same if your are looking for Sap Abap Interview Question, Sap Abap Interview Questions, Sap Bw Interview Questions, SAP Interview Question, Sap Interview Questions, Sap Pp Interview Questions, Sap R 3 Interview Questions, Abap Interview, Abap Interview Question and Abap Interview Questions.

SAP Interview Questions Part1

1. Can I integrate a data quality solution within other software applications?

Data quality solutions can be fully integrated into CRM, ETL (Extract Transform Load), ERP, or BI solutions and have the advantage of being “seamless” to the end user - reducing the learning curve, as well as decreasing the implementation time frames. Your data process flow should not have to be modified to add a new data quality solution. Through integration and strategic partnerships you are assured that you are getting a best-of-breed solution. However, keep in mind it is not absolutely necessary for the solution to be fully integrated. First logic also provides tools that your organization can easily integrate on your own, and oftentimes stand-alone solutions may be more effective for specific projects.

2. Will First logic’s Global Data Quality Connector for SAP manage my international data?

Yes. Built on a global framework capable of validating address information for over 190 countries in a single processing pass, First logic’s Global Data Quality Connector for SAP allows you to identify country names, format and standardize addresses, correct missing address information, and assign postal codes for each respective country. Furthermore, First logic’s Easy IQ technology offers the ability to complete/populate addresses with minimal data or offer suggestions for possible matches. This easy address system is ideal in call centers or any transactional environment where data needs to be cleansed at the point-of-entry. The software improves real-time transactions for your call centers, sales, and support centers by providing accurate address data for your customer facing employees. How easy is it to maintain First logic’s Global Data Quality Connector for SAP after implementation? Ongoing maintenance should be minimal. Once the solution is implemented and configured, typically maintenance will only be required when you receive postal directory updates, upgrade to a new data quality release, or decide to change your application or business rules.

3. What are the benefits of a data quality solution?

The biggest benefit is the confidence you have that your data is accurate. A data quality solution also allows you to: Manage customer data in different formats initially residing in separate databases Build and maintain successful relationships Better understand and service your customers Enhance knowledge management and business intelligence initiatives with reliable and accurate information Deliver clean, reliable data throughout your expanding information supply chains to all varieties of operational and analytical applications throughout your enterprise

4. How does Firstlogic’s Global Data Quality Connector for SAP Systems work?

Firstlogic’s Global Data Quality Connector is integrated at the BASIS layer and communicates with the SAP Applications via TCP/IP leveraging SAP’s Remote Function Call (RFC) interface. As users make postal validation inquiries in either batch or real-time, calls are made outside of the SAP Application to Firstlogic’s RFC Server. Once the customer’s address has been received by Firstlogic’s technology, our Information Quality Suite parses, standardizes, and corrects records according to configurable business rules and local postal authority standards. To ensure your customer view is optimized, Firstlogic’s technology catches duplicates at the point of entry; not after redundant information has infected your SAP Environment. Before any customer, vendor, or business partner is committed to the database, Firstlogic’s Information Quality suite will immediately inspect the data upon input. The connector scans the entire database for duplicates and assigns a similarity match score to potential duplicates. At that point, the user can determine whether the entered record is unique or a duplicate that should be eliminated from the system. In addition, convenient Error Tolerant Searching is available for prompt and precise address recognition. This improves transaction processing, saves time locating records, and optimizes system efficiency.

5. Explain the architecture of Firstlogic’s Global Data Quality Connector for SAP Systems.

Integrated at the BASIS/WAS layer, Firstlogic has developed Business Add-Ins (BAdI’s) that can be leveraged with a single instantiation; allowing for all SAP modules that utilize SAP’s Business Address Services framework to leverage the compelling advantages of Firstlogic technology. Furthermore, Firstlogic’s Information Quality Suite has been developed as a Remote Function Call (RFC) Server: the most common integration component of SAP software. Utilizing SAP’s RFC interface, SAP makes calls to Firstlogic technology for address check, updates, duplicate checks, and error tolerant searches.

6. Why does SAP support Linux?

SAP’s goal is to be able to provide its customers the maximum of flexibility to create the best IT environment for their needs and be able to get the most value out of their business applications driving growth and profit. Openness, flexibility, and integrity of our products have always been part of our product strategy, putting customers in the position to decide what’s best for their IT environment. So the main reason is to offer you a free choice. Many SAP customers want to use Intel hardware and at the same time use their Unix know-how. Linux is growing with incredible speed and absolutely meets the quality standards of SAP. And thanks to the platform-independent SAP architecture, the port of the SAP kernel was fairly easy: none of the SAP business applications had to be modified. Another reason is the number of Unix operating systems SAP has to support. Especially when you try to get maximum performance out of your hardware resources, there are significant differences between the different Unix flavors. SAP has to maintain, test and support each possible combination of OS, database, hardware and mySAP release. With Intel moving to 64 bit there is a high probability of even more Unix flavors. A consolidation of these Unix derivatives would benefit both vendors and customers. From our point of view Linux has a realistic chance to become the unified Unix running on different hardware platforms. If Open Source continues like this, it is very important for a software company to adapt early to the new situation. We are very proud that SAP was the first software in the world that run mission-critical ERP operations on Linux. We expect Linux to be successful in low and high end installations and SAP, as Trusted Adviser, is helping customers to make the right decisions around SAP on Linux.

7. What is the SAP LinuxLab?

The SAP LinuxLab assists in the releasing of SAP software on Linux and drives the porting of SAP software to new platforms, like the Intel Itanium or IBM Power PC. Furthermore it helps other SAP departments with developing on and for the Linux platform and processes Linux-specific support problems - internal ones, as of external - or forwards them to the appropriate hardware or software partner. Currently, developers from Bull, Dell, Fujitsu-Siemens, HP, IBM, Intel, Novell/SUSE, RealTech, Red Hat, SAP, SUN and a number of temporary “guests” share the same rooms in the LinuxLab. Despite our hardware partners being competitors, the cooperation is excellent and we had a number of very successful projects. The LinuxLab also closely cooperates with (and is located directly next to) SAP’s Server Infrastructure department, which is responsible for the development of the SAP kernel, the basis layers on top of the native operating systems, which make SAP’s business applications platform independent.

8. What role does SAP play in the Open Source scene?

We are supporting Open Source when it comes to Linux as an operating system or MaxDB (formerly Adabas/D or SAP DB) as a database. In fact, back in 1999, we were the first business software provider to support Linux as an operating system for running SAP solutions. We work closely with the Linux distributors and our partners to ensure our solutions work smoothly on Linux. Our main focus with SAP on Linux is helping our customers build the IT environment that is right for them. More and more customers are requesting help with SAP on Linux. And we are there to provide them with the high quality support they expect from SAP.

9. Interested in offering your software to SAP customers so they can enhance functionality of their SAP servers running Linux?

SAP is open to third party software and hardware products. As SAP only uses standard APIs provided by the Linux OS, third party software is usually transparent to us. Whereas we usually do not certify third party software, LinuxLab is open for joint development efforts.

10. What does “SAP NetWeaver on Linux” mean?

SAP is the market leader of inter-enterprise software solutions with the world’s largest enterprise software customer base. SAP has more than 10 million licensed users, more than 20,000 installations in more than 100 countries and supports 28 different languages. More than half of the world’s top 500 companies use SAP software! SAP supports the mySAP Business Suite in a productive environment under Linux. This also includes the database server (IBM DB2/UDB, Informix, Oracle and SAP DB) as well as the application server and the frontend. You can run SAP on Linux in homogeneous and heterogeneous environments. The mySAP Business Suite is running upon the SAP NetWeaver, which includes components like the SAP Web Application Server or the SAP Enterprise Portal.


Note: Above interview questions are same if your are looking for Sap Abap Interview Question, Sap Abap Interview Questions, Sap Bw Interview Questions, SAP Interview Question, Sap Interview Questions, Sap Pp Interview Questions, Sap R 3 Interview Questions, Abap Interview, Abap Interview Question and Abap Interview Questions.


SAP HR Interview Questions

1) 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.

Also In recruitment it is represented by 'P' as Person and 'AP" as external person.

2) What are problems generally faced while posting result to FICO ?

Normally mismatching of amount get posted.

3) 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.

4) 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.

5) 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.

6) What all infotypes which has to be created at the time of hiring OR PA40 and cannot be maintained later with PA30 ?

Why you require creation of infotypes...

7) If we have to create multiple positions, what method OR tool we can use to avoid errors due to creating them manually.

You can create muliple position by LSMW or batch programs for the Tcode PP01 or PPOCE

8) What do is LANDSCAPE in SAP Project, I think its related to no. of servers used, Pls correct me if I am wrong, Or what it is ?

It is related to Basis

9) What is the role of a administrator in PA ?

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

Administrator: we come across for Personnel admininstration, Time management, and Payroll in sap .

Each admiinistrator is reponsible for each individual activity. You can get the name of the administrator in the pay slip so the employee for any clarification he can meet the responsible administrator (accessed through payslip)

This administrtor (is created in PA of PM) is responsible for recruitment. *-- HR Tips by : Somasekhar

10) What is golive actually ? What is the role of a functional consultant in it ?

Go live is transfering of data from Development server to Production server.

Development -----> Quality server

In Quality you need to Unit, Integration testing, Once it is OK in Qulaity server,

Then you need

Development ----> Production *-- Karthik

See also; Implementing SAP

1) 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.

2) In OM, how to get the details for group of employees (ex.) group of Drivers in the organisation?

Drivers can be identified depending on their position at which they are working and you can have a different job codes for them who do you want to look into.

3) 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.

X000 schema carries xt00 and these data can be transfered between other modlues.

4) 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 )
CHECK ALL OF THEM , GO FOR PROGRAM

RHINTE00 PHINTE10 , PRHINTE20 , PHINTE30 AND 40 ALSO.

5) In TM, if group of employees get 10 days of annual leave, what will be the time evaluation status?

TIME evaluation shows the exact details maintained over to the employee through his 2006 and 2001. if they are all allowed to take leave it shows leave as paid or unpaid depending on the configuration done by the consultant for these situation. in
processing time data in payroll or even Time evaluation ( Valuation of absences ) also.

6) Find the scenario and give the result : A,B,C are employees, where A,B will get basic,HRA,DA. C gets Basic and DA. How to group for the allowances?.

Allowances are paid depending on his gradation and even wages are also paid on this criteria, if AB are paid bas, hra and DA then take three wage types ans assign to the ES Grouping and don't give HRA wage type to C.

Check basic salary of inda and ALlowances in indian payroll thorougly, bcos first of all v have to undestand this first and
then you have to decide the emp sub gtroupings

SAP Interview Questions

ABAP Questions:
1.Elementary search helps, Collective search help.
2.Difference between Search Helps and Match Codes
3.Have you created database tables?
4.Difference between client dependent and client independent tables?
5.How to create client independent tables
6.Have you created Maintenance dialog or Table Maintenance?
7.On ABAP: Did you set up a workflow? Are you familiar with all steps for setting up a workflow?
8.Have you used performance tuning? What major steps will you use for these?
9.In the ‘select’ statement what is “group by”?
10.Have you worked with field groups? Have you used Import/Export statements?

ABAP Editor:
1.Fixed point arithmetic – what is the use? How to set this?
2.Have you used client dependent ABAP programs?

Database Commands:
1.Select statement to read data into internal tables. Types of Select statements
2.What happens “Update” command is used without where clause ?
3.Difference between “Insert”, “Update” and “Modify”
4.Explain “Commit” and “Roll back”
5.“Catch” Command
6.What is “Group by” in Select statement?

More then 200 questions on Logical databases, Buffering, Basis, Reports, BDC, Transactions, SAP Script,User–Exits, SD module, MM module, FI module, Performance tuning,SAP Memory, Others, WorkFlow, General questions are availabe in our EFS Repository.



Note: Above interview questions are same if your are looking for Sap Abap Interview Question, Sap Abap Interview Questions, Sap Bw Interview Questions, SAP Interview Question, Sap Interview Questions, Sap Pp Interview Questions, Sap R 3 Interview Questions, Abap Interview, Abap Interview Question and Abap Interview Questions.



Monday, January 28, 2008

JDBC Interview Questions-5

41) Can I ensure that my app has the latest data?

Typically an application retrieves multiple rows of data, providing a snapshot at an instant of time. Before a particular row is operated upon, the actual data may have been modified by another program. When it is essential that the most recent data is provided, a JDBC 2.0 driver provides the ResultSet.refreshRow method.

42) What does normalization mean for java.sql.Date and java.sql.Time?

These classes are thin wrappers extending java.util.Date, which has both date and time components. java.sql.Date should carry only date information and a normalized instance has the time information set to zeros. java.sql.Time should carry only time information and a normalized instance has the date set to the Java epoch ( January 1, 1970 ) and the milliseconds portion set to zero.

43) What's the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?

Because PreparedStatement objects are precompiled, their execution can be faster than that of Statement objects. Consequently, an SQL statement that is executed many times is often created as a PreparedStatement object to increase efficiency.

A CallableStatement object provides a way to call stored procedures in a standard manner for all DBMSes. Their execution can be faster than that of PreparedStatement object.

Batch updates are used when you want to execute multiple statements together. Actually, there is no conflict here. While it depends on the driver/DBMS engine as to whether or not you will get an actual performance benefit from batch updates, Statement, PreparedStatement, and CallableStatement can all execute the addBatch() method.

44) What is JDO?

JDO provides for the transparent persistence of data in a data store agnostic manner, supporting object, hierarchical, as well as relational stores.

45) What is the difference between setMaxRows(int) and SetFetchSize(int)? Can either reduce processing time?

setFetchSize(int) defines the number of rows that will be read from the database when the ResultSet needs more rows. The method in the java.sql.Statement interface will set the 'default' value for all the ResultSet derived from that Statement; the method in the java.sql.ResultSet interface will override that value for a specific ResultSet. Since database fetches can be expensive in a networked environment, fetch size has an impact on performance.

setMaxRows(int) sets the limit of the maximum nuber of rows in a ResultSet object. If this limit is exceeded, the excess rows are "silently dropped". That's all the API says, so the setMaxRows method may not help performance at all other than to decrease memory usage. A value of 0 (default) means no limit.

46) What is DML?

DML is an abbreviation for Data Manipulation Language. This portion of the SQL standard is concerned with manipulating the data in a database as opposed to the structure of a database. The core verbs for DML are SELECT, INSERT, DELETE, UPDATE, COMMIT and ROLLBACK.

47) What is DDL?

DDL is an abbreviation for Data Definition Language. This portion of the SQL standard is concerned with the creation, deletion and modification of database objects like tables, indexes and views. The core verbs for DDL are CREATE, ALTER and DROP. While most DBMS engines allow DDL to be used dynamically ( and available to JDBC ), it is often not supported in transactions.

48) How can I get information about foreign keys used in a table?

DatabaseMetaData.getImportedKeys() returns a ResultSet with data about foreign key columns, tables, sequence and update and delete rules.

49) How do I disallow NULL values in a table?

Null capability is a column integrity constraint, normally aplied at table creation time. Note that some databases won't allow the constraint to be applied after table creation. Most databases allow a default value for the column as well. The following SQL statement displays the NOT NULL constraint:

CREATE TABLE CoffeeTable ( 
   Type   VARCHAR(25)   NOT NULL, 
   Pounds INTEGER       NOT NULL, 
   Price  NUMERIC(5, 2) NOT NULL 
                         )

50) What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?

The answer depends on both your code and the DBMS. If the program does not explicitly set the isolation level, the DBMS default is used. You can determine the default using DatabaseMetaData.getDefaultTransactionIsolation() and the level for the current Connection with Connection.getTransactionIsolation(). If the default is not appropriate for your transaction, change it with Connection.setTransactionIsolation(int level).

JDBC Interview Questions-4

31) What separates one tier from another in the context of n-tiered architecture?

It depends on the application.

In a web application, for example, where tier 1 is a web-server, it may communicate with a tier 2 Application Server using RMI over IIOP, and subsequently tier 2 may communicate with tier 3 (data storage) using JDBC, etc.

Each of these tiers may be on separate physical machines or they may share the same box.

The important thing is the functionality at each tier.

  • Tier 1 - Presentation - should be concerned mainly with display of user interfaces and/or data to the client browser or client system.
  • Tier 2 - Application - should be concerned with business logic

Tier 3+ - Storage/Enterprise Systems - should be focused on data persistence and/or communication with other Enterprise Systems.

32) What areas should I focus on for the best performance in a JDBC application?

These are few points to consider:

  • Use a connection pool mechanism whenever possible.
  • Use prepared statements. These can be beneficial, for example with DB specific escaping, even when used only once.
  • Use stored procedures when they can be created in a standard manner. Do watch out for DB specific SP definitions that can cause migration headaches.
  • Even though the jdbc promotes portability, true portability comes from NOT depending on any database specific data types, functions and so on.
  • Select only required columns rather than using select * from Tablexyz.
  • Always close Statement and ResultSet objects as soon as possible.
  • Write modular classes to handle database interaction specifics.
  • Work with DatabaseMetaData to get information about database functionality.
  • Softcode database specific parameters with, for example, properties files.
  • Always catch AND handle database warnings and exceptions. Be sure to check for additional pending exceptions.
  • Test your code with debug statements to determine the time it takes to execute your query and so on to help in tuning your code. Also use query plan functionality if available.
  • Use proper ( and a single standard if possible ) formats, especially for dates.
  • Use proper data types for specific kind of data. For example, store birthdate as a date type rather than, say, varchar.

33) How can I insert multiple rows into a database in a single transaction?

//turn off the implicit commit

Connection.setAutoCommit(false);

//..your insert/update/delete goes here

Connection.Commit();

a new transaction is implicitly started.

34) How do I convert a java.sql.Timestamp to a java.util.Date?

While Timesteamp extends Date, it stores the fractional part of the time within itself instead of within the Date superclass. If you need the partial seconds, you have to add them back in.

 
Date date = new Date(ts.getTime() + (ts.getNanos() / 1000000 )); 

35) What is SQL?

SQL is a standardized language used to create, manipulate, examine, and manage relational databases.

36) Is Class.forName(Drivername) the only way to load a driver? Can I instantiate the Driver and use the object of the driver?

Yes, you can use the driver directly. Create an instance of the driver and use the connect method from the Driver interface. Note that there may actually be two instances created, due to the expected standard behavior of drivers when the class is loaded.

37) What's new in JDBC 3.0?

Probably the new features of most interest are:

  • Savepoint support
  • Reuse of prepared statements by connection pools
  • Retrieval of auto-generated keys
  • Ability to have multiple open ResultSet objects
  • Ability to make internal updates to the data in Blob and Clob objects
  • Ability to Update columns containing BLOB, CLOB, ARRAY and REF types
  • Both java.sql and javax.sql ( JDBC 2.0 Optional Package ) are expected to be included with J2SE 1.4.

38) Why do I get the message "No Suitable Driver"?

Often the answer is given that the correct driver is not loaded. This may be the case, but more typically, the JDBC database URL passed is not properly constructed. When a Connection request is issued, the DriverManager asks each loaded driver if it understands the URL sent. If no driver responds that it understands the URL, then the "No Suitable Driver" message is returned.

39) When I create multiple Statements on my Connection, only the current Statement appears to be executed. What's the problem?

All JDBC objects are required to be threadsafe. Some drivers, unfortunately, implement this requirement by processing Statements serially. This means that additional Statements are not executed until the preceding Statement is completed.

40) Can a single thread open up mutliple connections simultaneously for the same database and for same table?

The general answer to this is yes. If that were not true, connection pools, for example, would not be possible. As always, however, this is completely dependent on the JDBC driver.

You can find out the theoretical maximum number of active Connections that your driver can obtain via the DatabaseMetaData.getMaxConnections method.

JDBC Interview Questions-3

11) I have the choice of manipulating database data using a byte[] or a java.sql.Blob. Which has best performance?

java.sql.Blob, since it does not extract any data from the database until you explicitly ask it to. The Java platform 2 type Blob wraps a database locator (which is essentially a pointer to byte). That pointer is a rather large number (between 32 and 256 bits in size) - but the effort to extract it from the database is insignificant next to extracting the full blob content. For insertion into the database, you should use a byte[] since data has not been uploaded to the database yet. Thus, use the Blob class only for extraction.

Conclusion: use the java.sql.Blob class for extraction whenever you can.

12) I have the choice of manipulating database data using a String or a java.sql.Clob. Which has best performance?

java.sql.Clob, since it does not extract any data from the database until you explicitly ask it to. The Java platform 2 type Clob wraps a database locator (which is essentially a pointer to char). That pointer is a rather large number (between 32 and 256 bits in size) - but the effort to extract it from the database is insignificant next to extracting the full Clob content. For insertion into the database, you should use a String since data need not been downloaded from the database. Thus, use the Clob class only for extraction.

Conclusion: Unless you always intend to extract the full textual data stored in the particular table cell, use the java.sql.Clob class for extraction whenever you can.

13) Do I need to commit after an INSERT call in JDBC or does JDBC do it automatically in the DB?

If your autoCommit flag (managed by the Connection.setAutoCommit method) is false, you are required to call the commit() method - and vice versa.

14) How can I retrieve only the first n rows, second n rows of a database using a particular WHERE clause ? For example, if a SELECT typically returns a 1000 rows, how do first retrieve the 100 rows, then go back and retrieve the next 100 rows and so on ?

Use the Statement.setFetchSize method to indicate the size of each database fetch. Note that this method is only available in the Java 2 platform. For Jdk 1.1.X and Jdk 1.0.X, no standardized way of setting the fetch size exists. Please consult the Db driver manual.

15) What does ResultSet actually contain? Is it the actual data of the result or some links to databases? If it is the actual data then why can't we access it after connection is closed?

A ResultSet is an interface. Its implementation depends on the driver and hence ,what it "contains" depends partially on the driver and what the query returns.

For example with the Odbc bridge what the underlying implementation layer contains is an ODBC result set. A Type 4 driver executing a stored procedure that returns a cursor - on an oracle database it actually returns a cursor in the database. The oracle cursor can however be processed like a ResultSet would be from the client.

Closing a connection closes all interaction with the database and releases any locks that might have been obtained in the process.

16) What are SQL3 data types?

The next version of the ANSI/ISO SQL standard defines some new datatypes, commonly referred to as the SQL3 types. The primary SQL3 types are:

STRUCT: This is the default mapping for any SQL structured type, and is manifest by the java.sql.Struct type.

REF: Serves as a reference to SQL data within the database. Can be passed as a parameter to a SQL statement. Mapped to the java.sql.Ref type.

BLOB: Holds binary large objects. Mapped to the java.sql.Blob type.

CLOB: Contains character large objects. Mapped to the java.sql.Clob type.

ARRAY: Can store values of a specified type. Mapped to the java.sql.Array type.

You can retrieve, store and update SQL3 types using the corresponding getXXX(), setXXX(), and updateXXX() methods defined in ResultSet interface

17) How can I manage special characters (for example: " _ ' % ) when I execute an INSERT query? If I don't filter the quoting marks or the apostrophe, for example, the SQL string will cause an error.


The characters "%" and "_" have special meaning in SQL LIKE clauses (to match zero or more characters, or exactly one character, respectively). In order to interpret them literally, they can be preceded with a special escape character in strings, e.g. "\". In order to specify the escape character used to quote these characters, include the following syntax on the end of the query:

{escape 'escape-character'}

For example, the query

SELECT NAME FROM IDENTIFIERS WHERE ID LIKE '\_%' {escape '\'}

finds identifier names that begin with an underbar.

18) What is SQLJ and why would I want to use it instead of JDBC?

SQL/J is a technology, originally developed by Oracle Corporation, that enables you to embed SQL statements in Java. The purpose of the SQLJ API is to simplify the development requirements of the JDBC API while doing the same thing. Some major databases (Oracle, Sybase) support SQLJ, but others do not. Currently, SQLJ has not been accepted as a standard, so if you have to learn one of the two technologies, I recommend JDBC.

19) How do I insert an image file (or other raw data) into a database?

All raw data types (including binary documents or images) should be read and uploaded to the database as an array of bytes, byte[]. Originating from a binary file,

  1. Read all data from the file using a FileInputStream.
  2. Create a byte array from the read data.
  3. Use method setBytes(int index, byte[] data); of java.sql.PreparedStatement to upload the data.

20) How can I pool my database connections so I don't have to keep reconnecting to the database?

  • you gets a reference to the pool
  • you gets a free connection from the pool
  • you performs your different tasks
  • you frees the connection to the pool

Since your application retrieves a pooled connection, you don't consume your time to connect / disconnect from your data source.


My Ad

.