This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 17 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 17 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the transformation of requests and results from one level to another called? A) Mapping. B) Schema. C) Data Independence. D) None of the above. Show Answer Correct Answer: A) Mapping. 2. Lock:A mechanism that restricts ..... to a data item. A) Creation. B) Deletion. C) Access. D) Modification. Show Answer Correct Answer: C) Access. 3. What is an ER diagram and what are its basic components? A) Entities, attributes, and diagrams. B) Attributes, relationships, and tables. C) Entities, relationships, and keys. D) The basic components of an ER diagram include entities, attributes, and relationships. Show Answer Correct Answer: D) The basic components of an ER diagram include entities, attributes, and relationships. 4. What are the main types of SQL joins? A) EXTERNAL JOIN, INNER OUTER JOIN, LEFT OUTER JOIN. B) CROSS JOIN, SELF JOIN, NATURAL JOIN. C) JOIN ALL, PARTIAL JOIN, COMPOSITE JOIN. D) INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN. Show Answer Correct Answer: D) INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN. 5. Which command would you use to remove a column from an existing table in SQL? A) DROP COLUMN. B) REMOVE COLUMN. C) DELETE COLUMN. D) ALTER COLUMN. Show Answer Correct Answer: A) DROP COLUMN. 6. Which clause is used to filter groups created by the GROUP BY clause? A) ORDER BY. B) LIMIT. C) HAVING. D) WHERE. Show Answer Correct Answer: C) HAVING. 7. What is the maximum number of characters allowed in text field is access? A) 65000. B) 256. C) 255. D) 64000. Show Answer Correct Answer: C) 255. 8. In a banking system within a certain Ethiopian business banks, two transactions attempt to withdraw from the same account simultaneously. Which technique helps prevent data inconsistency? A) Implementing Two-Phase Locking (2PL). B) Running both transactions in parallel. C) Creating more database indexes. D) Using a NoSQL database. Show Answer Correct Answer: A) Implementing Two-Phase Locking (2PL). 9. Hey there, database wizards! Can you help ALYA MAISARA, AISYAH NAJIHAH, and ANIS SOFIA figure out the different normal forms in database normalization? A) 1NF, 2NF, 3NF, 6NF. B) 1NF, 2NF, 3NF, 5NF, 8NF. C) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. D) 1NF, 2NF, 3NF, 4NF, 7NF. Show Answer Correct Answer: C) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. 10. What is the output of a Cartesian product? A) Multiple relations. B) No records. C) Single relation. D) Combined records. Show Answer Correct Answer: D) Combined records. 11. What is the purpose of the domain relational calculus? A) To simplify queries. B) To create new schemas. C) To use domain variables. D) To define relations. Show Answer Correct Answer: C) To use domain variables. 12. Which of the following is a disadvantage of a database system compared to a traditional file-processing system? A) Lower data integrity. B) Increased data redundancy. C) Greater complexity and higher initial cost. D) Poor data security. Show Answer Correct Answer: C) Greater complexity and higher initial cost. 13. What are primary keys and foreign keys in a database? A) Primary keys are used for indexing data only. B) Primary keys uniquely identify records in a table; foreign keys link records between tables. C) Primary keys can be duplicated across tables. D) Foreign keys are used to store images in a database. Show Answer Correct Answer: B) Primary keys uniquely identify records in a table; foreign keys link records between tables. 14. A company needs to generate monthly sales reports from its database. Which DBMS function would be primarily involved in storing the report definitions and related data entry forms? A) Data storage management. B) Data transformation and presentation. C) Data dictionary management. D) Data encryption. Show Answer Correct Answer: A) Data storage management. 15. A website developer wants to create a dynamic web application that updates content without reloading the page. Which web technology should he/she use? A) FTP. B) AJAX. C) HTML5. D) CSS3. Show Answer Correct Answer: B) AJAX. 16. What is one advantage of RDBMS? A) It is always slow. B) It can handle large amounts of data. C) It is only for small data. D) It does not allow data security. Show Answer Correct Answer: B) It can handle large amounts of data. 17. Which of the following is an example of agricultural database usage? A) Crop disease prediction system. B) Online video streaming. C) Image editing. D) Computer game design. Show Answer Correct Answer: A) Crop disease prediction system. 18. What is the purpose of the UNION operator in SQL? A) To create a new table in the database. B) To sort the result set in ascending order. C) To filter records based on specified conditions. D) To combine the results of two or more SELECT statements into a single result set. Show Answer Correct Answer: D) To combine the results of two or more SELECT statements into a single result set. 19. What does the MAX function do? A) Calculates the average. B) Finds the maximum value. C) Counts values. D) Finds the minimum value. Show Answer Correct Answer: B) Finds the maximum value. 20. A ..... does not have a distinguishing attribute if its own and most are dependent entities, which are part of some another entity. A) Weak entity. B) Dependent entity. C) Non-attributes entity. D) Strong entity. Show Answer Correct Answer: A) Weak entity. 21. Which of the following is used to sort the result set in SQL? A) SORT BY. B) GROUP BY. C) ORDER BY. D) ARRANGE BY. Show Answer Correct Answer: C) ORDER BY. 22. What is information? A) Processed data B) Unorganized facts C) A type of hardware D) A programming language A) A) Processed data. B) A type of software. C) A method of communication. D) Random numbers. Show Answer Correct Answer: A) A) Processed data. 23. What is the purpose of the DISTINCT keyword in SQL? A) To sort the result set in ascending order. B) To join two or more tables together. C) To filter records based on specified conditions. D) To retrieve unique values from a column in a table. Show Answer Correct Answer: D) To retrieve unique values from a column in a table. 24. What type of integrity constraint ensures that every attribute has a specific range of values? A) Referential Integrity Constraints. B) Entity Constraints. C) Domain Constraints. D) Key Constraints. Show Answer Correct Answer: C) Domain Constraints. 25. What is the main role of the 'conceptual schema' in database architecture? A) To define the physical storage details of the data. B) To provide different user views of the database. C) To define the overall logical structure of the database, independent of its physical storage. D) To manage the permissions and access controls for all users. Show Answer Correct Answer: C) To define the overall logical structure of the database, independent of its physical storage. 26. The following diagram shows: A) Total specialization. B) Partial specialization. C) The overlap rule. D) Subtype discriminator. Show Answer Correct Answer: D) Subtype discriminator. 27. Ted is creating a database for several customers. What is the data type for the field customer name? A) Data. B) Number. C) Yes/No. D) Currency. Show Answer Correct Answer: A) Data. 28. RDBMS is less expensive to set up compared to NoSQL databases. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 29. The SQL ALTER TABLE command is used to: A) Delete records from a table. B) Create a new table. C) Change the database name. D) Modify the structure of a table. Show Answer Correct Answer: D) Modify the structure of a table. 30. NoSQL databases are known for their rigid schema designs. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 31. Which query language is used for relational databases? A) SQL. B) HTML. C) XML. D) NoSQL. Show Answer Correct Answer: A) SQL. 32. What describes the physical structure of the database? A) Internal or Physical level. B) Conceptual or Logical level. C) External or View level. D) None of the above. Show Answer Correct Answer: A) Internal or Physical level. 33. What is a drawback of the cost of conversion to a DBMS? A) Ease of transitioning existing applications. B) Smooth integration with legacy systems. C) Low training costs for staff. D) Employment of specialist staff for conversion. Show Answer Correct Answer: D) Employment of specialist staff for conversion. 34. Why might "Data Independence" be an important topic in the context of "Levels of Data Representation" ? A) It allows changes in data structure without affecting application programs. B) It helps in designing user interfaces. C) It improves internet speed. D) It increases the size of the database. Show Answer Correct Answer: A) It allows changes in data structure without affecting application programs. 35. What is the function of a Database Administrator (DBA)? A) Develop software applications. B) Design database tables. C) Manage and maintain the database system. D) Write SQL queries. Show Answer Correct Answer: C) Manage and maintain the database system. 36. Explain the concept of referential integrity. A) Referential integrity ensures that foreign keys in a database correctly reference primary keys in related tables, maintaining data consistency. B) Referential integrity allows any foreign key to reference any table. C) Referential integrity is the process of deleting all records in a database. D) Referential integrity ensures that all tables in a database are identical. Show Answer Correct Answer: A) Referential integrity ensures that foreign keys in a database correctly reference primary keys in related tables, maintaining data consistency. 37. Select a query that retrieves all of the unique courses from the student table? A) SELECT DISTINCT coursename FROM studentinfo;. B) SELECT DISTINCT coursename FROM TABLE studentinfo;. C) SELECT INDIVIDUAL coursename FROM studentinfo;. D) SELECT UNIQUE coursename FROM studentinfo;. Show Answer Correct Answer: A) SELECT DISTINCT coursename FROM studentinfo;. 38. What are rows and columns in the context of RDBMS? A) Rows are vertical records and columns are horizontal fields in a table. B) Rows are horizontal records and columns are vertical fields in a table. C) Rows are fields and columns are records in a table. D) Rows are vertical fields and columns are horizontal records in a table. Show Answer Correct Answer: B) Rows are horizontal records and columns are vertical fields in a table. 39. Minimal data redundancy in databases means: A) Data is not shared. B) No control over redundancy. C) Reduced instances of data duplication. D) Increased data duplication. Show Answer Correct Answer: C) Reduced instances of data duplication. 40. Which are the two ways in which entities can participate in a relationship? A) Passive and active. B) Total and partial. C) Simple and Complex. D) All of the above. Show Answer Correct Answer: B) Total and partial. 41. When data is stored, maintained and retrieved from multiple tables then special database software are required called ..... A) DBMS. B) RDBMS. C) Special DBMS. D) All of the above. Show Answer Correct Answer: B) RDBMS. 42. What is an advantage of using indexes in a DBMS? A) They eliminate redundancy. B) They are always free. C) They enable fast lookups. D) They require no training. Show Answer Correct Answer: C) They enable fast lookups. 43. A table is in the ..... if only candidate keys are the determinants. A) Transitive dependency. B) 3NF. C) BCNF. D) Functional dependency. Show Answer Correct Answer: C) BCNF. 44. What is the purpose of the ALTER TABLE statement in SQL? A) To retrieve data from a table. B) To delete a table from the database. C) To modify an existing table structure. D) To create a new table in the database. Show Answer Correct Answer: C) To modify an existing table structure. 45. In a database system, the term 'schema' refers to: A) A snapshot of the data at a particular instant. B) The physical structure of the database. C) The overall logical structure of the database. D) The data types used in the database. Show Answer Correct Answer: C) The overall logical structure of the database. 46. Instagram uses which DBMS to store large-scaled distributed data? A) Microsoft SQL Server. B) PostgreSQL. C) MongoDB. D) Cassandra. Show Answer Correct Answer: D) Cassandra. 47. Which DBMS does Lyft use to handle real-time data related to rides and driver locations? A) Amazon DynamoDB. B) MySQL. C) Redis. D) Neo4j. Show Answer Correct Answer: A) Amazon DynamoDB. 48. Which of the following is an example of markup languages? A) HTML. B) Python. C) JavaScript. D) PHP. Show Answer Correct Answer: A) HTML. 49. Define the term 'database'. A) A database is a collection of random files stored on a computer. B) A database is a type of software used for web browsing. C) A database is a physical location where data is kept. D) A database is an organized collection of structured data stored electronically. Show Answer Correct Answer: D) A database is an organized collection of structured data stored electronically. 50. ..... :Security, performance tuning, backup, recovery, and access control. A) DBA Responsibilities. B) Data Models. C) SQL Queries. D) Database Tables. Show Answer Correct Answer: A) DBA Responsibilities. 51. The three-schema architecture of a database consists of which of the following levels? A) Internal, External, and Conceptual. B) Physical, Logical, and Relational. C) System, User, and Administrator. D) Table, Row, and Column. Show Answer Correct Answer: A) Internal, External, and Conceptual. 52. What should you do if you are unsure how to resolve a data discrepancy? A) Contact medical staff to discuss the discrepancy. B) Ignore the discrepancy and continue with the process. C) Correct the data without consulting anyone. D) Delete the incorrect data from the system. Show Answer Correct Answer: A) Contact medical staff to discuss the discrepancy. 53. What happens if a database is poorly designed? A) Faster processing. B) Redundant data and poor decision-making. C) Easier backups. D) Improved queries. Show Answer Correct Answer: B) Redundant data and poor decision-making. 54. Which of the following is NOT a function of a Database Management System? A) Data storage, retrieval, and update. B) Data security and integrity management. C) Word processing and document editing. D) Backup and recovery management. Show Answer Correct Answer: C) Word processing and document editing. 55. Network databases are more common than hierarchical databases. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 56. In MS Access, a form is primarily used for: A) Entering and viewing data conveniently. B) Running background calculations. C) Deleting unwanted records. D) Creating relationships between tables. Show Answer Correct Answer: A) Entering and viewing data conveniently. 57. ..... :Responsible management of data. A) Data Visualization. B) Data Encryption. C) Data Mining. D) Data Stewardship. Show Answer Correct Answer: D) Data Stewardship. 58. Cisco uses which DBMS to track network performance data? A) HBase. B) Snowflake. C) Neo4j. D) InfluxDB. Show Answer Correct Answer: D) InfluxDB. 59. At the external level of database abstraction, what is the user primarily concerned with? A) The physical storage of data. B) The network configuration. C) The internal database design. D) The data returned to their view level. Show Answer Correct Answer: D) The data returned to their view level. 60. Open Office base is not an open source software.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: B) B. False. ← PreviousNext →Related QuizzesScience QuizzesClass 12 QuizzesClass 12 Computer Science Chapter 3 Database Management Systems Quiz 1Class 12 Computer Science Chapter 3 Database Management Systems Quiz 2Class 12 Computer Science Chapter 3 Database Management Systems Quiz 3Class 12 Computer Science Chapter 3 Database Management Systems Quiz 4Class 12 Computer Science Chapter 3 Database Management Systems Quiz 5Class 12 Computer Science Chapter 3 Database Management Systems Quiz 6Class 12 Computer Science Chapter 3 Database Management Systems Quiz 7Class 12 Computer Science Chapter 3 Database Management Systems Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books