📊 Computer Awareness Quiz for Banking Exams (2024-2025)
Test your knowledge with these 50 MCQs covering essential computer concepts for IBPS, RRB, RBI, SBI, NABARD and other competitive examinations. 🚀
1. 🖥️ What are the uses of Structured Query Language (SQL)?
🔹 [A] Creating Databases
🔹 [B] Creating & Modifying Databases
🔹 [C] Creating, Modifying & Querying Databases
🔹 [D] None of the above
Notes: SQL is a standard computer language for managing data in RDBMS. It allows interaction with databases in all necessary ways - creating, modifying and querying them.
2. 🌐 BSNL, Reliance, Shaw cable, AOL, Tata Indicom all can be kept in which one of the following groups?
🔹 [A] ISDN
🔹 [B] IRC
🔹 [C] ISP
🔹 [D] Icons
Notes: All are internet service providers.
3. 🔢 In context with the dotted number format used in the IPv4, which among the following is NOT possible?
🔹 [A] 128.0.0.1
🔹 [B] 255.152.0.0
🔹 [C] 259.1.1.268
🔹 [D] 202.102.4.4
Notes: In IPv4 dotted format, none of the four numbers can exceed 256.
4. 💾 One nibble is equal to _?
🔹 [A] 4 Bits
🔹 [B] 4 Bytes
🔹 [C] 8 Bytes
🔹 [D] 8 Kilo Bytes
Notes: A nibble is a four-bit aggregation, or half an octet, corresponding to a single hexadecimal digit.
5. 🧠 Which of the following lies within the CPU?
🔹 [A] Primary Memory
🔹 [B] Secondary Memory
🔹 [C] Mouse
🔹 [D] Keyboard
Notes: Primary memory resides within the CPU while secondary memory is external to it.
6. ⚙️ What are the components of the Central Processing Unit?
🔹 [A] Control Unit
🔹 [B] Arithmetic Logic Unit
🔹 [C] Memory
🔹 [D] All of the above
Notes: Control Unit, Arithmetic Logic Unit and Memory together form the CPU.
7. 🏛️ Which of the following was considered as the world's first fully automatic digital computer?
🔹 [A] Z2
🔹 [B] Z1
🔹 [C] Z3
🔹 [D] None of the above
Notes: Konrad Zuse made the Z3, the first fully automatic digital and electromechanical programmable computer built with 2000 relays.
8. 🧮 With which scientist is the discovery of first practical mechanical calculator associated?
🔹 [A] Gottfried Leibniz
🔹 [B] Blaise Pascal
🔹 [C] George Boole
🔹 [D] Charles Babbage
Notes: Blaise Pascal invented the Pascaline, the first practical mechanical calculator to help his tax-collector father.
9. ⏱️ Which is the first programmable analog computer?
🔹 [A] South-Pointing Chariot
🔹 [B] Planisphere
🔹 [C] Castle Clock
🔹 [D] Astrolabe
Notes: The hydro-powered Castle Clock by Al-Jazari was the first programmable analog clock.
10. 💻 Which of the following machines were referred to as 1977 trinity?
🔹 [A] Commodore PET
🔹 [B] Apple II
🔹 [C] TRS-80
🔹 [D] All of the above
Notes: Commodore PET, Apple II and TRS-80 together were called the 1977 Trinity of personal computers.
11. 🔥 Which of the following issues clearly points to the overheating of the system?
🔹 [A] Abrupt Shut Downs
🔹 [B] Blue Screen Crashes
🔹 [C] Freezes
🔹 [D] All of the Above
Notes: Overheating can cause abrupt shutdowns, blue screen crashes, and freezes due to internal circuit issues or cooling mechanism failure.
12. 🛠️ A set of changes to a computer program designed to update, fix, or improve it. What is this called?
🔹 [A] Patching
🔹 [B] Bugging
🔹 [C] Defragmentation
🔹 [D] All of the Above
Notes: A patch is a software update that patches code into an executable program.
13. 🔌 What feature allows a spare monitor from a different manufacturer to work when the original breaks?
🔹 [A] Standardization
🔹 [B] Firmware
🔹 [C] Plug and play
🔹 [D] Componentization
Notes: Standardization maximizes compatibility between different manufacturers' components.
14. 💿 What is the full form of UDF?
🔹 [A] Universal data frequency
🔹 [B] Unique disk format
🔹 [C] Universal disk format
🔹 [D] Undated disk format
Notes: UDF is a file system for broad range of storage media maintained by OSTA.
15. 🖥️ What is Plan 9 from Bell labs?
🔹 [A] Distributed operating system
🔹 [B] First release in 2015
🔹 [C] Both A and B
🔹 [D] None of the Above
Notes: Plan 9 is a distributed OS originating from Bell Labs in mid-1980s.
16. ⏳ Which scheduling technique is most widely used in time-shared OS?
🔹 [A] Round Robin
🔹 [B] Shortest Job First
🔹 [C] Elevator
🔹 [D] First Come First Serve
Notes: Round Robin assigns time slices equally in circular order for fairness.
17. 🔗 Which system software resolves externally defined symbols?
🔹 [A] Loader
🔹 [B] Linker
🔹 [C] Compiler
🔹 [D] Assembler
Notes: Linker combines object files into executable programs.
18. 📈 Which is numerical computing software for scientists?
🔹 [A] MATLAB
🔹 [B] EDGE
🔹 [C] Excel
🔹 [D] Arc
Notes: MATLAB is multi-paradigm numerical computing environment by MathWorks.
19. 🗄️ What are basic components of relational database model?
🔹 [A] Table
🔹 [B] Record
🔹 [C] Field
🔹 [D] All of the Above
Notes: RDBMS consists of tables containing records made of fields.
20. 📜 What are the three rules to find logically implied functional dependencies called?
🔹 [A] Reflexivity Rules
🔹 [B] Normalization Rules
🔹 [C] W. Armstrong's Axioms
🔹 [D] Closure Rules
Notes: Armstrong's axioms test logical implication of functional dependencies.
21. 📅 What is the full form of PIM?
🔹 [A] Personal Information Manager
🔹 [B] Personal Insensitive Marketing
🔹 [C] Public Illegal Software Managing
🔹 [D] Personal Information Module
Notes: PIM is application software that functions as personal organizer.
22. 🌊 What defines the Ripple effect in software?
🔹 [A] System reaction to abnormal conditions
🔹 [B] Change in one area affects others
🔹 [C] Adapting components to contexts
🔹 [D] All of the Above
Notes: Ripple effect measures how changes propagate through a program.
23. 🔤 What are the two categories of Low Level Languages?
🔹 [A] Machine & Assembly Level
🔹 [B] Algorithms & Assembly Level
🔹 [C] Assembly & Binary Level
🔹 [D] Machine Level & Algorithms
Notes: Machine language is direct hardware code, Assembly is slightly more user-friendly.
24. 🏢 Which are examples of ORDBMS?
🔹 [A] PostgreSQL
🔹 [B] Greenplum
🔹 [C] SQL Server
🔹 [D] All of the Above
Notes: PostgreSQL, Oracle, Informix, SQL Server, Greenplum are ORDBMS examples.
25. 🎯 What does CAP Theorem conclude about distributed systems?
🔹 [A] Consistency
🔹 [B] Availability
🔹 [C] Partition Tolerance
🔹 [D] All of the Above
Notes: CAP Theorem states distributed systems can't simultaneously guarantee Consistency, Availability, and Partition Tolerance.
26. 📊 Which normal form is based on functional dependency?
🔹 [A] 1NF
🔹 [B] 2NF
🔹 [C] 3NF
🔹 [D] All of the Above
Notes: 3NF requires non-prime attributes to be non-transitively dependent on every super key.
27. 🌍 What defines a Wide Area Network?
🔹 [A] Larger than LAN
🔹 [B] Internet is biggest WAN
🔹 [C] Fast message transmission
🔹 [D] All of the Above
Notes: WAN spans large geographical areas using telephone lines, fiber optics or satellites.
28. 📶 What is wireless communication over short distances called?
🔹 [A] Wireless LAN
🔹 [B] Local Area Wireless Network
🔹 [C] Both A and B
🔹 [D] None of the Above
Notes: WLAN/LAWN provides wireless communication using radio or infrared signals.
29. 🖇️ In OSI model, where is bridging performed?
🔹 [A] Layer 7
🔹 [B] Data Link Layer
🔹 [C] Session Layer
🔹 [D] Transport Layer
Notes: Bridging creates aggregate networks from multiple segments at Data Link Layer.
30. 🔁 What device receives and retransmits signals at higher level?
🔹 [A] Hub
🔹 [B] Repeater
🔹 [C] Switch
🔹 [D] HIDS
Notes: Repeater receives and retransmits signals to cover longer distances.
31. 🌐 Which internet connection is always on?
🔹 [A] Dial-up
🔹 [B] ISDN
🔹 [C] DSL
🔹 [D] All of the above
Notes: DSL (Digital Subscriber Line) maintains constant connection without dialing.
32. 👁️ Which protocol monitors networks?
🔹 [A] POP3
🔹 [B] TCP
🔹 [C] SNMP
🔹 [D] HTTP
Notes: Simple Network Management Protocol monitors networks and components.
33. 🕸️ Which browser has largest market share?
🔹 [A] Edge
🔹 [B] Chrome
🔹 [C] Safari
🔹 [D] Firefox
Notes: Google Chrome holds about 62% worldwide browser market share.
34. 💼 Which is employment-oriented social network?
🔹 [A] Viber
🔹 [B] Pinterest
🔹 [C] Linkedin
🔹 [D] Line
Notes: LinkedIn is for professional networking, job postings and CVs.
35. 📱 Which apps are in Opera mobile store?
🔹 [A] iOS apps
🔹 [B] Android apps
🔹 [C] Java apps
🔹 [D] All of the above
Notes: Opera Mobile Store has apps for iOS, Java, BlackBerry, Symbian, Windows Mobile, Android.
36. 🗣️ What is Windows 10's virtual assistant called?
🔹 [A] Riya
🔹 [B] Siri
🔹 [C] Cortana
🔹 [D] Nancy
Notes: Cortana is Microsoft's virtual assistant for Windows 10 and other platforms.
37. 📄 What shortcut creates new document in MS Word?
🔹 [A] Ctrl + W
🔹 [B] Shift + N
🔹 [C] Ctrl + N
🔹 [D] Alt + N
Notes: Ctrl+N creates new document; also available in File menu.
38. 🖨️ Where is print option in MS Word?
🔹 [A] File
🔹 [B] Edit
🔹 [C] Tools
🔹 [D] Review
Notes: Print and Print preview are under File menu (Ctrl+P shortcut).
39. ✏️ Where is Track Changes in MS Word?
🔹 [A] Page Layout
🔹 [B] Review
🔹 [C] Insert
🔹 [D] View
Notes: Track Changes in Review tab's Tracking group records edits.
40. 📊 What does Shift+F11 do in Excel?
🔹 [A] Deletes workbook
🔹 [B] Deletes current sheet
🔹 [C] Inserts new sheet
🔹 [D] Inserts new row
Notes: Shift+F11 quickly adds new worksheet in Excel.
41. 🕰️ When was Google search launched?
🔹 [A] 1996
🔹 [B] 1998
🔹 [C] 1999
🔹 [D] 2001
Notes: Google launched in 1998 by Larry Page and Sergey Brin is now most visited website.
42. 🏢 Which is not MS Office product?
🔹 [A] Office Sway
🔹 [B] Office 365 Video
🔹 [C] Open Office
🔹 [D] Delve
Notes: OpenOffice is discontinued open-source suite, not Microsoft product.
43. 🎤 Which MS Office app enables real-time meetings?
🔹 [A] MS Powerpoint
🔹 [B] MS Excel
🔹 [C] Skype for Business
🔹 [D] MS Project
Notes: Skype for Business enables real-time conferences and meetings.
44. 🗃️ What are MS Access Database objects?
🔹 [A] Form
🔹 [B] Modules
🔹 [C] Tables
🔹 [D] All of the above
Notes: Major Access objects: Tables, Queries, Forms, Reports.
45. 🤖 What is Macro in MS Access?
🔹 [A] Datatype
🔹 [B] Automates tasks
🔹 [C] Creates charts
🔹 [D] None of the above
Notes: Macro automates tasks adding functionality to forms, reports, controls.
46. 🔗 What does OLE in MS Access stand for?
🔹 [A] Object Length Extension
🔹 [B] Object Linking and Embedding
🔹 [C] Object Load Estimate
🔹 [D] None of the above
Notes: OLE is Microsoft technology for embedding/linking documents.
47. 📧 What is email part before '@' called?
🔹 [A] Username
🔹 [B] Password
🔹 [C] Domain
🔹 [D] Website
Notes: Part before @ is mailbox name/username; after @ is domain.
48. 💰 What is RTGS full form?
🔹 [A] Raw Transaction Gaining System
🔹 [B] Real Time Gross Settlement
🔹 [C] Real Time Ground Support
🔹 [D] Readymade Transaction Gross System
Notes: RTGS systems transfer money between banks in real time.
49. 📱 What services does BHIM app offer?
🔹 [A] Transfer via VPA
🔹 [B] Transfer via account number
🔹 [C] Balance Enquiry
🔹 [D] All of the above
Notes: BHIM allows payments via UPI ID/QR/account number, requests money, checks balance.
50. 🇮🇳 What is India's Jan Dhan-Aadhaar-Mobile initiative called?
🔹 [A] MAJ trinity
🔹 [B] AJM trinity
🔹 [C] JAM trinity
🔹 [D] None of the above
Notes: JAM links Jan Dhan accounts, Mobile numbers, Aadhar cards to prevent subsidy leaks.
Post a Comment