Database interview Questions for Testers

Database Sql interview questions for Testers
Q.How do you select all records from the table?
Select * from table_name;
Q.What is a join?
Join is a process of retrieve pieces of data from different sets (tables) and returns them to the user or program as one “joined” collection of data.
Q.How do you add record to a table?
A. INSERT into table_name VALUES (‘ALEX’, 33 , ‘M’);
Q.How do you add a column to a table?
ALTER TABLE Department ADD (AGE, NUMBER);
Q.How do you change value of the field?
A. UPDATE EMP_table set number = 200 where item_munber = ‘CD’;
update name_table set status = 'enable' where phone = '4161112222';
update SERVICE_table set REQUEST_DATE = to_date ('2006-03-04 09:29', 'yyyy-mm-dd hh24:MM') where phone = '4161112222';
Q.What does COMMIT do?
A. Saving all changes made by DML statements
Q. What is a primary key?
A. The column (columns) that has completely unique data throughout the table is known as the primary key field.
Q. What are foreign keys?
A. Foreign key field is a field that links one table to another table’s primary or foreign key.
Q. What is the main role of a primary key in a table?
A. The main role of a primary key in a data table is to maintain the internal integrity of a data table.
Q. Can a table have more than one foreign key defined?
A table can have any number of foreign keys defined. It can have only one primary key defined.
Q. List all the possible values that can be stored in a BOOLEAN data field.
There are only two values that can be stored in a BOOLEAN data field: -1(true) and 0(false).
Q. What is the highest value that can be stored in a BYTE data field?A. The highest value that can be stored in a BYTE field is 255. or from -128 to 127. Byte is a set of Bits that represent a single character. Usually there are 8 Bits in a Byte, sometimes more, depending on how the measurement is being made. Each Char requires one byte of memory and can have a value from 0 to 255 (or 0 to 11111111 in binary).
Q. Describe how NULLs work in SQL?
The NULL is how SQL handles missing values. Arithmetic operation with NULL in SQL will return a NULL.
Q. What is Normalization?
A. The process of table design is called normalization.
Q. What is Trigger?
A. Trigger will execute a block of procedural code against the database when a table event occurs. A2. A trigger defines a set of actions that are performed in response to an insert, update, or delete operation on a specified table. When such an SQL operation is executed, in this case the trigger has been activated.
Q. Can one select a random collection of rows from a table?
Yes. Using SAMPLE clause. Example:
SELECT * FROM EMPLOYEES SAMPLE(10);
10% of rows selected randomly will be returned.
Q. You issue the following query:
SELECT FirstName FROM StaffListWHERE FirstName LIKE '_A%‘
Which names would be returned by this query? Choose all that apply.
Allen
CLARK
JACKSON
David
Q. Write a SQL SELECT query that only returns each city only once from Students table? Do you need to order this list with an ORDER BY clause?A. SELECT DISTINCT City FROM Students;
Q. What is DML and DDL?
DML and DDL are subsets of SQL. DML stands for Data Manipulation Language and DDL – Data Definition Language.
DML consist of INSERT, UPDATE and DELETE
DDL commands
CREATE TABLE, ALTER TABLE, DROP TABLE, RENAME TABLE, CREATE INDEX, ALTER INDEX, DROP INDEX.
CREATE/ALTER/DROP VIEW
Q. Write SQL SELECT query that returns the first and last name of each instructor, the Salary, and gives each of them a number.
A. SELECT FirstName, LastName, Salary, ROWNUM FROM Instructors;
Q. Is the WHERE clause must appear always before the GROUP BY clause in SQL SELECT ?
A. Yes. The proper order for SQL SELECT clauses is: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY. Only the SELECT and FROM clause are mandatory.
Q. Which of the following statements are Data Manipulation Language commands?
INSERT
UPDATE
GRANT
TRUNCATE
CREATE
Ans. A and B. The INSERT and UPDATE statements are Data Manipulation Language (DML) commands. GRANT is a Data Control Language (DCL) command. TRUNCATE and CREATE are Data Definition Language (DDL) commands
Question: Describe SQL comments.
A. SQL comments are introduced by two consecutive hyphens (--) and ended by the end of the line.
Q. Difference between TRUNCATE, DELETE and DROP commands?
A. The DELETE command is used to remove 'some or all rows from a table.
TRUNCATE removes ALL rows from a table. The operation cannot be rolled back
The DROP command removes a table from the database. All the tables' rows, indexes and privileges will also be removed.

Testing Interview Question Part -2

Testing Interview Question Part -2
111.Difference between bug,error and defect?
112.Explain about MicroSoft Six Rules Standard for User Interface testing?
113.Explain about use case document ?
114.Explain me the phases of STLC and explain each one briefly?
115.Give exact and appropriate definition of testing?
116.How many modes of recording are there ?
117.How to add objects to the Object Rpository?
118.How to arrive Testcase? and How to write Testcase in Email id? when we go for winrunner and why we go for?
119.How to carry out manual testing for a background process which does't have any user interface ?
120.How to do regression testing, and can give one or two examples on that in the same application?
121.How to test the Microsoft Word 2003? What all the major areas to be tested, please explain?
122.How to write a testcase and bugreport?plz expln with an example?
123.How will you review the test case and How many types are there ?
124.Share a particular project where you have been able to learn enough skills to help with testing?
125.The role of both QA & QC?
126.What are GET TO , SETTO,and GET RO properties in QTP?
127.What are the difference between per text mode and shared mode in qtp ?
128.What are the objectives of Lowlevel recording? What is Elapsed Time? When we use Update mode?
129.What are the objectives of Utility objects?
130.What are the objectives of debugging?
131.What are the processes followed in your company for automation?
132.What do you mean by Pilot Testing?
133.What is AUT?
134.What is BUG Life cycle?
135.What is Black Box Testing?
136.What is FSO can you explain?
137.What is Review?
138.What is SRS and BRS document?Can you explain them briefly?
139.What is SRS and BRS in manual testing?
140.What is STLC How many phases are there can you explain them?
141.What is Sanity Test, Adhoc Testing & Smoke Testing? When will use the Above Tests?
142.What is V model can u explain ?
143.What is V model in manual testing ?
144.What is a frame work at what situations we will use?
145.What is a test plan who will prepare that one?
146.What is alpha tesging and beta testing ?
147.What is application entry and exit criteria?
148.What is compatibility testing?
149.What is debugging?
150.What is determination?
151.What is exact difference between Debugging & Testing?
152.What is fish model can you explain?
153.What is frame work in qtp?
154.What is functional testing,system testing,datadriven testing?
155.What is integration testing?
156.What is mean by gui testing ? What is mean by client/Server? What is meant by web based application ?
157.What is objective of actions in qtp ?
158.What is performance testing?
159.What is port testing?
160.What is prototype model in manual testing?
161.What is regualr expression and when we will use regularexpression in qtp?
162.What is reusable action in qtp?
163.What is stand alone mode running in load runner?
164.What is stress testing?
165.What is stub and driver in manual testing?
166.What is system testing?
167.What is test bed?
168.What is test development?
169.What is test metrics ?
170.What is test strategy who will prepare that one. And what will be there in test strategy?
171.What is the Testcase Life Cycle?
172.What is the definition for test life cycle?
173.What is the difference between constant and parameter in qtp?
174.What is the difference between properties and methods in qtp?
175.What is the difference between smoke testing and sanitary testing ?
176.What is the difference between test scenarios and test strategy?
177.What is the difference between usability testing and GUI?
178.What is the model of spiral binding in manual testing? Can you explain spiral binding?
179.What is unit testing in manual?
180.What is unit testing?
181.What is virtual memory?
182.What is virtual object and at what we will use virtual object in qtp?
183.What is virtual object and when will we use?
184.What is visual source safe?
185.What part of the testing phase is the most important part for testing in the cycle?
186.What type of testing questions will be asked for 2+ yrs exssp people in interview?
187.When we do update mode in qtp?
188.Where do check points store in qtp ?
189.Who are prepared use case?
190.Why do need synchronization in qtp?
191.Why do u use object spy in qtp?
192.can u explain spiral binding model in manual testing developers looking to do= testing?
193.How i can do gui testing,what is its important contant,plz tell me all property of Gui testing?
194.How to wrtie test case with a minimum of 13 columns?
195.supports Java Script? What is extention for test script in Quick Test?
196.what is the Testcase Life Cycle ?
197.what is the differene between scenario and testcase ?
198.whta is open beta testing? ans it done at which end? what is the difference b/w open beta testing and beta testing?
199.why do u save .vbs in library files in qtp winrunner?
200.What is joins and define all the joins?
201.What is Foreign key ?
202.Write an SQL query if u want to select the data from one block which intern reflects another block ?
203.Which command is used to run an interface?
204.How will you see the hidden file ?
205.What is the command used to set the date and timings?
206.Some basic commands like copy, move,delete ?
207.Which command used to the go back to the home directory?
208.Which command used to view the the current directory?
209.Where u maintains the Repositories?
210.What is CVS?
211.Bug Tool used?
212.How will you prepare traceability matrix if there is no Business Doc and Functional Doc?
213.How will you validate the functionality of the Test cases, if there is no business equirement document or user requirement document as such?
214.Testing process followed in your company?
215.what are steps that to be followed to achieve the CMM -IV standards?
216.What is Back End testing?
217.What is Unit Testing?
218.How will u write test cases for an given scenario i.e. main page, login screen, transaction, Report Verification?
219.How will u write traceability matrix?
220.What is CVS and why it is used?
221.What will be specified in the Defect Report…?
222.What is Test summary Repor?
223.What is Test Closure report?
224.Explain Defect life cycle?
225.What will be specified in the Test Case?
226.What are the Testing methodologies that u have followed in your project ?
227.What kind of testing that u have been involved in and explain about it?
228.What is UAT Testing?
229.What is joins and what are the different types of joins in SQL and explain the same?
230.What is Foreign Key in SQL?
231.Bug life cycle?
232.Explain about the Project? And draw the architecture of your project?
233.what are the different types of severity?
234.Defect tracking tools used?
235.what are the responsibilities of an tester?
236.Give some example How will you write the test cases if an scenario involves Login
237.screen?
238.What are the different types of testing followed?
239.What are the different levels of testing used during testing the application?
240.What type of testing will be done in Installation testing or system testing?
241.What is meant by CMMI …what are different types of CMM Level?
242.Explain about the components involved in CMM-4 level?
243.Explain about Performance testing ?
244.What is Traceability matrix and How it is done ?
245.How can you differentiate Severity and Priority based on technical and business point
246.of view.
247.What is the difference between Test life cycle and defect life cycle ?
248.How will u ensure that you have covered all the functionality while writing test
249.cases if there is no functional spec and there is no KT about the application?
250.What is SCORM?
251.What is Sec 508?
252.Have u done any portal testing?
253.DO u have any idea about LMS or LCMS?
254.Have u done any compliance testing
255.Have u done any compatibility testing?
256.What are the critical issues found while testing the projects in your organization?
257.How do you test a flash file?
258.Have u find any difference while testing a flash file and Html file?
259.What types of testing do u aware of?
260.While doing the compatibility testing have u found any critical issues?
261.While doing the compliance testing has u noticed any critical/ abnormal issues?
262.What is the procedure u use while doing the Regression testing in your projects?
263.Is ur testing is conventional or non-conventional?
264.Have u done any other lang’s courses testing? If yes have u faced in any critical situations?
265.What are things to be more concentrated while testing same projects on differentenvironments?
267.What are AICC standards?
268.Test Passes:
269.What is meant by Test Passes? How many passes are required for Integration testing?
270.Automation Framework:
271.What are the driving parameters for automation framework?
272.Relation between Test Cases, Requirements and Defects:
273.How will you trace the relation between test cases, requirements and defects?
274.Testing Cycle and Testing Process:
275.Explain what is testing cycle and testing process and what are stages involved in each?

Protocol Testing Interview Questions

Protocol Testing Interview Questions
1)What is MTP?
2)What is protocol testing. whether u have used any tool in telecom testing.
3)What is the need of CPG message in ISUP protocol?
4)what is the significance of SGM (segmentation) message in ISUP?
5)What is TEMS? a telecom testing tools for GSM and which is the best cdma protocol testing tools ie AGILENT or CAIT or CNT.Whether these have same function.What are the institutes providing these courses.
6) what'll happen if one isup link gone down? to brief this question...isup link is active between two nodes.if one goes down what are all the messages will be transfered to active node(bit wise,MTP wise)?

Testing Interview Questions ,Testing Faqs

Testing Interview Questions ,Testing Faqs
1] Record and playback - drawbacks
Test scripts contains hard-coded values.
This is not a viable cost-effective test automation approach for long term.
2] Difference between Image and Bitmap checkpoint
Image Checkpoint Checks the whole Image whereas in bitmap checkpoint we can check the selected area of image/page
3] What is the Automation framework you are following?
Keyword driven/Datadriven approach, Functional decomposition.
4] Write one line code - to Get value from Datatable in the script
1)strText = DataTable("ColumnHeading", dtGlobalSheet)
2)strText=datatable("column Name")
5] Write one line code - to Connect to Excel
1)DataTable.Import "FilePath"
2)CreateObject("Excel.Application")
6] Explain Descriptive Programming, why do you go for that?
1)We can run the script without object repository.
2) Based on Properties and prop's Values .
7] How many actions can we write in a Test?
1) "N" no of Actions
8] What do u mean by Compile Module?
Compile Module in Win Runner is Same as library file. Collection of functions.
9] How will you declare a variable to access in multiple actions?
1)Parameters
2)Environment Variables.(User Defined).
10] What are associated files in QTP?
With QTP you can create VBScript library files containing VBScript functions, subroutines, classes, modules, etc., and then associate the files with your test
11] What is the difference between Object Repository and Object SPY?
Object Repository stores objects and gives basic properties and Object SPY gives in detail all the run-time and Test object properties associated with an object and to view the syntax for a selected method.
12] How to handle java tree in QTP?
To handle java tree, we must have Java Addin. After adding java addin we must go to object configuration and do some configurations
13] What are the different test status messages?
Done, Pass, Fail and Warning
14] What is the extension for the test version of Script? .mts
15] What are the types of ordinal identifier?
Index Property, Location Property, Creation Time Property

Project Manager or Technical manager Round Interview Questions for Testing

Project Manager or Technical manager Round Interview Questions for Testing
Questions may be like

1)How would you handle split development between the client, offshore, and us?
2)What tools and processes do you use?
3)Describe your Test Management Process?
4)How do you handle the time difference from a communications perspective?
5)Tell me about your strenghts and weakness?
6)In a Typical Day, what do you do?
7)can you tell me your rating in your current team?
8)If the top management ask's you to write testcases with in 7 days, how do you handle?
9)What points need to be consider while preparation of SRS from BRS ?
10)What difference u see in web testing and clent/server testing ?
11)What u will do if ur reported bug is rejected ?
12)Where can u rate ur self in Manual/Automation/Performance/Database Testing ?
13)When do u feel angry and what u do to control it ?

How can w add requirements to test cases in Quality Centre

Just you can use the option of add requirements.
Two kinds of requirements are available in TD.
1. Parent Requirement
2. Child requirements.

Parent Requirements nothing but title of the requirements, it covers high level functions of the requirements

Child requirement nothing but sub title of requirements, it covers low level functions of the requirements.

Can you map the defects directly to the requirements(Not through the test cases) in the Quality Centre?

In the following methods is most likely to used in this case:
Create your Req.Structure
Create the test case structure and the test cases
Map the test cases to the App.Req
Run and report bugs from your test cases in the test lab module.

The database structure in Quality Centre is mapping test cases to defects, only if you have created the bug from Application. test case may be we can update the mapping by using some code in the bug script module(from the customize project function), as per as i know, it is not possible to map defects directly to an requirements.

What is meant by test lab in Quality Centre

Test lab is a part of Quality Centre where we can execute our test on different cycles creating test tree for each one of them. We need to add test to these test trees from the tests, which are placed under test plan in the project. Internally Quality Centre will refer to this test while running then in the test lab.

How does TestDirector store data and Why should we create an Instance

How does TestDirector store data?

In TD data is stored on the server.

Why should we create an Instance?

Test Instance is used to run the test case in the test lab. It is the test instance that you can run since you can't run the test case in test set.

Is 'Not covered' and 'Not run' status the same in td

Not Covered status means all those requirements for which the test cases are not written whereas Not Run status means all those requirements for which test cases are written but are not run

What does the test grid contain

The test grid displays all the relevant tests related to a project in TD. It contains the some key elements like test grid toolbar with various buttons for commands which are commonly used when creating and modifying the tests, grid filter which displays the filter that is currently applied to a column, description tab which displays a description of the selected test in the test grid and history tab that displays the changes made to a test

How is the Defect ID generated in TestDirector

The Defect ID is automatically generated once the defect is submitted in TD

How to ensure that there is no duplication of bugs in TestDirector

In the defect tracking window of TD there is a “find similar defect” icon. When this icon is clicked after writing the defect, if anybody else has entered the same defect then it points it out.

Can a script in TD be created before recording script in Winrunner or QTP

Any automation script can be created directly in TD. You need to open the tool (Winrunner or QTP) and then connect to TD by specifying the url, project, domain, userid and password. And then you just record the script like you always do. When you save the script, you can save it in TD instead of your local system.

Is it possible to create custom defect template in TestDirector

It is not possible to create ones own template for defect reporting in TestDirector but one can customize the template that is already available in TestDirector as required.

How can one map a single defect to more than one test script

Using the 'associate defect' option in TestDirector one can map the same defect to a number of test cases.

What are the different types of reports in TestDirector

In TD reports are available for requirements, test cases, test execution, defects, etc. The reports give various details like summary, progress, coverage, etc. Reports can be generated from each TestDirector module using the default settings or it can be customized. When customizing a report, filters and sort conditions can be applied and the required layout of the fields in the report can be specified. Sub-reports can also be added to the main report. The settings of the reports can be saved as favorite views and reloaded as required.

What is the instance of the test case inside the Test Set

Test set is a place containing sets of test cases. We can store many test cases inside test set. Now instance of test case is the test case which you have imported in the test tab. If an another test case has the same steps as this test case till half way then you can create the instance of this test case.

Are TestDirector and QC one and the same

Yes TestDirector and Quality Center are same. Version of TD 8.2 onwards was known as Quality Center. The latest version of Quality Center is 9.2. QC is much more advanced when compared to TD.

What is the difference between TD and Bugzilla

TestDirector is a test management tool. In TD one can write manual and automated test cases, add requirements, map requirements to the test cases and log defects. Bugzilla is used only for logging and tracking the defects.