Technology Questions

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.

By providing callback function. Callback function gets called whenever corresponding event triggered.

Named PL/SQL blocks of code which can be invoked using parameters are called PL/SQL sub programs.

Advantages of PL/SQL subprograms are

- The application makes a single call to the database to run a block of statements which improves performance against running SQL multiple times. This will reduce the number of calls between the database and the application.

- PL/SQL is secure since the code resides inside the database thus hiding internal database details from the application. The application will only make a call to the PL/SQL sub program

- PL/SQL and SQL go hand in hand so there would be no need of any translation required between PL/SQL and SQL.

In SQL, a SQL view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table.

SQL views can be used to hide rows and columns and complicated SQL syntax.

The fields in a view are fields from one or more real tables in the database.

A poor Hashcode() function will result in frequent collision in HashMap which eventually increase time for adding an object into Hash Map.

C++ allows us to parameterize directly three kinds of entities through templates: types, constants, and templates.

We can apply at max of 12 triggers in a table.

The hypervisor is a virtual machine monitor (VMM) that manages resources for virtual machines. The name hypervisor is suggested as it is a supervisory tool for the virtual machines. There are mainly two types of hypervisors :

- Type-1: the guest Vm runs directly over the host hardware, e.g Xen, Hyper-V, VmWare ESXi

- Type-2: the guest Vm runs over hardware through a host OS, e.g Kvm, Oracle virtualbox