Interview Questions.

Q1. In Data Base Testing, What Are The Steps To Test Data Loading?

Following steps want to comply with to check statistics loading

Source statistics must be recognized

Target statistics ought to be known

Compatibility of supply and goal must be checked

In SQL Enterprise manager, run the DTS bundle after commencing the corresponding DTS package deal

You should examine the columns of target and statistics supply

Number of rows of goal and source have to be checked

After updating information inside the supply, test whether the changes seems inside the target or not.

Check NULLs and junk characters

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

DCL stands for Data Control Language, it's far used to manipulate records.

The  styles of DCL Commands are:

Grant: By the usage of this command person can access privilege to database

Revoke: By the usage of this command consumer can't get right of entry to the database

Q3. To Manage And Manipulate The Test Table What Are The Sql Statements That You Have Used In Database Testing?

The statements like SELECT, INSERT, UPDATE, DELETE are used to govern the desk, at the same time as ALTER TABLE, CREATE TABLE and DELETE TABLE are used to manipulate desk.

Q4. In Database Testing, What Do We Need To Check Normally?

Normally, the things that we take a look at in database checking out are:

Constraint Check

Validation of a Field size

Stored process

Matching software discipline length to database

Indexes for overall performance based totally issues

Q5. What Is The Way Of Writing Test Cases For Database Testing?

Writing a testcases is like practical testing. First you have to recognise the useful requirement of the software. Then you need to determine the parameters for writing testcases like

Objective: Write the objective which you would love to test

Input method: Write the technique of movement or enter you want to execute

Expected: the way it need to seem within the database

Q6. In Database Testing, What All Things Are Required For Writing Good Test Cases?

Knowledge of following things is needed before writing the database test instances:

At first, understand the application absolutely and useful requirement of the utility.

Second, take a look at-out different entities which have been used in an application; lower back-give up database tables, joins among the tables, cursors (if any), triggers (if any), stored strategies (if any), enter parameter and output parameters for growing that requirement.

After collecting all necessary data, write down the test case with different input values for examining all the sources.

Writing check instances for lower back give up checking out is contrary to useful trying out, one must use the white container checking out method.

Q7. What Rdbms Stands For And What Are The Important Rdmbs That Sql Use?

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

Q8. Explain What Is Data Driven Test?

In a facts-table, to test the multi numbers of facts, information-driven take a look at is used. By using this it may effortlessly replace the parameters at the identical time from distinct locations.

Q9. What Is Retesting & How It Is Different From Data Driven Testing?

After execution of the check in terms of finding the defect that has been already detected and stuck. Re-execution of the equal check with exclusive input values to verify the unique defect has been efficiently removed is referred to as Re-checking out or affirmation Testing.

Retesting is also referred to as Data Driven Testing, but the difference among both is,

Retesting:- It is a manual trying out system whereas application trying out performed with whole new set of information.

DataDriven Testing(DDT):-It is an Automation trying out process in which application could be examined with more than one check data.It is straightforward and smooth than retesting in which tester simply sit in front of device and input specific new input valuesmanually from the front-stop interface, it's miles virtually uninteresting method.

Q10. What Is White Box Testing And Black Box Testing?

Black field trying out me trying out the software program for the outputs on giving specific inputs. This trying out is normally finished to peer if the software program meets the user's requirements. There is not any specific purposeful output anticipated for jogging this take a look at.

The white box testing is achieved to test the accuracy of code and good judgment of this system. This trying out is performed through the programmer who knows the logical drift of the device.

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

For records load testing:

You need to have understanding approximately supply database (statistics tables, columns, related constraints, information types) and vacation spot database (information tables, columns, statistics sorts, and constraints).

You want to check the compatibility among supply database and vacation spot database thru the DTS package deal.

You want to Open corresponding DTS bundle in SQL Enterprise Manager and run the DTS package (If you are the usage of SQL Server).

Then you need to examine the column’s information of Source and the Target.

You have to test the wide variety to rows of Source and Target.

After updating records within the Source database, you need to check whether the adjustments had been meditated on vacation spot database or not.

You need to test approximately junk individual and NULLs.

Database load checking out, check the volume of the database server to method the queries, and also take a look at the reaction time of database server and purchaser.

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

On querying the not unusual audit log you'll recognise, whether or not, a cause is fired or no longer. It is in audit log where you can see the triggers fired.

Q13. What Is Performance Testing And The Bottlenecks Of It?

Performance testing is a software program trying out method to determine that how a system performance in terms of pace, sensitivity and balance beneath a heavy workload.

The overall performance testing calls for luxurious equipment and well-trained and skilled testers for operation.

Q14. What Is Data-base Testing?

Data base testing is segmented into four specific categories.

Testing of Data Integrity

Testing of Data Validity

Data base related performance

Testing of functions, process and triggers

Q15. What Is The Meaning Of Record In A Database?

In database, a file is the set of values/fields of a selected entity.

For instance; Office_Employee Record, Book Record and many others.

Q16. What Is Load Testing And Give Some Examples Of It?

To degree the system response, load testing is accomplished. If the weight exceeds the customers pattern it's far known as pressure checking out. Examples of load testing are downloading the set of massive files, executing multiple packages on a single laptop, subjecting a server to large range of e-mails and doling out many responsibilities to a printer one after another.

Q17. While Testing Stored Procedures What Are The Steps Does A Tester Takes?

The tester will take a look at the standard layout of the stored procedures and also it checks the fields are accurate like updates, joins, indexes, deletions as stated inside the saved method.

Q18. How Does Qtp Evaluate Test Results?

Once the testing is finished, QTP will generate a document. This record will show the checkpoints, system message and errors that were detected whilst testing. The take a look at effects window will display any mismatches encountered on the checkpoints.

Q19. What Does The Rdbms Stands For And What Are The Major Rdbms Used By Sql?

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

Q20. What Are Indexes And Mention Different Types Of Indexes?

Indexes are database items and they're created on columns. To fetch information quick they may be often accessed. Different styles of indexes are:

B-Tree index

Bitmap index

Clustered index

Covering index

Non-precise index

Unique index

Q21. How To Write Test Cases From Requirements, Do The Requirements Signify The Exact Functionality Of Aut?

Yes, the requirements must symbolize the exact capability of AUT.

To do so:

First have a look at the requirement to recognize normal capability.

Next, determine which check layout techniques are suitable to jot down test case – Black Box take a look at design strategies like; Equivalence Partitioning, Boundary Value Analysis, Error Guessing and Cause Effect Graphing.

Once you decide which check layout method is suitable, write your check instances in requirement evaluation and layout segment. In this way you may be ensure that all the requirements are testable.

Q22. What Is Ddl And What Are Their Commands?

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

Q23. How You Can Write Testcases From Requirements And Do The Requirements Represents Exact Functionality Of Aut (application Under Test)?

To write a testcases from requirements, you need to analyse the necessities thoroughly in phrases of functionality. Thereafter you consider the ideal testcases layout strategies like Equivalence partitioning, Black box layout, Cause impact graphing and so on. For writing the testcases.Yes, the requirements represent specific capability of AUT.

Q24. How To Test Database Procedures And Triggers?

To take a look at database approaches and triggers, enter and output parameters have to be recognised. EXEC statement may be used to run the process and observe the behaviour of the tables.

Open the database venture in answer explorer

Now in View menu, click on the database schema

Open the undertaking folder from schema View menu

Right click on on the item that needs to be tested, after which click on on the conversation field that asserts Create Unit Tests

After that create a brand new language test mission

Select both a) Insert the unit take a look at or b) Create a new test and then click on OK

Project that needs to be configured can be finished by clicking at the Project Configuration conversation container.

Once it configured click on on OK

Q25. What Is The Test Scenario To Test A Database Migrated From One Sql Server To Another?

First of all, we want to test what all improvements and adjustments came about to the SQL Server where we are making plans emigrate.

Next, design the check case consistent with the subsequent attention:

Data kind that has been used.

Length of the information subject of SQL Server (Server into which we are migrating the records) need to be identical because the SQL Server from where we are taking away the information.

Each and each venture have to be organized efficaciously.

Q26. Explain How To Use Sql Queries In Qtp?

In QTP the use of output database test point and database test, you need to pick the SQL guide queries choice. After choosing the guide queries alternative, enter the "pick" queries to fetch the records within the database and then compare the anticipated and real.

Q27. How To Test Database Manually?

Testing the database manually includes checking the information on the lower back stop and to see whether the addition of facts in front quit is affecting the again end or now not, and identical for delete, replace, insert and so forth.

Q28. Without Using Database Checkpoints, How You Test A Sql Query In Qtp?

By writing scripting method in VBScript, we will hook up with database and can test the queries and database.

Q29. What Are Joins And Mention Different Types Of Joins?

Join is used to display two or greater than two table and the forms of joins are:

Natural Join

Inner Join

Outer Join

Cross Join

The outer join is divided once more in two:

Left outer be part of

Right outer join

Q30. What Is Performance Testing And What Are The Bottlenecks Of Performance Testing?

Performance trying out determines the speed of the laptop device performance. It consists of the quantitative checks like response time measurement. The problem in overall performance trying out is that you always want a well-skilled and experienced guy power also the gear you use are steeply-priced.

Q31. Explain The Qtp Testing Process?

QTP checking out procedure is primarily based 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 exams: Test should be debugged

Run tests: Testcases must be run.

View results: The effects reflects the success or failure of the tests

Report detects: If the check is failed, the motives may be recorded inside the record hit upon file

Q32. What Is Cmmi And Describe Different Levels Of Cmm?

CMMI stands for Capability Maturity Model Integration is a system improvement schooling and assessment version of numerous enterprise procedures in software engineering.

Five CMM Maturity stages for an corporation are:

1) Initial: At this level, companies don’t have any tested approach and environment, so that; usually businesses finances and agenda time pass over.

2) Repeatable: At this stage, businesses have primary strategies and hints to restriction the value and schedule time, succesful in repeating the equal in the subsequent similar task.

Three) Defined: At this level, all techniques are properly organized and defined clear and preferred form.

4) Managed: At this degree, businesses are tons more advanced than Defined degree. Here, strategies are contacted the use of statistical and other quantitive method.

5) Optimizing: Organizations determinedly try and expand overall performance through current technical progress.