This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 8 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 8 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. 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. 2. Database refers ..... A) DBMMS. B) Python. C) Word. D) Excel. Show Answer Correct Answer: A) DBMMS. 3. Which type of query allows you to review planned changes before execution? A) Update Query. B) Delete Query. C) Make Table Query. D) Appended Queries. Show Answer Correct Answer: A) Update Query. 4. 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. 5. 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. 6. What is a tuple in a relational database? A) A column in a table. B) A row in a table. C) A relationship between two tables. D) A database management system. Show Answer Correct Answer: B) A row in a table. 7. 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. 8. ..... is considered as a blueprint of a database. A) Attributes. B) Database. C) Data model. D) Entities. Show Answer Correct Answer: C) Data model. 9. Which data type is most suitable to store "Yes" or "No" responses in a field? A) Text. B) Memo. C) Number. D) Yes/No. Show Answer Correct Answer: D) Yes/No. 10. News of 1976? A) Peter Chen developed and defined an important relationship model called the er model. B) Microsoft releases MS access, a custom DBMS that replaces all other custom DBMS products. C) Object-oriented DBMS are being developed. D) The first internet applications for databases. E) XML is used for processing databases. Many vendors are starting to integrate XML into their DBMS. Show Answer Correct Answer: A) Peter Chen developed and defined an important relationship model called the er model. 11. What distinguishes 'information' from 'data'? A) Information is unprocessed raw facts. B) Information is data processed in a meaningful way. C) Information is less useful than data. D) Information cannot be stored in a database. Show Answer Correct Answer: B) Information is data processed in a meaningful way. 12. 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. 13. 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. 14. Query A) A request for information from a database against set criteria. B) A type of database that stores information in a structured format. C) A programming language used to manipulate databases. D) A method for visualizing data in charts and graphs. Show Answer Correct Answer: A) A request for information from a database against set criteria. 15. 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. 16. How do records and fields relate in SQL tables? A) Records are keys and fields are values. B) Records are attributes and fields are entities. C) Records are rows and fields are columns. D) Records are columns and fields are rows. Show Answer Correct Answer: C) Records are rows and fields are columns. 17. What is the difference between a report and a form in Access? A) A report is a type of database; a form is a type of query. B) A report is for data entry; a form is for presenting data. C) A report is used for calculations; a form is for storing data. D) A report is for presenting data; a form is for data entry. Show Answer Correct Answer: D) A report is for presenting data; a form is for data entry. 18. A functional dependency is a relationship between or among: A) Tables. B) Rows. C) Relations. D) Attributes. Show Answer Correct Answer: D) Attributes. 19. What are the advantages of using cloud databases? A) Increased maintenance costs. B) Limited storage capacity. C) Complex setup requirements. D) Advantages of using cloud databases include scalability, flexibility, cost-effectiveness, automatic backups, high availability, and remote access. Show Answer Correct Answer: D) Advantages of using cloud databases include scalability, flexibility, cost-effectiveness, automatic backups, high availability, and remote access. 20. Update ..... set columname=value where condition; A) Tablename. B) Database name. C) Fieldname. D) Structurename. Show Answer Correct Answer: A) Tablename. 21. What is a Database Management System (DBMS)? A) A method for data encryption. B) A type of hardware used for data storage. C) Software that manages databases. D) A programming language for database queries. Show Answer Correct Answer: C) Software that manages databases. 22. Database can be physical or digital. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 23. What is the purpose of the JOIN operation in SQL? A) To create a new table from two existing tables. B) To combine rows from two or more tables based on a related column. C) To delete rows from one table. D) To update columns in two tables simultaneously. Show Answer Correct Answer: B) To combine rows from two or more tables based on a related column. 24. What is a flat file database? A) A database where data is stored in multiple interconnected tables. B) A database where all the data is stored in a single table. C) A database that requires constant internet connectivity. D) A database used exclusively for multimedia files. Show Answer Correct Answer: B) A database where all the data is stored in a single table. 25. Which SQL statement is primarily used to retrieve data from a table? A) SELECT. B) INSERT. C) UPDATE. D) DELETE. Show Answer Correct Answer: A) SELECT. ← 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 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books