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.

There is a decent page in the php manual on the subject, in short mysql_pconnect() makes a persevering association with the database which implies a SQL join that don't close when the execution of your script closes. mysql_connect()provides just for the database new association while utilizing mysql_pconnect , the capacity would first attempt to locate a (relentless) connection that is as of now open with the same host, username and password. On the off chance that one is found, an identifier for it will be returned as opposed to opening another connection... the connection with the SQL server won't be terminated when the execution of the script ends. Rather, the link will stay open for future use.

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.

Research

It is a group of functions and implemented under algorithm header file.

Data binding is an automatic synchronization of data between model and view components. ng-model directive is used in Data binding.

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.

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