This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 20 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 20 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Third normal form is based on the concept of ..... A) Closure Dependency. B) Functional Dependency. C) Transitive Dependency. D) Normal Dependency. Show Answer Correct Answer: C) Transitive Dependency. 2. Which of the following best describes the concept of 'atomicity' in ACID properties? A) Data remains consistent. B) Transactions can interfere with each other. C) Transactions are all-or-nothing. D) Data is stored permanently. Show Answer Correct Answer: C) Transactions are all-or-nothing. 3. What are some common techniques for optimizing SQL queries? A) Common techniques for optimizing SQL queries include using indexes, avoiding SELECT *, limiting rows with WHERE clauses, efficient JOINs, analyzing execution plans, and denormalization. B) Ignoring execution plans completely. C) Always using subqueries for better performance. D) Using only SELECT * for simplicity. Show Answer Correct Answer: A) Common techniques for optimizing SQL queries include using indexes, avoiding SELECT *, limiting rows with WHERE clauses, efficient JOINs, analyzing execution plans, and denormalization. 4. ..... model represents the data in many to-many relationships. A) Relational. B) Network. C) Object. D) Hierarchical. Show Answer Correct Answer: B) Network. 5. A ..... application can be used to organize data but lacks the robust functions of a true database management system. A) Email client. B) Presentation. C) Word processor. D) Spreadsheet. Show Answer Correct Answer: D) Spreadsheet. 6. Which of the following products is an early implementation of the relational model developed by E.F. Codd of IBM? A) IDMS. B) DBase-II. C) DB2. D) R:base. Show Answer Correct Answer: C) DB2. 7. In a Students table, the row:(101, 'Alice', 'Computer Science') is an example of: A) Attribute. B) Schema. C) Domain. D) Tuple. Show Answer Correct Answer: D) Tuple. 8. Which type of database is better for relating different types of information? A) In-memory database. B) Flat file database. C) NoSQL database. D) Relational database. Show Answer Correct Answer: D) Relational database. 9. What is the purpose of an entity-relationship (E-R) diagram? A) To write SQL queries. B) To manage user access. C) To store data. D) To visualize the database structure. Show Answer Correct Answer: D) To visualize the database structure. 10. When working with databases, which SQL statement is used to choose a specific database for operations? A) SHOW DATABASE. B) USE. C) OPEN DATABASE. D) SELECT DATABASE. Show Answer Correct Answer: B) USE. 11. Apa perbedaan antara tag dan dalam HTML? A) Tag digunakan untuk membuat elemen inline sedangkan tag digunakan untuk membuat blok elemen. B) Tag digunakan untuk menampilkan teks sedangkan tag digunakan untuk membuat hyperlink. C) Tag digunakan untuk mengatur tata letak halaman sedangkan tag digunakan untuk menambahkan gambar. D) Tag digunakan untuk membuat blok elemen sedangkan tag digunakan untuk membuat inline elemen. Show Answer Correct Answer: D) Tag digunakan untuk membuat blok elemen sedangkan tag digunakan untuk membuat inline elemen. 12. How would you establish a relationship between the 'Teachers' and 'Classes' tables? A) Using a secondary key. B) Using the TeacherID as a foreign key in the 'Classes' table. C) Using a new table. D) Using StudentID in both tables. Show Answer Correct Answer: B) Using the TeacherID as a foreign key in the 'Classes' table. 13. Paper-based is an example of physical database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 14. A non key attribute, whose values are derived from the primary key of some other table is known as A) Alternate key. B) Foreign key. C) Candidate key. D) None. Show Answer Correct Answer: B) Foreign key. 15. Which of the following is an example of alphabetic data? A) 12345. B) A12345. C) %&$. D) John Doe. Show Answer Correct Answer: D) John Doe. 16. What is the purpose of defining validation rules for fields in a database? A) To limit the number of records. B) To ensure data accuracy and integrity. C) To make the database visually appealing. D) To define primary keysTagsLO2. Show Answer Correct Answer: B) To ensure data accuracy and integrity. 17. What is the role of an index in a database? A) To create new tables. B) To speed up data operations. C) To store images. D) To delete records. Show Answer Correct Answer: B) To speed up data operations. 18. Which of the following best describes data abstraction? A) The process of hiding internal database complexities from users. B) Making backups. C) Encrypting data. D) Writing user interfaces. Show Answer Correct Answer: A) The process of hiding internal database complexities from users. 19. What are the benefits of Triggers? A) Generating some derived column values automatically. B) Enforcing referential integrity. C) Synchronous replication of tables. D) All of the above. Show Answer Correct Answer: D) All of the above. 20. Can some attributes accept a "null" value? A) Yes. B) No. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes. 21. Which of the following is NOT an acronym of sub languages of SQL A) DDL. B) DHL. C) DML. D) DQL. Show Answer Correct Answer: B) DHL. 22. Which data type should you use to store a phone number in an MS Access table? A) Currency. B) Text (Short Text). C) Date/Time. D) Number. Show Answer Correct Answer: B) Text (Short Text). 23. What is a database transaction? A) A financial exchange between two databases. B) The process of backing up a database. C) A logical unit of work that must be completed entirely or not at all. D) The act of querying a database. Show Answer Correct Answer: C) A logical unit of work that must be completed entirely or not at all. 24. Hierarchical model was developed by ..... A) Microsoft Corporation. B) IBM. C) Bell Labs. D) None of the above. Show Answer Correct Answer: B) IBM. 25. Explain the purpose of Data Query Language (DQL). A) The purpose of Data Query Language (DQL) is to create and delete database tables. B) The purpose of Data Query Language (DQL) is to query and retrieve data from a database. C) The purpose of Data Query Language (DQL) is to manage user permissions in a database. D) The purpose of Data Query Language (DQL) is to update and modify database structures. Show Answer Correct Answer: B) The purpose of Data Query Language (DQL) is to query and retrieve data from a database. 26. Which is NOT one of the most common types of SQL CHECK constraints? A) Comparing one column value to another within the same table. B) System date. C) Range checks. D) Lists of values. Show Answer Correct Answer: B) System date. 27. A household appliances manufacturer has hired you to help analyze its social media data sets to determine which of its refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data? A) Data mining software. B) Text mining tools. C) Web mining technologies. D) Sentiment analysis software. Show Answer Correct Answer: D) Sentiment analysis software. 28. What is the primary purpose of the SELECT statement in DML? A) To update existing records. B) To remove data from a table. C) To insert new records. D) To retrieve data from the database. Show Answer Correct Answer: D) To retrieve data from the database. 29. Which of the following is NOT a relationship type? A) One-to-Many. B) Many-to-One. C) None-to-Many. D) Many-to-Many. Show Answer Correct Answer: C) None-to-Many. 30. Which level of DBMS architecture defines how data is stored physically? A) External level. B) Conceptual level. C) Internal level. D) Application level. Show Answer Correct Answer: C) Internal level. 31. What is the highest level of data abstraction in a database system? A) Conceptual level. B) Physical level. C) Logical level. D) External level. Show Answer Correct Answer: A) Conceptual level. 32. A field set as "Boolean (Yes/No)" would be BEST for storing: A) Whether tuition is paid or not. B) The student's date of birth. C) The student's name. D) The student's grade. Show Answer Correct Answer: A) Whether tuition is paid or not. 33. In designing and creating tables, why is it important to choose appropriate data types and constraints for each column? A) It helps to minimize storage space by using one data type for all columns. B) It ensures data integrity and enforces business rules. C) It automatically creates indexes for every table. D) It is not necessary if you plan to use DML commands. Show Answer Correct Answer: B) It ensures data integrity and enforces business rules. 34. A DBMS acts as an interface between which two components of an enterprise database system? A) Database applications and databases. B) Data and databases. C) Users and database applications. D) Database applications and SQL. Show Answer Correct Answer: A) Database applications and databases. 35. What is a "table" in a relational database? A) A command used to retrieve data. B) A collection of rows and columns that represent data. C) A relationship between two tables. D) A type of query used to search data. Show Answer Correct Answer: B) A collection of rows and columns that represent data. 36. What is meant by a database? A) A database is an organized collection of data stored electronically. B) A database is a physical storage device for computers. C) A database is a collection of random files stored on a server. D) A database is a type of software used for web development. Show Answer Correct Answer: A) A database is an organized collection of data stored electronically. 37. Which of the following is true about removing rows from a table? A) You remove existing rows from a table using the DELETE statement. B) No rows are deleted if you omit the WHERE clause. C) You cannot delete rows based on values from another table. D) All of the above. Show Answer Correct Answer: A) You remove existing rows from a table using the DELETE statement. 38. Which of the following is a typical example of technical metadata? A) Data glossaries for business users. B) Description of storage details. C) Hardware requirements of the DBMS. D) None of the above. Show Answer Correct Answer: C) Hardware requirements of the DBMS. 39. Explain the concept of database security. A) Database security focuses on enhancing user interface design. B) Database security involves creating backups of data regularly. C) Database security is about optimizing database performance. D) Database security is the practice of protecting databases from unauthorized access and ensuring data integrity and confidentiality. Show Answer Correct Answer: D) Database security is the practice of protecting databases from unauthorized access and ensuring data integrity and confidentiality. 40. How do you modify the layout of a form in Access? A) Change the form layout by editing the database table directly. B) Use the Query Design tool to modify the form layout. C) Open the form in Design View and adjust controls as needed. D) Open the form in Read-Only View to make changes. Show Answer Correct Answer: C) Open the form in Design View and adjust controls as needed. 41. Which term refers to a single piece of data in a database table? A) Records. B) Primary KeyTagsLO1. C) Validation. D) Fields. Show Answer Correct Answer: D) Fields. 42. Which of the following best describes end user data? A) Data that is not relevant to users. B) Data that describes other data. C) Raw facts of interest to the end user. D) Data that is only used for storage. Show Answer Correct Answer: C) Raw facts of interest to the end user. 43. A column of a database relation is also known as A) Tuple. B) Degree. C) Attribute. D) Record. Show Answer Correct Answer: C) Attribute. 44. Which of the following best describes a column in a database? A) A type of flat file. B) A unique identifier for records. C) A collection of rows. D) A set of data values of a particular type. Show Answer Correct Answer: D) A set of data values of a particular type. 45. .... where the data is organized as row and column. A) Field. B) Column. C) Table. D) Row. Show Answer Correct Answer: C) Table. 46. Data abstraction helps in achieving ..... A) Data redundancy. B) Data security and independence. C) File duplication. D) Data inconsistency. Show Answer Correct Answer: B) Data security and independence. 47. If column "Fees" contains the data set (5000, 8000, 7500, 5000, 8000), what will be the output after the execution of the given query? SELECT SUM (DISTINCT Fees) FROM student; A) 20000. B) 10000. C) 20500. D) 33500. Show Answer Correct Answer: A) 20000. 48. Which of these is not a type of data integrity? A) Entity Integrity. B) Contextual Integrity. C) Logical Integrity. D) Referential Integrity. Show Answer Correct Answer: B) Contextual Integrity. 49. Which one of the following given stament possibly contains the error? A) Select * from emp where empid=1003;. B) Select empid from emp where empid=10006;. C) Select empid from emp;. D) Select empid where empid=1009 and Lastname='GELLER';. Show Answer Correct Answer: D) Select empid where empid=1009 and Lastname='GELLER';. 50. The set of all valid values for the attribute grade (e.g. {'A', 'B', 'C', 'D', 'F'}) is called the attribute's: A) Degree. B) Cardinality. C) Domain. D) Tuple set. Show Answer Correct Answer: C) Domain. 51. Which of the following best defines an instance in a database? A) A data entry form. B) The physical location of a database file. C) A type of SQL query. D) A snapshot of the data in the database at a particular time. Show Answer Correct Answer: D) A snapshot of the data in the database at a particular time. 52. Hubungan / relationship yang menggambarkan hubungan antara elemen yanglebih umum ke elemen yang lebih kusus/ spesifik disebut ..... A) Dependency. B) Include. C) Extend. D) Association. E) Generalization. Show Answer Correct Answer: E) Generalization. 53. What are fields in a database table? A) The physical storage space where data is saved. B) The categories of data being stored, such as customer surname. C) The individual entries or data items in a table. D) The tools used to input data into the database. Show Answer Correct Answer: B) The categories of data being stored, such as customer surname. 54. Which SQL statement is used to extract data from a database? A) OPEN. B) SELECT. C) EXTRACT. D) GET. Show Answer Correct Answer: B) SELECT. 55. When might a DBMS be unnecessary? A) When data needs to be shared. B) When there are stringent real-time requirements. C) When the database is complex. D) When multiple users need access. Show Answer Correct Answer: B) When there are stringent real-time requirements. 56. What does DBMS provide for unauthorized access prevention? A) Only password protection. B) File encryption only. C) User authentication, authorization, and privilege management. D) Hardware locks. Show Answer Correct Answer: C) User authentication, authorization, and privilege management. 57. Identify the total number of attributes in a relational data model. A) Cardinality. B) Entity. C) Tuple. D) Degree. Show Answer Correct Answer: D) Degree. 58. What is the role of a data model in database design? A) A data model focuses solely on data retrieval methods. B) A data model provides a visual representation of data structures and relationships. C) A data model is only concerned with data storage techniques. D) A data model is used to create user interfaces for applications. Show Answer Correct Answer: B) A data model provides a visual representation of data structures and relationships. 59. Which term best describes the process of defining the structure of a database? A) Querying. B) Indexing. C) Data Modeling. D) Normalization. Show Answer Correct Answer: C) Data Modeling. 60. The ..... method defines a relation that contains a vertical subset of Relation. A) SELECT. B) PROJECT. C) SET DIFFERENCE. D) UNION. Show Answer Correct Answer: B) PROJECT. ← 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