Job Solution - Subjective Question - Page 7 - Prothom Sir

1.

What do you understand about the IT disaster recovery plan? Describe your approach to disaster recovery and business continuity planning for the data centre of your office.

2.

Let a database has two tables, Customers and Orders. The following figure shows the partial data of these two tables. Based on this partial data, explain Inner, Left, Right and Full join. Show the result set of each join operation.

3.

Briefly describe primary key, foreign key and index in relational database and their relationship. Do you think database indexing always makes applications faster? Explain your answer.

4.

How many types of modes are used in data transferring through networks? Briefly explain those modes. Differentiate between TCP vs UDP.

5.

You are asked to lead a team of software engineers to develop an application software system for your company and deploy it as fast as possible. You need to gather user requirements, design, develop, test and then deploy the system. Between Waterfall Approach and Incremental Approach, which software development approach will you take for your software project? Explain your answer.