Interview Questions

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.

1. Based on the lock-size given while creating the table space

2. Programer can direct the DB2 what lock-size to use

3. If lock - size ANY is specified, DB2 usually chooses a lock-size of PAGE

Yes the object is retained. It creates a timer that calls a selector on the current threads run loop. It may not be 100% precise time-wise as it attempts to dequeue the message from the run loop and perform the selector.

Payroll reports gives information about the total 'cost to Company' for the Employee Salary, Benefits (Cash and Non-Cash), Taxes, Total Hours worked. 

All these information is helpful for the Management decisions.

- Multi-threading fetching in Amazon S3 is used to fetch the objects concurrently using the multiple threads and map the task so that fetching can be made simpler. 

- It is not a good practice to increase the threading for a particular object as every node on the server has some bandwidth constraints. 

- It provides user the ease with which they can upload the files and upload the threads in parallel. 

- It provides high speed of data transfer and easy maintenance of the sever as well.

RIP is a is an interior gateway protocol that was often used in interior networks and in some degree in internet networks. It helps the router adapt to the modifications that are made in a network regarding connections. Now it become less used since more efficient protocols were implemented like OSPF or IS-IS. It is limited to a lower number of routers, a maximum of fifteen router.