Technology Questions

- Web browser functions are to provide the resources or information to the user when asked by them. 

- It processes the user inputs in the form of URL like https://www.google.com in the browser and allows the access to that page. 

- URL is used to identify the resources and fetch them from the server and displays it to the client. 

- It allows the user to interact with the web pages and dynamic content like surveys, forms, etc. 

- It also allows the user to navigate through the complete web page and see its source code in the HTML format. 

- It provides security to the data and the resources that are available on the web that is by using the secure methods.

Advantages of 3G:

- Overcrowding is relieved in existing systems with radio spectrum
- Bandwidth, security and reliability are more
- Provides interoperability among service providers
- Availability of fixed and variable rates
- Support to devices with backward compatibility with existing networks
- Always online devices – 3G uses IP connectivity which is packet based
- Rich multi media services are available

Disadvantages of 3G:

- The cost of cellular infrastructure , upgrading base stations is very high
- Needs different handsets.
- Roaming and data/voice work together has not yet been implemented
- Power consumption is high
- Requires closer base stations and are expensive
- Spectrum-license costs, network deployment costs and handset subsidies subscribers are tremendous.

IUnknown as an interface of a COM object. Every COM object has to support IUnknown, besides optionally adding other interfaces.

IUnknown is made of QueryInterface, AddRef and Release.

Bitmap indexes make use of bit arrays (bitmaps) to answer queries by performing bitwise logical operations.

Bitmap indexes are useful in the data warehousing applications.

Bitmap indexes have a significant space and performance advantage over other structures for such data.

Tables that have less number of insert or update operations can be good candidates.

The advantages of Bitmap indexes are:

   - They have a highly compressed structure, making them fast to read.

   - Their structure makes it possible for the system to combine multiple indexes together so that they can      access the underlying table faster.

The Disadvantage of Bitmap indexes is:

  - The overhead on maintaining them is enormous. 

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.

A Thread is a block of code that can be executed in parallel with another block of code.

Catalog views return information that is used by the SQL Server Database Engine. Catalog Views are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user- available catalog metadata is exposed through catalog views.