This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 9 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 9 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Define an attribute and provide an example. A) An example of an attribute is 'size' in a clothing item. B) An example of an attribute is 'color' in a car object. C) An example of an attribute is 'speed' in a bicycle object. D) An example of an attribute is 'brand' in a smartphone object. Show Answer Correct Answer: B) An example of an attribute is 'color' in a car object. 2. What type of software is Microsoft Access? A) Database software. B) Spreadsheet software. C) Image editing software. D) Presentation software. Show Answer Correct Answer: A) Database software. 3. What is the smallest piece of information for an entity in a database? A) Field. B) Form. C) Record. D) Query. Show Answer Correct Answer: A) Field. 4. Which normal form removes duplicate groups of data? A) Fourth Normal Form (4NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) First Normal Form (1NF). Show Answer Correct Answer: D) First Normal Form (1NF). 5. Which of the following describes a composite key? A) A single attribute that uniquely identifies a record. B) A key used to establish a relationship between two tables. C) A combination of two or more attributes that uniquely identifies a record. D) A key that cannot be null. Show Answer Correct Answer: C) A combination of two or more attributes that uniquely identifies a record. 6. What is an Entity-Relationship Diagram (ERD) used for? A) To define data types for fields in a database. B) To perform complex calculations. C) To encrypt sensitive information in a database. D) To visualize the relationships between tables in a database. Show Answer Correct Answer: D) To visualize the relationships between tables in a database. 7. In an UPDATE statement, which clause is used to specify the records that should be modified? A) WHERE. B) GROUP BY. C) SET. D) ORDER BY. Show Answer Correct Answer: A) WHERE. 8. What language is primarily used for interacting with databases? A) SQL. B) Python. C) HTML. D) Java. Show Answer Correct Answer: A) SQL. 9. Setiap perintah SQL dalam video diakhiri dengan karakter apa? A) :(titik dua). B) , (koma). C) ; (titik koma). D) . (titik). Show Answer Correct Answer: C) ; (titik koma). 10. An attribute is represented by what in a database? A) Row. B) Table. C) Cell. D) Column. Show Answer Correct Answer: D) Column. 11. To create a relationship between two tables, what database element is placed in the child table referencing the parent's key? A) A calculated field. B) A foreign key column. C) A stored procedure. D) A unique index. Show Answer Correct Answer: B) A foreign key column. 12. In a library database, what would a single book most likely represent? A) A database. B) A record. C) A field. D) A table. Show Answer Correct Answer: B) A record. 13. Data independence refers to: A) The ability to run queries without a database. B) The independence of data from the user interface. C) The ability to use multiple database types. D) The ability to change the database schema without affecting the application. Show Answer Correct Answer: D) The ability to change the database schema without affecting the application. 14. What is a trigger in a database? A) A rule activated by updates. B) A type of database. C) A way to delete data. D) A method to store data. Show Answer Correct Answer: A) A rule activated by updates. 15. Purpose of a foreign key A) To create a link between two tables. B) To store data in a single table. C) To delete records from a database. D) To increase the speed of data retrieval. Show Answer Correct Answer: A) To create a link between two tables. 16. In a database, what is a unique identifier for each record in a table called? A) Primary key. B) Foreign key. C) Index key. D) Secondary key. Show Answer Correct Answer: A) Primary key. 17. Why might Excel NOT be the best choice for managing a school library system compared to a database? A) Excel is less efficient for large amounts of related records. B) Excel does not support ASCII. C) Excel cannot store numerical data. D) Excel cannot format tables. Show Answer Correct Answer: A) Excel is less efficient for large amounts of related records. 18. Dalam basis data relasional, sebuah kueri digunakan untuk: A) Menghapus tabel. B) Memindahkan data dari satu server ke server lain. C) Mengambil, memodifikasi, atau menambahkan data. D) Membuat cadangan data. E) Menghubungkan dua basis data. Show Answer Correct Answer: C) Mengambil, memodifikasi, atau menambahkan data. 19. In which of the following can many entity instances of one type be related to many entity instances of another type? A) Composite Relationship. B) Many-to-Many Relationship. C) One-to-One Relationship. D) One-to-Many Relationship. Show Answer Correct Answer: B) Many-to-Many Relationship. 20. What is the benefit of using forms for less-experienced users? A) Prevents changing vital table settings. B) Enhances video quality. C) Improves sound clarity. D) Increases internet speed. Show Answer Correct Answer: A) Prevents changing vital table settings. 21. Which of the following best describes a database? A) It is a tool used for creating spreadsheets. B) It is a program for designing websites. C) It is an electronic filing cabinet. D) It is used only for storing pictures. Show Answer Correct Answer: C) It is an electronic filing cabinet. 22. How can you define relationships between entities? A) By analyzing the color of the entities. B) Through random selection of entities. C) By measuring the size of the entities. D) Relationships between entities can be defined by identifying the entities, their interactions, and categorizing the types of relationships. Show Answer Correct Answer: D) Relationships between entities can be defined by identifying the entities, their interactions, and categorizing the types of relationships. 23. Object-Oriented Structure A) A database structure that stores data as objects. B) A method for organizing data in a linear format. C) A technique for encrypting data in databases. D) A way to visualize data relationships in spreadsheets. Show Answer Correct Answer: A) A database structure that stores data as objects. 24. The RDBMS terminology for a row is A) Attribute. B) Degree. C) Relation. D) Tuple. Show Answer Correct Answer: D) Tuple. 25. What does the UPDATE command do in a database? A) Removes rows from a table. B) Retrieves data from the table. C) Modifies existing records in a table. D) Inserts new rows into a table. Show Answer Correct Answer: C) Modifies existing records in a table. 26. What is the purpose of an information system (IS)? A) To provide software components for communication. B) To collect, store, and process data and provide information. C) To provide a hardware environment for applications. D) None of the above. Show Answer Correct Answer: B) To collect, store, and process data and provide information. 27. A ..... is essentially a lookup field to look up data in another table. A) Unique ID. B) Secondary key. C) Foreign key. D) Primary field. Show Answer Correct Answer: C) Foreign key. 28. A field identified in a table as holding the unique identifier of the table's records is called the: A) Key attribute. B) Primary key. C) Unique ID. D) Key field. Show Answer Correct Answer: B) Primary key. 29. A candidate key that is not a primary key is known as A) Alternate key. B) Foreign key. C) Primary key. D) None. Show Answer Correct Answer: A) Alternate key. 30. What are some common security measures to protect databases? A) Using weak access controls. B) Implementing strong access controls, encrypting sensitive data, regularly updating software and patches, conducting security audits, monitoring database activity, and implementing firewalls. C) Ignoring software updates and patches. D) Storing sensitive data in plain text. Show Answer Correct Answer: B) Implementing strong access controls, encrypting sensitive data, regularly updating software and patches, conducting security audits, monitoring database activity, and implementing firewalls. 31. Why does a database store currency as a numeric value rather than storing symbols (like '$ ') directly in the field? A) Currency symbols are too regional and confuse the software. B) Storing symbols would use up valuable and unnecessary storage space. C) Symbols interfere with the AutoNumber primary key function. D) Symbols can only be stored in Alphanumeric fields, which cannot perform calculations. Show Answer Correct Answer: B) Storing symbols would use up valuable and unnecessary storage space. 32. What are the advantages of using NoSQL databases over traditional relational databases? A) NoSQL databases have no advantages over traditional relational databases. B) NoSQL databases provide better support for unstructured and semi-structured data, horizontal scalability, and flexible data models. C) NoSQL databases are less secure than traditional relational databases. D) NoSQL databases are not suitable for large-scale applications. Show Answer Correct Answer: B) NoSQL databases provide better support for unstructured and semi-structured data, horizontal scalability, and flexible data models. 33. What does a physical ERD depict? A) The actual database schema with data types. B) The relationships without implementation details. C) A high-level overview of the database. D) Only the main entities. Show Answer Correct Answer: A) The actual database schema with data types. 34. Which SQL statement is used to add new records to a table? A) SELECT. B) DELETE. C) INSERT. D) UPDATE. Show Answer Correct Answer: C) INSERT. 35. Define Data Definition Language (DDL). A) Data Definition Language (DDL) is used for querying data in a database. B) Data Definition Language (DDL) is a programming language for creating applications. C) Data Definition Language (DDL) is a method for analyzing data trends. D) Data Definition Language (DDL) is a language used to define the structure of a database. Show Answer Correct Answer: D) Data Definition Language (DDL) is a language used to define the structure of a database. 36. Which PostgreSQL constraint ensures that a column cannot have NULL values? A) FOREIGN KEY. B) PRIMARY KEY. C) NOT NULL. D) UNIQUE. Show Answer Correct Answer: C) NOT NULL. 37. What does each *entity* in an ER diagram typically represent in a database? A) A row. B) A column. C) A relationship. D) A table. Show Answer Correct Answer: D) A table. 38. What is the main difference between data validation and data verification? A) Validation checks data against rules, while verification compares data to its original source. B) Validation is performed on input, while verification is only done on output. C) There is no difference; the terms are interchangeable. D) Verification is automatic, while validation is always manual. Show Answer Correct Answer: A) Validation checks data against rules, while verification compares data to its original source. 39. What data type is used to store short alphanumeric data, such as names and addresses? A) Date/Time. B) Text. C) Number. D) Long Text. Show Answer Correct Answer: B) Text. 40. Which protocol ensures no two transactions access the same data simultaneously? A) Validation. B) Lock-based. C) Serial schedule. D) Timestamp. Show Answer Correct Answer: B) Lock-based. 41. Each item from this list is classified as ..... Name, Birthdate, Street, County, PostCode A) Table. B) Record. C) Field. D) None of the above. Show Answer Correct Answer: C) Field. 42. How does a document database store data? A) In rows and columns. B) In word documents. C) In spreadsheets. D) In flexible documents. Show Answer Correct Answer: D) In flexible documents. 43. A ..... is a copy of database information saved in case the original data is lost or damaged. A) Archive. B) Backup. C) Snapshot. D) Replica. Show Answer Correct Answer: B) Backup. 44. Which of the following is an example of a NoSQL database? A) DB2. B) Crystal Reports. C) Microsoft Access. D) SimpleDB. Show Answer Correct Answer: D) SimpleDB. 45. A tuple is also known as ..... A) Field. B) Attribute. C) Table. D) Row. Show Answer Correct Answer: D) Row. 46. What is Data Manipulation Language (DML)? A) Data Manipulation Language (DML) is a language used for managing and manipulating data in a database. B) Data Manipulation Language (DML) is a tool for visualizing data trends. C) Data Manipulation Language (DML) is a method for designing database structures. D) Data Manipulation Language (DML) is a protocol for securing data access. Show Answer Correct Answer: A) Data Manipulation Language (DML) is a language used for managing and manipulating data in a database. 47. What is a key field in a database? A) A field that stores the largest value. B) A unique identifier for each record. C) A field that stores text data. D) A field that stores date and time. Show Answer Correct Answer: B) A unique identifier for each record. 48. What is the purpose of the Entity-Relationship (ER) Model? A) To define the structure of SQL queries. B) To model the data and relationships between entities. C) To create indexes on multiple tables. D) To manage database transactions. Show Answer Correct Answer: B) To model the data and relationships between entities. 49. An entity set that does not have sufficient attributes to form a primary key, is a ..... A) Primary entity set. B) Weak entity set. C) Strong entity set. D) None of the above. Show Answer Correct Answer: B) Weak entity set. 50. Interact with the system without writingprograms. Instead, they form their requests either using a database query language. A) Back-End Programmers. B) Sophisticated users. C) Application Programmers. D) System Programmers. Show Answer Correct Answer: B) Sophisticated users. 51. Which of the following is not a function of the database? A) Manipulating data. B) Security for stored data. C) Analyzing data. D) Managing stored data. Show Answer Correct Answer: C) Analyzing data. 52. Which of the following is used to manipulate data in DBMS? A) XML. B) CSS. C) DDL. D) DML. Show Answer Correct Answer: D) DML. 53. Why is it essential to use a database in a school to manage student information? A) To make the data look polished. B) To efficiently update, search, and generate reports. C) To replace teachers with computers. D) To store only numerical data. Show Answer Correct Answer: B) To efficiently update, search, and generate reports. 54. Pada menit 3:35, muncul pesan kesalahan 'ERROR 1064 (42000):You have an error in your SQL syntax;'. Apa arti umum dari pesan kesalahan ini? A) Koneksi ke server terputus. B) Database tidak ditemukan. C) Tabel tidak ada. D) Ada kesalahan dalam penulisan perintah SQL. Show Answer Correct Answer: D) Ada kesalahan dalam penulisan perintah SQL. 55. The school wants to sort the data by staff Surname. How will they sort it? A) Ascending order. B) Descending order. C) All the above. D) None of the above. Show Answer Correct Answer: A) Ascending order. 56. Which of the following is NOT a core concept in the relational database model? A) Domain. B) Attribute. C) Tuple. D) Relation. Show Answer Correct Answer: B) Attribute. 57. Perintah SQL yang digunakan untuk melihat struktur tabel, termasuk nama kolom, tipe data, dan batasan (constraints), adalah ..... A) GET STRUCTURE nama siswa;. B) INFO nama siswa;. C) SHOW COLUMNS FROM nama siswa;. D) DESCRIBE nama siswa;. Show Answer Correct Answer: D) DESCRIBE nama siswa;. 58. What is the acronym of DBMS? A) DataBase Management Symbol. B) DataBase Managing System. C) DataBase Management System. D) DataBasic Management System. Show Answer Correct Answer: C) DataBase Management System. 59. Which of these holds lots of data? A) Drawing. B) Field. C) Record. D) Table. Show Answer Correct Answer: D) Table. 60. Beyond simple identification, how does a primary key help improve the performance of a large database? A) It acts as an index to optimize storage and provide quicker searches. B) It converts all text data into images for faster visual scanning. C) It limits the search parameters to only numeric fields. D) It deletes old records automatically to keep the table size small. Show Answer Correct Answer: A) It acts as an index to optimize storage and provide quicker searches. ← 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