IBPS RRB IT Officer Quiz 2026, 200 IT Knowledge and Computer Q’s

1. Which normal form specifically removes transitive dependencies on a non-key attribute?

2. In a relational database, which constraint ensures that a foreign-key value either matches a candidate-key value in the referenced table or is NULL where allowed?

3. Which SQL operation combines rows from two relations based on a related attribute and returns only matching rows from both sides?

4. A database transaction moves from the active state to which state immediately after its final statement executes successfully, before the commit becomes durable?

5. Which ACID property guarantees that concurrent transactions behave as though they were executed serially?

6. In B+ trees used for database indexing, where are actual record pointers typically stored?

7. Which index is most appropriate when a table column has very low cardinality, such as a status field with only a few possible values?

8. Which database anomaly occurs when deleting one tuple unintentionally removes the only stored fact about another entity?

9. In SQL, which clause filters groups after GROUP BY has been applied?

10. Which concurrency-control technique orders conflicting operations according to transaction timestamps and may roll back transactions that violate that order?

11. A schedule is conflict-serializable if its precedence graph is:

12. Which RAID level provides block-level striping with distributed parity and can tolerate the failure of any one disk?

13. Which DBMS component is primarily responsible for choosing an efficient execution plan for a SQL query?

14. What is a materialized view?

15. Which property of a candidate key requires that no proper subset of the key can uniquely identify a tuple?

16. Which OS scheduling algorithm can cause starvation of low-priority processes unless aging is used?

17. In virtual memory, a page fault occurs when:

18. Which page-replacement algorithm is theoretically optimal because it replaces the page that will not be used for the longest time in the future?

19. What is the necessary condition for deadlock represented by a process holding at least one resource while waiting for additional resources?

20. Which technique lets an operating system move an entire process temporarily from main memory to secondary storage?

21. A semaphore initialized to 1 is commonly used as a:

22. Which scheduling metric is the total time from process submission to process completion?

23. Which of the following is a non-preemptive CPU scheduling algorithm in its standard form?

24. The primary purpose of a Translation Lookaside Buffer (TLB) is to:

25. Thrashing in a virtual-memory system is characterized by:

26. At which OSI layer does IP operate?

27. Which transport-layer protocol provides connection-oriented, reliable byte-stream delivery?

28. Which protocol maps an IPv4 address to a MAC address on a local network?

29. Which protocol is used by a host to obtain an IP configuration automatically from a server?

30. Which subnet mask corresponds to a /26 IPv4 prefix?

31. Which unit performs arithmetic and logical operations inside the CPU?

32. Which of the following is volatile memory?

33. Which memory retains its contents when power is removed?

34. What is the smallest unit of digital information?

35. How many bits are in one byte?

36. Which device is primarily used to convert a paper document into digital image data?

37. Which of the following is an output device?

38. Which hardware component provides long-term solid-state storage in a computer?

39. Which storage medium uses magnetic platters?

40. Which port is commonly used for modern digital audio/video connection to a monitor or TV?

41. Which device connects a computer to a network and has a hardware MAC address?

42. What is the primary function of a UPS?

43. Which term refers to the physical components of a computer system?

44. Which type of software manages hardware resources and provides services to application programs?

45. Which is an example of application software?

46. Which software is designed to detect and remove malicious programs?

47. Which software translates an entire high-level source program into machine code before execution?

48. Which software translates and executes source code statement by statement?

49. Which system software controls a specific hardware device and lets the OS communicate with it?

50. The BIOS/UEFI firmware is typically responsible for:

51. Which Windows keyboard shortcut is commonly used to copy selected content?

52. Which Windows keyboard shortcut is commonly used to paste copied or cut content?

53. Which shortcut is commonly used to undo the last action in many Windows applications?

54. Which shortcut is commonly used to save the current document?

55. Which shortcut is commonly used to select all content in a document or window?

56. In Microsoft Word, which feature is used to create personalized letters for many recipients using a common template and a data source?

57. In Microsoft Word, which feature records insertions, deletions, and formatting edits for review?

58. In Microsoft Word, a header normally appears:

59. Which Microsoft Word view is most suitable for seeing how a document will appear when printed?

60. Which Word feature copies formatting from one selection and applies it to another?