Sonali Bank Assistant Database Administrator 2020 – Preliminary question & solution

Questions from the Sonali Bank Assistant Database Administrator recruitment exam, 2020 – Preliminary, shared by the candidates who sat it. The paper: 70 MCQs. So far 68 MCQs have been shared. Topics include DBMS, English, General Knowledge, Bangla and Coding.

MCQ (68)

  1. Which is not a step of SQL query processing?
    1. a) Parsing
    2. b) Translation
    3. c) Optimization
    4. d) None
  2. Find the output: int a= 10, c, b; c = (a=99)? b = 11:20; printf("%d, %d", a, c);
    1. a) 11, 99
    2. b) 99, 11
    3. c) 20, 11
    4. d) 99, 20
  3. What will be the output of following code? int x=5, y=5, z=5; printf("%d", ++z+y-1-y+z+x++);
    1. a) 15
    2. b) 17
    3. c) 16
    4. d) 19
  4. A computer system has 6 tape drives and each process may need 3 tape drives. What is the maximum number of processes that is guaranteed to…
    1. a) 4
    2. b) 3
    3. c) 2
    4. d) None
  5. Consider the following table named "Course"- Course Title Content Web Programming Python, CSS, JS What is the main problem/anomaly in the…
    1. a) Attribute name is not correct
    2. b) Table is larger
    3. c) Attribute has multiple values
    4. d) It has functional dependency
  6. Which is the immediate addressing mode in an 8086 microprocessor?
    1. a) MOV AX, BX
    2. b) MOV AX, [BX]
    3. c) MOV AX, 1000
    4. d) MOV AX, [BX+1000]
  7. Consider the following relation- employee ID name first_name last_name address city zip birth_date age() Which are the composite…
    1. a) age, ID
    2. b) birth_date
    3. c) name, address
    4. d) name, age
  8. Which information is not correct for any constructor of a Java class?
    1. a) Constructor is not inherited
    2. b) Constructor has no return type
    3. c) Constructor can be final
    4. d) Constructor can be overloaded
  9. What will be the output of the given line? printf("%d", sizeof(int));
    1. a) 2
    2. b) 4
    3. c) 1
    4. d) 8
  10. The collection of information stored in the database at a particular moment is called-
    1. a) Schema
    2. b) Instance
    3. c) Relation
    4. d) Record
  11. In a table an attribute named interest is defined as follows, interest numeric (2,1) Then which one is the correct format for the interest…
    1. a) 65.2
    2. b) 7.2
    3. c) 19.02
    4. d) 1.03
  12. What is the disadvantage of multithreading?
    1. a) Share the same address space
    2. b) Simultaneous access to multiple applications
    3. c) Low cost communication
    4. d) Difficulty in managing concurrency
  13. Which one is a Data Control Language (DCL) command in SQL?
    1. a) Insert
    2. b) Create
    3. c) Drop
    4. d) Grant
  14. The time needed from the process arrival to the completion of that process is called
    1. a) Waiting time
    2. b) Response time
    3. c) Turnaround time
    4. d) Throughput
  15. A relationship is given below in an ER diagram How many tables can be created (preferred) from below diagram?
    1. a) No definite numbers
    2. b) Two
    3. c) Three
    4. d) Two or Three
  16. We can create a "View" of a relation using the "create view_name" command in SQL. Analyze the following information about views and find…
    1. a) View is not visible to user
    2. b) It is not a virtual table
    3. c) It is not a part of the logical model
    4. d) View cannot be updated
  17. Which information is wrong for a switch?
    1. a) Stores MAC address table
    2. b) Operates at Data Link Layer
    3. c) Forwards the packet to the intended computer
    4. d) Has no memory
  18. What is the postfix expression of the string a+(b-c)*d?
    1. a) abc-d*+
    2. b) abcd-*+
    3. c) ad*bc-
    4. d) abc-d+*
  19. Which is not the state of a process in an Operating System?
    1. a) New
    2. b) Sleep
    3. c) Terminated
    4. d) Ready
  20. If we represent a binary tree using array, what will be the children of node "n"-
    1. a) 2n & 2n+1
    2. b) 2n & 2-n
    3. c) (n+1)2
    4. d) 2n & 2n-1
  21. Consider the following "staff" table staff_name staff_dep city Riaz CSE Dhaka Toha EEE Rajshahi What should be the query to find the…
    1. a) select staff_name || '('|| staff_dep ||')' FROM staff where city= 'Dhaka'
    2. b) select staff_name '('|| staff_dep ||')' FROM staff where city== 'Dhaka'
    3. c) select staff_name || '('|| staff_dep ')'|| FROM staff where city= 'Dhaka'
    4. d) select staff_name || '(' staff_dep ||')' FROM staff where city= 'Rajshahi'
  22. Among the following, which is not a divisor of (1001011011110000000)₂?
    1. a) (2)₁₀
    2. b) (64)₁₀
    3. c) (128)₁₀
    4. d) (256)₁₀
  23. The ____ was the first wide-area packet-switching network with distributed control and one of the first networks to implement the TCP/IP…
    1. a) INTRANET
    2. b) UCLA
    3. c) CREN
    4. d) ARPANET
  24. What is the output of this Java program? class Test { int i; } public class Main{ public static void main(String args[]){ Test t=new…
    1. a) The program will cause a compile error because the object "t" was not initialized
    2. b) The program will cause a runtime exception because the variable "i" was not initialized
    3. c) A garbage value
    4. d) 0
  25. Which language was used to build Android Operating System?
    1. a) Java
    2. b) Python
    3. c) Kotlin
    4. d) Android is not an operating system
  26. In the following graph, determine the cost of the shortest path between node 1 and node 4
    1. a) 0
    2. b) 4
    3. c) -5
    4. d) -∞
  27. Suppose Y is an integer variable whose value is either 0 or 1. Which of the following is the equivalent of the statement: if(Y==0)Y=1…
    1. a) Y=1+Y
    2. b) Y=1-Y
    3. c) Y=Y-1
    4. d) Y=1%Y
  28. Which one is the characteristic of Stack ADT?
    1. a) Sequential Index
    2. b) Last-In-First-Out
    3. c) First-In-First Out
    4. d) Key indexing
  29. If you are told to remove the inconsistency from the course table, which normalization technique will you use?
    1. a) 1NF
    2. b) 2NF
    3. c) 3NF
    4. d) BCNF
  30. What is the maximum length of the "varchar" in the database?
    1. a) 35000
    2. b) 100
    3. c) 65535
    4. d) 255
  31. Which for loop statement is invalid?
    1. a) for(int x=10; k<=5; x/9)
    2. b) for(int x=10; x>=2; --x)
    3. c) for(int x=10; x>=200; x=3*x)
    4. d) for(int x=10; x>=0; x+=2)
  32. How many IP addresses can be assigned using IPv4 techniques?
    1. a) 2^32
    2. b) 2^64
    3. c) 4^32
    4. d) 4^64
  33. In which tree structure left and right subtree heights differ by not more than 1?
    1. a) Binary tree
    2. b) BST
    3. c) AVL tree
    4. d) Binary Heap
  34. Assume that in a table named "student" the cgpa is calculated using the GPAs of all courses. What kind of attribute is cgpa?
    1. a) Multivalued
    2. b) Derived
    3. c) Simple
    4. d) Composite
  35. Which is the lightweight message format?
    1. a) XML
    2. b) JSON
    3. c) SQL
    4. d) HTML
  36. Which is the wrong statement about SQL?
    1. a) Non-procedural language
    2. b) Input can be several tables
    3. c) Output is always a single table
    4. d) Output can be multiple tables
  37. The ____ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
    1. a) Union
    2. b) Set-difference
    3. c) Difference
    4. d) Intersection
  38. Why is RAID used in database storage?
    1. a) Improve performance
    2. b) Reduce Cost
    3. c) Both a & b
    4. d) None
  39. They while away their evenings with books and games. Here while is-
    1. a) Noun
    2. b) Verb
    3. c) Adjective
    4. d) Adverb
  40. His evidence bears out, the evidence of the first witness. Here bears out means
    1. a) confirms
    2. b) wcount
    3. c) attacks
    4. d) none
  41. The person with ____ you should ____ registering your complaint is the manager but he's unavailable ____ the moment.
    1. a) which, be, for
    2. b) who, at, for
    3. c) which, who,
    4. d) whom, be, at
  42. If you had come earlier, you would ____ found a good seat
    1. a) have
    2. b) had
    3. c) can
    4. d) has
  43. People who pay their debts are trusted. Here who pay their debts is
    1. a) Phrase
    2. b) Clause
    3. c) Idioms
    4. d) Gerund
  44. A misconception frequently held by novice writers is that sentence structure mirrors thought: the more convoluted the structure, the more…
    1. a) complicated
    2. b) engaged
    3. c) essential
    4. d) fanciful
  45. I've got a week to finish this, ____ is just about long enough
    1. a) what
    2. b) which
    3. c) whether
    4. d) who
  46. He really can't work out ____ he has to do to get ____ information he needs
    1. a) what, the
    2. b) which, to
    3. c) what, to
    4. d) for, which
  47. Reading is very good ____ children's intellectual development
    1. a) at
    2. b) on
    3. c) for
    4. d) in
  48. The quote "All that glitters is not gold" is from which play of Shakespeare?
    1. a) The Merchant of Venice
    2. b) Othello
    3. c) Romeo and Juliet
    4. d) None
  49. How many countries are members of Commonwealth?
    1. a) 47
    2. b) 51
    3. c) 54
    4. d) 61
  50. The total border district of Bangladesh?
    1. a) 29
    2. b) 32
    3. c) 45
    4. d) 53
  51. What is the position of Bangladesh in the financial Privacy Index 2020?
    1. a) 29th
    2. b) 37th
    3. c) 43th
    4. d) 54th
  52. The river Padma enters into Bangladesh through-
    1. a) Sylhet
    2. b) Rajshahi
    3. c) Mymensingh
    4. d) Pabna
  53. The headquarter of World Economic Forum is situated in-
    1. a) Cologny
    2. b) Geneva
    3. c) Davos
    4. d) San Francisco
  54. The term of a non-permanent member of the UN security council is-
    1. a) 2 years
    2. b) 3 years
    3. c) 5 years
    4. d) 7 years
  55. The Constitution Drafting Committee of Bangladesh formed in 1972 had-
    1. a) 21 members
    2. b) 24 members
    3. c) 31 members
    4. d) 34 members
  56. Which bank was the first to Introduce dual-currency debit card system in Bangladesh?
    1. a) Mutual Trust Bank
    2. b) City Bank
    3. c) Dutch Bangla Bank
    4. d) AB Bank
  57. Which one of the following is not an official language of United Nations?
    1. a) Arabic
    2. b) Chinese
    3. c) Portuguese
    4. d) Spanish
  58. The number of tribes lives in the Chattogram Hill Tracts is-
    1. a) 7
    2. b) 9
    3. c) 11
    4. d) 15
  59. অবাক হয়ে ওর দিকে তাকিয়ে থাকে ওরা। এখানে 'দিকে' শব্দটি-
    1. a) অনুসর্গ
    2. b) বিশ্লেষণ
    3. c) অব্যয়
    4. d) উপসর্গ
  60. 'চশমা' শব্দটি কোন ভাষা থেকে এসেছে?
    1. a) আরবি
    2. b) ফারসি
    3. c) তুর্কি
    4. d) পর্তুগীজ
  61. বৃক্ষ শব্দের সমার্থক নয় কোনটি?
    1. a) তরু
    2. b) বিটপী
    3. c) কানন
    4. d) মহীরুহ
  62. 'আমি কি ডরাই সখি ভিখারি রাঘবে?' কোন কারকে কোন বিভক্তি?
    1. a) কর্মে প্রথমা
    2. b) অপাদানে সপ্তমী
    3. c) অধিকরণে পঞ্চমী
    4. d) কর্মে সপ্তমী
  63. নিচের কোনটি দেশী শব্দ?
    1. a) ডাব
    2. b) ধর্ম
    3. c) তোশক
    4. d) হাত
  64. দুটি ব্যঞ্জনের পরস্পর পরিবর্তন কে বলে-
    1. a) স্বরসঙ্গতি
    2. b) বিষমীভবন
    3. c) ধ্বনি বিপর্যয়
    4. d) ব্যঞ্জনবিকৃতি
  65. ব্রাহ্মণ শব্দে 'হ্ম'-এর বিশ্লেষিত রূপ-
    1. a) হ+ম
    2. b) ক+ধ
    3. c) ক+ষ+ম
    4. d) ক+ষ+ণ
  66. 'কাজটি শেষ করার জন্য সে আদা-কাচকলা খেয়ে নেমেছে।' বাক্যটি কী হারিয়েছে?
    1. a) আকাঙ্ক্ষা
    2. b) আসক্তি
    3. c) যোগ্যতা
    4. d) পদক্রম
  67. ভাষা আন্দোলনের পটভূমিতে কবর নাটকটি রচনা করেন-
    1. a) কবীর চৌধুরী
    2. b) সৈয়দ শামসুল হক
    3. c) সেলিম আল দীন
    4. d) মুনীর চৌধুরী
  68. নিচের কোনটি সাধু রীতির বৈশিষ্ট্য নয়?
    1. a) তৎসম শব্দবহুল
    2. b) তদ্ভব শব্দবহুল
    3. c) সংলাপের অনুপযোগী
    4. d) শব্দবিন্যাস সুনির্দিষ্ট

Other papers for this post