This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 4 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 4 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. How do records and fields relate in SQL tables? A) Records are keys and fields are values. B) Records are attributes and fields are entities. C) Records are rows and fields are columns. D) Records are columns and fields are rows. Show Answer Correct Answer: C) Records are rows and fields are columns. 2. What is the difference between a report and a form in Access? A) A report is for data entry; a form is for presenting data. B) A report is for presenting data; a form is for data entry. C) A report is used for calculations; a form is for storing data. D) A report is a type of database; a form is a type of query. Show Answer Correct Answer: B) A report is for presenting data; a form is for data entry. 3. A functional dependency is a relationship between or among: A) Tables. B) Relations. C) Rows. D) Attributes. Show Answer Correct Answer: D) Attributes. 4. What are the advantages of using cloud databases? A) Increased maintenance costs. B) Limited storage capacity. C) Complex setup requirements. D) Advantages of using cloud databases include scalability, flexibility, cost-effectiveness, automatic backups, high availability, and remote access. Show Answer Correct Answer: D) Advantages of using cloud databases include scalability, flexibility, cost-effectiveness, automatic backups, high availability, and remote access. 5. Update ..... set columname=value where condition; A) Database name. B) Structurename. C) Fieldname. D) Tablename. Show Answer Correct Answer: D) Tablename. 6. What is a Database Management System (DBMS)? A) A programming language for database queries. B) Software that manages databases. C) A type of hardware used for data storage. D) A method for data encryption. Show Answer Correct Answer: B) Software that manages databases. 7. Database can be physical or digital. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 8. What is the purpose of the JOIN operation in SQL? A) To delete rows from one table. B) To update columns in two tables simultaneously. C) To combine rows from two or more tables based on a related column. D) To create a new table from two existing tables. Show Answer Correct Answer: C) To combine rows from two or more tables based on a related column. 9. What is a flat file database? A) A database where data is stored in multiple interconnected tables. B) A database where all the data is stored in a single table. C) A database that requires constant internet connectivity. D) A database used exclusively for multimedia files. Show Answer Correct Answer: B) A database where all the data is stored in a single table. 10. Which SQL statement is primarily used to retrieve data from a table? A) DELETE. B) UPDATE. C) INSERT. D) SELECT. Show Answer Correct Answer: D) SELECT. 11. RDBMS stands for A) Relational database system. B) Relational database management system. C) Relational management system. D) None of these. Show Answer Correct Answer: B) Relational database management system. 12. An insertion anomaly happens when: A) A table does not have a primary key. B) A table has too many relationships. C) Inserting redundant data occurs. D) A foreign key is missing. Show Answer Correct Answer: C) Inserting redundant data occurs. 13. Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a: A) Decision support system. B) Data dictionary. C) Relational database. D) Database management system (DBMS). Show Answer Correct Answer: D) Database management system (DBMS). 14. Write a SQL query to retrieve the unique records from a table named 'products'. A) RETRIEVE UNIQUE FROM products. B) SELECT DISTINCT * FROM products;. C) GET UNIQUE FROM products. D) SELECT UNIQUE products. Show Answer Correct Answer: B) SELECT DISTINCT * FROM products;. 15. The select operation in a database: A) Combines relational tables. B) Creates a subset consisting of all records that meet stated criteria. C) Creates a subset consisting of columns in a table. D) Identifies the table from which columns will be selected. Show Answer Correct Answer: B) Creates a subset consisting of all records that meet stated criteria. 16. Which common database challenge is illustrated by Sally receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of her full name? A) Data redundancy. B) Data accuracy. C) Data inconsistency. D) Data normalization. Show Answer Correct Answer: A) Data redundancy. 17. What role do entities play in a relational database? A) Entities serve as the primary building blocks in a relational database, defining the structure and relationships of the data. B) Entities are only used for data storage. C) Entities are irrelevant in defining relationships. D) Entities are solely responsible for data retrieval. Show Answer Correct Answer: A) Entities serve as the primary building blocks in a relational database, defining the structure and relationships of the data. 18. Which ACID property would be violated if a transaction writes data that is lost when the system crashes? A) Atomicity. B) Consistency. C) Durability. D) Isolation. Show Answer Correct Answer: A) Atomicity. 19. A ..... represents data as two-dimensional tables. A) Mobile DBMS. B) Non-relational DBMS. C) Hierarchical DBMS. D) Relational DBMS. Show Answer Correct Answer: D) Relational DBMS. 20. ..... is the one who manages the complex database management system. A) DBA. B) BAD. C) GIS. D) GPS. Show Answer Correct Answer: A) DBA. 21. What is the conceptual level in the ANSI three-level architecture? A) The programming interface for the database. B) The user interface for the database. C) The physical storage of data. D) The universal view of the database. Show Answer Correct Answer: D) The universal view of the database. 22. What is the first step in the normalization process? A) Convert to third normal form. B) Convert to first normal form. C) Identify the primary key. D) Create an E-R diagram. Show Answer Correct Answer: B) Convert to first normal form. 23. How can you filter records in a database? A) Using a query with specific conditions. B) Creating a new table. C) Deleting unwanted records. D) Changing the database format. Show Answer Correct Answer: A) Using a query with specific conditions. 24. How would you retrieve the "name" and "email" columns from a table named "users" ? A) RETRIEVE name, email FROM users;. B) SHOW name, email FROM users;. C) GET name, email FROM users;. D) SELECT name, email FROM users;. Show Answer Correct Answer: D) SELECT name, email FROM users;. 25. What does data redundancy refer to? A) The standardization of data formats. B) The process of securing data. C) Duplication of data within a database. D) The ability to share data among users. Show Answer Correct Answer: C) Duplication of data within a database. 26. Which PL/SQL object stores reusable SQL blocks without returning a value? A) Trigger. B) Procedure. C) Function. D) Cursor. Show Answer Correct Answer: B) Procedure. 27. What is a "query" in the context of relational databases? A) A table used to store data. B) A request for data or information from a database. C) A way to define relationships between tables. D) A command that joins two databases. Show Answer Correct Answer: B) A request for data or information from a database. 28. What does concurrency in data sharing refer to? A) The ability to access data sequentially. B) The ability to execute multiple transactions simultaneously. C) The ability to delete data quickly. D) The ability to store data in multiple locations. Show Answer Correct Answer: B) The ability to execute multiple transactions simultaneously. 29. Cascading aborts occur when: A) One rollback causes others to rollback. B) Transactions run serially. C) All commit successfully. D) Deadlock occurs. Show Answer Correct Answer: A) One rollback causes others to rollback. 30. Which one of the following attributes cannot be taken as a primary key? A) ID. B) DepartmentID. C) RegistrationNo. D) Street. Show Answer Correct Answer: D) Street. 31. Which data model represents entities and their relationships? A) Network Model. B) ER Model (Entity Relationship). C) Tabular Model. D) Flat File Model. Show Answer Correct Answer: B) ER Model (Entity Relationship). 32. What does the term 'referential integrity' mean in database relationships? A) A foreign key value must match a primary key in another table. B) Data in a query cannot be updated. C) A database cannot contain more than two tables. D) A field must contain only numbers. Show Answer Correct Answer: A) A foreign key value must match a primary key in another table. 33. Many users access many servers. Why is this statement not a good inclusion in an ER diagram? A) It creates duplicates and therefore redundancy. B) It is not a good idea to access too many servers. C) It is syntactically incorrect. D) It involves a bridging entity. Show Answer Correct Answer: A) It creates duplicates and therefore redundancy. 34. Which of the following is the most prominent data manipulation language today? A) Access. B) DB2. C) SQL. D) None of the above. Show Answer Correct Answer: C) SQL. 35. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as ..... A) Data Model. B) E-R Model. C) DBMS. D) All of the above. Show Answer Correct Answer: D) All of the above. 36. Which of the following is a benefit of using a database? A) It can store only text data. B) It can only be used by one person at a time. C) It allows for efficient data retrieval and management. D) It cannot be updated. Show Answer Correct Answer: C) It allows for efficient data retrieval and management. 37. What is the full form of DDL? A) Data Derivation Language. B) Data Definition Language. C) Dynamic Data Language. D) Detailed Data Language. Show Answer Correct Answer: B) Data Definition Language. 38. Which of the following data types is best suited for storing phone numbers? A) Logical. B) Numeric. C) Text. D) Currency. Show Answer Correct Answer: C) Text. 39. A transaction first checks the price of an item, then updates the item's stock level. Which isolation level guarantees that the price cannot be changed by another transaction between the SELECT and the UPDATE on the same row? A) READ UNCOMMITTED. B) READ COMMITTED. C) REPEATABLE READ. D) ATOMIC. Show Answer Correct Answer: C) REPEATABLE READ. 40. Validation rule to ensure data must be entered into that field ..... A) Is Not Nothing. B) Is Complete. C) Is Not Null. D) Is Not Empty. Show Answer Correct Answer: C) Is Not Null. 41. What is the primary difference between data and information? A) Data is the raw material, while information is the processed output. B) Data is processed, while information is raw facts. C) Data is irrelevant, while information is always accurate. D) Data is always numerical, while information is always descriptive. Show Answer Correct Answer: A) Data is the raw material, while information is the processed output. 42. What is the role of a primary key in a database table? A) To create a relationship between databases. B) To delete unnecessary data. C) To uniquely identify each record. D) To store duplicate values. Show Answer Correct Answer: C) To uniquely identify each record. 43. When you omit the field list in an INSERT statement, what MUST be true? A) All values must be inserted in the correct order. B) A WHERE condition must be used. C) Only text values can be added. D) The table must be empty. Show Answer Correct Answer: A) All values must be inserted in the correct order. 44. List some common data warehousing tools. A) SAP HANA Cloud. B) Some common data warehousing tools are Amazon Redshift, Google BigQuery, Snowflake, Microsoft Azure Synapse Analytics, and Teradata. C) Oracle Data Lake. D) IBM Db2 Warehouse. Show Answer Correct Answer: B) Some common data warehousing tools are Amazon Redshift, Google BigQuery, Snowflake, Microsoft Azure Synapse Analytics, and Teradata. 45. Which of the following is a benefit of using a database over file-based systems? A) Slower processing. B) Complex queries. C) Data Redundancy. D) Data Sharing. Show Answer Correct Answer: D) Data Sharing. 46. What is the focus of a logical ERD? A) Structure and relationships between entities. B) Actual database implementation. C) Only the attributes of entities. D) Data types and constraints. Show Answer Correct Answer: A) Structure and relationships between entities. 47. What does the term 'data abstraction' mean? A) Details of how data is stored. B) Data that is always changing. C) Data that is not important. D) Conceptual representation of data. Show Answer Correct Answer: D) Conceptual representation of data. 48. What is one benefit of using forms in databases? A) They make it harder to work with individual records. B) They offer less flexibility in organizing fields. C) They allow updating parent and child records simultaneously. D) They prevent any updates to records. Show Answer Correct Answer: C) They allow updating parent and child records simultaneously. 49. Which statement best defines referential integrity in a relational database? A) A primary key must change when rows are deleted. B) A foreign key must reference an existing related row. C) A composite key must be used in every relation. D) A foreign key may reference any table row anywhere. Show Answer Correct Answer: B) A foreign key must reference an existing related row. 50. Data once processed is called ..... A) Database. B) Raw Facts. C) Data. D) Information. Show Answer Correct Answer: D) Information. 51. The year when the first internet applications for databases appeared? A) 1995. B) 1994. C) 1990. D) 1999. E) 1996. Show Answer Correct Answer: A) 1995. 52. What are the key components of a data warehousing architecture? A) Data mining and analytics. B) Key components of a data warehousing architecture include data sources, ETL processes, data warehouse, data marts, and presentation layer. C) Real-time data processing. D) Data lakes and cloud storage. Show Answer Correct Answer: B) Key components of a data warehousing architecture include data sources, ETL processes, data warehouse, data marts, and presentation layer. 53. In data mining, which of the following involves events linked over time? A) Sequences. B) Clustering. C) Associations. D) Classifications. Show Answer Correct Answer: A) Sequences. 54. True or False:(102, 'John', 'Physics') is an instance of the Students table. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 55. Which SQL statement is used to retrieve data from a database? A) GET. B) READ. C) SELECT. D) FETCH. Show Answer Correct Answer: C) SELECT. 56. What does OLTP stand for? A) Online Transaction Processing. B) Operational Language Transaction Processing. C) Offline Transaction Processing. D) Open Language Transaction Protocol. Show Answer Correct Answer: A) Online Transaction Processing. 57. Why might a file cabinet be used as an analogy for a database structure? A) Because both are used for cooking. B) Because both store and organize information in a systematic way. C) Because both are made of metal. D) Because both are used for transportation. Show Answer Correct Answer: B) Because both store and organize information in a systematic way. 58. Which ACID property ensures that committed data remains even after a crash? A) Consistency. B) Isolation. C) Durability. D) Atomicity. Show Answer Correct Answer: C) Durability. 59. What is the primary purpose of Design View in MS Access? A) To enter data quickly into tables. B) To modify the structure and properties of database objects. C) To create reports automatically. D) To run complex queries. Show Answer Correct Answer: B) To modify the structure and properties of database objects. 60. Section A:True or False (5 marks)-Write True or False beside each statement. A table is made up of rows and columns. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. ← PreviousNext →Related QuizzesScience QuizzesClass 11 QuizzesClass 11 Computer Science Chapter 7 Database Concepts Quiz 1Class 11 Computer Science Chapter 7 Database Concepts Quiz 2Class 11 Computer Science Chapter 7 Database Concepts Quiz 3Class 11 Computer Science Chapter 7 Database Concepts Quiz 5Class 11 Computer Science Chapter 7 Database Concepts Quiz 6Class 11 Computer Science Chapter 7 Database Concepts Quiz 7Class 11 Computer Science Chapter 7 Database Concepts Quiz 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books