This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 59 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 59 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The database design that consists of multiple tables that are linked together through matching data stored in each table is called a: A) Hierarchical database. B) Network database. C) Object oriented database. D) Relational database. Show Answer Correct Answer: D) Relational database. 2. In an input mask, what does the character 'A' represent? A) User must enter a letter or a digit. B) User can enter a letter or a digit. C) User must enter a letter. D) User can enter a digit, space, plus or minus sign. Show Answer Correct Answer: A) User must enter a letter or a digit. 3. ..... resembles Create view. A) Create table as. B) Create view as. C) Create table like. D) With data. Show Answer Correct Answer: A) Create table as. 4. You ran an SQL command requesting the DBMS to display data in a table named USER ..... TABLES. The result includes columns labeled "TableName, " "NumberOfColumns, " and "PrimaryKey." You are looking at: A) User data. B) Metadata. C) A report. D) An index. Show Answer Correct Answer: B) Metadata. 5. MongoDB stores data in which format internally? A) JSON. B) BSON. C) XML. D) CSV. Show Answer Correct Answer: B) BSON. 6. Which of the following is NOT a common data validation method? A) Range check. B) Type check. C) Encryption check. D) Format check. Show Answer Correct Answer: C) Encryption check. 7. Which of the following refers to something that can be identified in the user's work environment, something that the users want to track? A) Entity. B) Attribute. C) Identifier. D) Relationship. Show Answer Correct Answer: A) Entity. 8. The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems? A) Program-data dependence. B) Lack of flexibility. C) Poor security. D) Lack of data sharing. Show Answer Correct Answer: B) Lack of flexibility. 9. In which of the following is a single-entity instance of one type related to many entity instances of another type? A) One-to-One Relationship. B) One-to-Many Relationship. C) Many-to-Many Relationship. D) Composite Relationship. Show Answer Correct Answer: B) One-to-Many Relationship. 10. Apa itu konsep entity-relationship (ER) dalam desain database? A) ER concept focuses on storing data in a database without relationships. B) Entity-Relationship (ER) concept is used for data visualization only. C) ER concept is not relevant for database design. D) Entity-Relationship (ER) concept in database design is a way to visually represent the relationships between entities in a database. Show Answer Correct Answer: D) Entity-Relationship (ER) concept in database design is a way to visually represent the relationships between entities in a database. 11. Which SQL clause is used to specify the order in which the result set is returned? A) ORDER BY. B) GROUP BY. C) SORT. D) FILTER. Show Answer Correct Answer: A) ORDER BY. 12. In the analogy comparing a database to a file cabinet, what do tables represent? A) File folders. B) Drawers. C) Sheets of paper. D) File cabinet. Show Answer Correct Answer: B) Drawers. 13. What is the purpose of normalization in database design? A) To increase data duplication for faster access. B) To enhance the visual representation of data in reports. C) The purpose of normalization is to reduce data redundancy and improve data integrity. D) To simplify the database structure by merging tables. Show Answer Correct Answer: C) The purpose of normalization is to reduce data redundancy and improve data integrity. 14. What is a composite primary key? A) A primary key that can be duplicated in the same table. B) An attribute that is a primary key in another table. C) A foreign key that is a primary key in more than one other table. D) A primary key made up from two or more attributes. Show Answer Correct Answer: D) A primary key made up from two or more attributes. 15. The $ and operator in MongoDB is used to: A) Combine two queries where both must be true. B) Combine two queries where one must be true. C) Sort data in ascending order. D) Perform aggregation. Show Answer Correct Answer: A) Combine two queries where both must be true. 16. A ..... is a type of command that retrieves data from a database on a server. A) Data dictionary. B) Query. C) Constraint. D) All of these. Show Answer Correct Answer: B) Query. 17. What is a database also known as? A) Data pond. B) Data lake. C) Data warehouse. D) Data bank. Show Answer Correct Answer: D) Data bank. 18. This is an organized collection of information. A) Data. B) Database. C) Information. D) DBMS. Show Answer Correct Answer: B) Database. 19. What are the main types of database security measures? A) Access Control, Encryption, Auditing, Backup and Recovery. B) User Interface Design. C) Network Security. D) Data Mining. Show Answer Correct Answer: A) Access Control, Encryption, Auditing, Backup and Recovery. 20. Which is NOT a disadvantage of a flat file system? A) Data redundancy. B) Lack of concurrency. C) High security. D) Difficult data retrieval. Show Answer Correct Answer: C) High security. 21. In a relational data model, entities are represented as: A) Attributes. B) Relations. C) Data models. D) Databases. Show Answer Correct Answer: B) Relations. 22. How can you manipulate data in Access? A) Access does not support any programming languages. B) Use queries, forms, reports, macros, and VBA. C) Use only tables to store data. D) Data cannot be manipulated in Access. Show Answer Correct Answer: B) Use queries, forms, reports, macros, and VBA. 23. How are "Fields" defined in a relational database? A) The ability to keep data consistent with relevant raw facts. B) The ability to store, sort, and search data. C) The single cell bisecting row and column. D) Categories of data being stored within the table. Show Answer Correct Answer: D) Categories of data being stored within the table. 24. Which of the following are not the examples of a database? A) FoxPro. B) MS Access 2019. C) MS PowerPoint 2019. D) MySQL. Show Answer Correct Answer: C) MS PowerPoint 2019. 25. Which data type is used to store $ 984746.93? A) Date/Time. B) Large Number. C) Number. D) Currency. Show Answer Correct Answer: D) Currency. ← 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