Technology Questions

To resolve all the side-effects in the program, the sequence point should not be overlapped.

The container manages the storage space for its elements and provides member functions to access them, either directly or through iterators which reference objects with similar properties to pointers.

Named PL/SQL blocks of code which can be invoked using parameters are called PL/SQL sub programs.

Advantages of PL/SQL subprograms are

- The application makes a single call to the database to run a block of statements which improves performance against running SQL multiple times. This will reduce the number of calls between the database and the application.

- PL/SQL is secure since the code resides inside the database thus hiding internal database details from the application. The application will only make a call to the PL/SQL sub program

- PL/SQL and SQL go hand in hand so there would be no need of any translation required between PL/SQL and SQL.

Cocoa is for Mac App development  and cocoa touch is for apples touch devices - that provide all development environment 

We can apply at max of 12 triggers in a table.

By providing callback function. Callback function gets called whenever corresponding event triggered.

C++ allows us to parameterize directly three kinds of entities through templates: types, constants, and templates.

Data warehouse

- It is a decision support database system for the purpose of organizational needs. 

-It is non volatile, integrated and time variant collection of data

Operational Data Stage

- It is an integrated collection of information. 

-It can contain 90 days of information at maximum.

-ODS supports dynamic data.