Technology Questions

ANALYZE command is used to perform various functions on index, table, or cluster, as listed below:
- It helps in dentifying migrated and chained rows of the table or cluster.
- It helps in validating the structure of the object.
- It helps in collecting the statistics about object used by the optimizer. They are then stored in the data dictionary.
- It helps in deleting statistics used by object from the data dictionary.

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.

* HTML elements communicate with the Browser how to represent the text.

* HTML elements become HTML tags when enclosed within the angular brackets as "<>".

- 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.

Research

There are three ways that can be used in order for a Thread to be created:

A class may extend the Thread class.

A class may implement the Runnable interface.

An application can use the Executor framework, in order to create a thread pool.

The Runnable interface is preferred, as it does not require an object to inherit the Thread class. In case your application design requires multiple inheritance, only interfaces can help you. Also, the thread pool is very efficient and can be implemented and used very easily.

Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. Enterprise Editions only supports log shipping. In log shipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and can be used this as the Disaster Recovery plan. The key feature of log shipping is that it will automatically backup transaction logs throughout the day and automatically restore them on the standby server at defined interval.