This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 12 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 12 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Consider a table with attributes A, B, C, D, E and the following functional dependencies:A$\rightarrow$B, B$\rightarrow$C, C$\rightarrow$D, and A$\rightarrow$E. Which normal form is the table currently in? A) 3NF. B) 2NF. C) BCNF. D) 1NF. Show Answer Correct Answer: D) 1NF. 2. Which of the following is an example of selecting different queries in a database? A) Choosing between SELECT, UPDATE, and DELETE statements. B) Changing the data type of a column. C) Adding a new user to the database. D) Backing up the database. Show Answer Correct Answer: A) Choosing between SELECT, UPDATE, and DELETE statements. 3. What is a relationship in database applications? A) An automatic check for data entry. B) A table of data items. C) A feature for linking tables together. D) A diagram representing database structure. Show Answer Correct Answer: C) A feature for linking tables together. 4. Juvante is managing a library database. What is the purpose of a query in this database? A) To delete records permanently. B) To ask questions and retrieve specific information from a table. C) To create new tables automatically. D) To back up the database. Show Answer Correct Answer: B) To ask questions and retrieve specific information from a table. 5. Which SQL command is used to remove a record from a table? A) REMOVE. B) TRUNCATE. C) DROP. D) DELETE. Show Answer Correct Answer: D) DELETE. 6. Which SQL statement correctly performs an inner join between Customer (alias c) and Order (alias o) on customerId? A) SELECT * FROM Customer c NATURAL JOIN;. B) SELECT * FROM Customer c, Order o;. C) SELECT * FROM Customer c INNER JOIN Order o ON c.customerId = o.customerId;. D) SELECT * FROM Customer c INNER JOIN Order o;. Show Answer Correct Answer: C) SELECT * FROM Customer c INNER JOIN Order o ON c.customerId = o.customerId;. 7. A transaction reads a row. Another transaction modifies and commits a change to that same row. When the first transaction reads the row again, it gets a different value. What is this phenomenon called? A) Deadlock. B) Non-Repeatable Read. C) Dirty Read. D) Phantom Read. Show Answer Correct Answer: B) Non-Repeatable Read. 8. In a client/server DBMS, the server is responsible for: A) Processing business logic. B) Handling user input. C) Managing database storage and queries. D) Running applications. Show Answer Correct Answer: C) Managing database storage and queries. 9. In the context of data mining, the term associations refers to ..... A) Occurrences linked to a single event. B) Events linked over time. C) Undiscovered groupings. D) Patterns that describe a group to which an item belongs. Show Answer Correct Answer: A) Occurrences linked to a single event. 10. What is the role of a foreign key in a database? A) To uniquely identify rows. B) To store encrypted values. C) To link related tables. D) To back up primary keys. Show Answer Correct Answer: C) To link related tables. 11. What does a relationship in a database do? A) Connects two entities. B) Creates a new database. C) Stores data. D) Deletes data. Show Answer Correct Answer: A) Connects two entities. 12. A database cannot be organised. A) TRUE. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 13. Database ..... which is the logical design of the database, and the database ..... which is a snapshot of the data in the database at a given instant in time. A) Relation, Schema. B) Relation, Domain. C) Schema, Instance. D) Instance, Schema. Show Answer Correct Answer: C) Schema, Instance. 14. In a database, what does the term 'row' refer to? A) A category of data. B) A type of database. C) A method of data retrieval. D) A single entry of data. Show Answer Correct Answer: D) A single entry of data. 15. Berdasarkan tugas yang diberikan di awal video, database 'Kasir' seharusnya memiliki tabel-tabel berikut, kecuali ..... A) Karyawan. B) Barang. C) Pelanggan. D) Penjualan. Show Answer Correct Answer: A) Karyawan. 16. Which of the following data types is automatically generated and incremented by Access? A) Memo. B) AutoNumber. C) Yes/No. D) Text. Show Answer Correct Answer: B) AutoNumber. 17. Which ACID property is best described as 'a transaction must bring the database from one valid state to another, following all defined rules and constraints'? A) Durability. B) Consistency. C) Isolation. D) Atomicity. Show Answer Correct Answer: B) Consistency. 18. What is a one-to-many relationship? A) Many records relate to one record. B) One record relates to many records. C) No relationship exists. D) One record relates to one record. Show Answer Correct Answer: B) One record relates to many records. 19. What does a one-to-one relationship in a relational database imply? A) Multiple records from one table link to one record in another table. B) One record from one table links to one record in another table. C) No records are linked between tables. D) One record from one table can link to multiple records in another table. Show Answer Correct Answer: B) One record from one table links to one record in another table. 20. Which component of a database is similar to a spreadsheet? A) Table. B) Record. C) Database. D) Field. Show Answer Correct Answer: A) Table. 21. What does WHERE clause do in an SQL SELECT statement? A) Deletes specific data. B) Sorts the data by date. C) Filters records based on conditions. D) Creates a new column. Show Answer Correct Answer: C) Filters records based on conditions. 22. Which of the following is NOT an ACID property of a transaction? A) Consistency. B) Integrity. C) Durability. D) Atomicity. Show Answer Correct Answer: B) Integrity. 23. Berikan contoh SQL query untuk menampilkan semua data dari tabel 'mahasiswa'. A) SELECT * FROM mahasiswa;. B) SELECT * FROM students;. C) SELECT * FROM data mahasiswa;. D) SHOW mahasiswa;. Show Answer Correct Answer: A) SELECT * FROM mahasiswa;. 24. What would be a strategic reason to use a flat-file database instead of a relational database for a small startup's employee records? A) It requires less technical skill to manage. B) It can handle more complex queries. C) It offers better connectivity with web applications. D) It provides automatic backup featuresTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: A) It requires less technical skill to manage. 25. The Database Management System can be divided into ..... major components A) Two. B) Six. C) Five. D) Three. Show Answer Correct Answer: C) Five. 26. What is the role of data consistency? A) To distribute data across systems. B) To allow for multiple, conflicting standards. C) To ensure data is in a uniform format across systems. D) None of the above. Show Answer Correct Answer: C) To ensure data is in a uniform format across systems. 27. What is the role of OLAP in data warehousing? A) OLAP focuses on real-time data processing and transaction management. B) OLAP is primarily used for data storage in warehouses. C) OLAP is a tool for data entry and data cleansing in databases. D) OLAP enables complex data analysis and multidimensional querying in data warehousing. Show Answer Correct Answer: D) OLAP enables complex data analysis and multidimensional querying in data warehousing. 28. What is data abstraction in database systems? A) Backing up data. B) Deleting old data. C) Encrypting data. D) Hiding irrelevant details from users. Show Answer Correct Answer: D) Hiding irrelevant details from users. 29. Database can be ..... based with one sole purpose of storing data. A) Software. B) Hardware. C) A (or) b. D) A (and) b. Show Answer Correct Answer: C) A (or) b. 30. What is the main difference between a database and a table? A) A database is smaller than a table. B) A table can contain multiple databases. C) A database can contain multiple tables. D) There is no difference. Show Answer Correct Answer: C) A database can contain multiple tables. 31. How do you represent relationships in an ER diagram? A) Relationships are represented by diamonds connecting entities in an ER diagram. B) Relationships are represented by arrows pointing to entities in an ER diagram. C) Relationships are represented by squares in an ER diagram. D) Relationships are represented by circles connecting entities in an ER diagram. Show Answer Correct Answer: A) Relationships are represented by diamonds connecting entities in an ER diagram. 32. What is a transaction in database terminology? A) A hardware component. B) A logical unit of database processing including one or more operations. C) A type of database user. D) A monetary exchange. Show Answer Correct Answer: B) A logical unit of database processing including one or more operations. 33. Apa kepanjangan dari DBMS? A) Sistem Manajemen Basis Data. B) Sistem Model Basis Data. C) Sistem Manajemen Cadangan Data. D) Sistem Manajemen Buffer Data. E) Sistem Manajemen Bisnis Data. Show Answer Correct Answer: A) Sistem Manajemen Basis Data. 34. Can an entity have multiple attributes? A) Attributes are not applicable to entities. B) Entities cannot have any attributes. C) Yes, an entity can have multiple attributes. D) An entity can only have one attribute. Show Answer Correct Answer: C) Yes, an entity can have multiple attributes. 35. .... model stores the data in the form of objects, attributes and methods, classes and Inheritance. A) Relational. B) Object. C) Entity Relationship. D) Hierarchical. Show Answer Correct Answer: B) Object. 36. Which of the following are components of relational databases? A) Files, Folders, Directories. B) Nodes, Edges, Graphs. C) Tables, Keys, Relationships. D) Classes, Objects, Methods. Show Answer Correct Answer: C) Tables, Keys, Relationships. 37. 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. 38. 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, C). B) (B, C) $\rightarrow$ A. C) A $\rightarrow$ B. D) A $\rightarrow$ C. Show Answer Correct Answer: C) A $\rightarrow$ B. 39. Which data type is used to store numerical values without decimals in a database? A) Integer. B) Date/timeTagsLO2. C) Real. D) Text/alphanumeric. Show Answer Correct Answer: A) Integer. 40. The language used to define database structure is: A) DML. B) HTML. C) DDL. D) DCL. Show Answer Correct Answer: C) DDL. 41. Who is responsible for managing the overall database environment including security and performance? A) End User. B) Application Programmer. C) Database Administrator (DBA). D) Database Designer. Show Answer Correct Answer: C) Database Administrator (DBA). 42. What does the $ in operator do? A) Checks if a field contains null. B) Matches values in an array of possible values. C) Matches only numeric values. D) Checks if a field exists. Show Answer Correct Answer: B) Matches values in an array of possible values. 43. Which of the following occurs when the same attribute in related data files has different values? A) Data discrepancy. B) Data redundancy. C) Data inconsistency. D) Data duplication. Show Answer Correct Answer: C) Data inconsistency. 44. In a relational database, what uniquely identifies each tuple? A) A primary key. B) A foreign key. C) An attribute. D) A field. Show Answer Correct Answer: A) A primary key. 45. Why would you want to store certain types of data in Microsoft Access rather than in Microsoft Excel? A) For simpler calculations. B) For more complex data management. C) For better data visualization. D) For creating presentations. Show Answer Correct Answer: B) For more complex data management. 46. 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. 47. What is a primary key in a database? A) A primary key in a database is a foreign key that links two tables. B) A primary key in a database is a unique identifier for each record in a table. C) A primary key in a database is a backup key used in case the original key is lost. D) A primary key in a database is a field that stores the most important data. Show Answer Correct Answer: B) A primary key in a database is a unique identifier for each record in a table. 48. A group of similar data in a database, with rows for each instance of an entity and columns for each attribute. A) Record. B) Field. C) Database. D) Table. Show Answer Correct Answer: D) Table. 49. Which of the following SQL commands is used to insert data into a table? A) Put into. B) Append to. C) Add to. D) Insert into. Show Answer Correct Answer: D) Insert into. 50. Which of the following is NOT a purpose of a DBMS in a school setting? A) To store student information. B) To track student attendance. C) To track student grades. D) To store information about social media users. Show Answer Correct Answer: D) To store information about social media users. 51. Which of the following best defines a foreign key in a relational database? A) A key that uniquely identifies each record. B) A key used for data encryption. C) A key used to index data for faster retrieval. D) A key used to establish relationships between tables. Show Answer Correct Answer: D) A key used to establish relationships between tables. 52. Which data model is designed to reflect real-world entities as objects? A) Flat-file. B) Relational. C) Network. D) Object-oriented. Show Answer Correct Answer: D) Object-oriented. 53. Berikut perintah yang digunakan untuk menambah kolom harga setelah penerbit padatabel buku adalah ..... A) Alter table buku add harga float after penerbit;. B) Insert into buku values harga;. C) . Alter table buku harga penerbit;. D) Alter table buku add harga after penerbit;. E) Insert into buku values harga after penerbit;. Show Answer Correct Answer: D) Alter table buku add harga after penerbit;. 54. 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. 55. 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. 56. 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. 57. 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. 58. In which Normal Form should you eliminate repeating groups? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of these. Show Answer Correct Answer: A) First Normal Form (1NF). 59. You are designing a system to sell subscriptions for online revision guides. What should be your first step when identifying entities? A) Create tables with surrogate primary keys. B) Design user interface wireframes first. C) Look at the data that must be recorded. D) Choose the database management system. Show Answer Correct Answer: C) Look at the data that must be recorded. 60. What is non-structured data? A) Data that is always numerical. B) Data that fits neatly into rows and columns. C) Data that doesn't have a clear order or pattern. D) Data that is always textual. Show Answer Correct Answer: C) Data that doesn't have a clear order or pattern. ← PreviousNext →Related QuizzesScience QuizzesClass 11 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books