SQL Interview Questions and Answers

Q1. How to delete duplicate records?

• Using rowid

——————-

SQL > delete from emp where rowid not in (select max (rowid) from emp group by empno);

This technique can be applied to almost scenarios. Group by operation should be on

Read More

Selenium Interview Questions and Answers

Selenium Interview Questions and Answers

Selenium is software testing tool framework, which is used for web applications. Selenium training in Chennai by Besant Technologies provides the best training. Our trainers are extremely talented and have many years of experience as developer and debugger. They know how to handle Selenium and Selenium-based program codes. Our tutors and mentors have prepared this top 100+ Selenium interview questions and answers.

Read More

API testing using POSTMAN

What is API testing ?

The API Testing is performed for the application, which has a collection of API that must be tested. API calls verify functionality and expose failure of application.
API testing is strongly connected with Back-end/Database testing, you may have brief knowledge of SQL queries. (That would be an advantage )

Read More

How to Run Test Cases using Selenium Grid

Selenium Grid is a tool that distributes the tests across multiple physical or virtual machines so that we can execute scripts in parallel (simultaneously). It dramatically accelerates the testing process across browsers and across platforms by giving us quick and accurate feedback.

Selenium Grid allows us to execute multiple instances of WebDriver or Selenium Remote Control tests in parallel which uses the same code base, hence the code need NOT be present on the system they execute. The selenium-server-standalone package includes Hub, WebDriver, and Selenium RC to execute the scripts in grid.

Read More

Apache Pig Notes

What is pig?

Implemented by Yahoo.
Pig Hadoop echo system s/w from apache foundation used for analysing the data.
Pig uses pig latin language.

Read More

Apache Sqoop Notes

Overview on Sqoop

Sqoop is open source s/w from Apache used for transfer data between RDBMS(oRACLE, sLQSERVER, mYSQL...) and HDFS.

MySQL Database

Connecting to MySQL Database:
root user: root/cloudera
other user: cloudera/cloudera

Read More

Apache Hive Notes

Apache Hive

• Hive is a data warehouse infrastructure tool to process structured data in Hadoop. 
• Initially Hive was developed by Facebook, later the Apache Software Foundation took it up and developed it further as an open source under the name Apache Hive.
• It stores schema in a database and processed data into HDFS.
• It is designed for OLAP not for OLTP.
• It provides SQL type language for querying called HiveQL or HQL.
• Hive is not RDBMS.
• Hive is a system for managing and querying un-structured data into structured format. It uses the concept of Map Reduce for execution.

Read More

How to Success in Job Interview

How to Success in Job Interview

Formula:
O = P x E x A

Read More

QA Interview Questions and Answers Part - 7

1. What are you expecting from our company?

Answer: My expectation from you company would be I will have more challenges and new things to learn and whatever the skills I have to contribute, hopefully, I will be able to contribute if they are in any way helpful to enhance productivity of the company.

Read More

QA Interview Questions and Answers Part - 6

1. What is end-to-end testing?

Answer: Similar to system testing, the *macro* end of the test scale is testing a complete application in a situation that mimics real world use, such as interacting with a database, using network communication, or interacting with other hardware, application, or system.

Read More

QA Interview Questions and Answers Part - 5

1. What are the different matrices that you follow?

Answer: There are various reports we normally prepare in QA:

Test summary Report – It is a report that has list of the total test cases, list of executed test cases, remaining test case to be executed, executed date, pass/fail

Read More

QA Interview Questions and Answers Part - 4

1. What is a “bug?”

Answer : A bug is a bug is an error, flaw, mistake, failure, or fault in a computer code (program) that prevents it from behaving as intended (e.g., producing an incorrect result). (You can also add this: When the expected results (accordingly to the requirement documents) don’t match with the actual results (while testing), then it is considered a bug)

Read More

QA Interview Questions and Answers Part - 3

1. Are you better working in a team or working alone?

Answer: I am a team player. I get along with team members very well. As far as the working is concerned, I can be equally productive in team or working alone.

Read More

QA Interview Questions and Answers Part - 2

1. Are Test Plan and Test Strategy same type of documents?

Answer: No, they are different documents. A Test Plan is a document that collects and organizes test cases by functional areas and/or types of testing in a form that can be presented to the other teams and/or customer (see the definition on this page for Test Plan) where as the Test Strategy (see the definition in the above question) is the documented approach to testing. The tester prepares test Plan whereas the Manager or lead prepares the Test Strategy. Both are important pieces of Quality Assurance processes since they help communicate the test approach scope and ensure test coverage while improving the efficiency of the testing effort.

Read More

QA Interview Questions and Answers Part - 1

1.Can you tell me about yourself?

Answer: In my QA career, I have been working on various system platforms and operating systems like Windows 95, Windows 2000, Windows XP and UNIX. I have tested applications developed in Java, C++, Visual Basic and so on. I have tested Web-based applications as well as client server applications.

Read More