StudyXT

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 ...

10 Multiple Choice Questions (MCQs) related to  Code Optimization , useful for UGC NET, SET, and GATE exams: 1. What is the main purpose of code optimization in a compiler? A) Convert source code to machine code B) Improve the execution speed and reduce resource usage C) Detect syntax errors D) Allocate memory for variables Explanation: Code optimization aims to enhance the performance of the compiled code by reducing execution time, memory usage, and power consumption . Answer: B) Improve the execution speed and reduce resource usage 2. Which of the following is NOT a type of code optimization? A) Peephole Optimization B) Loop Optimization C) Syntax Checking D) Constant Folding Explanation: Syntax Checking is part of syntax analysis , not code optimization. Answer: C) Syntax Checking 3. Which of the following is an example of local optimization? A) Loop Unrolling B) Constant Folding C) Register Allocation D) Dead Code Elimination Explanat...

10 Multiple Choice Questions (MCQs) related to  Intermediate Code Generation , useful for UGC NET, SET, and GATE exams: 1. What is the main purpose of intermediate code generation in a compiler? A) Convert high-level code to machine code B) Generate an intermediate representation for optimization and portability C) Detect syntax errors D) Allocate memory for variables Explanation: Intermediate code generation creates an intermediate representation (IR) that is machine-independent , allowing for optimization and easier translation to machine code. Answer: B) Generate an intermediate representation for optimization and portability 2. Which of the following is NOT an intermediate representation format? A) Abstract Syntax Tree (AST) B) Three-Address Code (TAC) C) Postfix Notation D) Machine Code Explanation: Machine code is the final output of compilation, not an intermediate representation . Answer: D) Machine Code 3. Which of the following is a charac...

10 Multiple Choice Questions (MCQs) related to  Semantic Analysis , useful for UGC NET, SET, and GATE exams: 1. What is the primary function of semantic analysis in a compiler? A) Checking syntax errors B) Checking logical errors C) Checking type mismatches and undefined variables D) Optimizing the code Explanation: Semantic analysis ensures that the program is meaningfully correct by checking type mismatches, undeclared variables, and function usage . Answer: C) Checking type mismatches and undefined variables 2. Which of the following errors is detected during semantic analysis? A) Missing semicolons B) Type mismatches C) Unrecognized tokens D) Invalid operator precedence Explanation: Semantic analysis checks for type mismatches, undeclared variables, and incompatible function calls . Answer: B) Type mismatches 3. What is the primary data structure used in semantic analysis? A) Parse Tree B) Symbol Table C) Stack D) Linked List Explanatio...

10 Multiple Choice Questions (MCQs)  related to   Syntax Analysis , useful for UGC NET, SET, and GATE exams: 1. What is the primary function of syntax analysis in a compiler? A) Checking token validity B) Checking grammatical structure C) Optimizing code D) Allocating memory Explanation: Syntax Analysis (Parsing) ensures that the sequence of tokens follows the grammar of the programming language. Answer: B) Checking grammatical structure 2. Which data structure is commonly used in syntax analysis? A) Queue B) Stack C) Linked List D) Hash Table Explanation: Parsers use a stack to keep track of grammar rules and parsing states . Answer: B) Stack 3. Which type of grammar is used for syntax analysis? A) Regular Grammar B) Context-Free Grammar C) Context-Sensitive Grammar D) Unrestricted Grammar Explanation: Context-Free Grammar (CFG) is used in syntax analysis to define language structure . Answer: B) Context-Free Grammar 4. W...

10 Multiple Choice Questions (MCQs)  related to  Lexical Analysis , suitable for UGC NET, SET, and GATE exams: 1. What is the main function of the lexical analyzer in a compiler? A) Syntax checking B) Semantic checking C) Token generation D) Code optimization Explanation: The Lexical Analyzer scans the input program and converts it into tokens , which are the basic building blocks for syntax analysis. Answer: C) Token generation 2. Which of the following is NOT performed during lexical analysis? A) Removing white spaces B) Removing comments C) Checking for syntax errors D) Identifying keywords and identifiers Explanation: Syntax error checking is done in the Syntax Analysis phase, not in Lexical Analysis . Answer: C) Checking for syntax errors 3. What type of errors are detected in the lexical analysis phase? A) Syntax errors B) Lexical errors C) Semantic errors D) Logical errors Explanation: Lexical errors include invalid tokens , un...

10 questions related to compiler phases , suitable for UGC NET, SET, and GATE exams, along with their descriptions: 1. Which phase of the compiler is responsible for removing comments and white spaces? A) Syntax Analysis B) Lexical Analysis C) Semantic Analysis D) Code Optimization Explanation: The Lexical Analysis phase scans the input source code and removes comments and white spaces while converting it into tokens. Answer: B) Lexical Analysis 2. What is the primary purpose of syntax analysis in a compiler? A) Checking grammatical structure B) Checking for type mismatches C) Generating intermediate code D) Allocating memory Explanation: Syntax Analysis (Parsing) ensures that the program follows the correct grammatical structure as per the language’s rules. Answer: A) Checking grammatical structure 3. In which compiler phase is a syntax tree generated? A) Lexical Analysis B) Syntax Analysis C) Semantic Analysis D) Code Generation Explanation...

Now a days kids are growing up with technology at their fingertips. While communication apps help children stay connected with family and friends, safety remains a top concern for parents. Unregulated platforms can expose children to inappropriate content, online predators, and cyberbullying. That’s why choosing a kid-friendly chat app with parental controls is essential. To help parents find the best options, we’ve compiled a list of the top five safest chat apps for kids that offer safe and controlled environment. 1. Messenger Kids (By Meta) Best for: Safe video calls and text messaging with parental supervision Features: Parents approve all contacts No ads or in-app purchases Fun filters, stickers, and games Monitored messaging and activity reports Why It’s Safe: Messenger Kids is designed for children under 13 and requires parental approval for every contact. Parents can monitor chats and control screen time through the Parent Dashboard. Download Messenger Kids 2...

System calls are mechanism that allows a user-level program to request a service from the operating system's kernel. Users can access various services using system calls. These services can include operations like file management, process control, memory allocation, and hardware interaction, which are not directly accessible by user. Common system calls that are frequently asked in competitive exams like UGC NET , GATE , STATE SET , and others, categorized based on their functionality: 1. Process Control System Calls fork() - Creates a new process. exec() - Replaces the current process image with a new one. wait() - Waits for a child process to terminate. waitpid() - Waits for a specific child process. exit() - Terminates the process. getpid() - Gets the process ID. getppid() - Gets the parent process ID. nice() - Changes the priority of a process. kill() - Sends a signal to a process. setuid() - Sets the user ID of the process. getuid() - Gets the user ID....

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...

10 multiplechoice questions related to Nyaya philosophy, which is a school of Indian logic for UGC-NET: Q1: Who is considered the founder of the Nyaya school of philosophy?  A) Patanjali  B) Gautama (Gotama)  C) Shankaracharya  D) Jaimini Answer: B) Gautama (Gotama) Q2: The foundational text of the Nyaya school is known as:  A) Yoga Sutras  B) Nyaya Sutras  C) Brahma Sutras  D) Samkhya Sutras Answer: B) Nyaya Sutras Q3: The primary concern of Nyaya philosophy is:  A) Yoga practices  B) Rituals and sacrifices  C) Logic and epistemology  D) Devotional practices Answer: C) Logic and epistemology Q4: Which of the following is NOT one of the four main Pramanas recognized by the Nyaya school?  A) Pratyaksha (Perception)  B) Anumana (Inference)  C) Upamana (Comparison)  D) Smriti (Memory) Answer: D) Smriti (Memory) Q5: In Nyaya philosophy, "Anumana" refers to:  A) Direct perception  B) Inference  C) ...

P revious year questions (PYQ)  and description related to various statistical tests from UGC NET and other competitive exams: 1. T-Test (UGC NET June 2023) Question: Which of the following tests is appropriate to compare the means of two independent groups ? A) Z-Test B) Chi-Square Test C) Independent T-Test D) ANOVA Answer: C) Independent T-Test Explanation: The Independent T-Test is used to compare the means of two independent groups to determine whether there is a significant difference between them. 2. Chi-Square Test (UGC NET December 2022) Question: The Chi-Square Test for Independence is used to test the relationship between: A) Two categorical variables B) Two continuous variables C) One categorical and one continuous variable D) Three continuous variables Answer: A) Two categorical variables Explanation: The Chi-Square Test for Independence checks whether there is a relationship between two categorical variables (e.g., gender and voting preference...

10 previous year questions (PYQ) related to the types of research from the UGC NET exam : 1. UGC NET June 2023 Question: Which of the following is an example of applied research ? A) Developing a new theory of motivation B) Investigating the relationship between stress and performance C) Designing a new teaching method to improve student learning D) Studying the historical development of educational policies Answer: C) Designing a new teaching method to improve student learning Description: Applied research aims to solve practical problems or improve existing practices. 2. UGC NET December 2022 Question: Qualitative research is characterized by: A) Numerical data analysis B) Subjective interpretation C) Experimental manipulation D) Statistical testing Answer: B) Subjective interpretation Description: Qualitative research focuses on understanding phenomena through subjective analysis rather than numerical data. 3. UGC NET June 2022 Question: What is the prima...

Multiple-choice questions (MCQs) on UGC-NET research methodology, along with their answers: 1. Which of the following is NOT a method of data analysis? a) Qualitative method b) Quantitative method c) Mixed method d) Subjective method Answer: d) Subjective method 2. Inductive reasoning involves drawing conclusions from: a) General principles to specific cases b) Specific observations to broader generalizations c) Hypotheses to data d) Theories to experiments Answer: b) Specific observations to broader generalizations 3. In research, a hypothesis must be: a) Vague and general b) Testable and specific c) Complex and untestable d) Based on assumptions Answer: b) Testable and specific 4. Which of the following is an example of qualitative data analysis? a) Calculating statistical percentages b) Narrative exploration c) Performing t-tests d) Computing mean and median Answer: b) Narrative exploration 5. The primary purpose of exploratory research is to: a) Test s...

Here are some UGC NET Research Methodology multiple-choice questions 1. The research that aims at immediate application is: a) Action Research b) Empirical Research c) Conceptual Research d) Fundamental Research. Answer: a) Action Research. 2. Deconstruction is a popular method of research in: a) Basic Science b) Applied Science c) Social Science d) Literature Answer: d) Literature. 3. Identify the correct sequence of research steps: a) Selection of topic, review of literature, data collection, interpretation of findings b) Review of literature, selection of topic, data collection, and interpretation of findings c) Selection of topic, data collection, review of literature, interpretation of findings d) Selection of topic, review of literature, interpretation of findings, data collection Answer: a) Selection of topic, review of literature, data collection, interpretation of findings. 4. The principles of fundamental research are used in: a) Action research b) App...

PYQ  related to Data Structures for UGC NET, SET, GATE, ASSISTANT PROFESSOR COMPUTER SCIENCE GATE CS 2020 Which of the following data structures is best suited for implementing a priority queue? A) Stack B) Queue C) Heap D) Linked List Answer: C) Heap Explanation: A heap allows efficient insertions and deletion of the highest priority element in O(log n) time. UGC NET 2021 Which data structure uses the concept of LIFO (Last In, First Out) ? A) Queue B) Stack C) Linked List D) Tree Answer: B) Stack Explanation: A stack follows the LIFO principle, where the last element inserted is the first to be removed. ISRO Scientist 2018 Which traversal technique in a binary tree uses a queue data structure? A) In-order Traversal B) Pre-order Traversal C) Post-order Traversal D) Level-order Traversal Answer: D) Level-order Traversal Explanation: Level-order traversal of a binary tree uses a queue to process nodes level by level. GATE CS 2019 Which of the...

MCQ questions related to Stack  for UGC NET, SET, GATE AND ASSISTANT PROFESSOR etc.. GATE CS 2019 Which of the following is the correct postfix form of the expression (A + B) * (C - D) ? A) AB+CD-* B) AB+ CD- C) AB+CD- D) ABCD-+* Answer: A) AB+CD-* UGC NET 2020 Which of the following operations can result in stack underflow ? A) Push B) Pop C) Peek D) IsEmpty Answer: B) Pop ISRO Scientist 2018 What is the maximum number of parentheses that can be correctly matched using a stack? A) n B) 2n C) n/2 D) Infinite Answer: A) n NIELIT Scientist B 2017 Which of the following expressions correctly represents the reverse of a string using a stack ? A) Push all characters and pop them one by one B) Pop all characters and push them again C) Enqueue and dequeue D) Sort the characters Answer: A) Push all characters and pop them one by one GATE CS 2020 Which of the following data structures is used by the compiler for syntax parsing ? A) Stack B) Queu...

  MCQ questions related to Queue with descriptions for UGC NET, SET, GATE AND ASSISTANT PROFESSOR etc.. GATE CS 2019 Which of the following data structures is best suited for Breadth-First Search (BFS) ? A) Stack B) Queue C) Priority Queue D) Linked List Answer: B) Queue Description: BFS explores neighbors level by level. A queue efficiently supports this by enqueuing and dequeuing nodes in the order they are discovered. UGC NET 2020 Which type of queue allows insertion and deletion from both ends ? A) Simple Queue B) Circular Queue C) Double-Ended Queue (Deque) D) Priority Queue Answer: C) Double-Ended Queue (Deque) Description: A deque (double-ended queue) supports insertion and deletion from both front and rear ends, making it versatile for various applications. ISRO Scientist 2018 What is the time complexity of the enqueue() and dequeue() operations in a queue implemented using a linked list? A) O(1) B) O(n) C) O(log n) D) O(n²) Answer: A)...