Interview Questions

strstr() returns part of a given string from the first occurrence of a given substring to the end of the string.
For example:
strstr("user@example.com","@") will return "@example.com".

stristr() is idential to strstr() except that it is case insensitive.

- %FOUND

 This is a Boolean variable which evaluates to TRUE if the last row is successfully fetched.

- %NOTFOUND

 This is a Boolean variable which evaluates to TRUE if the last row is not successfully fetched. This means there are no more rows to fetch.

- %ROWCOUNT

 Returns the number of rows fetched by the cursor.

- %ISOPEN

If the cursor is open, it evaluates to TRUE else FALSE.

The Singleton design pattern ensures a class only has one instance, and provides a global point of access to it. The class keeps track of its sole instance and ensures that no other instance can be created. Singleton classes are appropriate for situations where it makes sense for a single object to provide access to a global resource.Several Cocoa framework classes are singletons. They includeNSFileManager, NSWorkspace, NSApplication, and, in UIKit,UIApplication. A process is limited to one instance of these classes. When a client asks the class for an instance, it gets a shared instance, which is lazily created upon the first request.

There are lots of ways to solve the issue of callback hells:

1. Modularization: break callbacks into independent functions
2. Use a control flow library, like async
3. Use generators with Promises
4. Use async/await (note that it is only available in the latest v7 release and not in the LTS version)

It refers to the possibility for an investor to experience  losses due to  factors that affect the overall performance of the financial markets. Market risk cannot be eliminated through diversification, though it can be hedged against. The sources of market risk include natural disasters, recessions, political turmoil, changes in interest rates and terrorist attacks.

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.

I like new challenges and fortunate to develop. As long as I keep doing these, I don’t think I’ll need to alter. I’d like to consider that this relationship lasts for many years. However, I haven’t set a period of time limit as such.

Profitability control is a mechanism of monitoring the sales made, profits earned and expenditure incurred by a company. The relative profit earning capacity of a firm’s products and consumer groups can be determined via profitability control. Sometimes surpisingly, it may be found out by companies how a small proportion of their products and even customers actually account for a significant percentage of the company’s profits. This can be achieved through profitability control. At times when the companies earn surplus profits, then such profits may even be ploughed back or reinvested. This also forms part of profitability control.