This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 30 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 30 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. .... model stores the data in the form of objects, attributes and methods, classes and Inheritance. A) Relational. B) Object. C) Hierarchical. D) Entity Relationship. Show Answer Correct Answer: B) Object. 2. Which of the following are components of relational databases? A) Tables, Keys, Relationships. B) Files, Folders, Directories. C) Nodes, Edges, Graphs. D) Classes, Objects, Methods. Show Answer Correct Answer: A) Tables, Keys, Relationships. 3. A field- A) This is a piece of record with a single Data Fragment. B) This is a database optimized or designed for a virtualized environment. C) This is a set of instructions and rules that will help you use the DBMS. D) This is a systematic data set. E) This is a relatively new science that involves studying, planning, and developing interactions between people (users) and computers. Show Answer Correct Answer: A) This is a piece of record with a single Data Fragment. 4. A process for assigning attributes into a table and reduces data redundancy and helps eliminate the data anomalies that associated with poor database design is called as: A) Normalization. B) Information Redundancy. C) Anomalies. D) None of the above. Show Answer Correct Answer: A) Normalization. 5. Each time attribute A appears, it is associated with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that: A) A $\rightarrow$ B. B) A $\rightarrow$ C. C) A $\rightarrow$ (B, C). D) (B, C) $\rightarrow$ A. Show Answer Correct Answer: A) A $\rightarrow$ B. 6. Which data type is used to store numerical values without decimals in a database? A) Integer. B) Real. C) Text/alphanumeric. D) Date/timeTagsLO2. Show Answer Correct Answer: A) Integer. 7. The language used to define database structure is: A) DML. B) DDL. C) DCL. D) HTML. Show Answer Correct Answer: B) DDL. 8. Who is responsible for managing the overall database environment including security and performance? A) Database Designer. B) End User. C) Application Programmer. D) Database Administrator (DBA). Show Answer Correct Answer: D) Database Administrator (DBA). 9. What does the $ in operator do? A) Checks if a field exists. B) Matches values in an array of possible values. C) Checks if a field contains null. D) Matches only numeric values. Show Answer Correct Answer: B) Matches values in an array of possible values. 10. Which of the following occurs when the same attribute in related data files has different values? A) Data redundancy. B) Data duplication. C) Data discrepancy. D) Data inconsistency. Show Answer Correct Answer: D) Data inconsistency. 11. In a relational database, what uniquely identifies each tuple? A) A foreign key. B) An attribute. C) A primary key. D) A field. Show Answer Correct Answer: C) A primary key. 12. Why would you want to store certain types of data in Microsoft Access rather than in Microsoft Excel? A) For better data visualization. B) For more complex data management. C) For simpler calculations. D) For creating presentations. Show Answer Correct Answer: B) For more complex data management. 13. What is the primary goal of database normalization? A) To speed up query execution. B) To reduce data redundancy and improve data integrity. C) To create more tables in the database. D) To simplify SQL queries. Show Answer Correct Answer: B) To reduce data redundancy and improve data integrity. 14. What is a primary key in a database? A) A primary key in a database is a unique identifier for each record in a table. B) A primary key in a database is a backup key used in case the original key is lost. C) A primary key in a database is a field that stores the most important data. D) A primary key in a database is a foreign key that links two tables. Show Answer Correct Answer: A) A primary key in a database is a unique identifier for each record in a table. 15. A group of similar data in a database, with rows for each instance of an entity and columns for each attribute. A) Table. B) Record. C) Field. D) Database. Show Answer Correct Answer: A) Table. 16. Which of the following SQL commands is used to insert data into a table? A) Insert into. B) Add to. C) Append to. D) Put into. Show Answer Correct Answer: A) Insert into. 17. Which of the following is NOT a purpose of a DBMS in a school setting? A) To track student grades. B) To store information about social media users. C) To store student information. D) To track student attendance. Show Answer Correct Answer: B) To store information about social media users. 18. What is the purpose of a join operation in SQL? A) To combine rows from two or more tables based on a related column. B) To delete records from a table. C) To update existing records. D) To create a new table. Show Answer Correct Answer: A) To combine rows from two or more tables based on a related column. 19. Which of the following best defines a foreign key in a relational database? A) A key used for data encryption. B) A key that uniquely identifies each record. C) A key used to establish relationships between tables. D) A key used to index data for faster retrieval. Show Answer Correct Answer: C) A key used to establish relationships between tables. 20. Which data model is designed to reflect real-world entities as objects? A) Network. B) Object-oriented. C) Relational. D) Flat-file. Show Answer Correct Answer: B) Object-oriented. 21. Berikut perintah yang digunakan untuk menambah kolom harga setelah penerbit padatabel buku adalah ..... A) . Alter table buku harga penerbit;. B) Alter table buku add harga float after penerbit;. C) Alter table buku add harga after penerbit;. D) Insert into buku values harga;. E) Insert into buku values harga after penerbit;. Show Answer Correct Answer: C) Alter table buku add harga after penerbit;. 22. A ..... is a program that performs some common action on database data and that is stored in the database. A) Trigger. B) Stored procedure. C) Pseudofile. D) None of the above is correct. Show Answer Correct Answer: B) Stored procedure. 23. Which of the following best defines 'data'? A) Facts and statistics collected for reference or analysis. B) Information processed and organized in a meaningful way. C) Knowledge derived from study, experience, or instruction. D) None of the above. Show Answer Correct Answer: A) Facts and statistics collected for reference or analysis. 24. Indicate whether the statement is true or false:Many back-end databases cannot interpret commands written in HTML. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 25. What is concurrency in databases primarily concerned with? A) Preventing unauthorized access. B) Allowing multiple users to access data at the same time. C) Maintaining backup copies. D) Formatting data properly. Show Answer Correct Answer: B) Allowing multiple users to access data at the same time. ← 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