Agrani Bank Limited - Officer (ICT), 2017

Agrani Bank Limited - Officer (ICT), 2017

1.      Question: : Write the performance of a non-recursive function which is written in a recursive way.

•         It is good to at least understand how recursion works, because some algorithms are naturally recursive and thus much easier to express using recursion.

•         Also, recursive algorithms (or implementations) are not inherently slower than iterative ones. In fact, every recursive algorithm can be implemented by an equivalent iterative implementation at the cost of having to keep track some intermediate/temporary values yourself, where the recursive version automatically keeps track of those in the function call stack.

2.        Question: What is the SQL query for showing only the duplicate lists in student (stdid, name,gpa) table?

3.        Question: Write the use cases of withdrawing money for ATM card.

Use Cases for Example ATM System

4.        Question: Show the translation process of a NAT Box.

There are 3 different ways in which NAT works. However, the principle is the same for all 3 modes. To help understand it we need a good, simple example and the first one at the beginning of this page will do the job just fine.

The trick to understanding how NAT works is to realise that only the device (router, firewall or pc) that connects directly to the Internet performs NAT. For our example this device happens to be a router, but it could even be a simple PC; it makes no difference for us.

As you already know, all requests the workstations generate are sent to the Internet via the router. The router will then perform NAT on these packets and send them to their destination. As each packet arrives into the router's private interface, the router will strip the source IP Address from the 3rd layer (network layer) e.g 192.168.0.10 and place its own public IP address (203.31.220.134) before sending it to the Internet.

This is how the packet then seems to have originated from the router itself. In some cases, depending on the NAT mode, the source and destination port numbers (layer 4) will be changed as well but we examine that on the pages that follow. For now, we'll just look at the simple IP translation within the router.

The illustration below shows how the router modifies the packets:

5.        Question: What is . NET framework? What are the main components of .NET framework?

There are many articles are available in the web on this topic; I just want to add one more article over the web by explaining Components of .Net Framework.

Components of .Net Framework

Net Framework is a platform that provides tools and technologies to develop Windows, Web and Enterprise applications. It mainly contains two components,

1.   Common Language Runtime (CLR)

2.    .Net Framework Class Library.

1. Common Language Runtime (CLR)

.Net Framework provides runtime environment called Common Language Runtime (CLR).It provides an environment to run all the .Net Programs. The code which runs under the CLR is called as Managed Code. Programmers need not to worry on managing the memory if the programs are running under the CLR as it provides memory management and thread management.

2.  .Net Framework Class Library (FCL)

This is also called as Base Class Library and it is common for all types of applications i.e. the way you access the Library Classes and Methods in VB.NET will be the same in C#, and it is common for all other languages in .NET.

3.   Common Type System (CTS)

It describes set of data types that can be used in different .Net languages in common. (i.e), CTS ensures that objects written in different .Net languages can interact with each other.

For Communicating between programs written in any .NET complaint language, the types have to be compatible on the basic level.

4. Common Language Specification (CLS)

It is a sub set of CTS and it specifies a set of rules that needs to be adhered or satisfied by all language compilers targeting CLR. It helps in cross language inheritance and cross language debugging.

Common language specification Rules:

It describes the minimal and complete set of features to produce code that can be hosted by CLR. It ensures that products of compilers will work properly in .NET environment.

6.        Question: What is local Storage and session Storage in HTML5? Write down the proper use of these semantics in HTML-<header>,<footer>,<article>and<section>.

·         Local storage — The local storage uses the localStorage object to store data for your entire website, permanently. That means the stored local data will be available on the next day, the next week, or the next year unless you remove it.

·         Session storage — The session storage uses the session Storage object to store data on a temporary basis, for a single window (or tab). The data disappears when session ends i.e. when the user closes that window (or tab).

Local storage: 

          <script type="text/javascript">// Check if the localStorage object exists

          if(localStorage){ // Store data

              localStorage.setItem("first_name", "Peter"); // Retrieve data

              alert("Hi, " + localStorage.getItem("first_name"));

          } else{

              alert("Sorry, your browser do not support local storage.");

          }

          </script>

         

 Session storage: 

          <script type="text/javascript"> // Check if the sessionStorage object exists

          if(sessionStorage){ // Store data

              sessionStorage.setItem("last_name", "Parker"); // Retrieve data

              alert("Hi, " + localStorage.getItem("first_name") + " " + sessionStorage.getItem("last_name"));

          } else{

              alert("Sorry, your browser do not support session storage.");

          }

          </script>

 

7.        Question: Write differences between super key and candidate key with example.

SUPER KEY	CANDIDATE KEY
Super Key is an attribute (or set of attributes) that is used to uniquely identifies all attributes in a relation.	Candidate Key is a proper subset of a super key.
All super keys can’t be candidate keys.	But all candidate keys are super keys.
Various super keys together makes the criteria to select the candidate keys.	Various candidate keys together makes the criteria to select the primary keys.
In a relation, number of super keys are more than number of candidate keys.	While in a relation, number of candidate keys are less than number of super keys.
Super key’s attributes can contain NULL values.	Candidate key’s attributes can also contain NULL values.