This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 10 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A serial schedule means: A) Transactions run interleaved. B) One after another. C) All rollback. D) None. Show Answer Correct Answer: B) One after another. 2. In MongoDB, the $ set operator is used to: A) Replace an entire document. B) Update specific fields in a document. C) Rename a collection. D) Delete a field. Show Answer Correct Answer: B) Update specific fields in a document. 3. How do you create a data entry form in Access? A) Use the Form Wizard in the Create tab to create a data entry form. B) Select the Table Design view to create a data entry form. C) Import a data entry form from Excel to Access. D) Use the Query Builder to create a data entry form. Show Answer Correct Answer: A) Use the Form Wizard in the Create tab to create a data entry form. 4. Why are databases important in modern applications? A) They provide a graphical interface for user interaction. B) They enable secure storage and efficient retrieval of data. C) They are used to develop mobile applications only. D) They manage operating system functions. Show Answer Correct Answer: B) They enable secure storage and efficient retrieval of data. 5. Rows os relation are known as the ..... A) Degree. B) Tuples. C) Entity. D) All of the above. Show Answer Correct Answer: D) All of the above. 6. Pool of values from where a column draws the value is called ..... A) Domain. B) Attribute. C) Table. D) Dataset. Show Answer Correct Answer: A) Domain. 7. ..... is information collected, stored, and analyzed within a database system. A) Algorithm. B) Network. C) Data. D) Code. Show Answer Correct Answer: C) Data. 8. Which of the following is NOT a valid foreign key in a database? A) A customer's name. B) A product's name. C) A student's last name. D) An order's date. Show Answer Correct Answer: B) A product's name. 9. In the relational model, what is a primary key? A) A column that can have duplicate values. B) A key that can be null. C) A column that uniquely identifies each row. D) A key that links to another table. Show Answer Correct Answer: C) A column that uniquely identifies each row. 10. What is the role of the DBMS in relation to application programs? A) It is not related to application programs. B) It replaces the need for application programs. C) It provides a single, combined view of the data. D) It generates application programs automatically. Show Answer Correct Answer: C) It provides a single, combined view of the data. 11. A candidate key that will most commonly be used to uniquely identify a single entity instance is said to be a A) Candidate key. B) Primary key. C) Concatenated key. D) Alternate key. Show Answer Correct Answer: B) Primary key. 12. What are the advantages of using triggers in database management? A) Triggers are only useful for large databases. B) Triggers slow down database performance. C) Advantages of using triggers include automated enforcement of business rules, improved data integrity, automatic logging of changes, and reduced application complexity. D) Triggers can replace all application logic. Show Answer Correct Answer: C) Advantages of using triggers include automated enforcement of business rules, improved data integrity, automatic logging of changes, and reduced application complexity. 13. What does the CASE statement allow you to do? A) Create new databases. B) Delete records from a table. C) Perform multiple actions based on conditions. D) Define new data types. Show Answer Correct Answer: C) Perform multiple actions based on conditions. 14. Which file system problem makes it difficult to generate ad-hoc reports? A) Security problems. B) Data redundancy. C) Atomicity problems. D) Difficulty in accessing data. Show Answer Correct Answer: D) Difficulty in accessing data. 15. Which of the following is NOT an example of a Primary Key? A) Member ID. B) Order number. C) Product Name. D) Customer number. Show Answer Correct Answer: C) Product Name. 16. Database that supports data located at a single site. A) Centered Database System. B) Distributed Database System. C) Centralized Database System. D) Distribution Database System. Show Answer Correct Answer: C) Centralized Database System. 17. Which SQL command is used to change a column's data type? A) UPDATE. B) CHANGE. C) ALTER. D) MODIFY. Show Answer Correct Answer: C) ALTER. 18. The number of rows in a relation A) Tuple. B) Domain. C) Degree. D) Cardinality. Show Answer Correct Answer: D) Cardinality. 19. Which of the following statements contains an error? A) SELECT * FROM emp WHERE empid = 493945;. B) SELECT empid FROM emp WHERE empid= 493945;. C) SELECT empid FROM emp;. D) SELECT empid WHERE empid = 56949 AND lastname = 'SMITH';. Show Answer Correct Answer: D) SELECT empid WHERE empid = 56949 AND lastname = 'SMITH';. 20. Section B:Multiple Choice (5 marks)-Circle or write the correct letter (A, B, C, or D). Which of the following is an advantage of a database? A) It increases data errors. B) It allows easy searching and sorting of information. C) It makes data harder to access. D) It cannot be shared among users. Show Answer Correct Answer: B) It allows easy searching and sorting of information. 21. A database system mainly helps to reduce ..... A) Accuracy. B) Storage. C) Performance. D) Data redundancy. Show Answer Correct Answer: D) Data redundancy. 22. In SQL Developer, what is the role of the "Commit" button? A) Delete changes made. B) Display all tables. C) Permanently save the changes made to the database. D) Cancel the script execution. Show Answer Correct Answer: C) Permanently save the changes made to the database. 23. In SQL, Which of the following is a Data Manipulation Language(DML) command? A) Alter. B) Drop. C) Merge. D) Create. Show Answer Correct Answer: C) Merge. 24. What is the role of queries in a database? A) To present data. B) To ask questions about data. C) To automate tasks. D) To create tables. Show Answer Correct Answer: B) To ask questions about data. 25. We need database for ..... A) Accessing data and information . B) Processing the data as needed. C) Updating existing data. D) All of the above. Show Answer Correct Answer: D) All of the above. 26. Which data type would be most appropriate for storing a person's age? A) String. B) Boolean. C) Integer. D) FloatTagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: C) Integer. 27. Which model organizes data using parent-child relationships? A) Network model. B) Relational model. C) Object model. D) Hierarchical model. Show Answer Correct Answer: D) Hierarchical model. 28. A subscription table needs to uniquely identify each record using two attributes together:subID is missing, but startDate and endDate exist. What type of key would use startDate and endDate together to ensure uniqueness? A) Foreign reference key. B) Composite primary key. C) Surrogate alternate key. D) Secondary lookup key. Show Answer Correct Answer: B) Composite primary key. 29. An attribute or the smallest set of attributes in a table where no tuple has the same value. A) Primary key. B) Foreign key. C) Candidate key. D) Composite key. Show Answer Correct Answer: C) Candidate key. 30. Which of the following statements about flowcharting is TRUE? A) A flowchart is the only step in programming. B) A flowchart is a program. C) Flowcharts are limited to certain programming languages. D) Flowcharts are helpful in detecting errors. Show Answer Correct Answer: D) Flowcharts are helpful in detecting errors. 31. What is the relationship where a single row in one table relates to many entries in the other? A) One-to-many. B) None of the above. C) One-to-one. D) Many-to-many. Show Answer Correct Answer: A) One-to-many. 32. What is a key difference between anonymous blocks and stored procedures? A) Anonymous blocks accept parameters. B) Stored procedures cannot use variables. C) Stored procedures are named and stored in the database. D) Anonymous blocks can be reused outside of Oracle. Show Answer Correct Answer: C) Stored procedures are named and stored in the database. 33. What are the common data types used in MySQL? A) BOOLEAN, ENUM, SET, JSON, SMALLINT. B) Common data types in MySQL include INT, VARCHAR, TEXT, DATE, and DATETIME. C) FLOAT, CHAR, BLOB, TIME, TIMESTAMP. D) DOUBLE, MEDIUMINT, TINYTEXT, YEAR, CLOB. Show Answer Correct Answer: B) Common data types in MySQL include INT, VARCHAR, TEXT, DATE, and DATETIME. 34. What is the main goal of a database system? A) To limit user access to data. B) To ensure data is always redundant. C) To create complex data structures. D) To provide a way to store and retrieve database information conveniently and efficiently. Show Answer Correct Answer: D) To provide a way to store and retrieve database information conveniently and efficiently. 35. Which is an example of DBMS (Database Management System)? A) MS PowerPoint. B) MS Excel. C) Oracle. D) MS Word. Show Answer Correct Answer: C) Oracle. 36. What is a Foreign Key in a database? A) A key that is used for accessing the database remotely. B) A key that is used for database optimization. C) A reference to a primary key in another table. D) A key that is used for database backups. Show Answer Correct Answer: C) A reference to a primary key in another table. 37. Which symbol is commonly used to represent a relationship in an ER diagram? A) Circle. B) Triangle. C) Diamond. D) Square. Show Answer Correct Answer: C) Diamond. 38. What is an "attribute" in the context of a database? A) A primary key for a table. B) A field that allows NULL values. C) A grouping of related records. D) A characteristic of an entity represented by a column in a table. Show Answer Correct Answer: D) A characteristic of an entity represented by a column in a table. 39. Which lock allows concurrent read but prevents write? A) Exclusive lock. B) Shared lock. C) Update lock. D) None. Show Answer Correct Answer: B) Shared lock. 40. Which of the following is an example of a validation rule in a database field? A) Employee Name. B) Customer ID. C) Maximum allowed salary. D) Sales DateTagsLO2. Show Answer Correct Answer: C) Maximum allowed salary. 41. Which DDL command is used to modify the structure of an existing table? A) DROP. B) INSERT. C) DELETE. D) ALTER. Show Answer Correct Answer: D) ALTER. 42. In a DBMS, the term "view" refers to: A) A physical storage layout. B) An abstract data model. C) The interaction with the operating system. D) A subset of the database tailored to a particular user's needs. Show Answer Correct Answer: D) A subset of the database tailored to a particular user's needs. 43. .... Defines a relation consisting of a set of all tuple that are in both in A and B. A) PROJECT. B) INTERSECTION. C) UNION. D) SET DIFFERENCE. Show Answer Correct Answer: B) INTERSECTION. 44. Elairda is designing a database for her school project. Which rule applies when creating a primary key? A) It should be the last column in the table. B) It can be empty or null. C) It cannot contain duplicates. D) It must always store numbers. Show Answer Correct Answer: C) It cannot contain duplicates. 45. .... main component is a program that controls everything. A) Data. B) Hardware. C) Methods. D) Software. Show Answer Correct Answer: D) Software. 46. What is mismatched copies of data indicative of? A) Dependance. B) Isolation. C) Redundancy. D) Inconsistency. Show Answer Correct Answer: D) Inconsistency. 47. What is the main difference between Form View and Design View? A) Form View is for entering and viewing data, Design View is for modifying the form's layout. B) Form View is for creating queries, Design View is for running queries. C) Form View is for printing, Design View is for saving. D) Form View is for deleting records, Design View is for adding records. Show Answer Correct Answer: A) Form View is for entering and viewing data, Design View is for modifying the form's layout. 48. The relational model organizes data in: A) Objects. B) Trees. C) Tables. D) Graphs. Show Answer Correct Answer: C) Tables. 49. In a school database, which is the best example of a primary key for identifying students? A) Driver's License Number. B) Home Runs Hit. C) Price. D) First and Last Name. Show Answer Correct Answer: A) Driver's License Number. 50. Which of the following is an example of data validation? A) Entering random numbers. B) Ensuring a field only accepts dates. C) Using images instead of text. D) Copying and pasting data from the internet. Show Answer Correct Answer: B) Ensuring a field only accepts dates. 51. In SQL, which data type is best suited for storing large texts such as articles or comments? A) BLOB. B) CHAR. C) VARCHAR. D) TEXT. Show Answer Correct Answer: D) TEXT. 52. What is a relational database? A) A database where data is held in a single table. B) A database that does not support relationships between tables. C) A database where data is held in more than one table linked by relationships. D) A database where data is stored without any structured format. Show Answer Correct Answer: C) A database where data is held in more than one table linked by relationships. 53. Apa yang dimaksud dengan normalisasi dalam desain database? A) Normalisasi adalah proses menambahkan redundansi data dalam database. B) Normalisasi adalah proses mengurangi efisiensi database. C) Normalisasi adalah proses menghilangkan data dari database. D) Normalisasi dalam desain database adalah proses pengorganisasian data dalam database agar efisien dan mengurangi redundansi data. Show Answer Correct Answer: D) Normalisasi dalam desain database adalah proses pengorganisasian data dalam database agar efisien dan mengurangi redundansi data. 54. How can a unique value be created in a database table when there isn't a suitable single field to use as a primary key? A) By deleting non-unique fields. B) By combining two or more fields to create a unique value. C) By using a random number generator. D) By choosing the longest field as the primary key. Show Answer Correct Answer: B) By combining two or more fields to create a unique value. 55. Primary key uniquely identifies a: A) Row. B) Records. C) Table. D) None of them. Show Answer Correct Answer: A) Row. 56. Sebuah fakta tentang sesuatu di dunia nyata (yang dapat berupa angka, rangkaian karakter, simbol, dan gambar) yang dapat dicatat dan disimpan di media komputer. Ini adalah definisi dari ..... A) Informasi. B) Basis data. C) Sistem informasi. D) Data. E) Data base. Show Answer Correct Answer: D) Data. 57. The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called ..... A) Data scrubbing. B) Data cleansing. C) Data defining. D) Normalization. Show Answer Correct Answer: D) Normalization. 58. Which of the following best describes the role of a database compared to a spreadsheet? A) Databases are only for numbers, while spreadsheets store all data types. B) Databases manage large amounts of structured data more efficiently. C) Spreadsheets can search faster than databases. D) Spreadsheets are better for organizing student records. Show Answer Correct Answer: B) Databases manage large amounts of structured data more efficiently. 59. What is an entity in a database? A) An entity in a database is a file that contains information. B) An entity in a database is a software program used to manage data. C) An entity in a database is a distinct object or concept that is represented in the database. D) An entity in a database is a table that stores data. Show Answer Correct Answer: C) An entity in a database is a distinct object or concept that is represented in the database. 60. Which type of data model provides the foundation for building a physical data model? A) Conceptual Data Model. B) Logical Data Model. C) Abstract Data Model. D) Hierarchical Data Model. Show Answer Correct Answer: B) Logical Data 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