Interview Questions

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

Office salaries expense would not come under a selling expense.

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

Employees who do not complete their required payroll forms make the payroll administrator's job more challenging. Asking this question allows the applicant to explain how she would handle this to ensure the worker still gets paid.

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.

Continuously rendered services are those services, which are prepared and provided only to the customers who are physically present. This kind of service is not finished in instant time; it is a process, which is extended to a time limit. It is a kind of face-to-face interaction. For example reservation service, restaurant service, massage, etc.

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.