StudyXT

10 multiple-choice questions on the boot process in operating systems for ISRO, EMRS, GATE, KV, NET, and other exams. Question 1: Boot Process Definition Q1: The boot process is the sequence of events that occurs: A) When a user logs out B) When the system is powered on and the operating system is loaded C) When an application is opened D) When the system goes to sleep Answer: B) When the system is powered on and the operating system is loaded Explanation: The boot process refers to the series of steps that occur when a computer is turned on, including hardware initialization, loading the operating system, and preparing the system for use. Question 2: First Step in Boot Process Q2: The first step in the boot process is typically: A) Loading the operating system kernel B) Initializing system hardware C) Running the BIOS or UEFI firmware D) Loading device drivers Answer: C) Running the BIOS or UEFI firmware Explanation: When a computer starts, ...

10 multiple-choice numerical questions on paging in operating systems for UGC NET, SET, ISRO and Other exam. Question 1: Page Size Calculation Q1: If a system uses a 32-bit address space and a page size of 4 KB, how many pages are there in the address space? A) 1024 B) 4096 C) 1048576 D) 262144 Answer: C) 1048576 Explanation: The number of pages is calculated as: Total address space Page size = 2 32  bytes 2 12  bytes = 2 20 = 1048576  pages \frac{\text{Total address space}}{\text{Page size}} = \frac{2^{32} \text{ bytes}}{2^{12} \text{ bytes}} = 2^{20} = 1048576 \text{ pages} Question 2: Number of Frames Q2: If the physical memory is 1 GB and the page size is 4 KB, how many frames are available in the physical memory? A) 256 B) 1024 C) 256000 D) 262144 Answer: D) 262144 Explanation: The number of frames is given by: Physical memory Page size = 1  GB 4  KB = 2 30  bytes 2 12  b...

Most asked MySQL MCQs focused on Table and Join Operations Output for UGC NET, SET, EMRS, KVS, ISRO, and Assistant Professor exams. 21. Given the following tables, what will be the output of an INNER JOIN? Customers Table CustomerID Name City 1 Alice Delhi 2 Bob Mumbai 3 Charlie Kolkata Orders Table OrderID CustomerID Product 101 1 Laptop 102 2 Mobile 103 4 Tablet Query: SELECT Customers.Name, Orders.Product FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID; A) Returns all customers with their respective orders B) Returns customers who have placed orders C) Returns all customers, even if they don’t have an order D) Returns all orders, even if they don’t have a customer Answer: B) Returns customers who have placed orders (Output: Alice - Laptop, Bob - Mobile) 22. What will a LEFT JOIN return when there is no matching row in the right table? A) NULL values for the right table columns B) E...

 Here are 10 more MySQL MCQs for UGC NET, SET, EMRS, KVS, ISRO, and Assistant Professor exams. 11. What is the purpose of the HAVING clause in MySQL? A) It filters records before grouping B) It filters records after grouping C) It is used to rename columns D) It is used to join tables Answer: B) It filters records after grouping 12. Which MySQL function is used to count the number of rows in a table? A) COUNT() B) SUM() C) TOTAL() D) NUMBER() Answer: A) COUNT() 13. What does the FOREIGN KEY constraint do in MySQL? A) Ensures unique values in a column B) Links a column to a primary key in another table C) Automatically increments a column value D) Restricts NULL values in a column Answer: B) Links a column to a primary key in another table 14. Which command is used to create a backup of a MySQL database? A) BACKUP DATABASE B) SAVE DATABASE C) mysqldump D) EXPORT DATABASE Answer: C) mysqldump 15. Which MySQL JOIN returns only matching rows from bot...

Top MySQL MCQs for UGC NET, SET, EMRS, KVS, ISRO, and Assistant Professor and other competitive exams... 1. Which of the following is true about MySQL? A) MySQL is an open-source database management system B) MySQL is a NoSQL database C) MySQL does not support relational database features D) MySQL is a proprietary database Answer: A) MySQL is an open-source database management system 2. What is the default storage engine used by MySQL as of version 5.5? A) MyISAM B) InnoDB C) HEAP D) CSV Answer: B) InnoDB 3. Which command is used to view all databases in MySQL? A) SHOW DATABASES; B) DISPLAY DATABASES; C) LIST DATABASES; D) VIEW DATABASES; Answer: A) SHOW DATABASES; 4. Which data type is used to store large text data in MySQL? A) VARCHAR B) TEXT C) INT D) BLOB Answer: B) TEXT 5. What is the function of the AUTO_INCREMENT attribute in MySQL? A) Automatically increases a column value when a new row is inserted B) Decreases the column value after every ...

Here are 10 multiple-choice questions related to synchronization in DBMS with their answers: Question 1: Synchronization Definition Q1: Synchronization in DBMS is primarily concerned with: A) Improving the speed of transactions B) Ensuring data consistency and integrity when multiple transactions are executed concurrently C) Optimizing storage space D) Enhancing the user interface Answer: B) Ensuring data consistency and integrity when multiple transactions are executed concurrently Question 2: Race Condition Q2: A race condition in DBMS occurs when: A) Multiple transactions compete for CPU time B) The outcome of transactions depends on the non-deterministic timing of events C) Transactions are executed in a sequential manner D) The system runs out of memory Answer: B) The outcome of transactions depends on the non-deterministic timing of events Question 3: Lock-Based Protocols Q3: Which of the following is a lock-based protocol used for synchronization? A) Two-Phase Lo...

Here are 10 multiple-choice questions related to deadlock prevention in DBMS with their answers: Question 1: Deadlock Definition Q1: A deadlock in DBMS occurs when: A) Multiple transactions wait indefinitely for each other to release resources B) A single transaction is completed C) A transaction is rolled back D) The database is updated Answer: A) Multiple transactions wait indefinitely for each other to release resources Question 2: Deadlock Prevention Techniques Q2: Which of the following is a technique used for deadlock prevention? A) Wait-Die Scheme B) Two-Phase Commit C) Data Replication D) Shadow Paging Answer: A) Wait-Die Scheme Question 3: Resource Allocation Graph Q3: In the context of deadlock prevention, a Resource Allocation Graph (RAG) is used to: A) Schedule transactions B) Detect cycles and potential deadlocks C) Optimize queries D) Manage memory Answer: B) Detect cycles and potential deadlocks Question 4: Wait-Die Scheme Q4: In the Wait-Die Scheme...

Here are 10 multiple-choice questions related to Database Management Systems (DBMS) with their answers: Question 1: Definition of DBMS Q1: A Database Management System (DBMS) is primarily used for: A) Data processing B) Managing databases C) Compiling programs D) Controlling hardware devices Answer: B) Managing databases Question 2: Types of DBMS Q2: Which of the following is NOT a type of DBMS? A) Hierarchical B) Network C) Relational D) Graphical Answer: D) Graphical Question 3: SQL Q3: SQL stands for: A) Standard Query Language B) Sequential Query Language C) Structured Query Language D) Simple Query Language Answer: C) Structured Query Language Question 4: Primary Key Q4: In a relational database, a primary key is: A) A unique identifier for each record B) A field that allows duplicate values C) A field that stores large text D) A field that links to another table Answer: A) A unique identifier for each record Question 5: Normalization Q5: The process o...