Combined Bank (SBL,JBL)

Post: Assistant Database Administrator,
Exam Date: 01/03/2022, Exam Taker: BSC
1. Draw an ER diagram for BPL.
er_diagram_for_bpl
ER_diagram_for_bpl
2. What is distributed database?

Distributed Database

A distributed database is a database in which data is stored across multiple physical locations (different computers or servers) that are connected through a network. Although the data is distributed, it appears to users as a single unified database.

Each site in a distributed database system can process local queries independently and also participate in global queries.

Example: A bank database where customer data is stored in different branch servers located in different cities.

Distributed Database

Distributed database হলো এমন একটি database যেখানে data একাধিক physical location-এ (ভিন্ন computer বা server-এ) সংরক্ষিত থাকে এবং network-এর মাধ্যমে সংযুক্ত থাকে। তবে user-এর কাছে এটি একটি single unified database হিসেবেই দেখা যায়।

এই system-এ প্রতিটি site নিজস্ব local query process করতে পারে এবং একই সাথে global query-তেও অংশ নিতে পারে।

উদাহরণ: একটি bank system যেখানে বিভিন্ন শহরের branch server-এ customer data সংরক্ষিত থাকে।

3. Write the role of a DB administrator.

Role of a Database Administrator (DBA)

A Database Administrator (DBA) is responsible for managing, maintaining, and securing the database system to ensure data availability, integrity, and performance.

  • Database Installation & Configuration: Installs, configures, and upgrades database software.
  • Data Security: Controls user access, permissions, and ensures data protection.
  • Backup & Recovery: Performs regular backups and restores data during failures.
  • Performance Monitoring: Optimizes database performance and handles tuning.
  • Data Integrity: Ensures accuracy and consistency of stored data.

Database Administrator (DBA)-এর ভূমিকা

Database Administrator (DBA) হলো সেই ব্যক্তি যিনি database system পরিচালনা, রক্ষণাবেক্ষণ এবং নিরাপত্তা নিশ্চিত করেন যাতে data সবসময় available, secure এবং consistent থাকে।

  • Database Installation & Configuration: Database software install, configure এবং update করে।
  • Data Security: User access control ও permission manage করে data সুরক্ষিত রাখে।
  • Backup & Recovery: নিয়মিত backup নিয়ে data loss হলে restore করে।
  • Performance Monitoring: Database-এর performance পর্যবেক্ষণ ও tuning করে।
  • Data Integrity: Data-এর accuracy ও consistency নিশ্চিত করে।
4.Unix command (directory listing with hidden files).

Answer:

$ ls -al

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