Technology Questions

BlackBerry Enterprise Server: The BlackBerry handhelds are integrated into the e-mail system of the organization through software BlackBerry Enterprise Server. The BES versions are available for MS Exchange, Novell GroupWise and Lotus Domino. A connector was made by Google for BES for making BES available for Google Apps. A new feature is added which enables to track the current location of an individual through trailateration.

BES provides handhelds with the connectivity of TCP/IP which can be accessed through a component known as “Mobile Data Service – Connection Service – MDS-CS. This allows the development of custom application development using data streams on BlackBerry devices which are based on the Sun JME platform.

BES also provides network security in the form of Triple DES or AES encryption standard of all data including e-mail and MDS traffic, which travels between the BlackBerry hand held devices and a BES.

Personal Oracle lite is single user database for distributed and mobile computing. It supports a full range of Java database features as well as advanced replication. Or in other words it is Oracle's lightweight, fully-functional, single-user object- relational database. A small, zero administration embedded database.

Some of the features supported:

- Java Support

- Java Store Procedure Support

- Java triggers Supported

- Multi-column indexing and outer joins.

- Easy to use graphical user interface

- Supports both object and relational database models

- Simultaneous viewing of classes and relational tables

A function prototype is a declaration of a function that omits the function body. It specifies the function’s name, argument types and return type.

E.g. int add(int,int)

By using
$_SERVER['HTTP_USER_AGENT']
variable.

FMEA is Failure Mode and Effects Analysis. It is an analysis used to determine failure modes and how severe they are in a system or process.

3.

1- Dynaset, 0 Table, 2 Snap Shot. 

EIBRCODE

A package is a collection of related PL/SQL objects. The package contains a body and a specification. The package specification has the declaration which is public and can be used in the PL/SQL sub programs inside the package.

The package body holds the implementation of all the PL/SQL objects declared in the specification.

Example of a PL/SQL Package.

CREATE OR REPLACE PACKAGE emp_data AS 

PROCEDURE add_employee (

      ename VARCHAR2,

      job VARCHAR2,

      mgr NUMBER,

      sal NUMBER,

      deptno NUMBER);

END emp_actions;

CREATE OR REPLACE PACKAGE BODY emp_data AS 

PROCEDURE add_employee (

       ename VARCHAR2,

       job VARCHAR2,

       mgr NUMBER,

       sal NUMBER,

       deptno NUMBER) IS

BEGIN

         INSERT INTO emp VALUES (empno_seq.NEXTVAL, ename, job, mgr, SYSDATE, comm, deptno);

END add_employee;

END emp_data;

Advantages of  PL/SQL packages :

Packages are easier for application designing, encapsulating data, additional functionality and better performance. An application has various modules which can be placed in packages and handled easier.