Interview Questions

The financial statements should be prepared in the following order:

Income statement - Statement of retained earnings - Balance sheet

1. Income statement reports revenues and expenses and calculates net income or net loss for the time period.

2. Statement of retained earnings show how retained earnings changed during the period due to net income or net loss and dividends.

3. Balance sheet reports assets, liabilities, and stockholders’ equity as of the last day of the period.

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".

Locking is a mechanism to ensure data integrity while allowing maximum concurrent access to data. It is used to implement concurrency control when multiple users access table to manipulate its data at the same time.

Advantages :

- Avoids deadlock conditions

- Avoids clashes in capturing the resources

- 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.

Plug and Play is a technology wherein hardware components that are installed on PCs using Microsoft operating system are immediately recognized and made usable. This means that the drivers necessary to make it work are already available on the operating system package.

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.

A conversion constructor declared with the explicit keyword. The compiler does not use an explicit constructor to implement an implied conversion of types. It’s purpose is reserved explicitly for construction