Sponsored Ad

Monday, January 11, 2010

Database Testing Interview Questions

  1. What do you mean by Normalization and What is the use of normalized database?
    Answer: Read definition of first normal form, second normal form, third normal form, fourth normal form, fifth normal form,
  2. Give me the complete syntax of Select command?
    Answer:
SELECT [ DISTINCT | ALL ]

column_expression1, column_expression2, ....

[ FROM from_clause ]

[ WHERE where_expression ]

[ GROUP BY expression1, expression2, .... ]

[ HAVING having_expression ]

[ ORDER BY order_column_expr1, order_column_expr2, .... ]

column_expression ::= expression [ AS ] [ column_alias ]

from_clause ::= select_table1, select_table2, ...

from_clause ::= select_table1 LEFT [OUTER] JOIN select_table2 ON expr ...

from_clause ::= select_table1 RIGHT [OUTER] JOIN select_table2 ON expr ...

from_clause ::= select_table1 [INNER] JOIN select_table2 ...

select_table ::= table_name [ AS ] [ table_alias ]

select_table ::= ( sub_select_statement ) [ AS ] [ table_alias ]

order_column_expr ::= expression [ ASC | DESC ]

 


  1. What is the basic difference between where and having clause?
    Answer: having is used with aggregate functions.
  2. What are the outputs of the following operations: NULL*5 and NULL+5?
    Answer:
  3. Can you give me the command to create a new table on the basis of an existing table?
    Answer:

CREATE TABLE table [ ( column [, ...] ) ]             AS select




  1. You have employee table with a ‘joining date’ field. Can you give me a query which shows all the records which are sorted according to day wise; means all ‘Sunday’ records comes first then ‘Monday’ records and so on?
    Answer:
  2. What is the difference between ‘Left outer join’, ‘Right outer join’, ‘Full outer join’ and ‘Self Join’? Explain them with example using emp & dept tables.
    Answer: Read Definitions
  3. Give a query through which top 5 records can fetched on the basis of ‘Sal’ field of EMP table.
    Answer: select top 5 * from emp order by emp.sal desc?

  4. Fetch the 5th highest sal record from the emp table?
    Answer:
  5. Suppose you have a table with 3 columns:
    Write a query through which you show the sum of amount of quarters of each year in the separate quarter columns?
    Answer:
  6. What do you mean by D/W house?
    Answer: Read Definitions
  7. What is difference between OLAP and OLTP?
    Answer: OLAP – Online analytical processing

OLTP – Online transaction Processing



  1. Explain ETL process?
    Answer: ETL - extraction, transformation and loading
  2. What do you mean by Star Schema?
    Answer:
  3. Can you explain me DTS process in SQL server?
    Answer: DTS - Data Transformation Services
  4. Can SQL Servers linked to other servers like Oracle?
    Answer: SQL Server can be lined to any server provided it has OLE-DB provider from Microsoft to allow a link. E.g. Oracle has a OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.

Wednesday, January 6, 2010

HP Quality Center 10.0 Agile Accelerator Free downloads – no expiration

HP Quality Center 10.0 Agile Accelerator downloads – no expiration

HP Quality Center provides a single web-based application that supports all essential aspects of testing management. It Provides a consistent, repeatable method for gathering requirements, planning and scheduling tests, analyzing results and managing defects and issues. This application allows your organization to automate specific quality processes and procedures in the application lifecycle. It also supports high levels of communication and collaboration between your IT team.


The HP Quality Center Agile Accelerator can be imported into the Quality Center project as a basis for managing both the development and testing efforts within the same project Quality Center. It comes with pre-defined agile workflow method, configurations and rules to help manage the projects promoted by the agile methodology, pre-built Agile user roles and associated privileges that are easy to use.

How to Download:

https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=bto&cp=1-11-127-24^1131_4000_100__

HP Quality Center Demo:

HP LoadRunner 9.5 Evaluation version Free Download

HP LoadRunner 9.5 Evaluation version Free Download

HP LoadRunner can help prevent costly application performance problems in production by detecting bottlenecks before a new method of updating or unfolds. This Software allows you to measure end to end performance, diagnose application and bottlenecks and adjust the project for better performance, all from a single point of control. The integrated load control, performance monitoring and stress characteristics of the application of verification helps reduce costs and time to test and deploy new applications and systems in the production environment.

How to Download:

https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=bto&cp=1-11-126-17^8_4000_100__

Also visit for LoadRunner system requirement:

https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=bto&cp=1-11-126-17^9753_4000_100__

HP LoadRunner Introduction:

HP LoadRunner Tutorial:

All About Selenium, Selenium Documentation

All About Selenium, Selenium Documentation

Selenium is a powerful set of tools that supports the rapid development of automated testing for web based applications. Selenium provides a rich feature set of test tailored to the needs of testing a web application. These operations are very flexible, allowing plenty of options for the location of interface elements and compare the results of verification provisions against the behavior of the actual application.

One of the main features of selenium is the support for the implementation of the evidence of one in the platforms of multiple browsers.

You can visit the given link for detailed Selenium Documentation

http://seleniumhq.org/docs/

Selenium introduction:

Selenium Free Download, An Open Source Testing tool

Selenium Free Download, An Open Source Testing tool

Selenium Intro file:

Selenium Intro file:

http://seleniumhq.org/movies/intro.mov

 

Selenium  IDE Free Download

Selenium  IDE Free Download

http://seleniumhq.org/download/

 

Selenium Remote Control (RC)

Selenium Remote Control (RC)

http://seleniumhq.org/download

 

Selenium Grid Free Download

Selenium Grid

http://selenium-grid.openqa.org/download.html

Sunday, January 3, 2010

HP QuickTest Professional 10.0 (QTP 10) Evaluation Version Free Download

HP QuickTest Professional 10.0 (QTP 10)  Evaluation Version Free Download


Key features

  • Set up unattended recovery, enabling 24x7 testing that lets you meet test project deadlines
  • Maintain scripts using keyword-driven testing technology
  • Update multiple test scripts quickly using the shared object repository
  • Process Guidance to set a test development process and propagate it throughout an organization
  • Maintenance Run Mode to enable test modifications “on the fly” during test execution
  • Unique client performance validation to report on client performance issues identified during automated testing
  • Enhanced integration with HP Quality Center

How to download:

https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=bto&cp=1-11-127-24^1322_4000_100__

Saturday, January 2, 2010

Google C++ Testing Framework Free Download

Google Framework to write C++ tests is freely available for download. This supports verity of platforms (Linux, Mac OS X, Windows, Cygwin, Windows CE & Symbian).

For more details, Please visit following links:

Google test direct link:

http://code.google.com/p/googletest/

Google test Free downloads:

http://code.google.com/p/googletest/downloads/list

Friday, January 1, 2010

QA Bug Logging Process

This is Sample basic testing process and one can use it and design a complex QA testing process.

How to Log Errors

Things to be included in the bug report:

  • Put the Reporter’s Name on the bug. If there are questions we need to know who originated this report.
  • Specify the Feature or Specification or part of the code. This facilitates assigning the bug to a developer assigned to that part of the product.
  • Include a Brief Description of what the problem is.
  • List Details including how to duplicate the bug (Steps to Replicate) and any other relevant data or clues about the bug. Start with how the computer and software is setup. List each and every step (don’t leave any out) to produce the bug. Sometimes a minor detail can make all the difference in duplicating or not duplicating a bug. For example, using the keyboard versus using the mouse may produce very different results when duplicating a bug.
  • If the status isn’t ‘Submitted’ by default, change it to Submitted. This is a flag to the bug verifier that a new bug has been created and needs to be verified and assigned.
  • Include all associated URLs.
  • Environment Information needs to be added to identify if the issue is not environment related. Minimum information that will be required: OS, Browser and Version.
  • The Severity* tells the reader of the bug how bad the problem is. Or in other words, say what the results of the bug are. Here’s a common list for judging the severity of bugs. There is sometimes disagreement about how bad a bug is. This list takes the guess work out of assigning a severity to bugs.

 

Rating

Value

Emergency

An entire site is not accessible or an entire database is not accessible or corrupted.

Critical

A major function is not accessible and there is no workaround.

Moderate

A major function is not working but there is a workaround, a moderate function is not accessible and there is no workaround or a non-trivial part of a major function is not accessible or defective.

Minor

A minor function is not accessible or defective; a part of a minor function is not accessible or defective.

* Severity should not be confused with Priority. Priority will be assigned by Business.

Appendix A – Priority Definitions

Priority

Definition

1

Showstopper

2

Must be fixed in order to launch the product. This can represent a partial fix where applicable in order to move issue into P3

3

The product can be launched but issue should be fixed with the next maintenance release

4

The fix should be scheduled for the future release

Tuesday, December 22, 2009

QTP and DotNetfactory – ArrayList

Arraylist contains a list of values, you can add, insert and remove easily. You can add value with no information on the size which makes it a flexible information structure.

To work with this we just need to create an instance of ‘System.Collections.ArrayList’ using CreateInstance method.

Set MyList = DotnetFactory.CreateInstance("System.Collections.ArrayList")

Here are some of the functions which can be used to work with ArrayLists

Add – adds an item in an arraylist

MyList.Add(”ListItem”)

Remove – removes an item from the arraylist

MyList.Remove(”ListItem “)

Insert - inserts an item at a specified position in the array list

MyList.Insert (3, "List Item")

RemoveAt - remove an item from the specified position in the array list

MyList.RemoveAt (3)

Sort - Sort items in the array list

MyList.Sort

Consider a case where you need to sort a list in ascending or descending order.

First create the arraylist and add your list items in the arraylist. We will add five items in the list in random order.

Set MyList = DotnetFactory.CreateInstance("System.Collections.ArrayList")

2.MyList.Add("ListItem5")

3.MyList.Add("ListItem3")

4.MyList.Add("ListItem2")

5.MyList.Add("ListItem1")

6.MyList.Add("ListItem4")

When you add a new item in the arraylist, it adds some empty memory locations, they ought to remove these empty memory locations. To do this they can use ‘TrimToSize’ method, which sets the capacity to the actual number of elements in the arraylist. You can easily understand this with the example below.

QTP test data directly from external sheet

In a quantity of our earlier posts they have seen How to work on QTP datatable, How to import/export datatable, what are the different functions obtainable for datatable & also the basics of QTP Automation Object Model(AOM).

Here they will merge AOM & Excel automation model to import information from an external excel file to QTP without actually importing the file as a ‘datatable’.

The workflow for the method would be:

1. Generate an excel object.

2. Generate a workbook object that takes file path as input.

3. Generate a sheet name object that takes sheet name as input.

4. Perform operations on sheet.

1. …………………………………

2. …………………………………

3. …………………………………

5. Quit excel application.

6. Destroy objects defined above.

We will show the whole process with an example. It will generate a function that accepts the file path and name of the entry sheet and give the output of an array containing all values of column 1 of the entry sheet.

  1. 1: Function ParamValues(InputFilePath,SheetName)
  2.  
  3. 2: Dim input()
  4.  
  5. 3: Set appExcel = CreateObject(“Excel.Application”) ‘Step 1
  6. 4: Set objWorkBook = appExcel.Workbooks.Open (InputFilePath) ‘Step 2
  7. 5: Set objSheet = appExcel.Sheets(SheetName) ‘Step 3
  8.  
  9. 6: For i=2 to 50 ‘Step 4
  10. 7: if objSheet.cells(i,1).value <> “” then
  11. 8: Input(i-2)=Trim(objSheet.cells(i,1).value)
  12. 9: else
  13. 10: Exit For
  14. 11: End If
  15. 14: Next
  16. 15: appExcel.quit ‘Step 5
  17. 16: Set appExcel=Nothing ‘Step 6
  18. 17: Set objSheet=Nothing
  19. 18: Set objWorkBook=Nothing
  20. 19: End Function

InputFilePath & SheetName input arguments are passed to the function call paramValue. The output of the previous function will be an entry () matrix containing all the values in column 1 of the given Excel worksheet.

You can call the function above by: paramValues,

Sponsored Ad

Related Software Testing Articles

Development Updates

Tech Updates