This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 50 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 50 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the highest level of data abstraction in a database system? A) Physical level. B) Logical level. C) External level. D) Conceptual level. Show Answer Correct Answer: D) Conceptual level. 2. A field set as "Boolean (Yes/No)" would be BEST for storing: A) The student's grade. B) Whether tuition is paid or not. C) The student's name. D) The student's date of birth. Show Answer Correct Answer: B) Whether tuition is paid or not. 3. 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. 4. 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. 5. 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. 6. 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. 7. 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. 8. 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. 9. 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. 10. 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. 11. Which term refers to a single piece of data in a database table? A) Fields. B) Records. C) Validation. D) Primary KeyTagsLO1. Show Answer Correct Answer: A) Fields. 12. Which of the following best describes end user data? A) Data that is not relevant to users. B) Raw facts of interest to the end user. C) Data that is only used for storage. D) Data that describes other data. Show Answer Correct Answer: B) Raw facts of interest to the end user. 13. A column of a database relation is also known as A) Tuple. B) Degree. C) Attribute. D) Record. Show Answer Correct Answer: C) Attribute. 14. Which of the following best describes a column in a database? A) A collection of rows. B) A set of data values of a particular type. C) A unique identifier for records. D) A type of flat file. Show Answer Correct Answer: B) A set of data values of a particular type. 15. .... where the data is organized as row and column. A) Row. B) Column. C) Field. D) Table. Show Answer Correct Answer: D) Table. 16. 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. 17. 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) 20500. B) 10000. C) 20000. D) 33500. Show Answer Correct Answer: C) 20000. 18. Which of these is not a type of data integrity? A) Entity Integrity. B) Referential Integrity. C) Logical Integrity. D) Contextual Integrity. Show Answer Correct Answer: D) Contextual Integrity. 19. 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';. 20. 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) Domain. C) Cardinality. D) Tuple set. Show Answer Correct Answer: B) Domain. 21. Which of the following best defines an instance in a database? A) The physical location of a database file. B) A snapshot of the data in the database at a particular time. C) A type of SQL query. D) A data entry form. Show Answer Correct Answer: B) A snapshot of the data in the database at a particular time. 22. Hubungan / relationship yang menggambarkan hubungan antara elemen yanglebih umum ke elemen yang lebih kusus/ spesifik disebut ..... A) Association. B) Generalization. C) Dependency. D) Extend. E) Include. Show Answer Correct Answer: B) Generalization. 23. Which is the following is not a type of database? A) Hirerchical. B) Network. C) Distributed. D) Decentralized. Show Answer Correct Answer: D) Decentralized. 24. What are fields in a database table? A) The tools used to input data into the database. B) The individual entries or data items in a table. C) The categories of data being stored, such as customer surname. D) The physical storage space where data is saved. Show Answer Correct Answer: C) The categories of data being stored, such as customer surname. 25. Which SQL statement is used to extract data from a database? A) OPEN. B) GET. C) EXTRACT. D) SELECT. Show Answer Correct Answer: D) SELECT. ← PreviousNext →Related 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 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books