Technology Questions

The flow chart gives a clear graphical representation of an implemented process. This makes the system simple to understand for all persons involved in the project. 

By default, primary key creates a clustered index on the column, whereas a unique key creates a non clustered index by default.

Amazon SQS is a message passing mechanism that is used for communication between different connectors that are connected with each other. It also acts as a communicator between various components of Amazon. It keeps all the different functional components together. This functionality helps different components to be loosely coupled, and provide an architecture that is more failure resilient system.

-  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.

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.

boolean isDirectory();

-The shift() method is similar as the pop() method but the difference is that Shift method works at the beginning of the array. 

-The shift() method take the first element off of the given array and returns it. The array on which is called is then altered.

For example

var myarray = ["apple ", "banana ", "mango "]; 

console.log(myarray.shift());

console.log(myarray);

we get the following console output:

apple

["banana ", "mango "];

When we call shift() on an empty array, it will return an undefined value.