This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 73 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 73 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is referential integrity? A) A rule that ensures data consistency between related tables. B) A method for sorting data. C) A way to delete old records. D) A formatting tool for reports. Show Answer Correct Answer: A) A rule that ensures data consistency between related tables. 2. Which method is NOT a data validation method? A) Length Check. B) Format Check. C) Double Entry. D) Lookup Check. Show Answer Correct Answer: C) Double Entry. 3. Paul is organizing a database for his travel agency. Which of the following is an example of a primary key he might use to uniquely identify each client's record? A) Passport number. B) Country name. C) Address. D) Phone number. Show Answer Correct Answer: A) Passport number. 4. What skills are important for a career in database administration? A) Proficiency in knitting. B) Knowledge of database management systems, SQL, data modeling, data security, troubleshooting, and communication skills. C) Expertise in skydiving. D) Knowledge of cooking techniques. Show Answer Correct Answer: B) Knowledge of database management systems, SQL, data modeling, data security, troubleshooting, and communication skills. 5. Which of the following is NOT a basic building block of a database system? A) Data. B) Hardware. C) Users. D) Compiler. Show Answer Correct Answer: D) Compiler. 6. Define the relational data model. A) A method for storing data in a single flat file without relationships. B) A framework for organizing data in a non-tabular format. C) The relational data model is a way to structure data using tables (relations) with rows and columns, where each table represents an entity and relationships are defined through foreign keys. D) A model that uses only hierarchical structures for data storage. Show Answer Correct Answer: C) The relational data model is a way to structure data using tables (relations) with rows and columns, where each table represents an entity and relationships are defined through foreign keys. 7. What is typically produced during the analysis phase of SDLC? A) ER models. B) System blueprints. C) Code for the test system. D) None of the above. Show Answer Correct Answer: A) ER models. 8. Discuss the concept of data redundancy and how it can be minimized in database design. A) Normalizing the database. B) Denormalizing the database. C) Ignoring data redundancy. D) Adding more redundant data. Show Answer Correct Answer: A) Normalizing the database. 9. Why is assigning the correct data type to a field important? A) It makes the form colorful. B) It determines how data can be stored and processed. C) It shortens the query length. D) It prints the report faster. Show Answer Correct Answer: B) It determines how data can be stored and processed. 10. What is the significance of normalisation in databases? A) It is not necessary. B) It complicates data retrieval. C) It improves data integrity. D) It increases redundancy. Show Answer Correct Answer: C) It improves data integrity. 11. What type of database model organizes data in tables with rows and columns? A) Hierarchical. B) Network. C) Relational. D) Object-Oriented. Show Answer Correct Answer: C) Relational. 12. How do you use the BETWEEN keyword in SQL? Example:SELECT * FROM Orders WHERE OrderDate BETWEEN '2021-01-01' AND '2021-12-31'; A) To filter records within a range of values. B) To sort records in ascending order. C) To join two tables. D) To delete records from a table. Show Answer Correct Answer: A) To filter records within a range of values. 13. A graphical representation of a database and the relationships between the entities. A) Entity-relationship (E-R) model. B) Relational model. C) Object-oriented model. D) Hierarchical model. Show Answer Correct Answer: A) Entity-relationship (E-R) model. 14. In a client-server architecture, where is the DBMS typically located? A) Client-side. B) Server-side. C) Middle layer. D) Cloud platform. Show Answer Correct Answer: B) Server-side. 15. How do you create a new table in Access? A) Select 'File', then 'New', and choose 'Table'. B) Open Access, go to 'Home' tab, click 'New Document'. C) Open Access, go to 'Create' tab, click 'Table'. D) Right-click on the database and select 'Add Table'. Show Answer Correct Answer: C) Open Access, go to 'Create' tab, click 'Table'. 16. Tabel 'detail ..... jual' memiliki 'id ..... nota' dan 'id ..... barang' sebagai kunci utama. Ini menunjukkan bahwa tabel ini menggunakan konsep ..... A) Single Primary Key. B) Composite Primary Key. C) Foreign Key. D) Unique Index. Show Answer Correct Answer: B) Composite Primary Key. 17. What is data mining and how is it related to databases? A) Data mining is solely about data storage techniques. B) Data mining is the process of discovering patterns from large datasets, and it relies on databases to store and retrieve the data for analysis. C) Data mining is a method for creating databases from scratch. D) Data mining focuses only on data visualization tools. Show Answer Correct Answer: B) Data mining is the process of discovering patterns from large datasets, and it relies on databases to store and retrieve the data for analysis. 18. What is the role of an access object in a database? A) To store all database records permanently. B) To optimize database queries for faster performance. C) The role of an access object is to manage user permissions and control access to database data. D) To create backups of the database data. Show Answer Correct Answer: C) The role of an access object is to manage user permissions and control access to database data. 19. Which of the following best describes a field in MS Access? A) A row of data. B) A complete table. C) A column that holds specific type of data. D) A saved query. Show Answer Correct Answer: C) A column that holds specific type of data. 20. SQL (Structured Query Language) A) A standard language used to communicate with relational databases. B) A programming language for web development. C) A markup language for creating web pages. D) A database management system. Show Answer Correct Answer: A) A standard language used to communicate with relational databases. 21. What is a single row in a database called? A) Record. B) Field. C) Entity. D) Table. Show Answer Correct Answer: A) Record. 22. In Microsoft Access, which object allows users to view structured data entry? A) Query. B) Form. C) Report. D) Field. Show Answer Correct Answer: B) Form. 23. Why is using a 'Long Integer' field recommended for numeric data containing three or more digits? A) It allows for the inclusion of currency symbols like $ . B) It ensures the database can store and manipulate larger values without errors. C) It is the only data type that allows for a restricted number of decimal places. D) It automatically generates unique numbers for every new record. Show Answer Correct Answer: B) It ensures the database can store and manipulate larger values without errors. 24. In Oracle, who owns the data dictionary? A) DBA. B) SYS. C) SYSTEM. D) None of the above. Show Answer Correct Answer: B) SYS. 25. What type of data can a database organize? A) Only numbers. B) Only text. C) Sounds, graphics, and text files. D) Only spreadsheets. Show Answer Correct Answer: C) Sounds, graphics, and text files. ← 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