This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 71 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 71 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is a sign that a table is not in 3NF? A) It contains non-key attributes that depend on other non-key attributes. B) It has no primary key. C) It has a foreign key. D) It uses an index. Show Answer Correct Answer: A) It contains non-key attributes that depend on other non-key attributes. 2. One specific piece of information about a person or thing is called a: A) Field. B) File. C) Record. D) Table. Show Answer Correct Answer: A) Field. 3. Perintah SQL yang digunakan untuk masuk ke MySQL sebagai pengguna 'root' dengan kata sandi adalah ..... A) Mysql-u root. B) Mysql-p root. C) Mysql-u root-p. D) Mysql root-p. Show Answer Correct Answer: C) Mysql-u root-p. 4. What does ETL stand for? A) Extract, Transform, Load. B) Execute, Transfer, Load. C) Extract, Transfer, Load. D) Execute, Transform, Load. Show Answer Correct Answer: A) Extract, Transform, Load. 5. The AND operator combines two relational expressions where only one must be true to provide a true result A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 6. Which of the following is a limitation of a file-based approach? A) Data privacy. B) Data normalization. C) Data redundancy. D) Data integrity. Show Answer Correct Answer: C) Data redundancy. 7. What type of relationship exists when a single record in one table is related to multiple records in another table? A) One-to-One. B) Many-to-Many. C) One-to-Many. D) Many-to-One. Show Answer Correct Answer: C) One-to-Many. 8. What is a functional dependency? A) When an non-key attribute is determined by a whole part of a COMPOSITE primary key. B) When a key field is changed and it conflicts with another key. C) When a database function is dependant of the operation of another function to work correctly. D) When data is a database is repeated for different entities. Show Answer Correct Answer: A) When an non-key attribute is determined by a whole part of a COMPOSITE primary key. 9. Which model represents more complex applications? A) Relational model. B) Object model. C) ER Database model. D) None of the above. Show Answer Correct Answer: D) None of the above. 10. Ananya wants to make sure that each student's roll number is unique. What should she use? A) Filter. B) Caption. C) Primary Key. D) Field Template. Show Answer Correct Answer: C) Primary Key. 11. Involves database design and construction on how the databases will operate and f unction within exisiting structures and location. A) Database System Architecture. B) Database System Schedma. C) Database System Developer. D) Database System Platform. Show Answer Correct Answer: A) Database System Architecture. 12. What is the software used to manage databases called? A) Information Retrieval System. B) Database Management System (DBMS). C) Data Storage System. D) File Management System. Show Answer Correct Answer: B) Database Management System (DBMS). 13. 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? A) Program-data dependence. B) Lack of flexibility. C) Poor security. D) Data redundancy. Show Answer Correct Answer: B) Lack of flexibility. 14. What is the role of constraints in a database? A) To allow fields to be left blank. B) To define rules about what can or cannot be entered. C) To format data automatically. D) To create relationships between tables. Show Answer Correct Answer: B) To define rules about what can or cannot be entered. 15. Filter A) A function used to hide unwanted records in a table. For example:only show managers from an employee database. B) A method to sort records in ascending order. C) A tool to delete records permanently from a database. D) A feature that allows users to view all records without any restrictions. Show Answer Correct Answer: A) A function used to hide unwanted records in a table. For example:only show managers from an employee database. 16. What is the purpose of a social media database? A) To store information about products. B) To store information about customers. C) To store information about social media users. D) To store information about finances. Show Answer Correct Answer: C) To store information about social media users. 17. Write a SQL query to retrieve all the records from a table named 'students'. A) SELECT * FROM students;. B) GET FROM students. C) RETRIEVE * FROM students. D) SELECT ALL students. Show Answer Correct Answer: A) SELECT * FROM students;. 18. In order to retrieve data from two or more tables through query, we must establish a ..... between tables. A) Field. B) Primary key. C) Relationship. D) Criteri. Show Answer Correct Answer: C) Relationship. 19. Apa singkatan dari HTML? A) High Tech Markup Language. B) Hyperlink Markup Language. C) Hypertext Markup Language. D) Hyperspace Markup Language. Show Answer Correct Answer: C) Hypertext Markup Language. 20. A DBMS makes the ..... A) Physical database available for different logical views. B) Relational database available for different logical views. C) Physical database available for different analytic views. D) Relational database available for different analytic views. Show Answer Correct Answer: A) Physical database available for different logical views. 21. Data is the collection of raw facts. A) TRUE. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 22. Why is it important to have unique records in a database? A) To allow for easier data entry by having multiple records for the same entity. B) To increase the complexity of data retrieval processes. C) It is important to have unique records in a database to ensure data integrity, prevent duplication, and facilitate efficient data management. D) To ensure that all records are identical for consistency. Show Answer Correct Answer: C) It is important to have unique records in a database to ensure data integrity, prevent duplication, and facilitate efficient data management. 23. In which stage is user training typically conducted? A) Design. B) Maintenance. C) Implementation. D) Initial study. Show Answer Correct Answer: C) Implementation. 24. What is a columnar format in MS Access? A) A layout for tables and forms. B) A tool for exporting data. C) A way to delete data. D) A password protection feature. Show Answer Correct Answer: A) A layout for tables and forms. 25. Which SQL standard was introduced in 1999? A) SQL-2003. B) SQL-89. C) SQL-86. D) SQL:1999. Show Answer Correct Answer: D) SQL:1999. ← 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