This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 23 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 23 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. How many levels of data abstraction are there? A) Three. B) Two. C) Four. D) Five. Show Answer Correct Answer: A) Three. 2. Explain the concept of a primary key. A) A primary key is a type of foreign key. B) A primary key is used to store large amounts of data. C) A primary key can have duplicate values. D) A primary key is a unique identifier for a record in a database table. Show Answer Correct Answer: D) A primary key is a unique identifier for a record in a database table. 3. Dalam model ERD, entitas biasanya diwakili sebagai: A) Lingkaran. B) Garis. C) Segitiga. D) Oval. E) Persegi Panjang. Show Answer Correct Answer: E) Persegi Panjang. 4. Which key is a candidate to be a primary key but is not selected? A) Candidate key. B) Foreign key. C) Composite key. D) Index key. Show Answer Correct Answer: A) Candidate key. 5. Which of the following is NOT true about an Entity Relationship Diagram (ERD) A) It shows how the database is physically represented on the computer system. B) It is based on an abstract, conceptual representation of data called an entity relationship model (ERM). C) It consists of a collection of entity types and relationships. D) It includes attributes for each entity, and multiplicity and participation for each relationship. Show Answer Correct Answer: A) It shows how the database is physically represented on the computer system. 6. How do you design a form for effective data entry? A) Avoid any form of validation. B) Make the form visually complex with many colors. C) Design a user-friendly form with clear labels, grouped fields, input validation, and responsive design. D) Use a single text box for all inputs. Show Answer Correct Answer: C) Design a user-friendly form with clear labels, grouped fields, input validation, and responsive design. 7. What is a many-to-many (M:N) relationship? A) Each record in Table A relates to multiple records in Table C. B) A record in Table A can relate to multiple records in Table A. C) Each record in Table A relates to one record in Table B. D) Records in Table A can relate to multiple records in Table B and vice versa. Show Answer Correct Answer: D) Records in Table A can relate to multiple records in Table B and vice versa. 8. What are the main advantages of using indexes in database management? A) Indexes are used to store data in a database. B) Indexes help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. C) Indexes are only used for data deletion in a database. D) Indexes have no impact on database performance. Show Answer Correct Answer: B) Indexes help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. 9. Which command is used to remove a relation from an SQL? A) Delete. B) Remove. C) Purge. D) Drop table. Show Answer Correct Answer: D) Drop table. 10. What does referential integrity ensure? A) A foreign key must match a primary key in another table. B) Data can be deleted without restrictions. C) Data can be duplicated across tables. D) Data is always encrypted. Show Answer Correct Answer: A) A foreign key must match a primary key in another table. 11. Apa yang dimaksud dengan total participation? A) Entitas mungkin atau mungkin tidak berpartisipasi dalam sebuah relasi. B) Hanya beberapa entitas yang harus berpartisipasi. C) Semua entitas harus berpartisipasi dalam setidaknya satu relasi. D) Hanya beberapa entitas yang berpartisipasi. Show Answer Correct Answer: C) Semua entitas harus berpartisipasi dalam setidaknya satu relasi. 12. If a new table combines every customer's row with every account's row, it's an example of: A) Normalization. B) Integrity Rule. C) Schema Mapping. D) Cartesian Product. Show Answer Correct Answer: D) Cartesian Product. 13. In a database context, what does a "record" refer to? A) A file stored on disk. B) A collection of related files. C) A single row in a table representing a complete set of related data. D) A category of data types. Show Answer Correct Answer: C) A single row in a table representing a complete set of related data. 14. In E-R Diagram, attribute is represented by ..... A) Rectangle. B) Square. C) All the above. D) None of the above. Show Answer Correct Answer: A) Rectangle. 15. Which type of database management system is most commonly used? A) NoSQL database management system. B) Relational database management system (RDBMS). C) Object-oriented database management system. D) Hierarchical database management system. Show Answer Correct Answer: B) Relational database management system (RDBMS). 16. Which of the following is a type of data model? A) Spreadsheet. B) Relational. C) Browser. D) Word Processor. Show Answer Correct Answer: B) Relational. 17. Explain the role of triggers in database management. A) Triggers are used to create user interfaces for databases. B) Triggers are a type of mathematical equation used to calculate database storage. C) Triggers are procedural code that is automatically executed in response to certain events on a particular table or view in a database. D) Triggers are used to create data redundancy in a database. Show Answer Correct Answer: C) Triggers are procedural code that is automatically executed in response to certain events on a particular table or view in a database. 18. Computer professionals who write application programs. A) Back-End Developers. B) System Programmers. C) Database Developers. D) Application Programmers. Show Answer Correct Answer: D) Application Programmers. 19. Expansion of SQL is ..... A) Structured Query Language. B) Structured Question Language. C) System Query Language. D) Selection Query Language. Show Answer Correct Answer: A) Structured Query Language. 20. Which aggregation stage groups documents by a specified field? A) $ match. B) $ sort. C) $ project. D) $ group. Show Answer Correct Answer: D) $ group. 21. How can database security be ensured during data transmission? A) Use plain text for data transmission. B) Rely solely on user passwords for protection. C) Use encryption (TLS/SSL), authentication, and monitoring tools. D) Disable all security protocols. Show Answer Correct Answer: C) Use encryption (TLS/SSL), authentication, and monitoring tools. 22. What does the % symbol do in a SQL LIKE statement? A) Converts text to numbers. B) Deletes matching patterns. C) Matches patterns of characters. D) Limits results to exact matches. Show Answer Correct Answer: C) Matches patterns of characters. 23. Explain the concept of data lakes and their use cases. A) Data lakes are used for big data analytics, machine learning, data archiving, and real-time data processing. B) Data lakes focus exclusively on structured data processing. C) Data lakes are primarily used for traditional database management. D) Data lakes are designed for small-scale data storage and retrieval. Show Answer Correct Answer: A) Data lakes are used for big data analytics, machine learning, data archiving, and real-time data processing. 24. In the relational model, relationships between relations or tables are created using: A) Composite keys. B) Determinants. C) Candidate keys. D) Foreign keys. Show Answer Correct Answer: D) Foreign keys. 25. Which operator performs pattern matching? A) BETWEEN operator. B) LIKE operator. C) EXISTS operator. D) None of these. Show Answer Correct Answer: B) LIKE operator. 26. What does a record represent in a database table? A) The database name. B) A column of data. C) The table title. D) A single row of information. Show Answer Correct Answer: D) A single row of information. 27. In the ANSI-SPARC three-level architecture, which level deals with the physical storage of data? A) Internal Level. B) Logical Level. C) Conceptual Level. D) External Level. Show Answer Correct Answer: A) Internal Level. 28. What are the steps to create a table in Access? A) Open Access and delete an existing database. B) 1. Open Access and create a new database. 2. Go to 'Create' tab and select 'Table Design'. 3. Define fields and data types. 4. Set primary key if necessary. 5. Save the table. C) Go to 'Home' tab and select 'Import Data'. D) Define fields and data types in Excel before importing. Show Answer Correct Answer: B) 1. Open Access and create a new database. 2. Go to 'Create' tab and select 'Table Design'. 3. Define fields and data types. 4. Set primary key if necessary. 5. Save the table. 29. A ..... prevents unauthorized users from accessing a network where a database might be stored. A) Firewall. B) Router. C) Switch. D) Modem. Show Answer Correct Answer: A) Firewall. 30. Which of the following types of keys is used to ensure the uniqueness of a record, but can accept null values? A) Unique Key. B) Primary Key. C) Composite Key. D) Foreign Key. Show Answer Correct Answer: A) Unique Key. 31. What kind of information might a social media database store? A) User profiles. B) Weather forecasts. C) Traffic reports. D) Stock prices. Show Answer Correct Answer: A) User profiles. 32. Which data type in MS Access allows you to create an expression that uses data from one or more fields? A) Attachment. B) Hyperlink. C) OLE objects. D) Calculated. Show Answer Correct Answer: D) Calculated. 33. '%abc' matches strings beginning with 'abc' A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 34. What type of database users are middle or high-level managers who occasionally access databases? A) Naive End Users. B) Sophisticated End Users. C) Stand-alone Users. D) Casual End Users. Show Answer Correct Answer: D) Casual End Users. 35. The project operation ..... A) Identifies the table from which the columns will be selected. B) Organizes elements into segments. C) Creates a subset consisting of columns in a table. D) Combines relational tables to provide the user with more information than is otherwise available. Show Answer Correct Answer: C) Creates a subset consisting of columns in a table. 36. Section D:Fill in the Blanks (5 marks)-Write the correct word or term in each blank space. A ..... of databases is that they can be expensive to set up and maintain. A) Record. B) Disadvantage. C) Table. D) Benefit. Show Answer Correct Answer: B) Disadvantage. 37. What is a database schema? A) A database schema is a collection of user data in a database. B) A database schema is a type of database management system. C) A database schema is a programming language for databases. D) A database schema is a blueprint that outlines the structure and organization of a database. Show Answer Correct Answer: D) A database schema is a blueprint that outlines the structure and organization of a database. 38. In a Table, a row is known as a ..... A) Field. B) Record. C) Stage. D) File. Show Answer Correct Answer: B) Record. 39. Which command is used in SQL to add a primary key to a table? A) PRIMARY KEY. B) FOREIGN KEY. C) ALTER TABLE. D) CREATE TABLE. Show Answer Correct Answer: A) PRIMARY KEY. 40. Which method handles deadlock? A) Detection. B) Prevention. C) Avoidance. D) All of these. Show Answer Correct Answer: D) All of these. 41. Which of the following best describes a database management system (DBMS)? A) A tool that manages only the physical storage of data. B) A software system that facilitates the creation, maintenance, and use of databases. C) A type of database model used primarily for large datasets. D) A hardware component that stores data for quick accessTagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: B) A software system that facilitates the creation, maintenance, and use of databases. 42. Indicate whether the statement is true or false:Program-data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 43. Notasi usecase dilambangkan dengan symbol ..... A) Triangle. B) Oval. C) Parallelogram. D) Square. E) Circle. Show Answer Correct Answer: B) Oval. 44. The properties of entities that are used to differentiate one entity from the other entity is called: A) Entity. B) Database. C) Attributes. D) Relationship. Show Answer Correct Answer: C) Attributes. 45. Describe the importance of data governance in databases. A) Data governance is irrelevant to data analysis and reporting. B) Data governance is crucial for maintaining data quality, security, compliance, and effective decision-making in databases. C) Data governance is only necessary for large organizations. D) Data governance focuses solely on data storage efficiency. Show Answer Correct Answer: B) Data governance is crucial for maintaining data quality, security, compliance, and effective decision-making in databases. 46. Section A:True or False (5 marks)-Write True or False beside each statement. One advantage of a database is that it reduces data duplication. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 47. Which of the following is an example of information derived from data? A) A report showing average test scores per subject. B) The total number of students in a class. C) The raw scores of a test. D) A list of student names. Show Answer Correct Answer: A) A report showing average test scores per subject. 48. What is the purpose of a data dictionary? A) To store large amounts of data. B) To encrypt data. C) To decide what data is going to be stored in each table of a database. D) To delete unnecessary data. Show Answer Correct Answer: C) To decide what data is going to be stored in each table of a database. 49. ..... is a way to display only the data that meets certain criteria, like students over a certain grade. A) Grouping. B) Highlighting. C) Sorting. D) Filtering. Show Answer Correct Answer: D) Filtering. 50. Apa peran utama dari DBMS (Database Management System) A) Mengelola dokumen tertulis. B) Membuat aplikasi multimedia. C) Mengelola akses pengguna dan menjaga integritas data. D) Akses informasi internet. Show Answer Correct Answer: C) Mengelola akses pengguna dan menjaga integritas data. 51. What is the definition of a data type in database design? A) A code for accessing tables. B) A category that defines what kind of data a field can store. C) A printing template. D) A type of report format. Show Answer Correct Answer: B) A category that defines what kind of data a field can store. 52. The importance of data models lies in ..... A) Hardware configuration. B) Data representation and relationships. C) Program execution. D) File storage. Show Answer Correct Answer: B) Data representation and relationships. 53. Which of the following best describes a one-to-one relationship between two tables? A) Each record in one table can be related to multiple records in the other table. B) Each record in one table is related to exactly one record in the other table. C) Each record in one table can be related to multiple records in multiple tables. D) None of the above. Show Answer Correct Answer: B) Each record in one table is related to exactly one record in the other table. 54. A student wants to store multiple values of the same data type in each row using a lookup field in MS Access. Which feature should they use? A) Attachment data type. B) Hyperlink data type. C) Calculated data type. D) Complex lookup field via Lookup Wizard. Show Answer Correct Answer: D) Complex lookup field via Lookup Wizard. 55. Schemas define the ..... of a database. A) Structure. B) Transactions. C) Reports. D) Queries. Show Answer Correct Answer: A) Structure. 56. How does data replication work in distributed systems? A) Data replication requires a central server to manage all data transactions. B) Data replication involves compressing data to save space on a single node. C) Data replication is the process of deleting old data to improve performance. D) Data replication works by copying data across multiple nodes to ensure consistency and availability in distributed systems. Show Answer Correct Answer: D) Data replication works by copying data across multiple nodes to ensure consistency and availability in distributed systems. 57. Can you use ORDER BY with more than one column? A) Yes, you can use ORDER BY with more than one column. B) No, you cannot use ORDER BY with more than one column. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes, you can use ORDER BY with more than one column. 58. What type of key should 'StudentID' be in the Students table? A) Primary Key. B) Foreign Key. C) Composite Key. D) Secondary Key. Show Answer Correct Answer: A) Primary Key. 59. What type of data is numerical in nature? A) Statistical data. B) Quantitative data. C) Qualitative data. D) Descriptive data. Show Answer Correct Answer: B) Quantitative data. 60. The conceptual level describes: A) Physical file structure. B) Hardware configurations. C) Entire database logically. D) User-specific view. Show Answer Correct Answer: C) Entire database logically. ← 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 4Class 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books