Sonali & Janata Bank
Post: Officer (IT), (Job id:10152)
Exam Date: 14.10.2023, Exam Take: BIBM
9. Analize the following code:
SELECT d.department_name, AVG(e.salary) AS average_salary
FROM employees e
JOIN department d ON e.department_id = d.department_id
WHERE e.salary > (SELECT AVG(salary) FROM employees)
GROUP BY d.department_name
HAVING COUNT(*) > 2
ORDER BY average_salary DESC;
10. Find the output of following program:
int F(n) {
if n == 0
return 0;
if n == 1
return 1;
return F(n-2)+F(n-1);
}
int main () {
result F(5);
}
The output of the program will be 5.
=====================
Code Analysis
- Function
F(n):- The function calculates the Fibonacci number for a given
nusing recursion. - Base Cases:
- If
n == 0, it returns 0. - If
n == 1, it returns 1.
- If
- Recursive Case:
- For other values of
n, it returnsF(n-2) + F(n-1).
- For other values of
- The function calculates the Fibonacci number for a given
- Main Function:
- The main function calls
F(5)and stores the result (though it should be assigned to a variable likeresult).
- The main function calls
Calculation of F(5)
The Fibonacci sequence calculated by the function is:
11. Write a program for following sequence and analyze complexity of the program
1, 2, 2, 3, 3, 3, ……………………..100 (100times )
1, 2, 2, 3, 3, 3, ……………………..100 (100times )
#include <iostream>
using namespace std;
int main() {
// Loop from 1 to 100
for (int n = 1; n <= 100; n++) {
// Inner loop to repeat 'n' exactly 'n' times
for (int i = 0; i < n; i++) {
cout << n << " ";
}
}
cout << endl; // Print a newline at the end of the sequence
return 0;
}
12. Which SDLC do you prefer between Agile and waterfall model explain with example.
13. Difference between Guided and Unguided media. Difference between STP and UTP. Why using benefit UTP instead of STP?.
14. Difference between TCP and UDP. Distinguish between Cat5 and Cat6. Difference among exFAT, FAT32 and NTFS.
