Technology Questions

PHP is rapidly gaining the popularity and many companies are switching their current language for this language. PHP is a server side scripting language. PHP executes the instructions on the server itself. Server is a computer where the web site is located. PHP is used to create dynamic pages and provides faster execution of the instructions.

The ServiceInstaller class, also known as the project installer class, is used to install a Windows service.

Node.js is a framework for web applications built on Google Chrome's JavaScript Engine(V8 Engine).

Node.js is comes with runtime environment on which a cript based on javascript can be interpreted and executed (It is analogus to JVM to JAVA byte code). This runtime environment allows to execute a JavaScript code on any machine outside a browser. Because of this runtime of Node.js, JavaScript is now can be executed on server also.

Node.js is provides a rich library of various javascript modules which eases the developement of web application using Node.js to greater extents.

1. Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart. 

2. ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS. 

3. Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.

The main attributes are discussed below:

Maintainability: For each new release need to update the test automation suites.

Reliability: Accuracy and repeatability of the test automation.

Flexibility: Ease of working with all the different kinds of automation test ware. 

Efficiency: Total cost related to the effort needed for the automation.

Portability: Ability of the automated test to run on different environments.

Robustness: Effectiveness of automation on an unstable or rapidly changing system. 

Usability: Extent to which automation can be used by different types of user.

-  A stored procedure can accept parameters while a trigger cannot.
-  A trigger can’t return any value while stored procedures can.
-  A trigger is executed automatically on some event while a stored procedure needs to be explicitly called.
-  Triggers are used for insertions, update and deletions on tables while stored procedures are often using independently in the database.
-  A trigger cannot be written in a stored procedure. However, the reverse is not possible.

boolean isDirectory();