Skip to content
Past paper

NESCO Junior Assistant Manager (ICT) Exam: 2021 (BUET)প্রশ্ন ও সমাধান

Set by
NESCO
Post
Junior Assistant Manager (ICT)
Exam date
2021
Conducted by
BUET
Questions
4 (0 MCQ, 4 written)
Exam guide
Government IT officer posts · সরকারি প্রতিষ্ঠানের আইটি পদ
  • Database · ডেটাবেজ 1
  • Programming · প্রোগ্রামিং 1
  • Software Engineering · সফটওয়্যার ইঞ্জিনিয়ারিং 1
  • Web Technology · ওয়েব টেকনোলজি 1
Written question 1Web Technology

What is the difference between http session and http cookies?

Model answer

Cookies are small pieces of data stored on the client (browser); a session is server-side state tied to a client via a session identifier, usually delivered through a cookie.

Aspect Cookie Session
Storage location Client-side (browser) Server-side
Lifetime Set explicitly via an expiry date/max-age; can persist across browser restarts Typically ends when the browser closes or after a configured timeout
Size limit About 4KB per cookie Limited only by server memory
Dependency Independent of any session Usually depends on a cookie (the session ID) to identify the client
Clearing it No dedicated unset function - cleared by setting an already-expired date via setcookie() Cleared explicitly, e.g. session_destroy() in PHP
Security Readable/editable by the client unless flagged HttpOnly/Secure - less secure by default Data lives on the server, only an opaque ID is exposed to the client - generally more secure
  • A typical flow: the server creates a session on the server and sends the client a cookie containing only the session ID; the browser resends that cookie on every request so the server can look up the matching session data.
  • Practical rule: never store sensitive data (passwords, full card numbers) directly in a cookie - store only an opaque session ID, keep the real data server-side in the session.

Exam takeaway: cookie means client-side, size-limited, no dedicated unset function; session means server-side, backed by a cookie carrying just its ID, cleared via a destroy call - sessions are inherently more secure since the actual data never leaves the server.

Written question 2Database

emp [e_id, e_name, dept_id, salary, DOB], dept [dept_id, city, dept_name]; প্রত্যেকটি Department এর নাম এবং ঐ Department এর employee দের গড় Salary দেখার SQL Query লিখ।

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

Written question 3Programming

Find Output:

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

Written question 4Software Engineering

1 জন ব্যক্তি 1টি Bank Account খোলার জন্য একটি form fillup করেন। এরপর তাতে Manager স্বাক্ষর করেন। এবার উক্ত Account-এ ঐ ব্যক্তি কিছু টাকা Deposit করলে Account সচল হয়। এই Process টি DFD এর মাধ্যমে প্রকাশ করুন।

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