This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 56 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 56 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. How would you select all employees with either a 'Manager' or 'Analyst' title? A) SELECT * FROM employees WHERE title IN ('Manager', 'Analyst');. B) SELECT * FROM employees WHERE title = 'Manager' OR title = 'Analyst';. C) SELECT * FROM employees WHERE title = 'Manager' AND title = 'Analyst';. D) SELECT * FROM employees WHERE title LIKE 'Manager' OR title LIKE 'Analyst';. Show Answer Correct Answer: B) SELECT * FROM employees WHERE title = 'Manager' OR title = 'Analyst';. 2. Each row is known as ..... A) Relation. B) Tuple. C) Attribute. D) Field. Show Answer Correct Answer: C) Attribute. 3. What is the correct SQL statement to add a new record into a table? A) UPDATE table SET column=value;. B) INSERT INTO table (column1, column2) VALUES (value1, value2);. C) SELECT column FROM table;. D) DELETE FROM table WHERE condition;. Show Answer Correct Answer: B) INSERT INTO table (column1, column2) VALUES (value1, value2);. 4. What does a many-to-many relationship in a relational database describe? A) A single record in one table linking to multiple records in another table. B) Each record in one table linking to only one record in another table. C) Multiple records in one table linking to the same single record in another table. D) One record in table A links to many records in table B and vice versa. Show Answer Correct Answer: D) One record in table A links to many records in table B and vice versa. 5. ..... establishes an organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information. A) Data scrubbing. B) Data definition. C) Data quality assurance. D) Data governance. Show Answer Correct Answer: D) Data governance. 6. How is data perceived in a logical view compared to a physical view? A) Physical view emphasizes data relationships over structure. B) Data in a logical view focuses on structure and relationships, while in a physical view, it focuses on storage and access methods. C) Logical view deals with how data is stored on disk. D) Data in a logical view is only concerned with data types. Show Answer Correct Answer: B) Data in a logical view focuses on structure and relationships, while in a physical view, it focuses on storage and access methods. 7. Which data type is used in SQL to store true or false values? A) INT. B) BOOLEAN. C) VARCHAR. D) FLOAT. Show Answer Correct Answer: B) BOOLEAN. 8. How many levels of data abstraction are there? A) Two. B) Three. C) Four. D) Five. Show Answer Correct Answer: B) Three. 9. Explain the concept of a primary key. A) A primary key is a unique identifier for a record in a database table. B) A primary key is a type of foreign key. C) A primary key can have duplicate values. D) A primary key is used to store large amounts of data. Show Answer Correct Answer: A) A primary key is a unique identifier for a record in a database table. 10. Dalam model ERD, entitas biasanya diwakili sebagai: A) Lingkaran. B) Segitiga. C) Persegi Panjang. D) Oval. E) Garis. Show Answer Correct Answer: C) Persegi Panjang. 11. Which key is a candidate to be a primary key but is not selected? A) Candidate key. B) Foreign key. C) Composite key. D) Index key. Show Answer Correct Answer: A) Candidate key. 12. Which of the following is NOT true about an Entity Relationship Diagram (ERD) A) It shows how the database is physically represented on the computer system. B) It is based on an abstract, conceptual representation of data called an entity relationship model (ERM). C) It consists of a collection of entity types and relationships. D) It includes attributes for each entity, and multiplicity and participation for each relationship. Show Answer Correct Answer: A) It shows how the database is physically represented on the computer system. 13. How do you design a form for effective data entry? A) Avoid any form of validation. B) Make the form visually complex with many colors. C) Design a user-friendly form with clear labels, grouped fields, input validation, and responsive design. D) Use a single text box for all inputs. Show Answer Correct Answer: C) Design a user-friendly form with clear labels, grouped fields, input validation, and responsive design. 14. What is a many-to-many (M:N) relationship? A) Each record in Table A relates to multiple records in Table C. B) A record in Table A can relate to multiple records in Table A. C) Each record in Table A relates to one record in Table B. D) Records in Table A can relate to multiple records in Table B and vice versa. Show Answer Correct Answer: D) Records in Table A can relate to multiple records in Table B and vice versa. 15. What are the main advantages of using indexes in database management? A) Indexes are used to store data in a database. B) Indexes help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. C) Indexes are only used for data deletion in a database. D) Indexes have no impact on database performance. Show Answer Correct Answer: B) Indexes help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. 16. Which command is used to remove a relation from an SQL? A) Delete. B) Drop table. C) Purge. D) Remove. Show Answer Correct Answer: B) Drop table. 17. What does referential integrity ensure? A) Data can be deleted without restrictions. B) A foreign key must match a primary key in another table. C) Data is always encrypted. D) Data can be duplicated across tables. Show Answer Correct Answer: B) A foreign key must match a primary key in another table. 18. In a relational database, what is an entity? A) A real-world object or concept represented in the database. B) A specific value in a table. C) A software application. D) A piece of hardware. Show Answer Correct Answer: A) A real-world object or concept represented in the database. 19. Apa yang dimaksud dengan total participation? A) Hanya beberapa entitas yang harus berpartisipasi. B) Semua entitas harus berpartisipasi dalam setidaknya satu relasi. C) Entitas mungkin atau mungkin tidak berpartisipasi dalam sebuah relasi. D) Hanya beberapa entitas yang berpartisipasi. Show Answer Correct Answer: B) Semua entitas harus berpartisipasi dalam setidaknya satu relasi. 20. If a new table combines every customer's row with every account's row, it's an example of: A) Normalization. B) Cartesian Product. C) Integrity Rule. D) Schema Mapping. Show Answer Correct Answer: B) Cartesian Product. 21. In a database context, what does a "record" refer to? A) A collection of related files. B) A single row in a table representing a complete set of related data. C) A category of data types. D) A file stored on disk. Show Answer Correct Answer: B) A single row in a table representing a complete set of related data. 22. In E-R Diagram, attribute is represented by ..... A) Rectangle. B) Square. C) All the above. D) None of the above. Show Answer Correct Answer: A) Rectangle. 23. Which type of database management system is most commonly used? A) NoSQL database management system. B) Relational database management system (RDBMS). C) Hierarchical database management system. D) Object-oriented database management system. Show Answer Correct Answer: B) Relational database management system (RDBMS). 24. Which of the following is a type of data model? A) Spreadsheet. B) Word Processor. C) Relational. D) Browser. Show Answer Correct Answer: C) Relational. 25. Explain the role of triggers in database management. A) Triggers are used to create user interfaces for databases. B) Triggers are a type of mathematical equation used to calculate database storage. C) Triggers are procedural code that is automatically executed in response to certain events on a particular table or view in a database. D) Triggers are used to create data redundancy in a database. Show Answer Correct Answer: C) Triggers are procedural code that is automatically executed in response to certain events on a particular table or view in a database. ← 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