This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 32 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 32 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is a key characteristic of a database? A) Self-describing nature. B) Redundancy. C) Static content. D) Lack of data relationships. Show Answer Correct Answer: A) Self-describing nature. 2. A record is a group of related: A) Attributes. B) Fields. C) Tables. D) Bytes. Show Answer Correct Answer: B) Fields. 3. In file-based systems, data is: A) Managed by DBMS. B) Integrated and centralized. C) Independent of applications. D) Stored in separate files per application. Show Answer Correct Answer: D) Stored in separate files per application. 4. Which keyword is used to delete all rows from a table but keep its structure? A) DROP. B) TRUNCATE. C) DELETE. D) REMOVE. Show Answer Correct Answer: B) TRUNCATE. 5. What is the purpose of an entity in a database? A) To organize data in the database. B) To store data in the database. C) To represent a real-world object or concept in the database. D) To perform calculations in the database. Show Answer Correct Answer: C) To represent a real-world object or concept in the database. 6. Explain how to update a view in SQL. A) Use 'ALTER VIEW view name AS SELECT ;' to modify a view. B) Use 'DROP VIEW view name;' followed by 'CREATE VIEW view name AS SELECT ;' to update a view. C) Run 'REPLACE VIEW view name AS SELECT ;' to refresh the view. D) Execute 'UPDATE view name SET ;' to change the view definition. Show Answer Correct Answer: B) Use 'DROP VIEW view name;' followed by 'CREATE VIEW view name AS SELECT ;' to update a view. 7. Which concurrency control method completely avoids deadlock? A) Locking. B) Timestamp ordering. C) Two-phase locking. D) None. Show Answer Correct Answer: B) Timestamp ordering. 8. COLLECTION OF DATA A) DBMS. B) DATABASE. C) SQL. D) INFORMATION. Show Answer Correct Answer: B) DATABASE. 9. The property (or set of properties) that uniquely defines each row in a table is called the: A) Primary key. B) Symmetric key. C) Identifier. D) Index. Show Answer Correct Answer: A) Primary key. 10. Which of the following is not a true statement about performing a data quality audit? A) A data quality audit can be performed by surveying entire data files. B) A data quality audit can be performed by surveying samples from data files. C) A data quality audit can be performed by surveying data definition and query files. D) A data quality audit can be performed by surveying end users about their perceptions of data quality. Show Answer Correct Answer: D) A data quality audit can be performed by surveying end users about their perceptions of data quality. 11. Which level of data abstraction describes how data is actually stored in memory? A) Internal or Physical. B) External or View. C) Conceptual or Logical. D) Data Independence. Show Answer Correct Answer: A) Internal or Physical. 12. Which command is used to delete a table permanently? A) REMOVE. B) DELETE. C) TRUNCATE. D) DROP. Show Answer Correct Answer: D) DROP. 13. What type of database is designed to facilitate the exchange of structured documents? A) Object-Oriented. B) NewSQL. C) NoSQL. D) XML. Show Answer Correct Answer: D) XML. 14. A business wants to track whether or not an invoice has been paid. Which data type is the most efficient choice to minimize storage while providing a clear status? A) Alphanumeric. B) Boolean (Yes/No). C) Currency. D) Integer. Show Answer Correct Answer: B) Boolean (Yes/No). 15. Entities of a given type are grouped into a(n): A) Database. B) ERD. C) Attribute. D) Entity class. Show Answer Correct Answer: D) Entity class. 16. Which of the following best describes the responsibility of the conceptual level in a DBMS? A) Managing how data is physically stored. B) Providing user-specific views of the data. C) Defining all entities, attributes, and relationships in the database. D) Handling backup and recovery mechanisms. Show Answer Correct Answer: C) Defining all entities, attributes, and relationships in the database. 17. What is the purpose of a DBMS in a business setting? A) To better serve customers. B) To make better decisions. C) To improve business processes. D) All of the above. Show Answer Correct Answer: D) All of the above. 18. A table is synonymous with the term: A) Field. B) Column. C) Record. D) Relation. Show Answer Correct Answer: D) Relation. 19. If a query is created to show all students in 'Grade 10', what condition should be used? A) Criteria ClassName = Grade 10. B) Criteria Age = 10. C) Criteria ContactNumber IS NULL. D) Criteria Subject = 'Math'. Show Answer Correct Answer: A) Criteria ClassName = Grade 10. 20. What must be selected during the installation of SQL Server for distributed databases? A) SQL Server Management Studio. B) SQL Server Developer. C) SQL Server Express. D) SQL Server Replication. Show Answer Correct Answer: D) SQL Server Replication. 21. Which of the following is known as a set of entities of the same type that share same properties or attributes? A) Tuples. B) Entity Relation model. C) Relation set. D) Entity set. Show Answer Correct Answer: D) Entity set. 22. A relationship between Customer and Order entities with connectivity 1:M is classified as: A) Ternary relationship. B) Binary relationship. C) Unary relationship. D) Recursive relationship. Show Answer Correct Answer: B) Binary relationship. 23. Explain the concept of data mining in relation to databases. A) Data mining is solely focused on data entry and management. B) Data mining involves creating new databases from scratch. C) Data mining is the extraction of useful information and patterns from large datasets in databases. D) Data mining is the process of storing data in a database. Show Answer Correct Answer: C) Data mining is the extraction of useful information and patterns from large datasets in databases. 24. Which concurrency control technique validates transactions before commit? A) Locking. B) Timestamp. C) Validation-based. D) None. Show Answer Correct Answer: C) Validation-based. 25. Juvante is working on a project where he needs to analyze sales data. Which step is involved in creating a query? A) Adding a primary key to the table. B) Formatting the database layout. C) Exporting the data to a spreadsheet. D) Selecting a table to query data from. Show Answer Correct Answer: D) Selecting a table to query data from. 26. Which SQL clause is used to specify the condition on aggregate functions, such as 'COUNT' or 'SUM'? A) ORDER BY. B) WHERE. C) GROUP BY. D) HAVING. Show Answer Correct Answer: D) HAVING. 27. In ..... database, data is organized in the form of trees with nodes. A) Hierarchical. B) Relational. C) Network. D) None of the above. Show Answer Correct Answer: A) Hierarchical. 28. Which operation in relational algebra selects tuples that satisfy a given condition? A) Join Operation. B) Project Operation. C) Select Operation. D) Union Operation. Show Answer Correct Answer: C) Select Operation. 29. True or False:An "instance" of a relational database is not a specific entity represented in the database? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 30. Which of the following is an example of a primary key in a database? A) An order's date. B) A customer's name. C) A product's name. D) A student's last name. Show Answer Correct Answer: C) A product's name. 31. What are the different types of fields in a database? A) Float. B) Integer. C) Text, number, date/time, boolean, binary. D) Character. Show Answer Correct Answer: C) Text, number, date/time, boolean, binary. 32. What is the main purpose of a form in MS Access? A) To allow users to enter and view data easily. B) To filter data from multiple tables. C) To run complex calculations. D) To store data permanently. Show Answer Correct Answer: A) To allow users to enter and view data easily. 33. What does the 'Yes/No' data type represent? A) Date and time data. B) Text data. C) Boolean data. D) Numeric data. Show Answer Correct Answer: C) Boolean data. 34. What does a 'hyperlink' data type allow you to do in a database? A) Add a link to a website. B) Store numbers used in reports. C) Store long texts. D) Perform calculations. Show Answer Correct Answer: A) Add a link to a website. 35. How can you ensure data integrity in a database? A) By allowing unrestricted access to the database. B) By implementing measures such as primary keys, foreign keys, constraints, backups, data validation checks, access controls, and transaction management. C) By storing data in multiple databases. D) By regularly updating the database software. Show Answer Correct Answer: B) By implementing measures such as primary keys, foreign keys, constraints, backups, data validation checks, access controls, and transaction management. 36. What are fields in a database commonly referred to as? A) Entities. B) Attributes. C) Rows. D) Records. Show Answer Correct Answer: B) Attributes. 37. What is a foreign key in a database table? A) A set of related fields. B) A complete set of related records. C) A single type of data. D) A field used to uniquely identify any record. Show Answer Correct Answer: B) A complete set of related records. 38. An example of DBMS software is ..... A) Oracle. B) PostgreSQL. C) MongoDB. D) MySQL. Show Answer Correct Answer: D) MySQL. 39. Which of these statements about databases is true? A) A database only stores numbers. B) A field contains multiple rows of information. C) A record represents all data about one item. D) ASCII is not used in databases. Show Answer Correct Answer: C) A record represents all data about one item. 40. Which of the following property states that an incomplete transaction is not recorded? A) Atomicity. B) Consistency. C) Isolation. D) Durability. Show Answer Correct Answer: A) Atomicity. 41. Which of the following is an example of a composite key? A) A field that contains a foreign key. B) A field that stores a large text value. C) A combination of two or more fields that uniquely identify a record. D) A single field that uniquely identifies a record. Show Answer Correct Answer: C) A combination of two or more fields that uniquely identify a record. 42. In the ANSI-SPARC model, which level is responsible for specifying how data is stored in blocks, indexes, and file structures? A) External level. B) Conceptual level. C) Internal level. D) Logical level. Show Answer Correct Answer: C) Internal level. 43. Which of the following SQL statements retrieves all records from a table named Students? A) SELECT * IN Students. B) VIEW ALL FROM Students. C) SELECT * FROM Students. D) GET ALL Students. Show Answer Correct Answer: C) SELECT * FROM Students. 44. A developer is granted EXECUTE permission on a stored procedure named sp ..... UpdateUserEmail. This is the only way the developer can change user emails. What is the primary database concept this demonstrates? A) Encapsulation and Security. B) Performance Optimization. C) Transaction Isolation. D) Data Durability. Show Answer Correct Answer: A) Encapsulation and Security. 45. The details associated with an entity are called ..... A) Table. B) Records. C) Primary key. D) Attributes. Show Answer Correct Answer: D) Attributes. 46. Which SQL command grants user permissions? A) GRANT. B) CREATE. C) REVOKE. D) COMMIT. Show Answer Correct Answer: A) GRANT. 47. What is the purpose of concurrency control software? A) To allow multiple users to access data. B) To delete data. C) To create new databases. D) To store data securely. Show Answer Correct Answer: A) To allow multiple users to access data. 48. Who is responsible for authorizing access to the database? A) Database administrators. B) System analysts. C) Application programmers. D) End users. Show Answer Correct Answer: A) Database administrators. 49. Which PL/SQL object automatically executes when an event occurs? A) Trigger. B) Cursor. C) Procedure. D) Function. Show Answer Correct Answer: A) Trigger. 50. Which type of JOIN returns only rows that have matching values in both tables? A) INNER JOIN. B) RIGHT JOIN. C) LEFT JOIN. D) FULL OUTER JOIN. Show Answer Correct Answer: A) INNER JOIN. 51. What is the purpose of setting a primary key in an MS Access table? A) To ensure no duplicate records exist. B) To increase the speed of queries. C) To allow multiple users to access data. D) To provide additional security. Show Answer Correct Answer: A) To ensure no duplicate records exist. 52. Which of the following is a characteristic of a foreign key? A) It is always a number. B) It can be null. C) It is used to link two tables together. D) It must be unique within its table. Show Answer Correct Answer: C) It is used to link two tables together. 53. In SQL, which command is used to update existing row in a table? A) Insert. B) Delete. C) Update. D) None of the above. Show Answer Correct Answer: C) Update. 54. Which of the following is NOT a way to speed up a relational database? A) Limiting the number of results in a query. B) Creating an optimized database structure. C) Storing everything in a single table. D) Using data normalization. Show Answer Correct Answer: C) Storing everything in a single table. 55. In a relational database, what does normalization help to achieve? A) Improve performance. B) Simplify queries. C) Reduce data anomalies. D) Increase redundancy. Show Answer Correct Answer: C) Reduce data anomalies. 56. Which type of schedule may cause cascading aborts? A) Non-recoverable schedule. B) Serial schedule. C) Recoverable schedule. D) Strict schedule. Show Answer Correct Answer: A) Non-recoverable schedule. 57. Jahmar is designing a database for his school project. Which view should he use to create a primary key? A) Design View. B) Query View. C) Print View. D) Datasheet View. Show Answer Correct Answer: A) Design View. 58. Three-schema architecture improves: A) Data inconsistency. B) Redundancy. C) Query speed. D) Data independence. Show Answer Correct Answer: D) Data independence. 59. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) entity. A) Child. B) Parent. C) Instance. D) Subtype. Show Answer Correct Answer: B) Parent. 60. Which normal form is achieved when a table is in 2NF and no non-prime attribute is transitively dependent on the primary key? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of the above. Show Answer Correct Answer: C) Third Normal Form (3NF). ← 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