This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 3 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 3 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a record in a relational database? A) A database file. B) A single row in a table. C) A column in a table. D) A relationship between tables. Show Answer Correct Answer: B) A single row in a table. 2. Which of the following items is not the advantage of a DBMS? A) Improved ability to enforce standards. B) Improved data consistency. C) Local control over the data. D) Minimal data redundancy. Show Answer Correct Answer: C) Local control over the data. 3. What does the symbol represent in a flowchart when a decision has to be made? A) Rectangle. B) Parallelogram. C) Diamond. D) Arrow. Show Answer Correct Answer: C) Diamond. 4. Which function returns the maximum value in a column? A) SUM(). B) COUNT(). C) AVG(). D) MAX(). Show Answer Correct Answer: D) MAX(). 5. Which of the following best describes the difference between a field and a record? A) A field stores all information about one item, while a record stores one type of information. B) A field is a column of one type of data, while a record is a row about one item. C) A record is a collection of tables, while a field is a table name. D) A record and a field mean the same thing. Show Answer Correct Answer: B) A field is a column of one type of data, while a record is a row about one item. 6. What does DDL stand for in databases? A) Data Definition Language. B) Data Description Language. C) Database Design Language. D) Data Display Language. Show Answer Correct Answer: A) Data Definition Language. 7. Why is it important for a database to be associated with a general topic? A) It increases the risk of data loss. B) It limits the use of the database. C) It makes the database slower. D) It helps organize related data efficiently. Show Answer Correct Answer: D) It helps organize related data efficiently. 8. What does 3NF stand for in database normalization? A) Three Normal Forms. B) Three Normal Functions. C) Third Normal Form. D) Third Normal Function. Show Answer Correct Answer: C) Third Normal Form. 9. Jenis diagram UML yang menggambarkan interaksi antara system dan actor adalah ..... A) Object diagram. B) Use case diagram. C) Sequence diagram. D) Class diagram. E) Activity diagram. Show Answer Correct Answer: B) Use case diagram. 10. What is a Data Warehouse? A) A system used for reporting and data analysis. B) A type of database optimized for transaction processing. C) A software development methodology. D) A network security protocol. Show Answer Correct Answer: A) A system used for reporting and data analysis. 11. Which of the following describes a "schema" ? A) A collection of queries stored in the database. B) The structure of a database, defining how tables, fields, and relationships are organized. C) A type of SQL query used to retrieve data. D) A system for managing database connections. Show Answer Correct Answer: B) The structure of a database, defining how tables, fields, and relationships are organized. 12. What is the purpose of the DROP command in DDL? A) To remove an entire table or database object. B) To modify table data. C) To retrieve records from a table. D) To add new records to a table. Show Answer Correct Answer: A) To remove an entire table or database object. 13. When data of one file cannot be mapped to other relation file, it is called data ..... A) Dependence. B) Redundancy. C) Inconsistency. D) Isolation. Show Answer Correct Answer: C) Inconsistency. 14. Which of the following is a type of database management system? A) SQL Server. B) Microsoft Word. C) Microsoft Excel. D) Adobe Photoshop. Show Answer Correct Answer: A) SQL Server. 15. The separation of the data definition from the program is known as: A) Data integrity. B) Data independence. C) Referential integrity. D) Data dictionary. Show Answer Correct Answer: B) Data independence. 16. The purpose of DBLC is to: A) Build mobile apps. B) Create a database system systematically. C) Write queries. D) Encrypt network data. Show Answer Correct Answer: B) Create a database system systematically. 17. What should you do instead of repeating 'country' in every record? A) Use a text box. B) Enter manually. C) Create a dropdown list. D) Create a new table. Show Answer Correct Answer: C) Create a dropdown list. 18. Why is it important to accurately map entities, columns, and data types in a database? A) It simplifies the process of creating primary keys for each table. B) It ensures that data can be retrieved and stored correctly in the database. C) It eliminates the need for creating relationships between tables. D) It guarantees that the database can handle a large number of concurrent users. Show Answer Correct Answer: B) It ensures that data can be retrieved and stored correctly in the database. 19. Which data type can store up to 8 bytes of data? A) Number. B) Date/Time. C) Text. D) Large Number. Show Answer Correct Answer: A) Number. 20. What does a conceptual ERD provide? A) A high-level overview of the database. B) Detailed implementation steps. C) A list of all records. D) Only the data types. Show Answer Correct Answer: A) A high-level overview of the database. 21. Flat-file database A) A database that is used for large-scale data processing. B) A database that contains multiple tables. C) A database that contains only one table. D) A database that is designed for complex queries. Show Answer Correct Answer: C) A database that contains only one table. 22. A Query in Microsoft Access is used to: A) Store data for future use. B) Select records from the underlying table that meet some search criteria. C) Create a form to facilitate data entry. D) None. Show Answer Correct Answer: B) Select records from the underlying table that meet some search criteria. 23. Why is Data organised in a table? A) For records. B) For slave table. C) For collection of Data. D) For quick retreival of Information. Show Answer Correct Answer: D) For quick retreival of Information. 24. Which of the following is a type of database software? A) Microsoft Access. B) Microsoft Excel. C) Adobe Photoshop. D) Microsoft Word. Show Answer Correct Answer: A) Microsoft Access. 25. What is the significance of a database management system (DBMS)? A) It is not necessary for small databases. B) It simplifies data management and access. C) It is only used for large databases. D) It complicates data access. Show Answer Correct Answer: B) It simplifies data management and access. 26. All items in a column of a table should be ..... A) Heterogeneous. B) Homogeneous. C) All the above. D) None of the above. Show Answer Correct Answer: B) Homogeneous. 27. What is an update/modification anomaly? A) A missing primary key. B) A problem caused by redundant data when updating information. C) A foreign key not referencing a primary key. D) A table with too many records. Show Answer Correct Answer: B) A problem caused by redundant data when updating information. 28. A ..... stores data in tables that are related to each other, like students and courses. A) Key-value store. B) Document store. C) Relational database. D) Spreadsheet. Show Answer Correct Answer: C) Relational database. 29. True or False:Multiple transactions running at the same time must produce the same results even when run sequentially. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 30. Why is the transformation step important in ETL? A) It cleans and organizes data. B) It loads data into the target system. C) It extracts data from various sources. D) It monitors data quality. Show Answer Correct Answer: A) It cleans and organizes data. 31. What does metadata refer to? A) A programming language. B) Data about data. C) Raw facts of interest. D) A type of database. Show Answer Correct Answer: B) Data about data. 32. What is the role of information in decision-making? A) It serves as the key output that drives decisions. B) It is only useful in scientific research. C) It complicates the decision-making process. D) It is irrelevant to decision-making. Show Answer Correct Answer: A) It serves as the key output that drives decisions. 33. Which of the following is a step in normalizing a database? A) Removing repeating groups. B) Adding more redundant data. C) Removing all foreign keys. D) Creating a single table for all data. Show Answer Correct Answer: A) Removing repeating groups. 34. Which command is used to retrieve records from one or more table? A) Drop. B) Delete. C) Insert. D) Select. Show Answer Correct Answer: D) Select. 35. What characteristic does NOT mean that data is in 1NF? A) It is all in one table. B) There is redundancy. C) There is an assigned primary key. D) There are duplicate names. Show Answer Correct Answer: C) There is an assigned primary key. 36. What is a record in a database? A) A collection of fields containing information about one specific item. B) The name of a database file. C) A collection of tables. D) A type of query. Show Answer Correct Answer: A) A collection of fields containing information about one specific item. 37. Which of the following options is the purpose of the testing and refinement step in data modeling? A) To define the relationships between tables. B) To implement the database in the software. C) To ensure the database functions correctly and fix any issues. D) To create the conceptual model. Show Answer Correct Answer: C) To ensure the database functions correctly and fix any issues. 38. Which of the following is NOT a type of relationship in a relational database? A) One to One (1:1). B) One to Many (1:M). C) Many to Many (M:M). D) All to All (A:A). Show Answer Correct Answer: D) All to All (A:A). 39. Dalam ERD, kardinalitas menunjukkan: A) Jumlah maksimum entitas yang dapat terlibat dalam suatu hubungan. B) Atribut dari entitas. C) Nama hubungan antara entitas. D) Jumlah hubungan antara entitas. E) Proses normalisasi data. Show Answer Correct Answer: A) Jumlah maksimum entitas yang dapat terlibat dalam suatu hubungan. 40. Which of the following is an example of magnetic storage? A) Hard drive. B) CD-ROM. C) DVD-RW. D) USB flash drive. Show Answer Correct Answer: A) Hard drive. 41. Which of the following best defines a database? A) A computer hardware component. B) A type of software application. C) A structured collection of related data representing real-world aspects. D) A collection of programs. Show Answer Correct Answer: C) A structured collection of related data representing real-world aspects. 42. In data mining, which of the following involves using a series of existing values to determine what other future values will be? A) Sequences. B) Forecasting. C) Classifications. D) Clustering. Show Answer Correct Answer: B) Forecasting. 43. What is meant by concurrency of a database? A) All changes in the database by different users are reflected to all users. B) All transactions of a database are independent. C) Each transaction is considered as a single entity. D) All of the above. Show Answer Correct Answer: A) All changes in the database by different users are reflected to all users. 44. What is the main characteristic of sophisticated end users? A) They use only predefined functions. B) They rarely access the database. C) They only work with personal databases. D) They have high technical expertise and can formulate complex queries. Show Answer Correct Answer: D) They have high technical expertise and can formulate complex queries. 45. A ..... key may store NULL values in it. A) Primary key. B) Foreign key. C) Composite key. D) None of these. Show Answer Correct Answer: B) Foreign key. 46. What is the main purpose of establishing relationships between tables in a relational database? A) To eliminate the need for attributes. B) To increase redundancy. C) To connect related data. D) To simplify data entry. Show Answer Correct Answer: C) To connect related data. 47. Which data model is extended from of hierarchical data model? A) Network database model. B) Object Model. C) ER model. D) Relational. Show Answer Correct Answer: A) Network database model. 48. What does the term 'atomic values' refer to in a relational database? A) Values that are unique across the database. B) Values that can be broken down into smaller parts. C) Values that cannot be divided further. D) Values that are stored in multiple tables. Show Answer Correct Answer: C) Values that cannot be divided further. 49. Database refers ..... A) Word. B) DBMMS. C) Python. D) Excel. Show Answer Correct Answer: B) DBMMS. 50. Which type of query allows you to review planned changes before execution? A) Appended Queries. B) Update Query. C) Delete Query. D) Make Table Query. Show Answer Correct Answer: B) Update Query. 51. True or False:A schema includes both the structure and the data of a table. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 52. Which of the following statements about Hadoop is not true? A) Hadoop is proprietary software sold by the Apache Software Foundation. B) Hadoop runs on a cluster of inexpensive servers. C) Companies use Hadoop as a staging area for unstructured and semistructured data before they are loaded into a data warehouse. D) Hadoop breaks a big data problem down into subproblems. Show Answer Correct Answer: A) Hadoop is proprietary software sold by the Apache Software Foundation. 53. What is a tuple in a relational database? A) A column in a table. B) A database management system. C) A row in a table. D) A relationship between two tables. Show Answer Correct Answer: C) A row in a table. 54. In a relational database, how are tables related to each other? A) By duplicating data in each table. B) Through shared data fields known as key fields. C) By storing all data in a single table. D) By using a central database management system onlyTagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: B) Through shared data fields known as key fields. 55. ..... is considered as a blueprint of a database. A) Entities. B) Data model. C) Attributes. D) Database. Show Answer Correct Answer: B) Data model. 56. Which data type is most suitable to store "Yes" or "No" responses in a field? A) Number. B) Yes/No. C) Memo. D) Text. Show Answer Correct Answer: B) Yes/No. 57. What distinguishes 'information' from 'data'? A) Information is less useful than data. B) Information is unprocessed raw facts. C) Information cannot be stored in a database. D) Information is data processed in a meaningful way. Show Answer Correct Answer: D) Information is data processed in a meaningful way. 58. What is the purpose of a school using a DBMS? A) To store information about students. B) To store information about teachers. C) To store information about classes. D) All of the above. Show Answer Correct Answer: D) All of the above. 59. In a many-to-many relationship, how many times can a primary key exist as a foreign key? A) Once as a primary key and many times as a foreign key. B) Once as a primary key and once as a foreign key. C) Many times as a primary key and many times as a foreign key. D) Many times as a primary key and once as a foreign key. Show Answer Correct Answer: C) Many times as a primary key and many times as a foreign key. 60. Dalam pengembangan perangkat lunak dapat menggunakan beberapa model, kecuali ..... A) Waterfall. B) Prototype. C) RAD. D) Evolutionary development. E) URP. Show Answer Correct Answer: E) URP. ← PreviousNext →Related QuizzesScience QuizzesClass 11 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 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 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books