Interview Questions

- Sub Query also termed as Nested Query or Inner Query is used to get data from multiple tables.
- A sub query is added in the where clause of the main query.

There can be two types of subqueries:
a.) Correlated sub query :
- It can reference column in a table listed in the from list of the outer query but is not as independent as a query.
b.) Non-Correlated sub query :
- Results of this sub query are submitted to the main query or parent query.
- It is independent like a query

Pass By Reference means the passing the address itself rather than passing the value. Passby Value means passing a copy of the value to be passed.

- Yes, HTML 5 can get the location of a user with the use of Geolocation API.

- Use getCurrentPosition() method to get the user’s current position.

Silverlight 1 is purely AJAX and JavaScript based. All the code has to be written in JavaScript and XAML. 

 Silverlight 2 supports managed code. When the Silverlight 2 runtime is installed, it installs a limited version of the .NET runtime on the client machine

Dispatcher recieves the request from client and assigns the request to one of the work process.
Roll area: Each workprocess works in a particular memory that memory is known as Role Area, which consists of User context and session data.
ABAP- Processor :is an interpretor which can execute logic

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.

Most financial investments are examples of Human risk type of risks. Since, we humans invest in any kind of financial investments on our own risk expecting profits.