Combined Bank Senior Officer October 2021 – Preliminary question & solution
Questions from the Combined Bank Senior Officer recruitment exam, October 2021 – Preliminary, shared by the candidates who sat it. The paper: 98 MCQs. So far 97 MCQs and 11 written questions have been shared. Topics include Computer Networks, DBMS, Bangla, General Knowledge and Computer Architecture.
MCQ (97)
- A system has 12 magnetic tape drives and 3 processes: P0, P1, and P2. Process P0 requires 10 tape drives, P1 requires 4 and P2 requires 9…
- What is the network address for the IP address 178.112.13.10/8?
- Which RAID level creates a mirror of all disks for storing data?
- NIC stands for–
- In the priority queue, insertion and deletion take place at –
- In Unix operating system, which system call is used for creating a new process?
- Which type of JOIN operation in SQL command is used to return rows that do not have matching values?
- Consider a magnetic disk packed with 32 surfaces. Each surface is divided into 128 tracks with 256 sectors per track. If the size of a…
- Which is the correct definition of BUG?
- How can you clear the CMOS password?
- What is the best way to protect your hard drive data?
- Which feature is not applicable for memory-mapped I/O?
- Which of the following is a device that is used to connect a number of LANs?
- Which of the following causes the average memory access time to increase in a memory system with cache memory?
- Which searching algorithm can take O(1) time to find a data from a list?
- Which of the following techniques uses memoization?
- Consider a virtual memory system with FIFO page replacement policy. For an arbitrary page access pattern, increasing the number of page…
- In binary search, what is the average number of comparisons required to search an element in a list if the number of elements is n-
- Mapping of a known IP address to a MAC layer address is done by which of the following protocols?
- Applying LRU page replacement to the reference string 1 2 4 5 2 1 2 4, the main memory can accommodate 3 pages and it already holds pages…
- A student breaks the door of a professor's office to obtain a copy of the next day's examination. Define the type of security attack in…
- Which of the following registers is loaded with the contents of the memory location pointed to by the PC?
- Which of the following commands is a type of Data Definition Language command?
- Let transaction T1 have obtained a shared mode lock S on data item Q and transaction T2 has obtained an exclusive mode lock X on data item…
- The address bus flows in——
- A proxy server is used as the computer–
- Which would you do first when troubleshooting a faulty monitor?
- Which one of the following commands is used to restore the database to the last committed state?
- A workstation has just been installed on an Ethernet LAN, but cannot communicate with the network. What should you check first?
- Which is correct characteristic of Selection Sort?
- To remove partial dependency from a database, which technique will you use?
- Which is the correct output? int i = 4; printf("%d %d", +1,i++); printf("%d", i++);
- Which one is not a flag of the 8086 microprocessor?
- Find the correct output: System.out.print('D' + 'E'+ 'F');
- Which one is the correct SQL statement to find the second highest mark from the STUDENT database that contains the marks of all students?
- Suppose you have a complete undirected graph with 4 nodes. What is the maximum number of Minimum Spanning Trees (MSTs) you can form?
- The Θ notation in asymptotic evaluation represents–
- URL stands for-
- Find the output of the following code: int a=15, b=15; if((a-100) == (b-a)) System.out.print(b+a); else System.out.print(b-a);
- Which is correct output? int a = 100; int *p = &a +2; *p = 22; printf("%d", a);
- Which is the disadvantage of Optical Fiber?
- Related records of the different relations can be stored on the same block using which file organization technique?
- Find the correct output: int a = 10,b = 20; a ^= b; b ^= a; a ^= b; printf("%d %d", a, b);
- Which is the wrong statement about the BIOS of a computer?
- DHCP is-
- Which one is not a database transaction property?
- Which is correct for Merge sort-
- How many bits in IPv6?
- Which one is the loopback address?
- How can we prevent SQL Injection Attack?
- Which of the following is not a true statement?
- Which one is not a layer of cloud computing?
- What is the postfix expression of the string a+(b-c)*d?
- Which of the following is not a function of a database administrator?
- In which addressing mode, the effective address of the operand is generated by adding a constant value to the contents of the register?
- Most PCs give a single beep on boot up to indicate that the hardware is ok. If you do not get any beep, then what will be the first thing…
- The simplified form of the Boolean expression (A+B+AB) (A+C) is-
- Suppose you have an 8-bit binary number N. Which of the following operations does not change its lower 4 bits?
- Consider the following relational database– Order (OrderNumber, OrderDate, Promised Date) Orderline (OrderNumber, ProductID…
- 'সন্ধি' ব্যাকরণের কোন অংশে আলোচিত হয়?
- বিভক্তিহীন নাম শব্দকে কী বলে?
- 'রক্তাক্ত প্রান্তর' নাটকের পটভূমি-
- সঠিক সন্ধি বিচ্ছেদ কোনটি?
- নিচের কোনটি মৌলিক শব্দ নয়?
- 'ঠিক', তুমি সত্য বলেছ।'-
- বাংলাদেশের নাটকে 'কথানাট্যের' পথিকৃৎ-
- 'তুমি আসবে বলে হে স্বাধীনতা'- কার রচনা?
- চর্যাপদে কোন পদকর্তার রচনা সর্বাধিক?
- 'অর্ণব' শব্দের অর্থ কী?
- Which one word is closest in meaning to 'Franchise'?
- The complex form of 'A rolling stone gathers no moss' is
- Which word is spelt correctly?
- The people who carry a coffin at a funeral are called _______
- While living in poverty, the poet had to ____ a great deal of suffering.
- I differ ___ you ___ this question.
- Which phrase contains words opposed to each other in meaning?
- The _______ of the forest will result in the _______ of many animal species.
- If 5x + 4y = 22 and 3x + 5y = 21, what is the value of x and y?
- It is time to shut up the shop. (Passive)
- If 3x+5y =14 and x-y = 6 then what is the average of x and y?
- Of the series 5+8+11+14_______ which term is 383?
- If a man rows at 5km/hr in still water and 3.5 km/hr against the current, find his rate along the current.
- Alom sold a radio at the cost of 1950 taka at a loss of 25%. At what cost will he have to sell it to get a profit of 30%?
- Of 100 students 90 passed in Bangla, 85 in Mathematics and 80 in both subjects. How many students failed in both subjects?
- If a = √3 + √2, then the value of a³ + 1/a³ = ?
- The loss is 30% when 10 lemons are sold per taka. How many lemons are to be sold per taka to make a profit of 40%?
- The ratio of milk and water in 64 liters of a mixture is 5:3. What amount of water is added to make the ratio 3:5?
- Nassau is the capital city of–
- What are the small indentations on a golf ball called?
- When did Bangabandhu declared historic six point programme?
- The length of Dhaka Metro Rail will be–
- As per the latest changes in Bengali Calendar, leap year is calculated in which month?
- Which country gave the 'Statue of Liberty' to the United States of America as a gift?
- Who is the builder of the 'Sat Gumbad' (Seven-domed) mosque?
- When is the 'International Day of the Victims of Enforced Disappearances' observed?
- Free Market Economy started in Bangladesh in–
- Which countries are jointly called the 'Golden Crescent'?
Written (11)
- Explain Impact printer and Non-impact printer.
- What is the difference between OOP and POP?
- What is the difference between Overloading and Overriding?
- Simplify using K-Map: F (W,X,Y,Z) = ∑(3,5,7,9,11,13,14,15)
- Explain: Swapping, Virtual Memory.
- What is NAT? Why is it used and how does NAT translate?
- TDM math: rate = 1.536 Mbps, message size = 960000, slots = 32, end-to-end circuit switch time = 800 ms. Calculate the transfer time.
- 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?
- ER diagram to Schema diagram: Rectangles are entity sets, diamonds are relationship sets, rounded boxes are attributes; "(key)" marks an…
- Explain Confidentiality and Integrity. Can you have confidentiality without integrity? Can you have integrity without confidentiality?
- Given the classless IP 105.38.89.230/20, find the Net Id, Host Id, network address, broadcast address and network size. If classful…