Interview Questions

View:

- Tail raid data representation is provided by a view to access data from its table.

- It has logical structure can not occupy space.

- Changes get affected in corresponding tables.

Materialized view

- Pre calculated data persists in materialized view.

- It has physical data space occupation.

- Changes will not get affected in corresponding tables.

MIME - Multi-purpose Internet Mail Extensions. 

MIME types represents a standard way of classifying file types over Internet. 

Web servers and browsers have a list of MIME types, which facilitates files transfer of the same type in the same way, irrespective of operating system they are working in.

A MIME type has two parts: a type and a subtype. They are separated by a slash (/). 

MIME type for Microsoft Word files is application and the subtype is msword, i.e. application/msword.

In a mapreduce job the master pings each worker periodically. In case a worker does not respond to that system then the system is marked as failed. Even completed tasks are rescheduled because the output was stored in a in a local disk of a worker which failed. Hence mapreduce is able to handle large-scale failures easily by simply restarting a task. The master node always saves itself at checkpoints and in case of any failure it simply restarts from that checkpoint.

Credit Management is the process of managing the outstanding receivables of the organistion as per the policies adopted by the organisation. Companies might the approach of categorising the B/R by their ageing and provision for the same would be taken into account while preparing the financial statements for an organisation.

For material/Goods Purchases, the Po is required. In the Po, QTY, Product Name, Where is delivery price, Terms and Conditions. In the po there is no matter of final amount. It is just the approximate amount.

Generating random passwords in PHP can be done in multiple ways depending on how much security the application demands:-

Md5 function can be passed one parameter as uniqid() function which in turn generates a random number. Passing the parameter as TRUE in uniqid() adds additional uniqueness.

<?php
   $passwd = md5(uniqid(rand(), true));
   Echo $passwd;
?>

- Use a COBOL II CALL statement to invoke a subprogram. This method is transparent to CICS, which sees only the one load module. 

- EXEC LINK is similar to a call; it invokes a separate CICS program and ends with a RETURN to the invoking program

- EXEC XCTL which transfers control to another CICS program and does not get control 

back. 

COBOL II allows for static calls which are more efficient than the LINK instruction which establishes a new run-unit. 

Optimized code tends to run faster and make more efficient use of the system’s resources. Optimized codes are also less susceptible to errors and take lesser space in memory and in file size.