Technology Questions

- Packet data speed is higher in 3G, and it is up to 384 KBPS
- Voice and sms speed is also 384 KBPS in 3G
- 2G utilizes different switching techniques for voice and data, where as  3G uses single switching, irrespective of data
- 3G has at least 2MB of data link of a mobile, where in 2G the data rate is in KBPS
- 3G has WiMAX facility for faster VOIP and internet
- 2G uses GSM TDMA technology with narrowband 200Khz.
- 3G uses CDMA technology with broadband 5Mhz, with same frequency carrier and time.

There are three types of constructor in C++. They are Default constructor, Parameterized constructor, Copy constructor.

Row Level Trigger :
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger :
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

Use the LISTCAT command.

A binary tree with n nodes has exactly n+1 null nodes

It is an MVS message that indicates the presence of a duplicate catalogue in the database. This problem can be fixed by removing one of the entries and then adding a new one.

If an error occurs in program, then only exception object is created otherwise, It will not be created. So it’s expensive to use in the program.

Oracle HTTP Server is the Web server component of Oracle Database. It is based on the Apache HTTP Server. It is robust and reliable server due to following features:

- Provide high availability infrastructure integration with Oracle Process Manager and Notification Server (OPMN), for process management, death detection and failover for Oracle HTTP Server processes.

- Provide Dynamic Monitoring Services (DMS) metrics that give runtime performance statistics for Oracle HTTP Server processes.

- Enable securing of transactions with Secure Sockets Layer (SSL) technology.

- Execute Perl scripts in the same process as the Oracle HTTP Server, or as CGI script.