Interview Questions.

Question 1. What Is Data-base Testing?

Answer :

Data base checking out is segmented into four distinctive categories.

Testing of Data Integrity
Testing of Data Validity
Data base related performance
Testing of capabilities, method and triggers
Question 2. In Database Testing, What Do We Need To Check Normally?

Answer :

Normally, the things that we check in database trying out are:

Constraint Check
Validation of a Field length
Stored process
Matching utility subject length to database
Indexes for overall performance based troubles
Web Service Testing Interview Questions
Question three. Explain What Is Data Driven Test?

Answer :

In a information-table, to test the multi numbers of records, facts-pushed check is used. By the usage of this it may effortlessly replace the parameters on the identical time from one of a kind locations.

Question 4. What Are Joins And Mention Different Types Of Joins?

Answer :

Join is used to show  or extra than two desk and the sorts of joins are:

Natural Join
Inner Join
Outer Join
Cross Join
The outer be a part of is split again in :

Left outer be a part of
Right outer be part of
Web Service Testing Tutorial
Question five. What Are Indexes And Mention Different Types Of Indexes?

Answer :

Indexes are database objects and they are created on columns. To fetch statistics fast they are regularly accessed. Different forms of indexes are:

B-Tree index
Bitmap index
Clustered index
Covering index
Non-specific index
Unique index
ETL Testing Interview Questions
Question 6. While Testing Stored Procedures What Are The Steps Does A Tester Takes?

Answer :

The tester will take a look at the usual layout of the saved strategies and also it tests the fields are accurate like updates, joins, indexes, deletions as mentioned within the stored technique.

Question 7. How Would You Know For Database Testing, Whether Trigger Is Fired Or Not?

Answer :

On querying the commonplace audit log you'll know, whether, a cause is fired or no longer. It is in audit log where you may see the triggers fired.

ETL Testing Tutorial Agile Testing Interview Questions
Question 8. In Data Base Testing, What Are The Steps To Test Data Loading?

Answer :

Following steps need to comply with to check data loading

Source records must be known
Target information need to be acknowledged
Compatibility of supply and target must be checked
In SQL Enterprise manager, run the DTS package deal after commencing the corresponding DTS package deal
You must evaluate the columns of goal and information supply
Number of rows of target and source need to be checked
After updating records within the source, check whether the modifications seems within the target or no longer.
Check NULLs and junk characters
Question 9. Without Using Database Checkpoints, How You Test A Sql Query In Qtp?

Answer :

By writing scripting process in VBScript, we are able to hook up with database and can check the queries and database.

Manual Testing Interview Questions
Question 10. Explain How To Use Sql Queries In Qtp?

Answer :

In QTP using output database take a look at factor and database test, you have to pick out the SQL manual queries choice. After selecting the manual queries choice, input the "choose" queries to fetch the facts in the database and then compare the expected and actual.

Agile Testing Tutorial
Question eleven. What Is The Way Of Writing Test Cases For Database Testing?

Answer :

Writing a testcases is like practical testing. First you have to know the practical requirement of the utility. Then you have to determine the parameters for writing testcases like

Objective: Write the objective which you would love to check
Input technique: Write the method of movement or enter you want to execute
Expected: how it ought to seem inside the database
UI Developer Interview Questions
Question 12. To Manage And Manipulate The Test Table What Are The Sql Statements That You Have Used In Database Testing?

Answer :

The statements like SELECT, INSERT, UPDATE, DELETE are used to govern the table, whilst ALTER TABLE, CREATE TABLE and DELETE TABLE are used to control desk.

Web Service Testing Interview Questions
Question 13. How To Test Database Procedures And Triggers?

Answer :

To take a look at database procedures and triggers, input and output parameters ought to be recognized. EXEC declaration can be used to run the method and examine the behaviour of the tables.

Open the database task in answer explorer
Now in View menu, click the database schema
Open the project folder from schema View menu
Right click on at the object that has to be tested, after which click on on the dialog container that announces Create Unit Tests
After that create a brand new language take a look at project
Select both a) Insert the unit test or b) Create a brand new check after which click OK
Project that needs to be configured might be carried out with the aid of clicking on the Project Configuration dialog container.
Once it configured click on on OK
Database Testing Tutorial
Question 14. How You Can Write Testcases From Requirements And Do The Requirements Represents Exact Functionality Of Aut (application Under Test)?

Answer :

To write a testcases from necessities, you want to examine the requirements very well in phrases of functionality. Thereafter you think about the best testcases layout techniques like Equivalence partitioning, Black box layout, Cause effect graphing etc. For writing the testcases.Yes, the necessities represent precise capability of AUT.

Question 15. What Are Dcl Commands? What Are The Two Types Of Commands Used By Dcl?

Answer :

DCL stands for Data Control Language, it is used to control records.
The  types of DCL Commands are:
Grant: By the use of this command user can get entry to privilege to database
Revoke: By the usage of this command person can not get admission to the database

Automation Testing Interview Questions
Question sixteen. What Is White Box Testing And Black Box Testing?

Answer :

Black field trying out way testing the software for the outputs on giving particular inputs. This trying out is commonly done to see if the software program meets the consumer's necessities. There is no particular purposeful output expected for running this test.

The white container trying out is carried out to check the accuracy of code and logic of the program. This trying out is performed by way of the programmer who knows the logical flow of the system.

Software testing Tutorial
Question 17. How Does Qtp Evaluate Test Results?

Answer :

Once the trying out is achieved, QTP will generate a document. This file will show the checkpoints, machine message and errors that had been detected even as trying out. The check results window will show any mismatches encountered on the checkpoints.

Software testing Interview Questions
Question 18. Explain The Qtp Testing Process?

Answer :

QTP testing technique is based totally on following steps:
Creating GUI (Graphical User Interface) Map files :

Identifies the GUI object which needs to be examined
Creating check scripts: Test scripts are recorded
Debug checks: Test have to be debugged
Run assessments: Testcases should be run.
View effects: The effects reflects the success or failure of the assessments
Report detects: If the test is failed, the motives may be recorded within the document come across document
ETL Testing Interview Questions
Question 19. What Is Load Testing And Give Some Examples Of It?

Answer :

To measure the system response, load trying out is carried out. If the burden exceeds the customers pattern it is referred to as stress testing. Examples of load trying out are downloading the set of big documents, executing multiple packages on a single computer, subjecting a server to large quantity of e-mails and doling out many obligations to a printer one after any other.

Question 20. How To Test Database Manually?

Answer :

Testing the database manually entails checking the statistics on the back cease and to peer whether the addition of information in the front end is affecting the again give up or not, and same for delete, replace, insert etc.

API testing Interview Questions
Question 21. What Rdbms Stands For And What Are The Important Rdmbs That Sql Use?

Answer :

RDBMS stands for Relational Database Management Systems that use SQL, and the crucial RDBMS that SQL uses are Sybase, Oracle, Access ,Ingres, Microsoft SQL server and many others.

Question 22. What Is Performance Testing And What Are The Bottlenecks Of Performance Testing?

Answer :

Performance trying out determines the velocity of the pc gadget performance. It consists of the quantitative tests like reaction time measurement. The problem in performance testing is which you usually want a properly-educated and skilled man power also the equipment you use are high-priced.

Question 23. What Is Ddl And What Are Their Commands?

Answer :

To outline database structure, DDL is used. DDL stands for Data Definition Language. The various DDL instructions consist of Create, Truncate, Drop, Alter, Comment and Rename.

Unix Inter-Process Communication (IPC) Interview Questions
Question 24. What Does The Rdbms Stands For And What Are The Major Rdbms Used By Sql?

Answer :

RDBMS stands for Relational Database Management Systems. Major RDBMS which might be concerned with SQL are Sybase, Oracle, Access, Ingres, Microsoft SQL server and so forth.

Agile Testing Interview Questions
Question 25. What Is Performance Testing And The Bottlenecks Of It?

Answer :

Performance trying out is a software testing approach to determine that how a system overall performance in terms of velocity, sensitivity and stability below a heavy workload.
The overall performance testing calls for pricey gear and well-educated and experienced testers for operation.

Question 26. What Is Cmmi And Describe Different Levels Of Cmm?

Answer :

CMMI stands for Capability Maturity Model Integration is a process development training and assessment version of numerous enterprise procedures in software engineering.

Five CMM Maturity ranges for an employer are:

1) Initial: At this stage, organizations don’t have any validated technique and environment, so that; generally companies budget and agenda time move over.
2) Repeatable: At this level, corporations have primary techniques and suggestions to restrict the price and schedule time, succesful in repeating the identical inside the next comparable mission.
Three) Defined: At this degree, all techniques are properly organized and explained clear and fashionable shape.
Four) Managed: At this stage, groups are lots extra evolved than Defined degree. Here, techniques are contacted using statistical and other quantitive approach.
Five) Optimizing: Organizations determinedly try to increase performance through modern-day technical development.

Test Cases Interview Questions
Question 27. What Is The Meaning Of Record In A Database?

Answer :

In database, a record is the set of values/fields of a selected entity.
For example; Office_Employee Record, Book Record and so forth.

Manual Testing Interview Questions
Question 28. How To Write Test Cases From Requirements, Do The Requirements Signify The Exact Functionality Of Aut?

Answer :

Yes, the requirements need to symbolize the exact functionality of AUT.

To accomplish that:

First have a look at the requirement to apprehend overall functionality.
Next, determine which take a look at design techniques are suitable to write down test case – Black Box test layout techniques like; Equivalence Partitioning, Boundary Value Analysis, Error Guessing and Cause Effect Graphing.
Once making a decision which take a look at layout approach is appropriate, write your test cases in requirement evaluation and layout section. In this manner you'll be ensure that each one the requirements are testable.
Question 29. What Is The Test Scenario To Test A Database Migrated From One Sql Server To Another?

Answer :

First of all, we need to test what all enhancements and changes passed off to the SQL Server in which we're making plans to migrate.
Next, layout the take a look at case in step with the following attention:

Data type that has been used.
Length of the records field of SQL Server (Server into which we're migrating the statistics) should be identical because the SQL Server from in which we are taking out the data.
Each and every undertaking should be organized efficiently.
Hadoop Testing Interview Questions
Question 30. In Database Testing, What All Things Are Required For Writing Good Test Cases?

Answer :

Knowledge of following matters is required before writing the database test cases:

At first, understand the application absolutely and purposeful requirement of the application.
Second, test-out other entities which have been used in an software; back-quit database tables, joins among the tables, cursors (if any), triggers (if any), saved methods (if any), enter parameter and output parameters for growing that requirement.
After collecting all vital information, write down the test case with specific input values for examining all of the assets.
Writing take a look at cases for returned quit trying out is opposite to useful checking out, one have to use the white field checking out method.
Question 31. What Is Retesting & How It Is Different From Data Driven Testing?

Answer :

After execution of the take a look at in terms of locating the disorder that has been already detected and glued. Re-execution of the equal take a look at with exclusive input values to verify the authentic disorder has been efficiently eliminated is referred to as Re-checking out or affirmation Testing.

Retesting is likewise called Data Driven Testing, however the difference between each is,

Retesting:- It is a manual checking out technique whereas utility testing completed with entire new set of information.

DataDriven Testing(DDT):-It is an Automation trying out technique in which software might be examined with a couple of take a look at records.It is simple and smooth than retesting wherein tester just take a seat in the front of machine and enter one of a kind new input valuesmanually from front-quit interface, it's miles genuinely dull approach.

Question 32. Is A “a Fast Database Retrieval Rate” A Testable Requirement?

Answer :

No. I don’t suppose so due to the fact the requirement seems to be doubtful. The SRS should truely show the performance or transaction necessities, i.E. It have to point out like; “Database retrieval rate of five microseconds”.

Question 33. In Database Testing, How To Do The Data Load Testing?

Answer :

For data load checking out:

You want to have information approximately source database (statistics tables, columns, associated constraints, data kinds) and vacation spot database (facts tables, columns, records kinds, and constraints).
You need to test the compatibility between supply database and destination database thru the DTS bundle.
You want to Open corresponding DTS bundle in SQL Enterprise Manager and run the DTS bundle (If you are using SQL Server).
Then you need to evaluate the column’s records of Source and the Target.
You have to check the number to rows of Source and Target.
After updating data in the Source database, you want to check whether the modifications have been meditated on destination database or no longer.
You want to test about junk individual and NULLs.
Database load testing, take a look at the quantity of the database server to procedure the queries, and additionally take a look at the reaction time of database server and client.
UI Developer Interview Questions