This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 17 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 17 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A characteristic or quality that describes a particular database entity is called a(n): A) Key field. B) Attribute. C) Tuple. D) Field. Show Answer Correct Answer: B) Attribute. 2. All of the following are features of a flat file database except A) All records are stored in one place. B) Easy to setup. C) Easy to understand. D) Unique records. Show Answer Correct Answer: D) Unique records. 3. What does a wildcard () do in a query? A) Acts as a placeholder for any number of characters. B) Deletes records automatically. C) Converts text into numbers. D) Sorts records alphabetically. Show Answer Correct Answer: A) Acts as a placeholder for any number of characters. 4. Which of the following is a simple rule which states that at a time only one person can update an object in the database? A) Deadlock. B) Record Locking. C) Serialisation. D) Redundancy. Show Answer Correct Answer: B) Record Locking. 5. The goal of third normal form (3NF) is to A) Eliminate repeating groups. B) Make non-key attributes fully dependent on the primary key. C) Remove transitive dependencies. D) All of these. Show Answer Correct Answer: C) Remove transitive dependencies. 6. Advantages of the database A) Improved access to user data using host and query languages. B) Time is consumed in designing complex database systems. C) Damage to database affects virtually all applications programs. D) Considerable hardware and software start-up costs. E) Extensive conversion costs in shifting from a file-based system to a database system. Show Answer Correct Answer: A) Improved access to user data using host and query languages. 7. Which of the following is NOT one of the ACID properties of database transactions? A) Duplication. B) Consistency. C) Atomicity. D) Isolation. Show Answer Correct Answer: A) Duplication. 8. What is an attribute in a relational database? A) A set of facts or figures in rows and columns. B) A heading for organizing data. C) A unique identifier for a record. D) An automatic validation check. Show Answer Correct Answer: B) A heading for organizing data. 9. What are the key components of a database table? A) Database name, entries, types of data, main identifier, related keys, triggers. B) Row name, attributes, data formats, unique key, secondary keys, constraints. C) Table name, columns, data types, primary key, foreign keys, indexes. D) Table title, fields, value types, main key, linked keys, views. Show Answer Correct Answer: C) Table name, columns, data types, primary key, foreign keys, indexes. 10. Which of these field types would be best to hold a .jpg image? A) Text. B) Char binary. C) Nchar binary. D) Blob. Show Answer Correct Answer: D) Blob. 11. What is the primary purpose of a database form? A) To store raw data only. B) To make data entry and viewing more user-friendly. C) To create complex calculations. D) To delete records permanently. Show Answer Correct Answer: B) To make data entry and viewing more user-friendly. 12. What is the main difference between a spreadsheet and a database? A) A spreadsheet can only store numbers. B) A database is more structured and can handle larger amounts of data. C) A database cannot perform calculations. D) A spreadsheet is used for creating presentations. Show Answer Correct Answer: B) A database is more structured and can handle larger amounts of data. 13. How does a primary key ensure data integrity? A) A primary key can be changed frequently without affecting data. B) A primary key ensures data integrity by uniquely identifying records and preventing duplicates. C) A primary key is used to encrypt sensitive information in the database. D) A primary key allows multiple records to share the same identifier. Show Answer Correct Answer: B) A primary key ensures data integrity by uniquely identifying records and preventing duplicates. 14. A raw fact, such as an invoice date, is known as ..... A) A relationship. B) Data. C) Information. D) A record. Show Answer Correct Answer: B) Data. 15. Berikut ini perintah yang ada pada Data Manipulation Language adalah kecuali ..... A) Update. B) Select. C) Insert. D) Delete. E) Create. Show Answer Correct Answer: E) Create. 16. What is a join in SQL? A) A join in SQL is used to delete rows from a table. B) A join in SQL is used to combine rows from two or more tables based on a related column. C) A join in SQL is a function to sort data in a single table. D) A join in SQL is a method to create new tables. Show Answer Correct Answer: B) A join in SQL is used to combine rows from two or more tables based on a related column. 17. Fabia is designing a database for her small business. She wants to ensure that the data stored in each field is efficient and doesn't take up unnecessary space. What is the purpose of the "Field Size" property in his database? A) To define the maximum number of records in a table. B) To determine the type of data in the field. C) To organize records by size. D) To set the length of data stored in the field. Show Answer Correct Answer: D) To set the length of data stored in the field. 18. Which index type supports geospatial queries? A) 2dsphere index. B) Compound index. C) Hashed index. D) Text index. Show Answer Correct Answer: A) 2dsphere index. 19. A ..... is represented as rows in a table. A) Field. B) Attribute. C) Record. D) Candidate key. Show Answer Correct Answer: C) Record. 20. An attribute that names or identifies entity instances is a(n): A) Identifier. B) Relationship. C) Attribute. D) Entity. Show Answer Correct Answer: A) Identifier. 21. Which of the following indicates the maximum number of entities that can be involved in a relationship? A) Maximum cardinality. B) Greater Entity Count (GEC). C) Minimum cardinality. D) ERD. Show Answer Correct Answer: A) Maximum cardinality. 22. What is a parameter query? A) A query that asks for user input before running. B) A query that automatically updates records. C) A query that deletes unwanted data. D) A query that only works with primary keys. Show Answer Correct Answer: A) A query that asks for user input before running. 23. What does the IN clause do in SQL? A) It creates a new table. B) It updates rows in a table. C) It selects rows that match a list of values. D) It deletes rows from a table. Show Answer Correct Answer: C) It selects rows that match a list of values. 24. Which clause is used to filter records based on a specified condition? A) GROUP BY. B) HAVING. C) WHERE. D) ORDER BY. Show Answer Correct Answer: C) WHERE. 25. What is the main focus of the relational model? A) Class diagrams. B) Data stored in tables with relationships. C) Memory indexing. D) Binary data trees. Show Answer Correct Answer: B) Data stored in tables with relationships. 26. Entity instance of one type related to many entity instances of another type? A) One-to-One Relationship. B) Composite Relationship. C) Many-to-Many Relationship. D) One-to-Many Relationship. Show Answer Correct Answer: D) One-to-Many Relationship. 27. A data may contain any ..... A) Character. B) Text. C) Number. D) All the above. Show Answer Correct Answer: D) All the above. 28. A database is MOST useful when data needs to be: A) Written in ASCII code. B) Randomly stored without structure. C) Organized, searched, and updated quickly. D) Converted into symbolic language. Show Answer Correct Answer: C) Organized, searched, and updated quickly. 29. Which method is used to insert multiple documents at once? A) BulkInsert(). B) InsertMany(). C) InsertOne(). D) Insert(). Show Answer Correct Answer: B) InsertMany(). 30. In relational databases, what is a 'tuple'? A) A SQL operator. B) A type of index. C) A column of data. D) A row in a table. Show Answer Correct Answer: D) A row in a table. 31. What is the tiniest nugget of data in a database, representing a characteristic or attribute of an entity? A) Field. B) Database. C) Table. D) Row. Show Answer Correct Answer: A) Field. 32. Which schedule is always serializable and avoids cascading aborts? A) Cascaded. B) Strict. C) Non-recoverable. D) Recoverable. Show Answer Correct Answer: B) Strict. 33. The HAVING is similar to WHERE, but it can operate on the GROUP BY aggregate functions, whereas WHERE operates only on columns A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 34. Which of the following is a valid data type in SQL? A) Character. B) Text. C) Varchar. D) String. Show Answer Correct Answer: C) Varchar. 35. What is the function of the GROUP BY clause in SQL? A) To filter records. B) To join multiple tables. C) To group rows that have the same values in specified columns. D) To sort the result set. Show Answer Correct Answer: C) To group rows that have the same values in specified columns. 36. Data ..... occurs when the same data is duplicated in multiple files of a database. A) Repetition. B) Independence. C) Redundancy. D) Partitions. Show Answer Correct Answer: C) Redundancy. 37. Which operation is used for selecting a subset with tuples according to a given condition? A) Select. B) Project. C) Union. D) Product. Show Answer Correct Answer: A) Select. 38. What are some common data manipulation operations? A) Filtering, sorting, aggregating, merging, reshaping. B) Calculating, visualizing, exporting. C) Storing, deleting, indexing. D) Transcribing, encoding, compressing. Show Answer Correct Answer: A) Filtering, sorting, aggregating, merging, reshaping. 39. Jika sebuah kolom didefinisikan dengan 'NOT NULL', apa artinya? A) Kolom tersebut dapat berisi nilai kosong. B) Kolom tersebut adalah kunci utama. C) Kolom tersebut tidak boleh kosong. D) Kolom tersebut harus berisi nilai unik. Show Answer Correct Answer: C) Kolom tersebut tidak boleh kosong. 40. Data redundancy may lead to data inconsistency. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 41. ASCII codes are important because they allow computers to: A) Store numbers more quickly. B) Display characters by linking binary codes to letters, digits, and symbols. C) Format tables into readable reports. D) Translate data into databases. Show Answer Correct Answer: B) Display characters by linking binary codes to letters, digits, and symbols. 42. Explain the implementation of stored procedures in databases. A) Stored procedures are implemented using a web browser. B) Stored procedures in databases are implemented using a specific programming language such as SQL. They are precompiled and stored in the database for reuse, which helps improve performance and security. C) Stored procedures are implemented using a spreadsheet software. D) Stored procedures are implemented using a video editing software. Show Answer Correct Answer: B) Stored procedures in databases are implemented using a specific programming language such as SQL. They are precompiled and stored in the database for reuse, which helps improve performance and security. 43. Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of ..... A) Sorts. B) Validations. C) Data Types. D) Filters. Show Answer Correct Answer: C) Data Types. 44. Which of the following is the best definition of a field in a database? A) A table in the database. B) A relationship between tables. C) A single piece of data within a record. D) A primary key. Show Answer Correct Answer: C) A single piece of data within a record. 45. A DBMS that combines a DBMS and an application builder is: A) Microsoft SQL Server. B) IBM DB2. C) Microsoft Access. D) Oracle by Oracle Corporation. Show Answer Correct Answer: C) Microsoft Access. 46. What is the purpose of Queries in a database? A) Requests made to the database to retrieve, modify, or manipulate data using SQL. B) Requests made to the database to shut down the system. C) Requests made to the database to install new software. D) Requests made to the database to delete all data. Show Answer Correct Answer: A) Requests made to the database to retrieve, modify, or manipulate data using SQL. 47. Which of the following describes a data dictionary? A) A list of all users in the database. B) A hidden part of the database containing metadata. C) A backup of the database. D) A report generated from the database. Show Answer Correct Answer: B) A hidden part of the database containing metadata. 48. A one-to-many relationship means: A) Each record in table B can have many matching records in table A. B) Each table has only one record. C) There is no relationship between tables. D) Each record in table A can have many matching records in table B. Show Answer Correct Answer: D) Each record in table A can have many matching records in table B. 49. How might a school database help the school run more smoothly? A) By providing lunch recipes. B) By organizing student and teacher information. C) By controlling the school's temperature. D) By writing homework assignments. Show Answer Correct Answer: B) By organizing student and teacher information. 50. Which of the following is NOT a type of database query language? A) DB2. B) SQL. C) XML. D) PL/SQL. Show Answer Correct Answer: C) XML. 51. A bank has two tables- "Customers" and "Accounts." If each customer can have multiple accounts, they are related through a: A) Primary Key. B) Foreign Key. C) Candidate Key. D) Schema Key. Show Answer Correct Answer: B) Foreign Key. 52. A field in a database is: A) A whole table. B) A binary number. C) A row describing one item. D) A column that holds one type of information. Show Answer Correct Answer: D) A column that holds one type of information. 53. Perintah SQL yang digunakan untuk menampilkan semua data dari tabel 'pelanggan' adalah ..... A) SHOW DATA FROM pelanggan;. B) DISPLAY ALL FROM pelanggan;. C) SELECT * FROM pelanggan;. D) GET ALL FROM pelanggan;. Show Answer Correct Answer: C) SELECT * FROM pelanggan;. 54. Which of the following rule is NOT followed by a transaction in a database? A) All transactions are independent. B) All committed transactions survive a system crash. C) Multiple transactions might affect each other during run time. D) All of the above. Show Answer Correct Answer: A) All transactions are independent. 55. Serves as an interface between the database and its end-users or programs, allowing users to retrieve, update, and manage how the information is organized and optimized. A) RDBMS. B) MySQL. C) DBMS. D) Microsoft SQL Server Management. Show Answer Correct Answer: C) DBMS. 56. What is the purpose of normalisation? A) To reduce data redundancy and improve consistency. B) To increase data redundancy. C) To prevent data relationships. D) To make data retrieval slower. Show Answer Correct Answer: A) To reduce data redundancy and improve consistency. 57. Hierarchical Structure A) A database structure that organizes data in a parent-child relationship. B) A flat database structure with no relationships. C) A network of interconnected databases. D) A structure that only allows one parent per child. Show Answer Correct Answer: A) A database structure that organizes data in a parent-child relationship. 58. How do you establish a one-to-many relationship in Access? A) Use a foreign key in both tables referencing each other. B) Establish a relationship by merging the two tables into one. C) Create a single table with multiple primary keys. D) Create two tables, define a primary key in the primary table, and a foreign key in the related table that references the primary key. Show Answer Correct Answer: D) Create two tables, define a primary key in the primary table, and a foreign key in the related table that references the primary key. 59. What type of relationship is represented by a one-to-many (1:N) relationship? A) A record in Table A can relate to multiple records in Table B. B) Each record in Table A relates to multiple records in Table A. C) Records in Table A can relate to each other. D) Each record in Table A relates to one record in Table B. Show Answer Correct Answer: A) A record in Table A can relate to multiple records in Table B. 60. Which types of databases have you accessed before? A) Relational and non-relational. B) Only relational. C) Only non-relational. D) None. Show Answer Correct Answer: A) Relational and non-relational. ← 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