This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 52 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 52 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is an example of a database used in a school? A) A list of students with their names and grades. B) A storybook. C) A calculator. D) A video game. Show Answer Correct Answer: A) A list of students with their names and grades. 2. The Boyce-Codd Normal Form is another name for? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of these. Show Answer Correct Answer: C) Third Normal Form (3NF). 3. Which of the following is a characteristic of a self-describing database? A) It requires no user input. B) It stores metadata about the database. C) It is only accessible by administrators. D) It cannot be modified. Show Answer Correct Answer: B) It stores metadata about the database. 4. A function that has no partial functional dependencies is in ..... form A) 3NF. B) 2NF. C) 4NF. D) BCNF. Show Answer Correct Answer: B) 2NF. 5. Which of the following BEST describes a table in a database? A) A single row containing all details of one student. B) A collection of related fields and records. C) A collection of ASCII codes. D) A formatted Excel sheet. Show Answer Correct Answer: B) A collection of related fields and records. 6. Hierarchical model has ..... relationship. A) One to many. B) Many to one. C) One to one. D) Many to many. Show Answer Correct Answer: A) One to many. 7. Which of the following functions is used to count the number of records in a field? A) SUM. B) COUNT. C) AVG. D) MIN. Show Answer Correct Answer: B) COUNT. 8. Which of the following data types is the most suitable for a primary key? A) Text. B) AutoNumber. C) Date/Time. D) Short text. Show Answer Correct Answer: B) AutoNumber. 9. When might a flat file database be considered sufficient? A) When the database needs to handle complex queries and multiple users. B) When the database stores data that changes frequently. C) When there is only a small amount of data. D) When the data needs to be highly secure. Show Answer Correct Answer: C) When there is only a small amount of data. 10. Which type of data model provides a technical map of rules and data structures? A) Logical Data Model. B) Conceptual Data Model. C) Physical Data Model. D) Hierarchical Data Model. Show Answer Correct Answer: A) Logical Data Model. 11. Which SQL clause is used to filter records? A) WHERE. B) SELECT. C) GROUP BY. D) ORDER BY. Show Answer Correct Answer: A) WHERE. 12. Which type of data model includes technical details and performance needs for hardware? A) Conceptual Data Model. B) Physical Data Model. C) Logical Data Model. D) Abstract Data Model. Show Answer Correct Answer: B) Physical Data Model. 13. DCL provides commands to perform actions like A) Change the structure of Tables. B) Insert, Update or Delete Records and Values. C) Authorizing Access and other control over Database. D) None of Above. Show Answer Correct Answer: C) Authorizing Access and other control over Database. 14. A transaction runs a query SELECT COUNT(*) and gets a higher count when running the same query again 5 seconds later. What concurrency phenomenon has occurred? A) Phantom Read. B) Non-Repeatable Read. C) Dirty Read. D) Consistency Failure. Show Answer Correct Answer: A) Phantom Read. 15. Normalization A) It reduces data redundancy and improves data integrity. B) It increases data redundancy and decreases data integrity. C) It eliminates all data from the database. D) It is a method to encrypt sensitive data. Show Answer Correct Answer: A) It reduces data redundancy and improves data integrity. 16. What data type is used to store a unique sequential number for each record in a table? A) Number. B) Date/Time. C) AutoNumber. D) Yes/No. Show Answer Correct Answer: C) AutoNumber. 17. In Datasheet View, how can you arrange records alphabetically? A) Using Advanced Filter Sort. B) Using the Sort button (A to Z or Z to A). C) Using Design View. D) None of the above. Show Answer Correct Answer: B) Using the Sort button (A to Z or Z to A). 18. Andre is setting up a new business and needs to keep track of his sales and expenses. Which data type is suitable for storing monetary values? A) Currency. B) Text. C) Date/Time. D) Memo. Show Answer Correct Answer: A) Currency. 19. What happens when you modify a field's data type in Design View? A) All existing data is automatically converted. B) The database might lose data if incompatible. C) Nothing changes until you enter new data. D) The field is automatically deleted. Show Answer Correct Answer: B) The database might lose data if incompatible. 20. What is a table in a database? A) A collection of unrelated records. B) A basic unit containing data on a specific topic. C) A type of software. D) A method of data retrieval. Show Answer Correct Answer: B) A basic unit containing data on a specific topic. 21. What is the purpose of restoring data from a backup? A) To recover lost information. B) To create new designs. C) To edit photos. D) To write stories. Show Answer Correct Answer: A) To recover lost information. 22. Which programming language is widely used for business applications? A) COBOL. B) FORTRAN. C) Java. D) PASCAL. Show Answer Correct Answer: A) COBOL. 23. A Database Management system isa type of ..... software. A) Itis a type of system software. B) It is a kind of application software. C) It is a kind of general software. D) Both A and C. Show Answer Correct Answer: A) Itis a type of system software. 24. In an ERD, what does a diamond shape represent? A) An entity. B) An attribute. C) A relationship. D) A primary key. Show Answer Correct Answer: C) A relationship. 25. Berikut adalah contoh perangkat lunak yang digunakan untuk mengelola basis data, kecuali ..... A) Oracle. B) Microsoft SQL. C) Sybase. D) Microsoft Access. E) Microsoft Word. Show Answer Correct Answer: E) Microsoft Word. ← 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