Interview Questions

In a database table, the category of information is called Field.

Oracle Web Cache is a secure reverse proxy cache and a compression engine deployed between Browser and HTTP server, Browser and Content Management server to improve the performance of web sites by caching frequently accessed content. Oracle Web Cache supports:

- Static content caching

- Dynamic content caching

- Partial Page catching

- Request Filtering.

DB2 acts as the participant and CICS acts as a co-ordinator

- By using method overriding a sub class can change the definition of super class method.

- By using overriding a sub class can modify the functionality of the super class.

DNS servers often must communicate with DNS servers outside of the local network. A forwarder is an entry that is used when a DNS server receives DNS queries that it cannot resolve locally. It then forwards those requests to external DNS servers for resolution.

A payroll journal is like a payroll register. It has salary, bonuses, commission in other words earnings, any deductions such as 401k, fsa etc, state and income taxes etc.
It shows the gross salary less any deductions "Net pay" for the period.

The differences between HTML and HTML5 are:

- Document of HTML is very large as compare to the HTML5.

- Audio and Video tags are not present in HTML whereas HTML5 contains audio and video tags.

- Vector technology is not integral part of HTML whereas HTML5 Vector technology is the integral part of it.

- HTML supported by all old browsers whereas HTML5 is supported by new browser.

- In HTML web sockets are not available whereas in HTML5 Full duplex communication channel is present.

A stored procedure is a segment of declarative SQL statements stored inside the database catalog. A stored procedure can be invoked by triggers, other stored procedures or applications such as Java, C#, PHP, etc.

Advantages 

- Typically stored procedures help increase the performance of the applications. Once created, stored procedures are compiled and stored in the database. However MySQL implements the stored procedures slightly different. MySQL stored procedures are compiled on demand. After compiling a stored procedure, MySQL puts it to a cache. And MySQL maintains its own stored procedure cache for every single connection. If an application uses a stored procedure multiple times in a single connection, the compiled version is used, otherwise the stored procedure works like a query.

- Stored procedures helps reduce the traffic between application and database server because instead of sending multiple lengthy SQL statements, the application has to send only name and parameters of the stored procedure.

- Stored procedures are reusable and transparent to any applications. Stored procedures expose the database interface to all applications so that developers don’t have to develop functions that are already supported in stored procedures.

- Stored procedures are secure. Database administrator can grant appropriate permissions to applications that access stored procedures in the database without giving any permission on the underlying database tables.

Disadvantages

- If you use a lot of stored procedures, the memory usage of every connection that is using those stored procedures will increase substantially. In addition, if you overuse a large number of logical operations inside store procedures, the CPU usage will also increase because database server is not well-designed for logical operations.

- A constructs of stored procedures make it more difficult to develop stored procedures that have complicated business logic.

- It is difficult to debug stored procedures. Only few database management systems allow you to debug stored procedures. Unfortunately, MySQL does not provide facilities for debugging stored procedures.

-It is not easy to develop and maintain stored procedures. Developing and maintaining stored procedures are often required specialized skill set that not all application developers possess. This may lead to problems in both application development and maintenance phases.