Interview Questions

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.

Structure: Initially (in C) a structure was used to bundle different type of data types together to perform a particular functionality. But C++ extended the structure to contain functions also. The major difference is that all declarations inside a structure are by default public.
Class: Class is a successor of Structure. By default all the members inside the class are private.

No.java and javascript are two different languages.
Java is a powerful object - oriented programming language like C++,C whereas Javascript is a client-side scripting language with some limitations.

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.

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. 

Personal financial planning is the process of creating and achieving financial goals.

True statements regarding personal financial planning:

As we age, the number and complexity of the financial decisions that we make increases.

There are two means for achieving financial goals—you either need to increase your savings or reduce spending.

A family's resources are limited.

Definition: 3G, known as 3rd Generation, is a standard for mobile / cellular phones. It provides the services that fulfill the International Telecommunication Union specifications.

The application services of 3G include wireless voice telephone, mobile internet access, video calls and mobile television – all in a mobile environment.

3G allows simultaneous use of speech and data services
3G provides peak data rates of at least 200 KBits according to the IMT-2000 specification.
Mobile broadband access of several MBits to laptop computer systems, smart phones is provided by latest 3.5G, 3.75G versions.

3G standards:

UMTS:

  -  Universal Mobile Telecommunications System – One of the 3G mobile telecommunications technologies, also being developed into a 4G technology.
  -  Most common form of UMTS uses W-CDMA as an underlying air interface.
  - UMTS also covers Radio Access Network – UMTS Terrestrial Radio Access Network (UTRAN), and Mobile Application Part (MAP).
  -  Users are authenticated via USIM cards (Universal Subscriber Identity Module).

CDMA2000

   -  Also known as IMT Multi-Carrier (IMT-MC), uses CDMA channel access for sending voice, data and signaling data between mobile phones and cell sites.
   -  The standards are CDMA2000 IX, CDMA2000 EV-DOR Rev.0, CDMA2000 EV-DO Rev.A and CDMA2000 EV-Rev.B. They are approved radio interfaces for the ITU’s IMT-2000.