Loading...
Sonali Bank PLC

Post: Assistant Database Administrator
Date: 23.02.24
1. Justify: “Invention of Transistor changed the world.”

The invention of the transistor revolutionized electronics and computing.

• It replaced bulky and unreliable vacuum tubes, making devices much smaller and more efficient.
• Transistors consume less power and generate less heat, increasing reliability.
• It enabled the development of modern computers, smartphones, and digital systems.
• It made possible the creation of integrated circuits (ICs) and microprocessors.
• It contributed to the rapid growth of the information technology industry.

Conclusion:
Without the transistor, today’s advanced technology, including computers, mobile devices, and the internet, would not exist. Hence, it truly changed the world.

2. Draw the truth table from the follwoing circuit (2 bit input A,B full adder with carry bit Cin)
InputsOutputs
ABCinS (Sum)Cout (Carry)
00000
00110
01010
01101
10010
10101
11001
11111

S= A⊕B⊕Cin
Cout= AB+Cin(A⊕B)

3. Ensure secure communication between a client application and the database server.

To ensure secure communication between a client application and a database server, the following measures should be taken:

  • Encryption (SSL/TLS): Use SSL/TLS protocols to encrypt data during transmission.
  • Authentication: Verify user identity using strong authentication methods (username/password, MFA).
  • Authorization: Ensure proper access control so users can only access permitted data.
  • Use Secure Connections: Avoid plain-text connections; always use secure database connections (e.g., HTTPS, secure ports).
  • Firewall Protection: Restrict database access only to trusted IP addresses.
  • Regular Updates: Keep database software and security patches up to date.
  • VPN: Use Virtual Private Network for secure remote access.

Client application এবং database server-এর মধ্যে নিরাপদ যোগাযোগ নিশ্চিত করতে নিচের বিষয়গুলো অনুসরণ করা উচিত:

  • Encryption (SSL/TLS): Data transmission-এর সময় SSL/TLS ব্যবহার করে data encrypt করা।
  • Authentication: শক্তিশালী user verification (username/password, MFA) ব্যবহার করা।
  • Authorization: User যেন শুধুমাত্র অনুমোদিত data access করতে পারে তা নিশ্চিত করা।
  • Secure Connection: Plain-text connection ব্যবহার না করে secure connection ব্যবহার করা।
  • Firewall Protection: শুধুমাত্র trusted IP থেকে database access দেওয়া।
  • Regular Update: Database software এবং security patch update রাখা।
  • VPN ব্যবহার: Remote access-এর জন্য secure VPN ব্যবহার করা।
4. What is normalization in a database? If needed, draw an ER diagram using containers.

Normalization in Database:
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It divides large tables into smaller related tables and defines relationships between them.

Goals of Normalization:
• Eliminate duplicate data
• Ensure data consistency
• Improve database structure

Common Normal Forms:
• 1NF → Remove repeating groups
• 2NF → Remove partial dependency
• 3NF → Remove transitive dependency

Before Normalization (Unnormalized ER/Table):
Problem:
• Data redundancy (same student & course repeated)
• Update anomaly
• Insertion/deletion problem

After Normalization (ER Diagram):

• STUDENT and COURSE are separate tables (normalized)
• ENROLLMENT table removes redundancy and maintains relationship
• No redundancy
• Better structure
• Easy update, insert, delete

5. Simplify the Boolean algebra: Q = C' + A'B + BC'(B' + C) and draw a logic circuit.


Logic Circuit:

6. What is the primary motivation for transitioning from classful IP addressing to classless IP addressing?

The primary motivation for moving from classful IP addressing to classless IP addressing (CIDR) was to use IP addresses more efficiently

  • Address Wastage: Classful addressing allocated fixed-size blocks, leading to large wastage of IP addresses.
  • Flexibility: CIDR allows flexible allocation of IP addresses based on actual need.
  • Routing Efficiency: CIDR reduces the size of routing tables by using route aggregation.
  • Scalability: Helps support the rapid growth of the internet.
  • Better Utilization: Ensures optimal use of available IP address space.

Classful IP addressing থেকে CIDR (classless)-এ যাওয়ার মূল উদ্দেশ্য ছিল IP address-এর সঠিক ও efficient ব্যবহার নিশ্চিত করা

  • Address Wastage: Classful পদ্ধতিতে fixed block দেওয়ায় অনেক IP address অপচয় হতো।
  • Flexibility: CIDR প্রয়োজন অনুযায়ী IP address বরাদ্দ করতে দেয়।
  • Routing Efficiency: Route aggregation-এর মাধ্যমে routing table ছোট হয়।
  • Scalability: Internet দ্রুত বড় হওয়ার সাথে মানিয়ে নিতে সাহায্য করে।
  • Better Utilization: IP address-এর সর্বোত্তম ব্যবহার নিশ্চিত করে।
7. Write a program for the following series: e^x = 1 + x/1! + x²/2! + x³/3! + ...
#include <stdio.h>
int main() {
    int n, i;
    float x, sum = 1, term = 1;
    printf("Enter value of x: ");
    scanf("%f", &x);
    printf("Enter number of terms: ");
    scanf("%d", &n);
    // Calculate series
    for (i = 1; i <= n; i++) {
        term = term * x / i;   // x^i / i!
        sum = sum + term;
    }
    printf("Value of e^x = %.4f\n", sum);
    return 0;
}

You must subscribe & Login to view more.

Don’t have an account? Register

Or your subscription is under review by admin. Please message on WhatsApp / Telegram.

Leave a Comment

Latest Post
Field Based Job Question & Solution
Bank IT Job Solution

MCQ + Written from Bangladesh Bank, Sonali, Combined Bank IT recruitment.

BPSC IT Job Solution

BPSC Computer/IT cadre & non-cadre post Question papers with full solutions.

Gas Field IT Job Solution

Gas field like TGTDCL, BGDCL, JGTDSL, KGDCL, SGCL, RPGCL, GTCL etc. question solution

Power Sector IT Job Solution

Power sector such as NESCO, DESCO, DPDC, WZPDCL, BPDB, PGCB, BREB etc

Other IT Job Solution

Other Govt. Semi govt. organization like BCC, BTCL, CAAB, NSI etc.

NTRCA IT Job Solution (upcoming)

NTRCA ICT-related posts such as Assistant Teacher, Demonstrator, Lecturer.

IT MCQ Job Solution

Collected MCQ Job solution of BANK, BPSC, POWER SECTOR, GAS Field and Others.

Topic Based Q&S
WhatsApp Telegram Messenger