StudyXT

10 multiple-choice questions related to identifying the normal form of a table based on given functional dependencies, useful for UGC NET, SET, GATE, ISRO, and other competitive exams .  Question 1: 1NF Identification Q1: A table with the following structure is given: Attributes: {A, B, C} Functional Dependencies: A → B, A → C Does this table meet the requirements of 1NF? A) Yes, because all attributes are atomic B) No, because there are partial dependencies C) Yes, because there are no repeating groups D) No, because it violates 3NF Answer: A) Yes, because all attributes are atomic Explanation: A table is in 1NF if all its attributes contain atomic values and there are no repeating groups. The given table does not have any repeating groups or multi-valued attributes, so it satisfies the criteria of 1NF. Question 2: 2NF Identification Q2: A table with the following structure is given: Attributes: {A, B, C} Functional Dependencies: A → B, A → C Is thi...

Multiple-Choice Questions on Normalization and Normal Forms in DBMS for UGC NET, GATE, SET, ISRO and other exams  Question 1: Normalization Definition Q1: Normalization in a database is a process of: A) Reducing data redundancy and improving data integrity B) Increasing data redundancy for faster access C) Encrypting the database D) Creating more tables Answer: A) Reducing data redundancy and improving data integrity Explanation: Normalization is a systematic approach to organizing data in a database to minimize redundancy and ensure data integrity. It involves decomposing larger tables into smaller, well-structured tables while maintaining relationships among data. Question 2: First Normal Form (1NF) Q2: A table is in the First Normal Form (1NF) if: A) All values in the table are atomic and there are no repeating groups B) It contains no partial dependencies C) It contains no transitive dependencies D) It is free of all anomalies Answer: A) All value...

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