10 Feb, 2007
- How do you read transaction logs?
- How do you reset or reseed the IDENTITY column?
- How do you persist objects, permissions in tempdb?
- How do you simulate a deadlock for testing purposes?
- How do you rename an SQL Server computer?
- How do you run jobs from T-SQL?
- How do you restore single tables from backup in SQL Server 7.0/2000? In SQL Server 6.5?
- Where to get the latest MDAC from?
- I forgot/lost the sa password. What do I do?
- I have only the .mdf file backup and no SQL Server database backups. Can I get my database back into SQL Server?
10 Feb, 2007
- Compare and contrast SQL Server with MySQL.
- Compare and contrast stored procedures and dynamic SQL.
- Describe a standard 3-tier architecture and the interfaces between each tier.
- Compare and contrast a rich client and browser-based web application
- Compare and contrast WS and remoting protocols.
- Design the data structures for the game battleship.
10 Feb, 2007
- What criteria would you use to select Web transactions for load testing?
- Why are virtual users created?
- Why is it recommended to add verification checks to your all your scenarios?
- What’s the scenario, where you would want to parameterize a text verification check?
- Why do you need to parameterize fields in your virtual user script?
- What are the cases why parameterization is necessary when load testing the Web server and the database server?
- How can data caching have a negative effect on load testing results?
10 Feb, 2007
- Describe the process of planning a test in WinRunner?
- How do you record a new script? Can you e-mail a WinRunner script? How can a person run a previously saved WinRunner script?
- How can you synchronize WinRunner scripts?
- What is a GUI map? How does it work?
- How can you verify application behavior?
- Explain in detail how WinRunner checkpoints work. What are standard checkpoints?
- What is a data-driven test? What are the benefits of a data-driven test?
- How do you modify logical names on GUI map?
10 Feb, 2007
- Define load, performance and stress testing?
- What are the goals of a performance testing of a web application?
- State a generalized process for load test? Or explain how you did it previously.
- How do you determine user soad for a perf test of a Web application?
- What do you understand by the terms ‘Response Time’, ‘Pages Per Second’, ‘Transactions Per Secpnd’?
- How would you determine the performance of a web application by looking at the values of ‘Response Time’ and ‘Pages Per Second’?
- What will be your approach if a particular script in Load Test fails?
