Technology Questions

SQL statement gets executed when we open cursor

Automated testing cannot replace manual testing because of following reason:

- Automated testing cannot replace the analytical skills required to conduct testing. It can only enhance or supplement manual testing,

- Through manual testing, information can be gathered about the application, and real-time decisions can be made about how to enhance a test that would be too difficult to program into an automated script.

- We need a manual tester to analyze and maintain the automated scripts after they can run.

advantages: view is used to retrieve the data very fastly from the database tables
* memory wastage is reduced
* faster than joins to retrieve the data from database tables

disadvantages:
* view is not a container,it will not hold the data
* view memory is not permanent memory

There are two major platforms that providing hosting and servers to host on. The differences between them are as follows:

- Unix are more efficient in performing offsite and onsite, whereas windows doesn’t provide very good efficiency to work with. 

- Unix provide lower hosting cost for the website using the high bandwidth, whereas windows take more resources and have the cost higher for the storage. 

- Unix is better for the websites that are static and includes HTML and graphics, whereas Windows is used for heavy websites and having more requirements. 

- Unix supports the scripting languages like PHP and databases like MySQL and other related categories, whereas Windows supports IIS, coldfusion and big applications that take more space.

Before form , After form , Before report, Between page, After report.

The common tools that can be used by a business analyst are MS Visio, MS word, MS Excel, Power point, Quality center/test director MS Project. There may be tools that are client specific also, but these will be supplied the client. 

Pass By Reference means the passing the address itself rather than passing the value. Passby Value means passing a copy of the value to be passed.

Dynamic binding is orthogonal to dynamic linking. Binding refers to the linking of a procedure call to the code to be executed in response to the call. Dynamic binding It is associated with polymorphism and inheritance, it(also known as late binding) means that the code associated with a given procedure call is not known until the time of the call at run-time.