Technology Questions

One can use simple conditions like >= and <=, or use between/and but the trick here is to know your exact data type.

- Sometimes date fields contain time and that is where the query can go wrong so it is recommended to use some date related functions to remove the time issue. In SQL Server common function for accomplishing the task datediff () function.

- Interviewees also have to be aware of different time zones and server time zone.

-To increase query performance you may still want to use between however you should be aware of proper format you should use if not it might misbehave during filtering.

PHP is similar to the C style syntax in terms of keywords and language syntax.

If conditions, for and while loops, and function returns are similar in syntax to languages such as C, C++, C#, Java and Perl.

All the above listed options are c++ tokens .They  include:

             - keywords

             - Identifiers

             - Constants

             - Strings

             - operators

- Clustering means one than one database server configured for the same user connection. When users connect, one of the server’s responds and connects based on availability. The user is completely ignorant of the fact that there are more than one database servers. It demands high cost due to infrastructure needs. Clustering is hence done on server level.

- Mirroring means, one has many configured databases on the same server. Mirrors are basically copies of the original database. Mirroring is hence done on database level. 

Cloud computing is a metaphor used for internet. It provides on-demand access to virtualized IT resources that can be shared by others or subscribed by you. It provides an easy way to provide configurable resources by taking it from a shared pool. The pool consists of networks, servers, storage, applications and services.

Destructor is a special member function of a class, which is invoked automatically whenever an object goes out of the scope. It has the same name as its class with a tilde character prefixed.

As in the case of not using an exception, it will remain useless in the program and increase the code complexity.

1. Zero infrastructure investment : Cloud architecture provide user to build large scale system with full hardware, machines, routers, backup and other components. So, it reduces the startup cost of the business. 

2. Just-in-time Infrastructure : It is very important to scale the infrastructure as the demand rises. This can be done by taking cloud architecture and developing the application in the cloud with dynamic capacity management. 

3. More efficient resource utilization : Cloud architecture provides users to use their hardware and resource more efficiently and utilize it in a better way. This can be done only by applications request and relinquish resources only when it is needed (on-demand).