Testing Guide

During interviews , instead of directly asking questions on theoretical concepts, now a days interviewers ask SQL queries that test both the theoretical as well as practical understanding and usage of the different SQL concepts. In this post, we discuss some of the most common SQL queries for the interviews that you should prepare. So, let’s begin. Q1. Write a query to update a field’s values by removing any leading and trailing spaces.  Ans.  UPDATE command with LTRIM() and RTRIM() functions. UPDATE Table1 SET Name = LTRIM(RTRIM(Name)); Q2. Write an SQL query to return the count of occurrence of a character in a particular field.  Ans. For this query, we will use the Length() function with the subtraction operator and aReplace function.  SELECT Name, LENGTH(Name) - LENGTH(REPLACE(Name, 'k', '')) FROM Employee; Q3. How can we create a new table with data and structure the same as an existing table?  Ans. Creating a new table just requires us to use the CREATE TA...

In this tutotial, we will learn about the basic of Software Testing concepts. With our software testing tutorial series , you will learn different types of  testing concepts with a practical approach. In order to increase the quality of software , it is very important to make sure the effectiveness of software application. What is Software Testing The present universe of innovation is totally overwhelmed by machines, and their conduct is constrained by the product controlling it. software testing gives a financially savvy answer for every one of our concerns.  software Testing is an interaction of assessing the usefulness of a product application to discover any product bugs. It checks whether the created programming met the predefined necessities and recognizes any imperfection in the product to accomplish a quality item. It is fundamentally executing a framework to recognize any holes, blunders, or missing prerequisites as opposed to the real necessities. Different...