Previous Question Bank for all IT Job Exam
1. Computer Fundamental and Hardware
1. How can improve the performance of computer in memory? [Combined Bank, SO(IT) 2020]
2. Optical disk data Read/Write operation [BPSC
ANE 2020]
3. Write functions of the CPU in short. [BB IT
2020]
4. What are the building blocks of a digital
computer? Describe each unit briefly with their functions.
[38th BCS]
5. Differentiate between system software and
application software. [MM AP 2017]
6. Explain the functions of ALU and Control Unit of
a computer. [MM AP 2017]
7. “Pentium processor has a superscalar
architecture.” Explain the meaning of statement. [MM AP
2017]
8. Explain how cache memory is used to increase the
processing speed of computer. [MM AP 2017]
9. Write down the necessary components of a USB bus
with block diagram. [ICT Ministry AP 2017]
10. What is computer bus? What is the unit of
measurement of speed of computer bus? Describe about various types of computer
bus. (BKKB AP 2017]
11. Differentiated between cache memory and virtual
memory. [BKKB AP 2017]
12. Define system software and application software
with three examples of each. [BB AME 2016]
13. Suppose you are entering data into computer but
facing some problem with your monitor. You need to buy a new monitor. What
factor should you consider in case of monitor? [BB AME 2016]
14. Distinguish between OMR and MICR. [BB AME
2016]
15. Write the difference between RAM and ROM.
[BNPS Programmer 2014]
16. Describe what works in a computer's boot-up
process. [MEBA AP 2013]
17. What's the bit? How many bits are a terabyte? [MEBA
AP 2013]
18. Enter the name and overview of the main hardware
components of a computer? [MEBA AP 2013]
19. What are the main differences between software
and hardware? Discuss with examples. [MF
Programmer 2013]
20. What is a computer virus? Name of the two softwares
that are used to prevent the virus. [MF
Programmer 2013]
21. Write down the features of notebook computers
and tablet computers. [MHPW SCO 2013]
22. Difference between ROM and RAM. What are EPROM and EEPROM? [ICT Ministry AP 2017]
2. Data Communication and Computer Networking
1.
Given IP address is 172.168.10.0/24, administrator wants to create 32 subnets, and
then find out subnet mask, number of address of each subnet, first and last
address of subnet 1, first and last address of subnet 32. [JBL SO(ANE) 2020]
2.
Computer network কী?
বিভিন্ন প্রকার Computer network সম্পর্কে আলচনা করুন।
[BPSC
ANE 2020]
3.
Difference between Router and Modem. [SPARRSO 2020]
4.
Describe different types of computer network. [SPARRSO 2020]
5.
What is protocol? Describe TCP/IP protocol in computer network? [SPARRSO
2020]
6.
What is firewall? How you can ensure IT security in the computer system? [SPARRSO
2020)
7.
Name and draw different type of network Topologies. [BB IT 2020, BBL AM
(ICT) 2019]
8.
Let your computer is connected to internet through Ethernet. At some point you
have found that there is no internet available in your computer. How
will you identify where the problem occurs? [BB
IT 2020]
9.
Computer network 4 router-49 PIG P TTICI CO JA UE vi po 1[40'h BCS 2020]
10.
TCP/IP protocol and UDP protocol suit আলোচনা [40th BCS 2020]
11.
Define network topologies with features. [NU AP 2020]
12.
RFID has huge applications in business, especially in supply chain management
and toll collection system. Show the basic working principle of RFID in brief. (Combined
Bank, Officer (IT) 2020]
13.
Make a list of LTE Network elements. [Combined Bank, Officer (IT) 2020]
14.
The primary function of the Transmission Control Protocol (TCP) is to turn an
unreliable network into a reliable network that is free from lost and duplicate
packets. What are the functions performed by TCP to make a network more
reliable? [Combined Bank, Officer(IT) 2020]
15.
What is the function of ARP in TCP / IP? [Combined Bank, SO(IT) 2020]
16.
Given IP address 172.16.128.120/25 what is the subnet mask, network address,
broadcast address and total usable host in this network? [NACTAR 2020]
17.
What is the function of GGSN? [Combined Bank, SO (IT) 2020]
18. Figure shows synchronous TOM with a data stream for each input and one data stream for the output. The unit of data is 1bit. Find (a) the input bit duration (b) the output bit duration (c) the output bit rate and (d) the output frame rate. (JBL, SO (ANE) 2020]
19.
Write short note: Node, Hub, Backbone, Router and Gateway. [BB AME 2019]
20.
What is the difference between threat, vulnerability and risk? Explain SSL and
TLS. [BB AME
2019]
21.
What is private IP? List the class B private IP. [BTV AP 2019]
22.
Find subnet mask and number of host on each subnet mask at a class B IP is
172.16.2.1/23. [PSB
AP
2018]
23.
Find Network Address, Broadcast Address, Net mask, valid host of the IP:
192.16.13.0/30 [NESCO
AM
(ICT) 2018]
24.
Define cloud computing? What is the benefit of cloud computing? [BLPU AP
2018]
25.
Define digital signature, digital divider and NAT. [BLPU AP 2018]
26.
Determine the Nyquist sampling rate and the Nyquist sampling interval for the
signal
X(t)=sin(2100nt)
[38h BCS]
27.
What is modulation? Describe the pulse code modulation (PCM) technique. State
the advantage
and
disadvantage of PCM. [38th BCS]
28.
A host IP address in a network is written as both 192.68.25.16/28 and
3FFE:85B:IFIF:: A9:1234
[38th
BCS]
29.
Which one is IPv6 address? How many bits are used for IPv6 address? How does
the above IPv6
address
completely with the addressing scheme? [38th BCS]
30.
How
many
subnets and hosts are to be supported by the above mentioned IPv4 address? [38th
BCS]
31.
Given an IP address is 240.133.10.20/8 Find out network address, number of host
and subnet
mask.
[BWDB AP 2018]
32.
What is OSI model? Which layers are important for data transfer and user
interaction? [BWDB AP
2018]
33.
What is the difference between DNS server and caches? What is the importance of
DNS cache in
World
Wide Web? [BWDB AP 2018]
34.
Explain the component of Data Center. [ABL SO (IT) 2017]
35.
Show the translation process of a NAT Box. [ABL Officer (ICT) 2017]
36.
How many subnets and hosts per subnet can you get from the network
172.20.0.0/27? [BB AME
2017]
37.
Write short notes on DHCP and SMTP. [BB AME 2017]
38.
A block address is granted to a small organization. If one of the addresses is
205.16.37.39/28,
what
is the first and last address of the block? [MM AP 2017]
39.
Explain the terms Domains, Bandwidth, Broadcast and Multicast. [MM AP 2017]
40.
Consider a noiseless channel with a bandwidth of 3 KHz transmitting a signal
with two signal
levels.
What is the maximum bit rate? [MM AP 2017]
41.
What is data communication? Define Simplex, half duplex and full duplex.
[ICT Ministry AP 2017]
42.
Discuss about ISO, OSI and TCP/IP model with figure. [ICT Ministry AP 2017]
43.
Briefly discus about Hub, Router, Switch, Gateway, and Bridge. [BCSCL NE
2017]
44.
Given network address 192.18.10.0/23. Divide the network address four equal
subnet. Write down
each
subnet address, start address, subnet mask and broadcast address. [BCSCL NE
2017]
45.
What is circuit switch and packet switch? Which switch is better and why? [BCSCL
NE 2017]
46.
4. Differentiate between client server network and peer-to-peer network. [PSC
Lecturer 2017]
47.
What is data communication? Describe about three modes of data transmission.
[BKKB AP 2017]
48.
What are the difference between Web server and Application server? [IBBL AD
2017]
49.
Distinguish between TCP and UDP. [3 7th BCS)
50.
What do we need a static private IP address and what are the advantages? [37th
BCS]
51.
What is Modulation and demodulation? Write down five uses? [BCSCL NE 2017]
52.
Differentiate between Intranet and Extranet. [BB AME 2016]
53.
What is main difference between Domain and Workgroup? [BB AP 2016]
54.
What is the difference between layer 2 and 3 network switch? [ICT AP 2014]
55.
State the advantage and disadvantage of voice band and broadband? [ICT AP
2014]
56.
What is meant by the term link in case of network? [MHFP SCO 2014]
57.
Describe about twisted pair, co-axial and fiber optic cable. [BNPS
Programmer 2014]
58.
What is network? What is sub-netting? When and why sub-netting used? [ICT M
AP 2014]
59.
What is modulation? Write the necessary of modulation? [BTEB Instructor
2014]
60.
Define satellite. Write down the name of five satellite orbits? [BTEB
Instructor 2014]
61.
What is 4G in Information Technology? What are the benefits in this Technology?
(BTEB
3. Programming |
1.
Linear search (Searching algorithm) which is used to find whether a given
number is present in an
array
and if it is present then at what location it occurs. (Using any programming
language).
[Combined
Bank, SO(IT) 2020]
2.
X is an integer stream of N numbers. You have to select 2 data P and Q such
that A<= (P+Q) <=B.
Write
an algorithm / pseudo code/ C program how many ways you can select P & Q.
The time complexity must be n log n. [Combined 4 Bank, AP 2020]
3.
Write a Program to check for balanced parenthesis in an expression. (JBL, SO
(ANE) 2020]
4.
Formatted Input/Output Statement কাকে বলে?
Key-Board থেকে কিভাবে input নেয়া যায়? %d এর অর্থ কী? [BPSC ANE 2020]
5.
Recursion কী?
Recursion পদ্ধতির একটি Sample C-programming 97
এরCode লিখুন[BPSC ANE 2020]
6.
if......else statement এর
format লিখ।১+৩+৫+৭..+n সিরিজ টির যোগফল নির্ণয়ের জন্য C language এ একটি প্রোগ্রাম লিখুন [BPSC ANE 2020]
7.
What are the main objectives of structured programming? Write two advantages of
structured Programming. [SPARRSO 2020]
8.
Object oriented programming- 47 এর প্রেক্ষিতে function overloading বলতেকিবুঝায়? Function-overloading এর একটি উদাহরন দিন? [40th BCS 2020]
9.
Write down the difference between Compiler and Interpreter. [40th BCS 2020]
10.
After compilation and execution, what will be output in the following code:
[DPDC 2020]
int
main() {
int
i=-3, j=1, k=0, m;
m=++i ||
++j && ++k;
printf("%d,%d,%d,
%d", i, j, k, m);
return
0;
11.
Difference between ++i and i++. [NU AP 2020]
12.
Difference between Overloading and Overriding. [NU AP 2020]
13. Inheritance is one of important issues for any
object oriented programming language. The main advantage of Inheritance is the
ability to reuse the code. Explain in brief different types of Inheritance. [Combined
Bank, Officer(IT) 2020]
14. An employee's total weekly pay is calculated by multiplying the hourly wage and number of regular hours plus any overtime pays which in turn is calculated as total overtime hours multiplied by 1.5 times the hourly wage. Write a program that takes as inputs the hourly wage, total regular hours, and total overtime hours and prints an employee's total weekly pay. (Combined Bank, Officer (IT) 2020]
15. Insertion sort is a simple sorting algorithm. Write a program to sort some given numbers using insertion sort algorithm. [Combined Bank, Officer (IT) 2020]
16. Write a C program: 1+2n+3n+4n+………
+n" (where n>0). [NACTAR 2020]
17. Find the error of given code [5 Bank AME 2019]
unsigned int i;
for (i=100; i<=0; --i)
printf("%d", i);
18. Difference between compiler and interpreter with
example? [BCC Programmer 2019]
19. Briefly Describe Abstraction, Encapsulation. (BCC
Programmer 2019]
20. Write a program in C to find the sum of
following series : 12+22+32+....+n? [BCC Programmer2019]
21. What is the output of following code (BCC
Programmer 2019]
#include<stdio.h>
void main () {
char *f [] = { "Ronaldo",
"Messi", "Zidan", "Maradona"}, str[20];
printf("%s\n", f[1] +2);
printf("%s", f[2] +1);
22. A prime number is a number that is evenly divided
by only me and it. Write a program to your favorite language to print the first
100 prim numbers. [BCC Programmer 2019]
23. What is CLR in .NET framework? List the
components of .NET Framework. (BTV AP 2019)
24. Difference between getch() and getche (). What is file pointer in C? [BBL AM (ICT) 2019]
25. How many bits have to change to convert int A to
int B. Sample A=31 and B=14. [CB AP2018]
26. Write down the sudo-code that accepts I, n is
integer and value as input, store all n integers in an array, called pairs and
return all pairs where the summation of individuals pair=value. [BB
SO(IT/ICT) 2018]
Input Output
5
{1,5}, {7,-1}
1 7 - 15 - 7
6
27. Difference between call by value and call by
reference with example. [PSB AP 2018]
28. Find the output of following program. [PSB AP
2018]
i) int main() { ii) int main() {
int n = 10; inti = 2, j = 2;
for (;;) while(i?--i:j++)
printf("%d", n); printf("%d",i);
return 0; return 0;
} }
29. Explain feature of OOP with example. [PSB
Programmer 2018]
30. What is main difference Destructor and
constructor with example? [PSB Programmer 2018]
31. What do you mean by Polymorphism and Inheritance
in object oriented programming (OOP)?
Give appropriate example. [PBL SO 2018]
32. What is looping? Why use looping? Give a proper
example. [BCPSC AP 2018
33. What is the basic difference between looping and
branching? [BCPSC AP 2018]
34. Find the output of following program. [PSB
Programmer 2018]
i) int main() { inti; for (i=0; i<5; i++) if (i==3) continue; printf ("%d\n", i); return 0; } |
char str[120]= "Digital Bangladesh";
int n;
n = strlen (str);
str[4] "10":
printf("%s", str);
return 0;
}
35. Write the difference between throw and throws
using Exception handling? [PBL SO 2018]
36. Write a program where a number is Prime or not. [BLPU
AP 2018]
37. Write a program to store information using structures with dynamically memory allocation. [38th BCS]
38. Why are the following two overloaded functions
inherently ambiguous? (38th BCS]
int f (int a, int b=5);
int f(int &a)
39. Write a c program to verify a perfect number.
Perfect number is a positive integer which is equal to the sum of its proper
positive divisors. [BWDB AP 2018]
40. Write a java program using 2D array and array
output will be: [BWDB AP 2018]
1
12
1 2 3
1 2 3 4
41. Write simple java program to convert string into
camel case and display camel case string. [BWDBAP 2018]
42. What will be the output of following program?
[BWDB AP 2018]
using namespace std;
class A{
private:
int a;
int b;
void set_a (int a) {
this->a=a;
}
//set value of b
void set_b(int b) {
this->b=b;
}
public:
void getValues (int x, int y) {
set_a (x); //calling private number
set_b(x); //calling private number
}
void putValues() {
//printing values of private data member
cout<< "a=" << a
<<" ,b=" << b <<endl;
};
int main() {
AobjA; //creating object
//set values to class data members
objA.getValues (100,200);
objA.putValues(); //print values
return 0;
}
43. Consider a base class Shape and its
derived class Rectangle. Design a code inheritance code using C++.[BWDB
AP 2018]
#include <iostream>
using namespace std;
// Base class
class Shape
public:
void setWidth (int w) {
width = w;
void setHeight (int h) {
height = h;
}
protected:
int width;
int height;
};
// Derived class
class Rectangle: public Shape {
public:intgetArea () {
return (width*height);
}
};
int main (void) {
Rectangle Rect;
Rect.setWidth (5);
Rect.setHeight (7);
// Print the area of the object.
cout<< "Total area:
<<Rect.getArea () <<endl;
return 0;
}
44. Find the output below following code. [BWDB
AP 2018]
public class Test {
public static void main(String[] args) {
String s1 "testi";
String s2 new String
("test1");
System.out.println(s1==s2);
String s3 = new String
("test1");
System.out.println (s2==53);
s3 = s1;
System.out.println (s3==s1);
}
}
45. A program sorts an array of integer. Write down the code that tests the sorting algorithm [written BDB SO (IT) 2017]
46. Write a program using any programming language
that reads five numbers from keyboard and display the smaller, larger and
average of those numbers. [BDB SO (IT) 2017]
47. Write a program to read the coordinates of the
end points of a line and to find its length. Use a structured variable name
'Line' to store the relevant information about its end points. [MM AP 2017]
48. Write a program in C++ to calculate the sum of
the series: 1+(1+2)+(1+2+3)+...+(1+2+...+n). [MM AP 2017]
49. Write а program in C with recursive function to
compute the value X" where n is a positive integer
and x has real value. [MM AP 2017]
50. Draw a flowchart of ax2+bx+c=0 through C/C++
program. [PSC Lecturer 2017]
51. What is trigger? Write a code for auto increment
sequence and trigger. [DBBL PO 2017]
52. What is the difference among String, String Buffer
and String Builder? [DBBL PO 2017]
53. Write a java program based on following
conditions: There is one Circle class and one Cylinder
Class. Circle class has an area function. Cylinder
Class has to Circle area*height). Use inheritance to calculate Volume of
Cylinder. [DBBL PO 2017]
54. Write a structured program to display Fibonacci
series up to 100 Numbers. [BB AP 2016]
55. Write a C/C++ program to calculate factorial of
any integer? [ICT AP 2014]
56. What is multi-tasking, multi programming,
multi-threading? [JB AME 2012]
4. Data Structure and Algorithm |
2.
There are no well-defined standards for writing algorithms. Efficiency of an
algorithm depends on several factors. Similarly, complexity of an algorithm
also depends of several factors. Describe the algorithm complexity factors. [Combined
Bank, Officer (IT) 2020]
3.
Explain Binary Search Tree operation. [Combined Bank, SO (IT) 2020]
4.
Usually, recursion involves a function calling itself until specified condition
is met and it is very useful to find out the factorial. Write a recursive
algorithm to find the factorial of a number.
[Combined
Bank, Officer (IT) 2020]
5. যেকোন একটা array নাও, সেই array থেকে একটি সংখ্যার binary search করার step গুলো লিখ এবং এর time complexity কত হবে তা বের কর (DPDC 2020]
6.
Write code to test a sorting algorithm of array? [5 Bank AME 2019]
7.
Advantage and complexity of Marge sort, Heap sort, Insertion sort. [BBL AM
(ICT) 2019]
8.
Describe infix conversion method. [BBL AM (ICT) 2019]
9.
A program sorts an array of integer. Write down the code that tests the sorting
algorithm of written in a program. [CB AP 2018]
10.
Write an algorithm to find a node in a binary search tree. [PSB AP 2018]
11.
Difference between linear and nonlinear data structure. [PSB ADA 2018]
12.
Write Algorithm of Fibonacci series. [PSB Programmer 2018]
13.
Draw a graph to find the shortest path to transmit power. (i) Calculates the
average cost. (NESCO AM (ICT) 2018]
14.
Find Pre-order, in order, post order from following image. [EPB Programmer
2018]
15. A list of numbers 3, 5, 7, 11, 13, 17 is stored in sequence. Which of the following data structure will have the least data movement when the number 11 is removed from the list? FIFO, QUEUE, HEAP, Linked list and stack. Justify your answer. [38th BCS]
16.
Explain the instructions LDS, PUSHF, TEST and CLD. [MM AP 2017]
17.
What is algorithm? Write down the algorithm to find out the second highest
element in an n Element array. [ICT Ministry AP 2017]
18.
Difference between stacks and queue with example. [PSC Lecturer 2017]
19.
Calculate Complexity of merge sort. [IBBL AD 2017]
20.
Write an algorithm that sort an array, also test code for sorting test.
[IBBL AD 2017]
21.
Why do we use stack? Differentiate between linked list and array? (BNPS AP
2017]
22. Illustrate singly linked list, doubly linked list and circular linked list with diagram. [BNPS AP 2017]
23.
Write down time complexities of different sorting algorithm. [DBBL PO 2017]
24.
Explain BFS Traversal of a graph with an example. [DBBL PO 2017]
25.
Find time and space complexity like below pseudo code. [BB AP 2016]
26.
Write prefix and postfix notations from the statement like ((A+B)*C-(D-E)^F) [BB
AP 2016]
27.
What data structure? Give the example of linear data structure. [BNPS
Programmer 2014]
28.
Differentiate between array and linked list. (BNPS Programmer 2014]
29.
What is binary search tree? Draw a BST using following data: 18, 22, 7, 23, 25
and 37. [BNPS
Programmer
2014]
30.
What is flowchart? Draw a flowchart to finding out biggest number between two
numbers. [BNPS Programmer 2014]
31.
Write an algorithm for multiplication two matrixes? [BTEB Instructor 2014]
32.
Using 8, 10, 26, 2, 78, 102, 115 data make a binary search tree. [DIP ME
2014]
33.
How to work Bubble Short? Shorting this data using Bubble short:(68, 27, 56,
13, 87, 42, 66)
[MHPW
SCO 2013]
34.
What is Data structure? Difference between stack and queue? [MHPW SCO 2013]
35.
Show the various passes of bubble sort on an unsorted list 5,2,1,4,3,7,6 [JB
AME 2012]
36.
Write an algorithm to inserting into a Linear Array. [JB AME 2012]
5. Digital Electronics |
1.
F=
2.
লজিক গেইটকী? মৌলিক লজিক গেইট কয়টি ও কী কী? সত্যক সারণি সহ আলোচনা করুন।
[BPSC ANE 2020]
3.
R-S Flip-flop সত্যক সারণিও বৈশিষ্ট্য আলোচনা করুন।
[BPSC ANE 2020]
4.
Simply the following function: ABCD +ĀBD +ABCD [DPDC 2020]
5. (i) (1AC) 16 = (?) and (?)10
(ii) What is the Excess-3 code of 1010? [DPDC
2020]
6.
How will realize a AND gate and an OR gate using a CMOS NAND gate? [BB AME
2019]
7.
Circuit Expression Solved by CMOS. [BBL AM (ICT) 2019]
8.
Define logic gate. Solve this equation using AND, or and NOT gate. [BBL AM
(ICT) 2019]
9.
Draw a truth table that satisfies the above-mentioned equation. [38th BCS]
Y=
AB͞ CD͞
+ABC͞+ĀBD+ AB͞ CD
10.
Simplify the equation by using K-map: f(A, B, C) = ĀBC͞ +ĀBC+ ͞AB͞͞͞ C+ABC [38th BCS]
11.
Draw circuit diagram for the simplified equation by using basic gates.
Calculate the number of basic gates required for implementing the simplified
circuit. [38th BCS]
12.
Why binary logic is used for digital system? [BWDB AP 2018]
13.
What is the difference between flip-flop and latch with figure? [BWDB AP 2018]
14.
What is synchronous? Why sequential circuit use synchronization. [BWDB AP
2018]
15.
What is the difference between latch and flip-flop? [BB AME 2017]
16.
Convert (2345)10 to hexadecimal and (ABCD16 to octal number. [ICT Ministry
AP 2017]
17.
Draw a full adder that is made of two half adder and find out the function of
output of that full adder. [PSC Lecturer 2017]
18.
What is the functionality of multiplexer? Draw a 4-to-1-line multiplexer and
its truth table and describe its functionality. [PSC Lecturer 2017]
19.
What are Multiplexer and de-multiplexer? Name five application of multiplexer.
[BCSCL NE 2017]
20.
What do you mean by Truth table, characteristics table and Excitation table? [DIP
ME 2014]
21.
What is Unicode? What is the reason for using Unicode? [DIP ME 2014]
22.
Describe the binary and hexadecimal numbering methods with numerical examples.
[MF
Programmer
2013]
23.
Draw J-K Flip Flop [JB AME 2012]
24.
Show NAND and NOR gates are universal gates. [JB AME 2012]
6. Web Technology |
2.
"https://www.bb.org.bd”-discuss different parts of this web address. [BB
IT 2020]
3.
HTTPs কীভাবে একটি website- এর সুরক্ষা দেয়
?ব্লক ডায়াগ্রামের মাধ্যমে উত্তর দিন I
4.
Discuss the necessary of using application framework in web application
development. [BB AME
2019]
5.
How do you change the value of a HTML element using HTML DOM? [5 Bank AME
2019]
6.
MVC কী ?এর সুবিধা গুলো লিখুন I BPSC ANE 2020]
7.
Write down the description of
<header><footer><section><article> tag of new HTML5.
[5 Bank
AME
2019]
8.
Differentiate between .ajax(), get() and load() function of jquery with
necessary example. [5 BankAME 2019]
9.
Write down the name of HTML5 media tag. [CB AP 2018]
10.
Suppose you've a javaScript code name as “bankScript" write the code for
loading in HTML
using
JS. [PBL SO 2018]
11.
What is MVC? Write down the MVC design pattern. [PBL SO 2018]
12.
Which is the shortcut symbol of Jquery? [BCPSC AP 2018]
13.
What is an Internet cookie? Why it is use? [BCPSC AP 2018)
14.
What is canvas HTML? What is difference between canvas and SVG? [ICB AP
2017]
15.
What is closure in JavaScript? Explain with an example? [ICB AP 2017]
16.
What is the working procedure of AJAX? [ABL SO (IT) 2017]
17.
What is local Storage and session Storage in HTML5? [ABL Officer (ICT) 2017]
18.
What are the important steps to secure a web server? [BB AME 2017]
19.
What is session hijacking and how to encrypt username and password in PHP? [BB
AME 2017]
20. How many times HTML Tag is used web pages? How can your comments at web pages so that browser not read this? [BB AP 2016]
7. Database Management system
|
2.
Main components of SQL are DDL (Data definition Language). DML (Data Manipulation
Language) and DCL (Data Control Language). Give some examples of DDL, DML and
DCL commands. [Combined Bank, Officer(IT) 2020]
3.
DBMS কী?
একটি database কে normalize করার পদ্ধতি গুলো বর্ণনা করুন। [BPSC ANE 2020]
4.
What is database? What are uses of database in office administration? [BB IT
2020]
5.
DBMS বলতে কী বুঝানো হয়
?DBMS শ্রেণিবিন্যাস বর্ণনা করুন।[40th
BCS 2020)
6.
Write down the difference between Authentication and Authorization. [40th
BCS 2020]
7.
Given a database schema and worker table with fully code: Now writes SQL Query
from theেfollowing
questions. [DPDC 2020]
(i)
Write a query to get distinct name
(ii)
Write a query to get the first three letter of first_name column from worker
table.
8.
Write down Integrity rules in database. [NU AP 2020]
9. Write down SQL Query: (a) commission greater than 10% (b) Remove duplicate data from table. [NU AP 2020]
10.
Database Query: Given two table COURSE (Course_ID, Course_name, Chief_ID) and
INSTRUCTOR
(Instructor ID, Course_ID, Salary, Joining_date). Write down database query Average
salary for different courses. [NACTAR 2020]
11.
Explain the concept distributed DBMS. What are the features of DBMS? [BB AME
2019]
12.
Design a database of student with the gpa of a university. Find the top 10% gpa
holder from the different department of the university. [5 Bank AME 2019]
13.
What is the difference between primary key and candidate key? Explain the
foreign key with an example. [BCC Programmer 2019]
14.
What is SQL injection? How many ways to prevent it? [BTV AP 2019]
15.
What is normalization? Explain composite key with example. [BTV AP 2019]
16.
What in inner join? Explain with syntax and example. [BTV AP 2019]
17.
Describe Database ACID properties. [BBL AM (ICT) 2019]
18.
Difference between primary key, foreign key and candidate key. [CB AP 2018]
19.
Write a query to select top 10% row from grade table. [CB AP 2018]
20.
Define weak Entity? What are the difference between primary key and super key? [PSB
Programmer
2018]
21.
Suppose you've “X-Bank Account, and there are three statement (Real State, Bank
Account, Insurance) and bank account have another two Insurance (Saving,
Current), Now how can you do increase real estate? Draw the UML Design. [PBL
SO 2018]
22.
Suppose you've a method name “total Amount" and there three properties
(transaction Name, transaction Type, amount). Write down the full code using JAVA
where total Amount method return total balance after debit or credited. [PBL
SO 2018]
23.
Suppose you've two table(Employee, Department) in a Database and Employee table
three cell
(emp_name, dept_id, salary) also Department table two cell (dept_id, dept_name), now update the salary 10% increase value from Department table. Give the appropriate example. [PBL SO 2018]
24.
Difference between Super Key and UNIQUE constraint key? [PBL SO 2018]
25. Write an SQL query to insert a tuple in the table: Employee (ID, Name, Designation, and Salary). [NESCO AM (ICT) 2018]
26. What is the SQL command used to fetch first 3 characters name from employees? [BCPSC AP 2018]
27.
Describe Database Schema and data directory with example. [EPB Programmer
2018]
28.
What is database security? Describe different approaches to ensure database
security. [38th BCS]
29. What is the SQL query for showing only the duplicate lists in student (id, name, gpa) table? [ABL Officer (ICT) 2017]
30.
What is database? What is DBMS? Write the full meaning of DDL and DML. [BKKB
AP 2017]
31.
Given two tables are employee (id, name, salary, dept_id) and department
(dept_id, dept name),
Write
a SQL to find MAX salary and AVERAGE Salary for Specific department. [DBBL PO
2017]
32.
Define 'integrity rules' of database systems. Write a SQL query to get the
second highest salary from Employee table. [BB AP 2016]
33.
What is database? State the RDBMS with example? [ICT AP 2014]
34.
Explain the one to many relationships with E-R diagram? [ICT AP 2014]
35.
Draw an E-R diagram of hotel management. [BNPS Programmer 2014]
36.
What is a database? Discuss the importance of database. [MF Programmer 2013]
37.
What do you mean by atomicity and aggregation? [JB AME 2012]
38.
What is Data warehouse? Why We Need Data Warehouse? Advantages &
Disadvantages of Data warehouse. (CB AP 2018)
39.
Explain data warehouse with figure. Describe fact table & dimension table
with example. [ICT Ministry AP 2017]
40.
Compare between TPS and DSS. [BB SO (IT/ICT) 2018]
8. Operating System |
1.
Operating system (OS) scheduling is the key concept of multiprogramming. List
and briefly define the major types of OS scheduling. (Combined Bank, Officer
(IT) 2020]
2.
What is page and block? Draw simple block diagram of SSD, page and block. [Combined
Bank [SO(IT) 2020]
3.
Cache Memory কী
? Computer এর
main memory এর সাথে এর পার্থক্যকী?
[BPSC ANE 2020]
4.
A, B two resources. Two processes (P1 and P2) share these resources. When a
process request fora resources, if that resource is free then it will be
allocated with that resources. If the resources arenot free then the process
will halt. Now the scenario is: [DPDC 2020]
·
Pl request A
·
P2 request B
·
Pl request B
·
P2 request A
5.
Define FCFS, SJF and RR algorithm (Quantum=20). [NU AP 2020]
6.
Turnaround time of FCFS and SJF. [NU AP 2020]
7.
What is the difference between micro kernel and macro kernel? What is the sub
components off/on manager in Windows NT? [BB AME 2019]
8.
Congestion Control ? [BPSC ANE 2020]
9.
What is operating System? What are the main components of operating System? [BCC
Programmer2019]
10.
What is multitasking and multithreading? What are the advantage threads over
process? [BCC Programmer 2019]
11.
What is access time and transfer time? (BTV AP 2019]
12.
What is deadlock? Describe the way of detecting and protecting deadlock.
[38th BCS]
13.
What are the relationship between operating system and computer hardware? [38th
BCS]
14.
Explain Type 1 and Type 2 hypervisors in virtual machine operating system with
figure. [ABL SO (IT) 2017)
15.
Explain in ode data structures in Linux OS. [ABL SO (IT) 2017]
16.
If main memory access time is 100ns, cache access time is 50 ns, cache hit rate
is 90% then what
is
the average time to read from memory? [BB AME 2017]
17.
Explain the functionalities of operating system. [ICT Ministry AP 2017]
18.
What is the difference between preemptive and non-preemptive scheduling? [3
7th BCS]
19.
What is again? What is it used in Operating system? (37th BCS]
20.
How does dynamic memory allocation help in managing data? [37th BCS)
21.
What is again? Why is it used in operating system? [BNPS AP 2017]
22.
How does dynamic memory allocation help in managing data? (BNPS AP 2017]
23.
What is the difference between RAID level 2 and RAID level 3? [ICT AP 2014]
24.
A disk pack has 19 surfaces and storage area on each surface has an outer
diameter of 33cm and inner diameter of 22cm. The maximum recording storage
density on any track is 200 bits/cm and minimum spacing between tracks, 0.25
mm, then how to calculate the capacity of disk pack?[ICT AP 2014]
25.
What is cache memory? Write a detailed explanation of the differences between
primary memory and cache memory. [DIP ME 2014]
26.
What is the difference between general operating system and distributed operating
system?
[MHPW
SCO 2013]
27.
Illustrate the differences between a computer's operating system and an
application system. [MEBAAP 2013]
28.
Enter FAT and NTFS in full. Enter the main features of the Linux operating
system. [MHPW SCO2013]
29.
You have created a file containing 1 million characters. Suppose you want to
save the file in ASCII format. How much memory space in MB in needed to store
the file? [BB AME 2016]
30.
What is FAT? Name of different types of File allocation system in HD. [IBBL
AD 2017]
9. Software Engineering |
1.
Software development এর ধাপ সমূহ সম্পর্কে বর্ণনা করুন। [BPSC
ANE 2020]
2.
Software Engineering-এর প্রেক্ষিতে পাঁচটি ভিন্ন ভিন্ন design pattern এর নাম লিখুন।[40h
BCS 2020]
3.
Integration testing and Beta testing difference [40th BCS 2020]
4.
Explain the main step of Software development life cycle (SDLC). [40th BCS
2020]
5.
Software –এর প্রেক্ষিতে data এবং information সম্পর্কে বর্ণনা করুন।[40"
BCS 2020]
6.
Testing is an activity that is performed to verify correct behavior of a program.
Testing should be conducted in all the stages of program development. Describe
different types of tests conducted in the implementation stage. [Combined
Bank, Officer (IT) 2020]
7.
What Difference between black box and white box testing? [PSB Programmer
2018]
8.
Write the agile method components for Software development. [PBL SO 2018]
9.
Define software security? Challenge of software security. [BLPU AP 2018]
10.
Difference Black box and White box testing. [EPB Programmer 2018]
11.
Describe different techniques use the risk analysis of software development.
[38th BCS]
12.
Difference between black box and white box testing. (ICB AP 2017]
13.
What is software testing and name of some testing tool? (IBBL AD 2017]
14.
How to do beta testing on software testing? [DIP ME 2014]
15.
What is Software Piracy? What is the difference between freeware and open
source software? [MHPW SCO 2013]
16.
Discuss the advantages and disadvantages of open source software. [MHPW SCO
2013]
17.
What do you understand by the software? Critically discuss the classification
of software? [ECBAP 2012]
10. Discrete Mathematics
1.
Propositional logic ও
Predicate Logic উদাহরণসহ বর্ণনা করুন [BPSC ANE 2020]
2.
What is tautology? A statement like AB)^A] →A was given and said to prove it is
a tautology by using truth table. [BB AP 2016]
3.
A full joint probability distribution for the Toothache, Cavity and catch world
is given below. [33 BCS]
11. Microprocessor
1.
General purpose Microprocessor-এ
program counter কী?
Program counter এর ব্যাবহার লিখুন [40" BCS2020]
2.
Describe addressing mode of 8086 Microprocessors. [BB AME 2017]
3.
Difference between microprocessor and micro-controller. [MM AP 2017]
4.
What are the advantages of microcontroller over microprocessors? [ICT AP
2014]
5.
What do you mean by 32-bit microprocessor? [MHFP SCO 2014]
6.
What is the work of Microprocessor? What are the characteristics of a
dependable Microprocessor? [BTEB Instructor 2014]
7.
Draw the 8086 CPU (BIU and EU)? [JB AME 2012]
8.
How many interrupts are there in 8085? Discuss. [JB AME 2012
9.
Write a program to reverse the given string for 8086. [JB AME 2012]
10.
What is pipelining? How does pipeline implementation make faster instruction
execution? [38th BCS]
11.
How does an interrupt can be enabled? What are the steps that occur when an
interrupt is processed? [38th BCS]
12. Artificial Intelligence
1.
What is artificial Neural Network (ANN)? Based on ANN, describe input &
hidden layer, weight and activation function. [ICT Ministry AP 2017]
2.
Draw a non-linear model for a diagram used in a neural network and write down
each of its basic element equations? [BTEB Instructor 2014]
13. E-Commerce and Digital Marketing
1. ই-কমার্স কী? ই-কমার্সের প্রকারভেদ উল্লেখ করুন। সার্চ ইঞ্জিন কী? এর কয়েকটি উদাহরণ দিন।
[BPSC ANE 2020]
2. What is E-Commerce? What are the types of
E-commerce? [NESCO AM (ICT) 2018]
3. Difference between e-commerce and m-commerce.
[371h BCS]
4. What are barrier of e-commerce? [37th BCS)
5. What is e-governance? [ICT M AP 2014]
6. Why cryptography and public key infrastructure
are important to e-commerce? [BNPS AP 2017]
14. Miscellaneous (Technology)
1.
‘Knowledge’ কী?
Human Knowledge কে
Computer এ প্রকাশ করার একটি flow diagram দেখান। [BPSC
ANE 2020]
2.
Explain terms: (i) CAD and CAL (ii) Cookies and Trojan horse [BB IT 2020]
3.
How computer Architecture is characterized. What are the 5 stages of the DLX
pipeline? [BB AME2019]
4.
Write down different stage of data mining? [5 Bank AME 2019]
5.
In an excel sheet cell A1, A2, A3, A4 contains the value of power generation by
four plants. Write
a
function in A5 to show the average of best three power plants. [NESCO AM
(ICT) 2018]
6.
What is the difference between battery and capacitor? [BB AME 2017]
7.
Derive the Escape Velocity equation? [BCSCL NE 2017]
8.
Define satellite. Write the name of five satellite orbits? (BCSCL NE 2017]
9.
Define source voltage and source current. Why it is called dependent and
independent source?[BCSCL NE 2017]
10.
Draw a common emitter BJT circuit and explain. [BCSCL NE 2017]
11.
What is image processing? Where it is uses? [BTEB Instructor 2014]
12.
What is Multimedia? What does a video conference mean and how does it work? [DIP
ME 2014]
13.
Describe about Firewalls, Microcontroller, COCOMO, Query Optimization, Genetic algorithm
and UML. [ICT Ministry AP 2017]
14.
How a-ß pruning is better than minimal search in game planning? Describe with
example. (ICT Ministry AP 2017]
15.
What is public key encryption? Explain digital signature with example. [ICT
Ministry AP 2017]
16.
What is cardinality and modality? [BB AP 2016]
15. Others
1.
Make a list of banking software used in Bangladesh. List the essential features
for successful Banking Software and Apps. [Combined Bank, Officer (IT) 2020]
2.
How would you test an ATM in a banking system? [BB AME 2019]
3.
A 3phase 12 pole alternator running at 500 rpm supplying power to an 8 pole
induction motor. If ship is 3% what is the full load speed of the motor? [BB
AME 2019]
4.
How would you test an ATM in a distributed system? [5 Bank AME 2019]
5.
Write down the use case diagram for ATM. [CB AP 2018]
6.
If 10 people meet each other and each shakes hands only once with each of the
others, how many handshakes will there be? [PBL SO 2018]
7.
Write the use cases of withdrawing money for ATM card. [ABL Officer (ICT)
2017]
8.
Write 5 popular names of web browser and also 5 popular search engines? (BTEB
Instructor 2014]
9.
What is antivirus? Name some popular antivirus names. [DIP ME 2014]
10. How to Animate Microsoft PowerPoint Slides? How to add an image to a slide? [DIP ME 2014]