This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 57 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 57 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Computer professionals who write application programs. A) Database Developers. B) Back-End Developers. C) Application Programmers. D) System Programmers. Show Answer Correct Answer: C) Application Programmers. 2. Expansion of SQL is ..... A) Structured Question Language. B) Selection Query Language. C) Structured Query Language. D) System Query Language. Show Answer Correct Answer: C) Structured Query Language. 3. Which aggregation stage groups documents by a specified field? A) $ match. B) $ group. C) $ project. D) $ sort. Show Answer Correct Answer: B) $ group. 4. 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. 5. What does the % symbol do in a SQL LIKE statement? A) Deletes matching patterns. B) Matches patterns of characters. C) Limits results to exact matches. D) Converts text to numbers. Show Answer Correct Answer: B) Matches patterns of characters. 6. 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. 7. 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. 8. 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. 9. What does a record represent in a database table? A) A single row of information. B) A column of data. C) The table title. D) The database name. Show Answer Correct Answer: A) A single row of information. 10. In the ANSI-SPARC three-level architecture, which level deals with the physical storage of data? A) External Level. B) Conceptual Level. C) Internal Level. D) Logical Level. Show Answer Correct Answer: C) Internal Level. 11. 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. 12. 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. 13. Which of the following types of keys is used to ensure the uniqueness of a record, but can accept null values? A) Primary Key. B) Foreign Key. C) Unique Key. D) Composite Key. Show Answer Correct Answer: C) Unique Key. 14. 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. 15. Which data type in MS Access allows you to create an expression that uses data from one or more fields? A) Calculated. B) Attachment. C) OLE objects. D) Hyperlink. Show Answer Correct Answer: A) Calculated. 16. '%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. 17. 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. 18. The project operation ..... A) Combines relational tables to provide the user with more information than is otherwise available. B) Creates a subset consisting of columns in a table. C) Organizes elements into segments. D) Identifies the table from which the columns will be selected. Show Answer Correct Answer: B) Creates a subset consisting of columns in a table. 19. 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) Disadvantage. B) Record. C) Table. D) Benefit. Show Answer Correct Answer: A) Disadvantage. 20. 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. 21. In a Table, a row is known as a ..... A) File. B) Field. C) Record. D) Stage. Show Answer Correct Answer: C) Record. 22. Which command is used in SQL to add a primary key to a table? A) FOREIGN KEY. B) CREATE TABLE. C) PRIMARY KEY. D) ALTER TABLE. Show Answer Correct Answer: C) PRIMARY KEY. 23. Which method handles deadlock? A) Detection. B) Prevention. C) Avoidance. D) All of these. Show Answer Correct Answer: D) All of these. 24. 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. 25. 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. ← PreviousNext →Related 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 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books