Skip to content
Past paper

NESCO Assistant Manager (MIS & ICT) Written Test: 2018প্রশ্ন ও সমাধান

Set by
NESCO
Post
Assistant Manager (MIS & ICT)
Exam date
2018
Questions
5 (0 MCQ, 5 written)
Exam guide
Government IT officer posts · সরকারি প্রতিষ্ঠানের আইটি পদ
  • General ICT · সাধারণ আইসিটি 2
  • Algorithms · অ্যালগরিদম 1
  • Database · ডেটাবেজ 1
  • Networking · নেটওয়ার্কিং 1
Written question 1Networking

Find Network Address, Broadcast Address, Net mask, valid host of the IP address is: 192.16.13.0/30

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

Written question 2Algorithms

S1, S2, S3, S4, S5 are five nodes and a value on lines denotes the cost to transmit power.

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

Written question 3General ICT

What is E-Commerce? What are the types of E-commerce?

Model answer

Definition: E-commerce (electronic commerce) is the buying, selling, marketing and delivery of goods/services carried out electronically over networks, primarily the internet.

graph TD
  E[E-Commerce] --> B2B[B2B: Business-to-Business]
  E --> B2C[B2C: Business-to-Consumer]
  E --> C2C[C2C: Consumer-to-Consumer]
  E --> C2B[C2B: Consumer-to-Business]
  E --> B2G[B2G: Business-to-Government]
Type Description Example
B2B Businesses trade with other businesses A manufacturer ordering raw material through a supplier portal
B2C Business sells directly to end consumers Daraz, an Amazon retail storefront
C2C Consumers trade with each other via a platform Facebook Marketplace, an eBay listing
C2B Individuals offer goods/services to businesses A freelancer bidding on Upwork/Fiverr
B2G Businesses supply goods/services to government An IT firm winning a government e-tender

Exam takeaway: the classification is based on who is on each side of the transaction — Business, Consumer, or Government.

Written question 4General ICT

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.

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

Written question 5Database

Write an SQL query to insert a tuple in the table: Employee (ID, Name, Designation, and Salary).

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

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