Why Database Testing is necessary?

The database persists data that your application (and organization) depends on. The data thus persisted is most often of mission-critical nature and a key asset for the organization. Also, many of today's data-enabled applications implement a fair amount of their functionality and business logic in the database itself. For an enterprise class application, the data in the database would be accessed and updated (insert/modify/delete) simultaneously by a large number of users (think thousands to millions depending on the scale of your application's usage). 

The above statements highlight a few areas where database testing is needed. One, to validate the quality of data being persisted. Two, if we plan to test the application code, it is imperative that we also test the code in the database which implements the business functionality and three, we should plan for non-functional database testing to support the usage of the database in a real-world deployment scenario.

Let us briefly look at the above mentioned database test areas.

1. Data quality testing

Testing the quality of the data may be approached in three ways - data validity testing, data integrity testing and data format testing.

a) Data validity testing - is done to verify the validity of the data that is stored in the database. When data is entered via the front end application, check if the data is correctly updated in the back-end database. Apart from the positive checks, look for other behavior such as data truncation, verify how null/empty field values are handled, verify how special characters or code snippets are handled in the database. Check that the right columns in the right tables are being updated. Data validity testing normally involves use of SQL queries to validate the data.

QTP Certification Sample Questions?

1) ‘Browser navigation timeout’ is in which tab of Test Settings (File->Settings) window.
A) Properties
B) Resources
C) Web
D) Web Settings
2) How many tabs are there in Test Settings (File->Settings) window
A) 7
B) 6
C) 5
D) 8
3) Identify the tabs in the Test Settings (File->Settings) window
A) Properties, Run, Resources, Parameters, Environment, Web, Recovery
B) Properties, Run, Resources, Parameters, Environment, Web Settings,Recovery
C) Properties, Run Options, Resources, Parameters, Environment, Web, Recovery
D) Properties, Run, Resources, Input Parameters, Environment, Web, Recovery
4) ‘Generate Script’ is in which tab of Test Settings (File->Settings) window
A) Properties
B) Web
C) Resources
D) Recovery
5) The following are the four main columns in the Keyword view
A) Item, Operation, Value, Comments
B) Item, Operation, Value, Documentation
C) Item, Operation, Property, Documentation
D) Number, Operation, Value, Documentation
6) For each object and method in an Expert View statement, a corresponding row exists in the Keyword View.
A) True
B) False
C) There is a problem with the statement.
D) None of above
7) You can work on one or several function libraries at the same time.
A) True
B) False
8) You can insert additional steps on the test objects captured in the Active screen after the recording session.
A) True
B) False
9) The Active Screen enables you to parameterize object values and insert checkpoints
A) True
B) False
10) A QTP user can increase or decrease the active screen information saved with the test.
A) True
B) False
11) The Information pane provides a list of…………. in the test:
A) Semantic errors
B) Syntax errors
C) Common errors
D) Logic errors
12) When we switch from Expert view to the Keyword view, QTP automatically checks for syntax errors in the test and shows them in the information pane.
A) True
B) False
13) If the information pane is not open, QTP automatically opens it in case a syntax error is detected.
A) True
B) False
14) ………………… provides a list of the resources that are specified in your test but cannot be found.
A) Missing pane
B) Missing Resources pane
C) Resources pane
D) Missing Items pane
15) Whenever you open a test or a function library, QTP automatically checks for the availiblity of specified resources.
A) True
B) False
16) The Data Table does not assists you in parameterizing your test.
A) True
B) False
17) Tabs in the Debug Viewer pane are:
A) Watch, Variables, Debug
B) Watch, Data, Command
C) Watch, Variables, Command
D) View, Variables, Command
18) …………… tab enables you to view the current value of any variable or VBScript expression.
A) Watch
B) VIew
C) Locate
D) Current
19) The …. tab displays the current value of all variables that have been recognized up to the last step performed in the run session.
A) View
B)Variables
C) Locate
D) Current
20) The ………tab enables you to run a line of script to set or modify the current value of a variable or VBScript object in your test or function library.
A) View
B) Variables
C) Command
D) Current
21) Panes in QTP can have one of the following states—docked or floating.
A) True
B) False
22) Which of the following statement is True:
A) QuickTest enables you to open and work on one test at a time
B) QuickTest enables you to open and work on two tests at a time
C) QuickTest enables you to open and work on predefined number of tests at a time
D) QuickTest enables you to open and work on nine test at a time
23) Which of the following statement is True:
A) You can open and work on two function libraries simultaneously
B) You can open and work on multiple function libraries simultaneously
C) You can open and work on nine function libraries simultaneously
D) You can open and work on one function library at a time
24) You can open any function library, regardless of whether it is associated with the currently open test.
A) True
B) False
25) You can work with multiple documents (test, component, or application area, function libraries) using the…… dialog box
A) Panes
B) Display
C) Show
D) Windows
26) QuickTest has ….. built-in toolbars.
A) 5
B) 6
C) 7
D) 8
27) The ……… toolbar contains buttons for recording and running your test.
A) Standard
B) Tools
C) Automation
D) Edit
28) Shortcut Key for opening a new Function Library is:
A) Shift+Alt+N
B) Ctrl+Alt+N
C) Shift+N
D) CRTL+N
29) Shortcut Key for Closing all open Function Libraries in one go.
A) Ctrl+Alt+C
B) Shift+A+C
B)Shift+N
D) None of these
30) shortcut Key for Commenting out the current row, or selected rows
A) Shift+M
B) Ctrl+C
C) Ctrl+M
D) Shift+C
31) You can manage the test actions and the test or function library steps using the … menu commands
A) File
B) Edit
C) Automation
D) Tools
32) To expand all the steps in the keyword view which option you would use from the View menu.
A) Expand
B) Expand All
C) Expand Items
D) Expand Rows
33) What is the shortcut key to open a Step Generator.
A) F2
B) F5
C) F6
D) F7
34) Function Definition Generator in found in which menu option.
A) File
B) Tools
C) Insert
D) View
35) The shortcut keys for Record, Stop and Run respectively are
A) F3, F4, F5
B) F4, F3, F5
C) F4, F5, F3
D) F3, F5, F4
36) What is the shortcut key for opening an Object Repository.
A) Alt+R
B) Shift+R
C) Ctrl+R
D) Shift+O+R
37) Shortcut key to Insert/Remove a breakpoint is
A) F9
B) F8
C) Ctrl+b
D) Shift+b
38) ………runs only the current line of the script. If the current line calls a method, the method is displayed in the view but is not performed.
A) Step Over
B) Step Out
C) Step Into
D) Step Till
39) ………runs only the current line of the script. When the current line calls a method, the method is performed in its entirety, but is not displayed in the view.
A) Step Over
B) Step Out
C) Step Into
D) Step Till
40) What is the shortcut key to Clear all Breakpoints
A) Ctrl+Shift+F9
B) Shift+Ctrl+F9
C) Alt+Shift+F9
D) Alt+Ctrl+F9
41) Object Spy can be found in ……..menu.
A) Tool
B) Tools
C) Task
D) Tasks
42) ………… displays the open documents side-by-side.
A) Tile Vertically
B) Tile Horizontally
C) Cascade
D) Tile Cascade
43) For opening the QuickTest Professional Help we can use…….
A) F3
B) F5
C) F1
D) F2
44) If QTP cannot find any object that matches the description, or if it finds more than one object that matches, QuickTest may use the…………mechanism to identify the object.
A) Ordinal Identifier
B) Index Identifier
C) Smart Identification
D) Assistive Identification
45) You can configure the …….., ………… and …………
properties that QuickTest uses to record descriptions of the objects in your application
A) mandatory, assistive, and ordinal identifier
B) mandatory, required, and ordinal identifier
C) smart, assistive, and ordinal identifier
D) Index, assistive, and ordinal identifier
46) The ………. property set for each test object is created and maintained by QuickTest.
A) Run-Time Object
B) Test Object
C) Smart Identification Object
D) Assistive Object
47)You can access and perform ……… methods using the Object property.
A) Run-Time Object
B) Test Object
C) Smart Identification Object
D) Assistive Object
48) You can view or modify the test object property values that are stored with your test in the ………
A) Information Pane
B) Data Table
C) Information Pane & Data Table Both
D) Object Properties & Object Repository dialog box.
49) You can retrieve or modify property values of the test object during the run session by adding ……….statements in the Keyword View or Expert View.
A) GetROProperty & SetROProperty
B) GetTOProperty & SetTOProperty
C) GetTOProperty & SetROProperty
D) GetROProperty & SetTOProperty
50) If the available test object methods or properties for an object do not provide the functionality you need, you can access …………..of any run-time object using the Object property.
A) The internal methods and properties
B) The mandatory methods and properties
C) The selective methods and properties
D) The assistive methods and properties

What is Scrum and what is the relationship between Scrum and Agile?

Scrum is an iterative and incremental Agile development methodology. Scrum may be viewed as an agile framework for developing software. Unlike many other software development methodologies, scrum does not provide a complete template or detailed description of what to do during software development. Scrum prescribes desired outcomes and leaves it to the agile scrum team to best determine how to solve the problems they encounter. Scrum may be used for both software development and software maintenance projects.

The term "scrum" is borrowed from an analogy put forth in a 1986 study by Takeuchi and Nonaka wherein they described a new holistic approach that would increase speed and flexibility in new product development. In that study, Takeuchi and Nonaka compare high-performing, cross-functional teams to the scrum formation used by rugby teams.

Principles of Scrum

These principles have been borrowed from the Agile Manifesto
 
Scrum values -
  • Individuals and interactions over processes and tools
  • Completed functionality over comprehensive documentation
  • Customer collaboration over contract negotiation
  • Responding to change over following a plan

Top Software Testing Myths?

Myth #1: Software can be tested completely
Many books on software testing start with a discussion of the impossibility of testing all the data or paths in non-trivial software, but I’m still surprised by people who ask how long it will take to finish testing, without considering that being “done” is a subjective tradeoff between the risk of bugs and the cost of delaying a software release.
Myth #2: Testers can find all the bugs
Related to the impossibility of testing everything, a tester won’t find all the bugs, and likely won’t even find all the important bugs.
Myth #3: It is the tester’s fault when an important bug is missed or found late
Related to #2, I so often see blame focused on the tester when an important bug escapes or is found late.  I’ve certainly felt it, and I’ve seen root cause analysis done that squarely identifies that the tester should have found the bug, with no consideration that the developer could have avoided the issue.

Context-Free Questions for Testing !


In Jerry Weinberg and Don Gause’s Exploring Requirements, there’s a set of context-free questions to ask about a product or service. The authors call them context-free questions, but to me, many of them are more like context-revealingquestions.
In the Rapid Software Testing class, the participants and the instructors make discoveries courtesy of our exercises and conversations. Here’s a list of questions that come up fairly consistently, or that we try to encourage people to ask. Whether you’re working with something new or re-evaluating your status, you might find these questions helpful to you as you probe the context of the test project, your givens, and your mission.
I leave it as an exercise for the reader to link these questions to specific points in the Heuristic Test Strategy Model and the Satisfice Context Model.

Who is making software testers, dumb and bad?


Not so long ago, I thought there existed a set of testers called, “bad testers”. I hated them. I wanted to punch them on their face and get their face to bleed. I wanted to become a powerful politician and kill them all and escape without being charged for genocide. I wanted to become a superhero and get people to fire them from their jobs. I wanted them to beg for jobs, money and survival. I thought that is the way to get them to open their minds for learning. All this should have shot my blood pressure up while those bad testers remained cool.

Auto-generation of Test Cases from Requirements


While a lot of assay engineers accomplish use of HP Superior Center for assay administration effective, accouterment a cogent bulk of licensing costs, abounding of its appearance are not getting acclimated by them. In this article, we intend to acquaint assay engineers about the conception of assay cases from requirements.
The afterward workflow would be advantageous for creating assay cases application the superior ascendancy requirements.

Cost Of Quality?


In the software industry, superior is something that is accustomed abundant accent and so a ample bulk of time and money spent on testing activities. These investments fabricated in the tests alleged COQ amount of superior or in short, allowance to advance superior of the artefact beneath investigation.

Traceability ?


Traceability is an important abode in SDLC. A activity starts with the business abstraction is getting developed, and again put them calm to actualize what we apperceive as requirements. It is with the requirements use cases are developed, business rules are, etc. As we advance through the SDLC, the branches of the altitude out in the modules .

What do U mean by Perl?


PERL = Applied Extraction and Address
Perl programming accent is a able and adaptable. It was developed by Larry Wall, who formed as a systems ambassador for NASA in backward 1980 as a way to accomplish address processing easier. He has back confused to a ample amount of functions: the automation of arrangement administration, which acts as a cement amid altered computer systems, and of course, getting one of the a lot of accepted languages for CGI programming on the Web.

What do U mean by AJAX?


AJAX (Asynchronous JavaScript and XML) is a abstruse accumulation of commutual web development acclimated to actualize alternate Web applications and affluent Internet applications. With Ajax, web applications can retrieve abstracts from the server asynchronously in the accomplishments after interfering with the affectation and behavior of the absolute page. Abstracts is retrieved application the XMLHttpRequest 

What is Test Management ?


There is a website area you charge to use user ID and countersign into the login page on the site. How can you prove this page? A bulk of scenarios beam through his mind. I'll try to enumerate some of them:
Type "correct" user ID and "correct" countersign - the hit Login button
Type "wrong" user ID and "correct" countersign - hit affair
Type "correct" user ID and "incorrect" countersign - hit session
Validate for access restrictions in the acreage of user identification
Validate for access restrictions of the countersign acreage
So on and so forth.