Skip to content
Past paper

Probashi Kallyan Bank Programmer: 2019 Exam Taker: AUSTপ্রশ্ন ও সমাধান

Set by
Probashi Kallyan Bank
Post
Programmer
Exam date
2019
Questions
40 (40 MCQ, 0 written)
Exam guide
Bank IT jobs · ব্যাংকের আইটি চাকরি
  • Networking · নেটওয়ার্কিং 10
  • Programming · প্রোগ্রামিং 7
  • Software Engineering · সফটওয়্যার ইঞ্জিনিয়ারিং 6
  • Database · ডেটাবেজ 5
  • General ICT · সাধারণ আইসিটি 3
  • Digital Logic · ডিজিটাল লজিক 2
  • Web Technology · ওয়েব টেকনোলজি 2
  • Algorithms · অ্যালগরিদম 1
  • Cloud & Emerging Tech · ক্লাউড ও উদীয়মান প্রযুক্তি 1
  • Cyber Security · সাইবার নিরাপত্তা 1
  • Data Structures · ডেটা স্ট্রাকচার 1
  • Mathematics · গণিত 1
Question 1Digital Logic

The number of bits in the 'BCD' code used in computing is-

  • a)seven bits
  • b)twelve bits
  • c)eighteen bits
  • d)six bits (correct answer)
Answer and explanation

Correct answer: (d) six bits

Read as a character code "used in computing", BCD is the six-bit code (also called BCDIC) that IBM used on its early computers for digits, upper-case letters and some special characters. Six bits give 2⁶ = 64 code patterns: the low four bits carry the digit value, as in ordinary BCD, and two extra zone bits mark letters and symbols. IBM's later 8-bit EBCDIC (1964) was built on this code.

Why the other options are wrong

  • (a) seven bits: 7 bits is the size of standard ASCII, a different character code; the BCD character code has six.
  • (b) twelve bits: 12 bits is three 4-bit BCD digits (enough for 000–999), not the size of the code itself.
  • (c) eighteen bits: 18 bits would be three 6-bit BCD characters; no BCD code uses 18 bits for one symbol.

Exam note: In digital logic, "BCD" normally means 8421 BCD, which uses 4 bits per decimal digit (59 → 0101 1001). 4 is not among these options, so this paper must mean the old six-bit BCD character code. If a question asks how many bits one BCD digit needs, the answer is 4.

Tip: BCD digit = 4 bits; old IBM BCD character code = 6 bits; EBCDIC = 8 bits.

Source: HyperPhysics (Georgia State University): Binary Coded Decimal; Wikipedia: BCD (character encoding)

Question 2Programming

Which of the following provides a programmer with the facility of using object of a class inside other classes?

  • a)Inheritance
  • b)Abstraction
  • c)Encapsulation
  • d)Composition

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 3Programming

Type of software which is designed for users to customize programs is-

  • a)freeware
  • b)shareware
  • c)macros (correct answer)
  • d)none of these
Answer and explanation

Correct answer: (c) macros

A macro is a series of commands and instructions grouped into a single command that carries out a task automatically. Programs such as Word and Excel let users record or write macros (in VBA) and attach them to a button or keyboard shortcut, so each user can automate repetitive work and customize the program to fit the way they work. Of the options, only macros exist to let users customize programs.

Why the other options are wrong

  • (a) freeware: Software that is given away free of charge. The term describes price and licensing, not customization.
  • (b) shareware: Software distributed free on a trial basis, with payment expected for continued use or full features. It is also a distribution model.
  • (d) none of these: Wrong, because (c) fits.

Tip: Freeware/shareware = how software is distributed; macros = how users automate and customize it.

Source: Create or run a macro - Microsoft Support

Question 4Database

A major challenge in mixing SQL with a general-purpose language is the mismatch in the

  • a)Definition of data
  • b)Manipulation of data
  • c)Execution of data
  • d)Output of data

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 5General ICT

In user facilities, copying of all records onto a main store from permanent store is considered as-

  • a)delete file
  • b)rename file
  • c)save file
  • d)load file

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 6Networking

To divide a class C network into a maximum of 14 subnets – each capable of having up to 14 hosts, the subnet mask used should be:

  • a)255.255.255.0
  • b)255.255.255.192
  • c)255.255.255.240
  • d)255.255.255.78

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 7Database

If the master and transaction files have keys in the same order, then it takes___

  • a)less time
  • b)more time
  • c)many hours
  • d)many days

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 8Networking

What is not an advantage of IPv6 over IPv4?

  • a)Longer address
  • b)Classification of traffic
  • c)More real IP addresses
  • d)Jumbo Payload

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 9Programming

What is the precedence of arithmetic operators (from highest to lowest)?

  • a)%,+,/,*,-
  • b)+,-,%,*,/
  • c)%,+,-,*,/
  • d)%,*,/,+,-

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 10Database

Once the connection is set up, the program can send SQL commands to the database by using

  • a)SQLExcelConn
  • b)SQLDirect
  • c)SQLExecDirect
  • d)SQLConnect

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 11Database

A file used to update information in a computer's master file is classified as

  • a)transaction file (correct answer)
  • b)direct file
  • c)order file
  • d)sequence file
Answer and explanation

Correct answer: (a) transaction file

A master file is the permanent, up-to-date file (for example, all customer accounts with their balances). A transaction file collects the changes that happen over a period (deposits, withdrawals, new or closed accounts). At update time, the transaction file is matched with the master file on a key such as the account number, and the changes are applied to produce the new master.

Why the other options are wrong

  • (b) direct file: Describes how a file is organised and accessed (records reached directly by address or key), not the role of holding updates.
  • (c) order file: Not a standard file classification; at most it would be an application file holding customer orders.
  • (d) sequence file: Also a type of file organisation (records stored one after another in key order). A transaction file may be sequential, but "sequential" does not describe its purpose.

Tip: Master = permanent data; transaction = changes that update the master.

Source: UPDATE command overview - IBM SPSS Statistics documentation

Question 12Software Engineering

Testing of software with actual data and in actual environment is known as-

  • a)Regression testing
  • b)Beta testing
  • c)Alpha testing
  • d)None of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 13Programming

What are the values of the following expressions? 2** (3**2), (2**3) **2, 2**3**2

  • a)64, 512, 64
  • b)64, 64, 64
  • c)512, 512, 512
  • d)512, 64, 512

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 14Cyber Security

Special set of characters that computer associates with specific user identification is classified as___.

  • a)password
  • b)identity code
  • c)inquiry code
  • d)dump code

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 15Web Technology

What will be the output of the following PHP code? <?php "Hello World" ?>

  • a)Error
  • b)Hello World
  • c)Nothing
  • d)None of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 16Programming

What is the output of the code shown?

'%(qty)d more %(food)s' % {'qty':1, 'food':'spam'}
  • a)Error
  • b)1 more spam
  • c)No output
  • d)1 more foods

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 17Networking

To check to see if the Web server you are trying to reach is available or is down, which command line utility should you use?

  • a)PING
  • b)ICS
  • c)Telnet
  • d)None of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 18Networking

A device which converts digital signals into sound and sound from telephone handset into digital signals is classified as-

  • a)digital coupler
  • b)analogue coupler
  • c)acoustic coupler
  • d)terminal coupler

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 19Networking

___ provides a connection-oriented reliable service for sending messages.

  • a)TCP
  • b)IP
  • c)UDP
  • d)None of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 20Networking

What type of network provides access to the regional service providers and typically spans distances greater than 100 miles?

  • a)LAN
  • b)MAN
  • c)WAN
  • d)WLAN

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 21Web Technology

Which of the following types is not supported for mobile application viewing for Google Docs?

  • a)Spreadsheets
  • b)Word processor files
  • c)Database files
  • d)All of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 22Data Structures

The terms push and pop are related to the-

  • a)array
  • b)stacks
  • c)lists
  • d)All of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 23Algorithms

Interleaving of records to form one file containing all records is classified as___.

  • a)merging
  • b)finding
  • c)file learning
  • d)searching

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 24Networking

Type of error which occurs when data is transferred from one device to another is classified as-

  • a)transmission error
  • b)interval error
  • c)software error
  • d)discontinued error

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 25Software Engineering

Program background, program functions and computing requirements are part of-

  • a)decision box
  • b)statement box
  • c)operations detail
  • d)none of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 26Software Engineering

A Non-Functional Software testing is done to check if the user interface is easy to use and understand-

  • a)Security Testing
  • b)Unit testing
  • c)Black Box Testing
  • d)Usability Testing

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 27Digital Logic

A device that allows one of several analog or digital input signals to be selected and transmits the selected input into a single medium is called-

  • a)signal changer
  • b)multiplexer
  • c)de-multiplexer
  • d)digital transmitter

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 28Networking

Which of the following media is used for broadband local networks?

  • a)Coaxial
  • b)Optic fiber
  • c)CATV (correct answer)
  • d)DUTP
Answer and explanation

Correct answer: (c) CATV

In LAN terminology, a broadband network sends analog (RF) signals and uses frequency-division multiplexing to put many independent channels on one cable. The cable used for this is the 75 Ω CATV (cable-television) coaxial cable, the same broadband coax that delivers many TV channels to homes. The IEEE 802.3 broadband Ethernet, 10BROAD36, also runs on this broadband coaxial cable.

Why the other options are wrong

  • (a) Coaxial: Too general. Baseband LANs such as 10BASE5 and 10BASE2 also use (50 Ω) coaxial cable; the medium that specifically defines broadband LANs is CATV coax.
  • (b) Optic fiber: Fibre is used for LAN backbones, but it is not the classic broadband (multi-channel RF) LAN medium.
  • (d) DUTP: Twisted pair (UTP) carries a single baseband digital signal in LANs such as 10BASE-T; it is not a broadband LAN medium.

Tip: Baseband LAN: one digital signal on 50 Ω coax or twisted pair. Broadband LAN: many FDM channels on 75 Ω CATV coax.

Source: SECL 1.0 Glossary (Cisco)

Question 29Programming

A variable which uses the same name in the whole program and in all its routines is thus best classified as-

  • a)middle variable
  • b)default variable
  • c)local variable
  • d)global variable

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 30General ICT

Issuance of cash through terminal outside bank is an example of-

  • a)terminals
  • b)interfaces
  • c)hardware devices
  • d)telecommunication

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 31Networking

Any hardware or software which is used to connect two devices by enabling them to communicate is classified as-

  • a)analogue modem
  • b)digital modem
  • c)analogue interface
  • d)interface

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 32Software Engineering

The name of the testing which is done to make sure the existing features are not affected by new changes

  • a)Recursive testing
  • b)Regression testing
  • c)Whitebox testing
  • d)Unit testing

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 33Database

A set of numbers used to check that all records of a group are within the limits of the data is classified as-

  • a)variable check
  • b)decimal check
  • c)type check
  • d)range check

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 34General ICT

Process of converting data or information into a form which is readily available for processing is called-

  • a)encoding
  • b)decoding
  • c)translating
  • d)data organization

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 35Mathematics

All decimal values and integers are included in set of

  • a)whole numbers
  • b)natural numbers
  • c)real numbers
  • d)integers

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 36Software Engineering

Waterfall model phase in which system design is prepared and this system design helps in specifying system requirements and defining the overall system architecture is-

  • a)planning
  • b)modeling
  • c)construction
  • d)communication

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 37Software Engineering

Which of the following is not a Software Development Life Cycle Phase?

  • a)Test Closure (correct answer)
  • b)Coding
  • c)Testing
  • d)None of these
Answer and explanation

Correct answer: (a) Test Closure

Test closure belongs to the test process (often called the Software Testing Life Cycle, STLC), not to the SDLC itself. The ISTQB Foundation syllabus lists the test process as groups of activities (planning, monitoring and control, analysis, design, implementation, execution and completion) and says test completion usually happens at project milestones such as a release or the end of an iteration. There it archives testware, shuts down the test environment, records lessons learned and issues a test completion report.

Why the other options are wrong

  • (b) Coding: a core SDLC phase in which the design is implemented as source code.
  • (c) Testing: also an SDLC phase; the STLC lives inside it.
  • (d) None of these: wrong because (a) is not an SDLC phase.

Exam note: ISTQB syllabus v4.0.1 calls this activity "test completion"; "test closure" is the older name for the same step.

Tip: a phase with the word "Test" in its name (test planning, test execution, test closure) is usually an STLC step.

Source: ISTQB Certified Tester Foundation Level Syllabus v4.0.1

Question 38Programming

Language compilers and interpreters do not translate statements correctly when they have ____

  • a)transcription error
  • b)base errors
  • c)syntax error
  • d)logical error

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 39Cloud & Emerging Tech

Which of the following web service can be controlled by iAWSManager cloud app from an iPhone?

  • a)EC2
  • b)ELB
  • c)SQS
  • d)All of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 40Networking

Five components that make up a data communications system are message, sender, receiver, medium and-

  • a)Code
  • b)Connecting device
  • c)Protocol
  • d)All of these

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question text is from the public recruitment exam; answers and explanations are written by ARBS Academy. All past papers · Bank IT jobs guide