This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 22 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 22 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of an information system (IS)? A) To provide software components for communication. B) To collect, store, and process data and provide information. C) To provide a hardware environment for applications. D) None of the above. Show Answer Correct Answer: B) To collect, store, and process data and provide information. 2. A ..... is essentially a lookup field to look up data in another table. A) Foreign key. B) Secondary key. C) Primary field. D) Unique ID. Show Answer Correct Answer: A) Foreign key. 3. A field identified in a table as holding the unique identifier of the table's records is called the: A) Primary key. B) Key field. C) Unique ID. D) Key attribute. Show Answer Correct Answer: A) Primary key. 4. A candidate key that is not a primary key is known as A) Alternate key. B) Foreign key. C) Primary key. D) None. Show Answer Correct Answer: A) Alternate key. 5. What are some common security measures to protect databases? A) Using weak access controls. B) Implementing strong access controls, encrypting sensitive data, regularly updating software and patches, conducting security audits, monitoring database activity, and implementing firewalls. C) Ignoring software updates and patches. D) Storing sensitive data in plain text. Show Answer Correct Answer: B) Implementing strong access controls, encrypting sensitive data, regularly updating software and patches, conducting security audits, monitoring database activity, and implementing firewalls. 6. Why does a database store currency as a numeric value rather than storing symbols (like '$ ') directly in the field? A) Currency symbols are too regional and confuse the software. B) Storing symbols would use up valuable and unnecessary storage space. C) Symbols interfere with the AutoNumber primary key function. D) Symbols can only be stored in Alphanumeric fields, which cannot perform calculations. Show Answer Correct Answer: B) Storing symbols would use up valuable and unnecessary storage space. 7. What are the advantages of using NoSQL databases over traditional relational databases? A) NoSQL databases have no advantages over traditional relational databases. B) NoSQL databases provide better support for unstructured and semi-structured data, horizontal scalability, and flexible data models. C) NoSQL databases are less secure than traditional relational databases. D) NoSQL databases are not suitable for large-scale applications. Show Answer Correct Answer: B) NoSQL databases provide better support for unstructured and semi-structured data, horizontal scalability, and flexible data models. 8. What does a physical ERD depict? A) Only the main entities. B) A high-level overview of the database. C) The relationships without implementation details. D) The actual database schema with data types. Show Answer Correct Answer: D) The actual database schema with data types. 9. Which SQL statement is used to add new records to a table? A) SELECT. B) DELETE. C) UPDATE. D) INSERT. Show Answer Correct Answer: D) INSERT. 10. Define Data Definition Language (DDL). A) Data Definition Language (DDL) is a method for analyzing data trends. B) Data Definition Language (DDL) is a programming language for creating applications. C) Data Definition Language (DDL) is a language used to define the structure of a database. D) Data Definition Language (DDL) is used for querying data in a database. Show Answer Correct Answer: C) Data Definition Language (DDL) is a language used to define the structure of a database. 11. Which PostgreSQL constraint ensures that a column cannot have NULL values? A) NOT NULL. B) UNIQUE. C) PRIMARY KEY. D) FOREIGN KEY. Show Answer Correct Answer: A) NOT NULL. 12. What does each *entity* in an ER diagram typically represent in a database? A) A column. B) A row. C) A table. D) A relationship. Show Answer Correct Answer: C) A table. 13. What is the main difference between data validation and data verification? A) Validation checks data against rules, while verification compares data to its original source. B) Verification is automatic, while validation is always manual. C) Validation is performed on input, while verification is only done on output. D) There is no difference; the terms are interchangeable. Show Answer Correct Answer: A) Validation checks data against rules, while verification compares data to its original source. 14. What data type is used to store short alphanumeric data, such as names and addresses? A) Date/Time. B) Number. C) Long Text. D) Text. Show Answer Correct Answer: D) Text. 15. Which protocol ensures no two transactions access the same data simultaneously? A) Lock-based. B) Timestamp. C) Validation. D) Serial schedule. Show Answer Correct Answer: A) Lock-based. 16. Each item from this list is classified as ..... Name, Birthdate, Street, County, PostCode A) Table. B) Record. C) Field. D) None of the above. Show Answer Correct Answer: C) Field. 17. How does a document database store data? A) In rows and columns. B) In word documents. C) In spreadsheets. D) In flexible documents. Show Answer Correct Answer: D) In flexible documents. 18. A ..... is a copy of database information saved in case the original data is lost or damaged. A) Backup. B) Archive. C) Snapshot. D) Replica. Show Answer Correct Answer: A) Backup. 19. Which of the following is an example of a NoSQL database? A) Crystal Reports. B) Microsoft Access. C) SimpleDB. D) DB2. Show Answer Correct Answer: C) SimpleDB. 20. News of 1997? A) XML is used for processing databases. Many vendors are starting to integrate XML into their DBMS. B) Microsoft releases MS access, a custom DBMS that replaces all other custom DBMS products. C) Charles Bachman created the first DBMS system?. D) Object-oriented DBMS are being developed. E) The first internet applications for databases. Show Answer Correct Answer: A) XML is used for processing databases. Many vendors are starting to integrate XML into their DBMS. 21. A tuple is also known as ..... A) Table. B) Row. C) Attribute. D) Field. Show Answer Correct Answer: B) Row. 22. What is Data Manipulation Language (DML)? A) Data Manipulation Language (DML) is a language used for managing and manipulating data in a database. B) Data Manipulation Language (DML) is a tool for visualizing data trends. C) Data Manipulation Language (DML) is a method for designing database structures. D) Data Manipulation Language (DML) is a protocol for securing data access. Show Answer Correct Answer: A) Data Manipulation Language (DML) is a language used for managing and manipulating data in a database. 23. What is a key field in a database? A) A field that stores the largest value. B) A unique identifier for each record. C) A field that stores text data. D) A field that stores date and time. Show Answer Correct Answer: B) A unique identifier for each record. 24. What is the purpose of the Entity-Relationship (ER) Model? A) To define the structure of SQL queries. B) To model the data and relationships between entities. C) To create indexes on multiple tables. D) To manage database transactions. Show Answer Correct Answer: B) To model the data and relationships between entities. 25. Data Definition A) The process of defining tables, fields, and data types. B) The method of analyzing data trends. C) The technique of visualizing data in charts. D) The practice of securing data against breaches. Show Answer Correct Answer: A) The process of defining tables, fields, and data types. ← 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