Technology Questions

An application plan or package is generated by the bind to define an access path. 

A session is a logical object created by the PHP engine to allow you to preserve data across subsequent HTTP requests. Sessions are commonly used to store temporary data to allow multiple PHP pages to offer a complete functional transaction for the same visitor.

Basic Replication : Basic replication is implemented using standard CREATE SNAPSHOT or CREATE MATERIALIZED VIEW statements. It can only replicate data and not procedures, indexes replication is always one-way, and snapshot copies are read only.

Advanced Replication : Advanced replication supports various configurations of updatable snapshot, multi-master and update anywhere replication. It is more difficult to configure but allows data and other database objects like indexes and procedures to be replicated.

Differences between Basic and Advanced replications:

- With basic replication, data replicas provide read-only access to the table data whereas advanced replication features extend the capabilities of basic read-only replication by allowing applications to update table replicas throughout a replicated database system.

- With Basic Replication applications can query data from local data replicas. On the other hand with advanced replication, data replicas anywhere in the system can provide both read and update access to a table's data.

Optimized code tends to run faster and make more efficient use of the system’s resources. Optimized codes are also less susceptible to errors and take lesser space in memory and in file size.

There are lots of ways to solve the issue of callback hells:

1. Modularization: break callbacks into independent functions
2. Use a control flow library, like async
3. Use generators with Promises
4. Use async/await (note that it is only available in the latest v7 release and not in the LTS version)

Bitmap indexes make use of bit arrays (bitmaps) to answer queries by performing bitwise logical operations.

Bitmap indexes are useful in the data warehousing applications.

Bitmap indexes have a significant space and performance advantage over other structures for such data.

Tables that have less number of insert or update operations can be good candidates.

The advantages of Bitmap indexes are:

   - They have a highly compressed structure, making them fast to read.

   - Their structure makes it possible for the system to combine multiple indexes together so that they can      access the underlying table faster.

The Disadvantage of Bitmap indexes is:

  - The overhead on maintaining them is enormous. 

The standard query operators implement the IEnumerable<T> or the IQueryable<T> interface in C# and the IEnumerable(Of T) or the IQueryable(Of T) interface in Visual Basic.