This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 35 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 35 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which one of the following is an example for RDBMS? A) Dbase. B) FoxPro. C) Oracle. D) All the above. Show Answer Correct Answer: C) Oracle. 2. What is a composite attribute? A) An attribute with multiple values. B) An attribute that is derived from others. C) An attribute composed of multiple sub-parts. D) None of the above. Show Answer Correct Answer: C) An attribute composed of multiple sub-parts. 3. What data type is used to store numeric data that is larger than 8 bytes, such as currency values? A) Currency. B) Large Number. C) Date/Time. D) Number. Show Answer Correct Answer: B) Large Number. 4. What is normalization? A) Organizing data into multiple related tables. B) Deleting all redundant data. C) Adding more data to a table. D) Changing data formats. Show Answer Correct Answer: A) Organizing data into multiple related tables. 5. How does a foreign key differ from a primary key? A) A primary key can be null; a foreign key must always be unique. B) A primary key is optional; a foreign key is always required in a table. C) A primary key uniquely identifies records; a foreign key links to a primary key in another table. D) A primary key can link to multiple tables; a foreign key is unique to one table. Show Answer Correct Answer: C) A primary key uniquely identifies records; a foreign key links to a primary key in another table. 6. Which feature helps in creating a basic form quickly? A) Form Wizard. B) Report Wizard. C) Table Wizard. D) Query Wizard. Show Answer Correct Answer: A) Form Wizard. 7. Which type of data is best stored in a relational database? A) Random data. B) Structured data. C) Semi-structured data. D) Non-structured data. Show Answer Correct Answer: B) Structured data. 8. Which SQL statement would you use to remove a student from a database? A) SELECT. B) UPDATE. C) DELETE. D) INSERT. Show Answer Correct Answer: C) DELETE. 9. Two-phase locking protocol ensures: A) Durability. B) Atomicity. C) Serializability. D) Deadlock freedom. Show Answer Correct Answer: C) Serializability. 10. Collection of multipleinterconnected databases, spread physically across various locations. A) Distribution Database System. B) Centered Database System. C) Centralized Database System. D) Distributed Database System. Show Answer Correct Answer: D) Distributed Database System. 11. Which of the following best describes MongoDB? A) Relational database. B) Graph database. C) Key-value store. D) Document-oriented NoSQL database. Show Answer Correct Answer: D) Document-oriented NoSQL database. 12. A database is a collection of ..... that can be organized, sorted, and searched. A) Fields. B) Tables. C) Data. D) Records. Show Answer Correct Answer: C) Data. 13. What is an attribute in an ERD? A) A unique identifier for a record. B) A characteristic or property of an entity. C) A field that contains a foreign key. D) A relationship between two entities. Show Answer Correct Answer: B) A characteristic or property of an entity. 14. Which clause is used to sort the result set of a query? A) WHERE. B) ORDER BY. C) GROUP BY. D) SORT BY. Show Answer Correct Answer: B) ORDER BY. 15. What does DML stand for in databases? A) Database Management Language. B) Data Manipulation Language. C) Data Migration Language. D) Data Modeling Language. Show Answer Correct Answer: B) Data Manipulation Language. 16. Which set lists typical attributes for the Customer table in this schema? A) SubID, startDate, endDate, price. B) CustID, title, surname, email. C) ProductID, subject, level, price. D) OrderID, shipDate, warehouse, city. Show Answer Correct Answer: B) CustID, title, surname, email. 17. When using the Form Wizard, what is NOT a standard option? A) Selecting fields to include. B) Creating automatic calculations. C) Selecting the data source. D) Choosing a layout style. Show Answer Correct Answer: B) Creating automatic calculations. 18. Ava is working on a project where she needs to analyze sales data. What do queries allow her to do with her data? A) View related data and perform calculations. B) Create animations. C) Design websites. D) Write novels. Show Answer Correct Answer: A) View related data and perform calculations. 19. Which data model is used for conceptual database design? A) Relational. B) Hierarchical. C) Network. D) ER model. Show Answer Correct Answer: D) ER model. 20. Deadlock occurs when: A) Transactions execute serially. B) Two transactions wait for each other. C) Commit is delayed. D) DB crashes. Show Answer Correct Answer: B) Two transactions wait for each other. 21. A deletion anomaly occurs when: A) A foreign key is added. B) Deleting data unintentionally removes other related information. C) A table is updated. D) Relationships are removed. Show Answer Correct Answer: B) Deleting data unintentionally removes other related information. 22. Data redundancy leads to ..... A) Data independence. B) Data consistency. C) Data security. D) Data inconsistency. Show Answer Correct Answer: D) Data inconsistency. 23. How is data organized within a record? A) Data is stored as a single block within a record. B) Data is categorized by types within a record. C) Data is organized into fields within a record. D) Data is organized into tables within a record. Show Answer Correct Answer: C) Data is organized into fields within a record. 24. Information in Database A) Processed data that is meaningful and useful to users. B) Raw data that has not been analyzed. C) Data that is stored in a database without context. D) Information that is outdated and irrelevant. Show Answer Correct Answer: A) Processed data that is meaningful and useful to users. 25. Dalam video, kolom 'id ..... nama' pada tabel 'nama ..... siswa' menggunakan tipe data 'VARCHAR(40)'. Apa fungsi dari 'VARCHAR'? A) Menyimpan teks dengan panjang variabel. B) Menyimpan nilai boolean (benar/salah). C) Menyimpan bilangan bulat. D) Menyimpan tanggal dan waktu. Show Answer Correct Answer: A) Menyimpan teks dengan panjang variabel. 26. Which DBMS advantage helps in reducing storage costs and eliminating update anomalies? A) Controlling redundancy. B) Security control. C) Backup and recovery. D) Multiple user interfaces. Show Answer Correct Answer: A) Controlling redundancy. 27. Indicate whether the statement is true or false:A query is a request for data from a database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 28. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity? A) ID-dependent entity. B) Weak entity. C) ID-independent entity. D) Strong entity. Show Answer Correct Answer: A) ID-dependent entity. 29. What is a data model? A) A conceptual blueprint. B) A table. C) A report. D) A keyboard layout. Show Answer Correct Answer: A) A conceptual blueprint. 30. What SQL command is used to create a trigger? A) INSERT TRIGGER. B) MODIFY TRIGGER. C) CREATE TRIGGER. D) ADD TRIGGER. Show Answer Correct Answer: C) CREATE TRIGGER. 31. Which of the following options states the importance of data modeling? A) It helps in organizing and securing data. B) It ensures medical professionals are trained. C) It guarantees patient confidentiality. D) It reduces the need for technology. Show Answer Correct Answer: A) It helps in organizing and securing data. 32. What is the maximum size of a single BSON document in MongoDB? A) 1 MB. B) 64 MB. C) 32 MB. D) 16 MB. Show Answer Correct Answer: D) 16 MB. 33. What characterizes a flat-file database? A) It stores data using multiple linked tables. B) It stores all data items using one table. C) It involves a diagram illustrating relationships. D) It includes automatic validation checks. Show Answer Correct Answer: B) It stores all data items using one table. 34. Kemar is organizing his computer. What is the difference between a file and a folder? A) A file contains other files, while a folder stores data. B) A folder contains files, while a file stores specific data. C) A file is larger than a folder. D) A folder is always smaller than a file. Show Answer Correct Answer: B) A folder contains files, while a file stores specific data. 35. A school keeps a register where each student's name, roll number, and marks are written. This register is an example of a: A) Spreadsheet. B) Application. C) Program. D) Database. Show Answer Correct Answer: D) Database. 36. Why might Subscription include both startDate and endDate fields? A) Track the active period of a subscription. B) Hold the product's academic difficulty level. C) Store the customer's full legal name. D) Calculate the static product attributes. Show Answer Correct Answer: A) Track the active period of a subscription. 37. List one advantage of using Structured Query Language (SQL). A) SQL provides a standardized way to manage and query relational databases. B) SQL requires complex programming skills. C) SQL is limited to non-relational databases. D) SQL is only used for data visualization. Show Answer Correct Answer: A) SQL provides a standardized way to manage and query relational databases. 38. What does "normalization" aim to achieve in a database? A) Speed up data retrieval. B) Organize data to reduce redundancy and improve integrity. C) Create relationships between databases. D) Combine multiple columns into one. Show Answer Correct Answer: B) Organize data to reduce redundancy and improve integrity. 39. ..... refers to the data about data. A) Relation. B) Metadata. C) Instance. D) Schema. Show Answer Correct Answer: B) Metadata. 40. Which function returns the current system date? A) CURRENT(). B) SYSDATE(). C) TODAY(). D) DATE(). Show Answer Correct Answer: B) SYSDATE(). 41. In an E-R diagram that uses Chen Notation attributes are represented by A) Square. B) Rectangle. C) Ellipse. D) Triangle. Show Answer Correct Answer: C) Ellipse. 42. Which SQL keyword is used to filter records before an aggregation is performed? A) HAVING. B) GROUP BY. C) DISTINCT. D) WHERE. Show Answer Correct Answer: D) WHERE. 43. Apa fungsi CRUD dalam sebuah basis data? A) Operasi dasar pada data (Buat, Baca, Perbarui, Hapus). B) Proses migrasi data. C) Proses pencadangan data. D) Proses normalisasi basis data. E) Menghapus data dari basis data. Show Answer Correct Answer: A) Operasi dasar pada data (Buat, Baca, Perbarui, Hapus). 44. If we delete all rows from a table but keep its columns, what remains? A) Instance. B) Schema. C) Domain. D) Tuple. Show Answer Correct Answer: B) Schema. 45. Which of the following is an example of a field in a student database? A) Student ID. B) A list of all students. C) A table of student grades. D) A query to find students with grades above 90. Show Answer Correct Answer: A) Student ID. 46. What is the purpose of the 'Check' constraint? A) To enforce a condition on a column's values. B) To prevent null values. C) To define a foreign key. D) None of the above. Show Answer Correct Answer: A) To enforce a condition on a column's values. 47. Jenis hubungan manakah yang merupakan tipe hubungan dalam ERD? A) Dua-ke-Satu, Satu-ke-Dua, Banyak-ke-Banyak. B) Satu-ke-Satu, Satu-ke-Banyak, Banyak-ke-Banyak. C) Banyak-ke-Banyak, Satu-ke-Satu, Dua-ke-Dua. D) Satu-ke-Satu, Satu-ke-Satu, Banyak-ke-Satu. E) Satu-ke-Banyak, Dua-ke-Banyak, Banyak-ke-Banyak. Show Answer Correct Answer: B) Satu-ke-Satu, Satu-ke-Banyak, Banyak-ke-Banyak. 48. What is a field in a database table? A) A field used to uniquely identify any record. B) A single type of data. C) A set of related fields. D) A complete set of related records. Show Answer Correct Answer: B) A single type of data. 49. Which data type is used to store true/false values? A) BIT. B) BOOLEAN. C) BOOL. D) LOGICAL. Show Answer Correct Answer: B) BOOLEAN. 50. Which term describes a single piece of information within a record? A) Attribute. B) Field. C) Composite key. D) File. Show Answer Correct Answer: B) Field. 51. Explain the concept of data encryption in databases. A) Data encryption in databases protects sensitive information by converting it into a coded format that is unreadable without the proper decryption key. B) Data encryption in databases makes data more accessible to unauthorized users. C) Data encryption in databases is used to speed up data retrieval. D) Data encryption in databases involves storing data in plain text format. Show Answer Correct Answer: A) Data encryption in databases protects sensitive information by converting it into a coded format that is unreadable without the proper decryption key. 52. Which of the following is a characteristic of a "Many to Many" relationship in databases? A) Each record in one table relates to only one record in another table. B) Each table has only one record. C) Each record in one table can relate to multiple records in another table. D) There are no relationships between tables. Show Answer Correct Answer: C) Each record in one table can relate to multiple records in another table. 53. Perintah yang digunakan untuk menampilkan struktur table adalah ..... A) Desc nama table:. B) Desc nama table ;. C) Select nama table;. D) Show tables nama table ;. E) Show databases nama table ;. Show Answer Correct Answer: B) Desc nama table ;. 54. Which of the following is not considered a core element of an enterprise database system? A) DBMS. B) COBOL programs. C) Database applications. D) Users. Show Answer Correct Answer: B) COBOL programs. 55. What happens in the DBLC design phase? A) Write code. B) Create logical/physical structure. C) Launch website. D) Analyze budget. Show Answer Correct Answer: B) Create logical/physical structure. 56. What is "embedded SQL" ? A) SQL written by users in SQL Developer. B) SQL included within a GUI application and executed via code. C) SQL stored in a stored procedure. D) SQL used by the Oracle server to create indexes. Show Answer Correct Answer: B) SQL included within a GUI application and executed via code. 57. The SQL statement 'select round (1047.785, 2) from dual' will display 1047.78 A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 58. In the relational model, a tuple represents: A) A column. B) A row. C) A relation. D) A primary key. Show Answer Correct Answer: B) A row. 59. Which of the following is NOT a feature of a primary key? A) Uniqueness. B) Allowing null values. C) Identifying records. D) Being a candidate key. Show Answer Correct Answer: B) Allowing null values. 60. Which of the following is an example of a data model? A) Python. B) SQL. C) Relational Model. D) HTML. Show Answer Correct Answer: C) Relational Model. ← 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