This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 60 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 60 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which feature helps restrict the kind of data that can be entered in a field? A) AutoNumber. B) Field Size and Data Type settings. C) Save As option. D) Design View. Show Answer Correct Answer: B) Field Size and Data Type settings. 2. What is the difference between a database and a table? A) A database is a collection of tables. B) A table is a collection of databases. C) They are the same. D) A table is larger than a database. Show Answer Correct Answer: A) A database is a collection of tables. 3. In SQL, which command is used to SELECT only one copy of each set of duplicable rows A) SELECT DISTINCT. B) SELECT UNIQUE. C) SELECT DIFFERENT. D) All of the above. Show Answer Correct Answer: A) SELECT DISTINCT. 4. What would be the main effect of a change at the conceptual level of the database? A) It would require hardware upgrades. B) It could affect all external views but not the physical storage. C) It would directly change indexing structures. D) It would force a change in file system layout. Show Answer Correct Answer: B) It could affect all external views but not the physical storage. 5. What gives meaning to these numbers and figures is ..... A) Information. B) Data. C) Knowledge. D) Wisdom. Show Answer Correct Answer: A) Information. 6. A quick way to find data in a database is to use ..... A) Queries. B) Quandries. C) Questions. D) File folders. Show Answer Correct Answer: A) Queries. 7. How does a database administrator ensure data integrity? A) By ignoring software updates and patches. B) By implementing constraints, performing backups, validating input data, and enforcing security measures. C) By sharing the database password with unauthorized users. D) By deleting random data entries. Show Answer Correct Answer: B) By implementing constraints, performing backups, validating input data, and enforcing security measures. 8. Which of the following is a key advantage of using a DBMS over a file-based system? A) Simplified data structure. B) Reduced data redundancy. C) Lower initial setup cost. D) Faster data retrieval for small datasets. Show Answer Correct Answer: B) Reduced data redundancy. 9. What is the function of a primary key? A) It represents a table in a database. B) It is a heading for data organization. C) It provides a unique identifier for a record/entity. D) It reduces data-entry errors. Show Answer Correct Answer: C) It provides a unique identifier for a record/entity. 10. How do you link tables using primary keys? A) Use the primary key of one table as a foreign key in another table to create a relationship. B) Create a relationship by copying the entire table into another. C) Link tables by matching the names of the columns directly. D) Use the primary key of one table as a primary key in another table. Show Answer Correct Answer: A) Use the primary key of one table as a foreign key in another table to create a relationship. 11. Why is data integrity important in a database? A) To allow for faster data retrieval. B) To maintain accurate and consistent data. C) To enable data encryption. D) To ensure data is stored securely. Show Answer Correct Answer: B) To maintain accurate and consistent data. 12. What is a "foreign key" in a relational database? A) A key that is used for encryption. B) A key that uniquely identifies each record in a table. C) A key that references the primary key in another table. D) A key that is used for indexing purposes. Show Answer Correct Answer: C) A key that references the primary key in another table. 13. What is a key characteristic of the relational model? A) Uses hierarchical indexes. B) Contains only unstructured data. C) Organizes data into rows and columns. D) Uses object inheritance. Show Answer Correct Answer: C) Organizes data into rows and columns. 14. What does a double-lined box represent in an ER diagram? A) Entity. B) Attribute. C) Relationship. D) Key. Show Answer Correct Answer: A) Entity. 15. Which IS component includes switches and firewalls? A) Hardware/Network infrastructure. B) Applications/Services. C) Software/Development tools. D) None of the above. Show Answer Correct Answer: A) Hardware/Network infrastructure. 16. Which data model uses a tree-like structure? A) Network model. B) Hierarchical model. C) Relational model. D) Object-oriented model. Show Answer Correct Answer: B) Hierarchical model. 17. ..... states that only valid data will be written to the database. A) Consistency. B) Atomicity. C) Durability. D) Isolation. Show Answer Correct Answer: A) Consistency. 18. Which of the following is an example of end user data? A) Data characteristics. B) Database management system. C) Database structure. D) Patient ID. Show Answer Correct Answer: D) Patient ID. 19. Which of the following is NOT a type of database application? A) Textual Databases. B) Multimedia Databases. C) Geographic Information Systems (GIS). D) Spreadsheet Applications. Show Answer Correct Answer: D) Spreadsheet Applications. 20. What is the purpose of a field in a database? A) The purpose of a field in a database is to store a specific piece of information for each record in a table. B) The purpose of a field in a database is to display data in a table. C) The purpose of a field in a database is to organize records in a table. D) The purpose of a field in a database is to calculate values for each record in a table. Show Answer Correct Answer: A) The purpose of a field in a database is to store a specific piece of information for each record in a table. 21. Jazari is designing a student database for his school project. What is a primary key in this database? A) A field that uniquely identifies a record. B) A duplicate field in a table. C) A field used for calculations. D) A field that stores only text values. Show Answer Correct Answer: A) A field that uniquely identifies a record. 22. One shopper buys many items. How is this expressed as a relationship on an ER diagram? A) 1:M. B) M:1. C) M:N. D) 1:1. Show Answer Correct Answer: A) 1:M. 23. Which of the below SELECT statement is used to select all columns of EMP table? A) SELECT ALL FROM emp. B) SELECT # FROM emp. C) SELECT * FROM emp. D) SELECT empno, ename, deptno, sal, job, mgr, hiredate FROM emp. Show Answer Correct Answer: C) SELECT * FROM emp. 24. Explain the difference between SQL and NoSQL databases. A) SQL databases are relational with a fixed schema; NoSQL databases are non-relational with flexible schemas. B) SQL databases are designed for unstructured data. C) NoSQL databases require a predefined schema. D) SQL databases are non-relational with a fixed schema. Show Answer Correct Answer: A) SQL databases are relational with a fixed schema; NoSQL databases are non-relational with flexible schemas. 25. Pooja is entering data directly into a spreadsheet-like interface in Access. She is working in: A) Design View. B) Query View. C) Datasheet View. D) Form View. Show Answer Correct Answer: C) Datasheet View. ← 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