Notes for BSc CSIT

  Multiple-Choice Questions on Database Management System for IT Officer Exams Database Management System and Its Applications What is a primary function of a Database Management System (DBMS)? a) To design user interfaces b) To manage and organize data efficiently c) To compile application code d) To manage network protocols Answer : b) To manage and organize data efficiently Explanation : A DBMS provides an interface to store, retrieve, and manage data, ensuring data integrity and efficient access. Which application commonly uses a DBMS? a) Word processing b) Banking systems c) Image editing d) Operating system management Answer : b) Banking systems Explanation : DBMS is widely used in banking for managing transactions, customer data, and accounts due to its reliability and security features. ER Modeling What does an entity represent in an ER diagram? a) A relationship between tables b) A real-world object with attributes c) A database query d) A normalization rule Answer : b) A ...

  Multiple-Choice Questions on UGC and TU for Officer Exams UGC and Its Role in Higher Education of Nepal What is the primary objective of the University Grants Commission (UGC) in Nepal? a) To conduct university examinations b) To promote and enhance the quality of higher education c) To manage university admissions d) To appoint university faculty Answer : b) To promote and enhance the quality of higher education Explanation : The UGC, established under the UGC Act (1993), aims to improve higher education quality, support institutions, and meet national workforce needs. Under which act was the UGC of Nepal established? a) Education Act 1971 b) UGC Act 1993 c) TU Act 1992 d) Higher Education Act 1986 Answer : b) UGC Act 1993 Explanation : The UGC was established as an autonomous body under the University Grants Commission Act of 1993 to facilitate higher education development. What is one of the UGC’s key roles in Nepal’s higher education? a) Directly teaching university courses b...

  Multiple-Choice Questions on Operating Systems for IT Officer Exams Operating System and Its Functions What is a primary function of an operating system? a) To compile programs b) To manage hardware and software resources c) To design user interfaces d) To develop applications Answer : b) To manage hardware and software resources Explanation : An operating system acts as an intermediary between hardware and software, managing resources like CPU, memory, and I/O devices. Which operating system function ensures efficient CPU utilization? a) File management b) Process scheduling c) Memory allocation d) Device driver management Answer : b) Process scheduling Explanation : Process scheduling allocates CPU time to processes, ensuring efficient multitasking and resource use. Types of Operating Systems Which type of operating system is designed for time-critical applications like air traffic control? a) Batch OS b) Real-Time OS c) Distributed OS d) Multi-programmed OS Answer : b) Real-Ti...

 Multiple-Choice Questions on Microprocessors and Computer Architecture Microprocessor and Bus System of Microprocessor Based System What is the primary function of the address bus in a microprocessor-based system? a) Transfers data between CPU and memory b) Specifies memory or I/O device locations c) Controls the timing of operations d) Carries power to peripherals Answer: b) Specifies memory or I/O device locations Explanation: The address bus carries the memory address or I/O port number to identify the location for data transfer. Which bus in a microprocessor system is bidirectional? a) Address bus b) Data bus c) Control bus d) System bus Answer: b) Data bus Explanation: The data bus is bidirectional, allowing data to be transferred to and from the CPU, memory, or I/O devices. Intel 8085 Microprocessor Architecture, Programming, and Interfacing How many general-purpose registers are available in the Intel 8085 microprocessor? a) 4 b) 6 c) 8 d) 10 Answer: b) 6 Explanation: The 8...

  Multiple-Choice Questions on Computer Networks and Security Computer Networks, Types of Networks, and Applications Which of the following is NOT a type of computer network? a) LAN b) WAN c) SAN d) MAN Answer : c) SAN Explanation : SAN (Storage Area Network) is a specialized network for data storage, not a general-purpose computer network like LAN, WAN, or MAN. What is a primary application of a Personal Area Network (PAN)? a) Connecting devices in a single office b) Facilitating short-range wireless communication between personal devices c) Supporting enterprise-wide data storage d) Connecting multiple cities Answer : b) Facilitating short-range wireless communication between personal devices Explanation : PANs, such as Bluetooth networks, are used for short-range communication between devices like smartphones and headsets. Layered Network Architecture, OSI and TCP/IP Model How many layers are there in the OSI model? a) 5 b) 6 c) 7 d) 8 Answer : c) 7 Explanation : The OSI model c...

Computer A computer is an electronic device that processes data and performs tasks according to a set of instructions called a program. It is a versatile tool that has become an integral part of modern life. Computers can handle a wide range of tasks, from simple calculations to complex simulations, and they are used in various fields such as education, business, healthcare, entertainment, and research. Characteristics of Computers: 1. Speed: Computers can perform tasks much faster than humans. They can execute millions of instructions per second. 2. Accuracy: Computers provide high levels of accuracy in calculations and data processing, reducing the chances of errors compared to manual methods. 3. Storage: Computers can store large amounts of data in digital format, allowing for easy retrieval and efficient management of information 4. Automation: Computers can perform repetitive tasks automatically, freeing humans to focus on more complex and creative activities. 5. Versatility: Comp...