This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 25 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 25 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which symbol is commonly used to represent a relationship in an ER diagram? A) Circle. B) Triangle. C) Diamond. D) Square. Show Answer Correct Answer: C) Diamond. 2. What is an "attribute" in the context of a database? A) A primary key for a table. B) A field that allows NULL values. C) A grouping of related records. D) A characteristic of an entity represented by a column in a table. Show Answer Correct Answer: D) A characteristic of an entity represented by a column in a table. 3. Which lock allows concurrent read but prevents write? A) Exclusive lock. B) Shared lock. C) Update lock. D) None. Show Answer Correct Answer: B) Shared lock. 4. Which of the following is an example of a validation rule in a database field? A) Employee Name. B) Customer ID. C) Maximum allowed salary. D) Sales DateTagsLO2. Show Answer Correct Answer: C) Maximum allowed salary. 5. Which DDL command is used to modify the structure of an existing table? A) ALTER. B) DROP. C) DELETE. D) INSERT. Show Answer Correct Answer: A) ALTER. 6. In a DBMS, the term "view" refers to: A) A physical storage layout. B) A subset of the database tailored to a particular user's needs. C) An abstract data model. D) The interaction with the operating system. Show Answer Correct Answer: B) A subset of the database tailored to a particular user's needs. 7. .... Defines a relation consisting of a set of all tuple that are in both in A and B. A) UNION. B) SET DIFFERENCE. C) PROJECT. D) INTERSECTION. Show Answer Correct Answer: D) INTERSECTION. 8. Elairda is designing a database for her school project. Which rule applies when creating a primary key? A) It cannot contain duplicates. B) It must always store numbers. C) It can be empty or null. D) It should be the last column in the table. Show Answer Correct Answer: A) It cannot contain duplicates. 9. .... main component is a program that controls everything. A) Hardware. B) Data. C) Software. D) Methods. Show Answer Correct Answer: C) Software. 10. What is mismatched copies of data indicative of? A) Dependance. B) Redundancy. C) Inconsistency. D) Isolation. Show Answer Correct Answer: C) Inconsistency. 11. What is the main difference between Form View and Design View? A) Form View is for entering and viewing data, Design View is for modifying the form's layout. B) Form View is for creating queries, Design View is for running queries. C) Form View is for printing, Design View is for saving. D) Form View is for deleting records, Design View is for adding records. Show Answer Correct Answer: A) Form View is for entering and viewing data, Design View is for modifying the form's layout. 12. The relational model organizes data in: A) Trees. B) Graphs. C) Tables. D) Objects. Show Answer Correct Answer: C) Tables. 13. In a school database, which is the best example of a primary key for identifying students? A) Driver's License Number. B) Home Runs Hit. C) Price. D) First and Last Name. Show Answer Correct Answer: A) Driver's License Number. 14. Which of the following is an example of data validation? A) Entering random numbers. B) Ensuring a field only accepts dates. C) Using images instead of text. D) Copying and pasting data from the internet. Show Answer Correct Answer: B) Ensuring a field only accepts dates. 15. In SQL, which data type is best suited for storing large texts such as articles or comments? A) TEXT. B) VARCHAR. C) CHAR. D) BLOB. Show Answer Correct Answer: A) TEXT. 16. What is a relational database? A) A database where data is stored without any structured format. B) A database where data is held in a single table. C) A database where data is held in more than one table linked by relationships. D) A database that does not support relationships between tables. Show Answer Correct Answer: C) A database where data is held in more than one table linked by relationships. 17. Apa yang dimaksud dengan normalisasi dalam desain database? A) Normalisasi adalah proses menambahkan redundansi data dalam database. B) Normalisasi adalah proses mengurangi efisiensi database. C) Normalisasi adalah proses menghilangkan data dari database. D) Normalisasi dalam desain database adalah proses pengorganisasian data dalam database agar efisien dan mengurangi redundansi data. Show Answer Correct Answer: D) Normalisasi dalam desain database adalah proses pengorganisasian data dalam database agar efisien dan mengurangi redundansi data. 18. What are the advantages of using stored procedures in database management? A) Increased data redundancy. B) Decreased security. C) Some advantages of using stored procedures in database management include improved performance, better security, and easier maintenance. D) More complex maintenance. Show Answer Correct Answer: C) Some advantages of using stored procedures in database management include improved performance, better security, and easier maintenance. 19. How can a unique value be created in a database table when there isn't a suitable single field to use as a primary key? A) By deleting non-unique fields. B) By combining two or more fields to create a unique value. C) By using a random number generator. D) By choosing the longest field as the primary key. Show Answer Correct Answer: B) By combining two or more fields to create a unique value. 20. Primary key uniquely identifies a: A) Row. B) Records. C) Table. D) None of them. Show Answer Correct Answer: A) Row. 21. Sebuah fakta tentang sesuatu di dunia nyata (yang dapat berupa angka, rangkaian karakter, simbol, dan gambar) yang dapat dicatat dan disimpan di media komputer. Ini adalah definisi dari ..... A) Data. B) Informasi. C) Basis data. D) Data base. E) Sistem informasi. Show Answer Correct Answer: A) Data. 22. The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called ..... A) Normalization. B) Data scrubbing. C) Data cleansing. D) Data defining. Show Answer Correct Answer: A) Normalization. 23. Which of the following best describes the role of a database compared to a spreadsheet? A) Databases are only for numbers, while spreadsheets store all data types. B) Databases manage large amounts of structured data more efficiently. C) Spreadsheets can search faster than databases. D) Spreadsheets are better for organizing student records. Show Answer Correct Answer: B) Databases manage large amounts of structured data more efficiently. 24. What is an entity in a database? A) An entity in a database is a table that stores data. B) An entity in a database is a software program used to manage data. C) An entity in a database is a file that contains information. D) An entity in a database is a distinct object or concept that is represented in the database. Show Answer Correct Answer: D) An entity in a database is a distinct object or concept that is represented in the database. 25. Which type of data model provides the foundation for building a physical data model? A) Abstract Data Model. B) Logical Data Model. C) Conceptual Data Model. D) Hierarchical Data Model. Show Answer Correct Answer: B) Logical Data Model. ← 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