Technology Questions

Android is a stack of software for mobile devices which has Operating System, middleware and some key applications. The application executes within its own process and its own instance of Dalvik Virtual Machine. Many Virtual Machines run efficiently by a DVM device. DVM executes Java language’s byte code which later transforms into .dex format files.

Features of Android :

- Components can be reused and replaced by the application framework.
- Optimized DVM for mobile devices
- SQLite enables to store the data in a structured manner.
- Supports GSM telephone and Bluetooth, WiFi, 3G and EDGE technologies
- The development is a combination of a device emulator, debugging tools, memory profiling and plug-in for Eclipse IDE.

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.

Following are the data integration factors:

- Sub set of the available data should be optimal. 

- Noise/distortion estimation levels because of sensory/processing conditions at the time of data collection.

- Accuracy, spatial and spectral resolution of data.

- Data formats, storage and retrieval mechanisms.

- Efficiency of computation for integrating data sets to reach the goals.

•  NO_CACHE – It is used for not caching values.


•  PRE_LOAD_CACHE – Result column preloads and compares the column into the memory, prior to executing the lookup.


•  PRE_LOAD_CACHE is used when the table can exactly fit in the memory space.


•  DEMAND_LOAD_CACHE – Result column loads and compares the column into the memory when a function performs the execution.


•  DEMAND_LOAD_CACHE is suitable while looking up the highly repetitive values with small subset of data.

RIP is a is an interior gateway protocol that was often used in interior networks and in some degree in internet networks. It helps the router adapt to the modifications that are made in a network regarding connections. Now it become less used since more efficient protocols were implemented like OSPF or IS-IS. It is limited to a lower number of routers, a maximum of fifteen router.

SELECT DISTINCT(salary) FROM emp as e1 

WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2  WHERE e1.salary <= e2.salary)

A session is a logical object created by the PHP engine to allow you to preserve data across subsequent HTTP requests. Sessions are commonly used to store temporary data to allow multiple PHP pages to offer a complete functional transaction for the same visitor.

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name.

We use them to format the database and segregate specific repetitions of rows and columns in the database.