Interview Questions

Goods that are excludable include both private goods and natural monopolies.

There are three types of lock, namely:

Shared – This type of lock permits two or more programs to read from the locked space but does not allow them to change it.

Update – This lock is more lenient. It permits the program to read and change the locked space.

Exclusive – This lock restricts all users from accessing the locked space.

Templates are the rendered view with information from the controller and model. These can be a single file like index.html or multiple views in one page using "partials".

- Rename : It is a permanent name provided to a table or column.
- Alias : It is a temporary name provided to a table or column which gets over after the execution of SQL statement.

The primary purpose of life insurance is to provide financial protection to surviving dependents after the death of an insured.

- If the table structure is changed ( a field is added ), the program will have to be modified.

- Program might retrieve the columns which it might not use, leading on I/O over head.

- The chance of an index only scan is lost.

Data cleaning is also known as data scrubbing. Data cleaning is a process which ensures the set of data is correct and accurate. Data accuracy and consistency, data integration is checked during data cleaning. Data cleaning can be applied for a set of records or multiple sets of data which need to be merged.

Data cleaning is performed by reading all records in a set and verifying their accuracy. Typos and spelling errors are rectified. Mislabeled data if available is labeled and filed. Incomplete or missing entries are completed. Unrecoverable records are purged, for not to take space and inefficient operations.