This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 15 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 15 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the significance of theoretical relational languages? A) They focus solely on graphical representations of data. B) They offer a formal framework for understanding data relationships and support the development of robust database systems. C) They simplify the process of data entry in databases. D) They eliminate the need for data normalization. Show Answer Correct Answer: B) They offer a formal framework for understanding data relationships and support the development of robust database systems. 2. .... Father of Relational DataBase . A) Dr. Edgar F Code. B) Dr. Edgar F Codd. C) Dr. canon F Codd. D) Dr. Edgar F Chen. Show Answer Correct Answer: B) Dr. Edgar F Codd. 3. Apa itu primary key dalam database? A) Sebuah kolom yang dapat diubah setiap saat dalam sebuah tabel. B) Sebuah kolom yang tidak unik dalam sebuah tabel. C) Sebuah kolom yang tidak diperlukan dalam sebuah tabel. D) Sebuah kolom atau kumpulan kolom yang secara unik mengidentifikasi setiap baris dalam sebuah tabel. Show Answer Correct Answer: D) Sebuah kolom atau kumpulan kolom yang secara unik mengidentifikasi setiap baris dalam sebuah tabel. 4. Explain the difference between INNER JOIN and OUTER JOIN. A) INNER JOIN includes all records from both tables. B) OUTER JOIN provides only unmatched records from one table. C) INNER JOIN provides only matched records, while OUTER JOIN includes all records from one table and matched records from the other. D) INNER JOIN and OUTER JOIN are the same and can be used interchangeably. Show Answer Correct Answer: C) INNER JOIN provides only matched records, while OUTER JOIN includes all records from one table and matched records from the other. 5. Which technique involves using locks to control access to data? A) Multi-version Concurrency Control. B) Locking. C) Time-stamping. D) Data validation. Show Answer Correct Answer: B) Locking. 6. What does database scalability refer to? A) The speed of data retrieval. B) The ability to handle increasing demands. C) The type of data stored. D) The security of the database. Show Answer Correct Answer: B) The ability to handle increasing demands. 7. Which of the following is NOT a benefit of using a database management system? A) Enhanced data accessibility. B) Reduced data redundancy. C) Improved data security. D) Increased data inconsistency. Show Answer Correct Answer: D) Increased data inconsistency. 8. In a database, a record represents: A) A whole table. B) A column of values. C) A binary code for letters. D) One row of information about a person or item. Show Answer Correct Answer: D) One row of information about a person or item. 9. Which of the following is NOT a type of database testing? A) Structural Database Testing. B) Operational Database Testing. C) Non-functional Testing. D) Functional Database Testing. Show Answer Correct Answer: B) Operational Database Testing. 10. Which of the following is an example of a domain in a database? A) A specific table in a database. B) A set of all possible values for a particular attribute. C) A relationship between two tables. D) A unique identifier for a row in a table. Show Answer Correct Answer: B) A set of all possible values for a particular attribute. 11. What is the purpose of field properties? A) To print reports. B) To delete old data. C) To determine how a field is stored and displayed. D) To create new records. Show Answer Correct Answer: C) To determine how a field is stored and displayed. 12. What is a database program used for? A) Writing documents. B) Organizing and retrieving information. C) Creating graphics. D) Browsing the internet. Show Answer Correct Answer: B) Organizing and retrieving information. 13. What is the first step in database design? A) Avoid storing the same data. B) Data modelling. C) Keep consistency with relevant raw facts. D) Stay up-to-date. Show Answer Correct Answer: B) Data modelling. 14. What is the primary function of a DBMS? A) To store data in a cloud. B) To provide internet access to databases. C) To facilitate the creation and maintenance of a computerized database. D) To create hardware for databases. Show Answer Correct Answer: C) To facilitate the creation and maintenance of a computerized database. 15. Berikut ini perintah yang digunakan untuk merubah nama tabel buku menjadi LKS adalah ..... A) Rename table buku to LKS;. B) Alter buku to LKS;. C) Alter table buku modify to LKS;. D) Alter table buku change to LKS;. E) Rename buku to LKS;. Show Answer Correct Answer: A) Rename table buku to LKS;. 16. Data is unorganised and no meaning or context. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 17. SQL command to create a table A) INSERT INTO. B) CREATE TABLE. C) DROP TABLE. D) SELECT * FROM. Show Answer Correct Answer: B) CREATE TABLE. 18. Which of the following is an example of a database? A) A list of students in a class with their names and ages. B) A storybook. C) A calculator. D) A video game. Show Answer Correct Answer: A) A list of students in a class with their names and ages. 19. Which ACID property ensures that a transaction brings the database from one valid state to another? A) Consistency. B) Isolation. C) Atomicity. D) Durability. Show Answer Correct Answer: A) Consistency. 20. What is a candidate key? A) A key that is always selected as the primary key. B) A key that could potentially be a primary key. C) A key that is not used in any table. D) A key that is used for indexing. Show Answer Correct Answer: B) A key that could potentially be a primary key. 21. ..... is a top-down process in EERD. It divides high level entities into lower levels. Example:EMPLOYEES can have subclass of Teachers or Technicians. A) Specialization. B) Generalization. C) Association. D) Aggregation. Show Answer Correct Answer: A) Specialization. 22. The element of ERD that represents real-world things such as people, places, or events about which we want to store data is called: A) Database. B) Attributes. C) Relationship. D) Entities. Show Answer Correct Answer: D) Entities. 23. An ACID transaction is one that is: A) Atomic. B) Consistent. C) Isolated. D) Durable. E) All of the above. Show Answer Correct Answer: E) All of the above. 24. True or false:Can databases be a simple file or a complex set of related tables? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 25. All of the following are issues with the traditional file environment except ..... A) Data inconsistency. B) Poor security. C) Lack of flexibility in creating ad-hoc reports. D) Inability to develop specialized applications for functional areas. Show Answer Correct Answer: D) Inability to develop specialized applications for functional areas. 26. Which data model uses parent-child relationships? A) Hierarchical. B) Network. C) Relational. D) Object-oriented. Show Answer Correct Answer: A) Hierarchical. 27. Which of the following statements about queries is FALSE? A) Queries can display data in reports. B) Queries can be used to update records. C) Queries cannot be modified after they are created. D) Queries can filter data. Show Answer Correct Answer: C) Queries cannot be modified after they are created. 28. Entity-Relationship Model was developed by ..... in 1976. A) Chen. B) Codd. C) Dr. Edgar. D) None of these. Show Answer Correct Answer: A) Chen. 29. What is the purpose of normalisation in a relational database? A) To reduce data redundancy and ensure integrity. B) To increase data redundancy and complexity. C) To speed up searching for data. D) To store data in a non-structured manner. Show Answer Correct Answer: A) To reduce data redundancy and ensure integrity. 30. Define a foreign key and its purpose. A) A foreign key is a unique identifier for a single table. B) A foreign key is a type of primary key used in the same table. C) A foreign key is a field that stores data without any relationship to other tables. D) A foreign key is a field that links two tables by referencing the primary key of another table, ensuring data integrity. Show Answer Correct Answer: D) A foreign key is a field that links two tables by referencing the primary key of another table, ensuring data integrity. 31. What is the purpose of a report in a database? A) To create tables. B) To enter data. C) To display data in a formatted way. D) To delete data. Show Answer Correct Answer: C) To display data in a formatted way. 32. What problem in file systems occurs when data is scattered across multiple files in different formats? A) Atomicity problems. B) Security problems. C) Data isolation. D) Data redundancy. Show Answer Correct Answer: C) Data isolation. 33. What does the 'primary key' constraint ensure? A) Uniqueness of values in a column. B) Allows null values. C) Links to another table. D) Defines the data type. Show Answer Correct Answer: A) Uniqueness of values in a column. 34. Which SQL operation is used to retrieve data from a database? A) SELECT. B) DELETE. C) INSERT. D) MODIFY. Show Answer Correct Answer: A) SELECT. 35. Which relationship type represents a single record in one table linked to multiple records in another table? A) One-to-one. B) Self-referencing. C) Many-to-many. D) One-to-many. Show Answer Correct Answer: D) One-to-many. 36. What is the purpose of an Access Object in Microsoft Access? A) To store only images and videos. B) To automatically generate reports without user input. C) To create new databases from scratch. D) To provide a way to interact with and manage database elements. Show Answer Correct Answer: D) To provide a way to interact with and manage database elements. 37. To skip the first 5 documents in a query result, you use: A) .limit(5). B) .offset(5). C) .start(5). D) .skip(5). Show Answer Correct Answer: D) .skip(5). 38. If you want to store "Grades" in a student database, which field type is most suitable? A) Boolean (Yes/No). B) Date/Time. C) Short Text. D) Number. Show Answer Correct Answer: D) Number. 39. Choose the best example of enforcing referential integrity between Customer and Subscription. A) Delete all subscriptions before any customer insert. B) Prevent a subscription referencing a missing custID. C) Require subID to match productID in both tables. D) Allow duplicate custID values across all tables. Show Answer Correct Answer: B) Prevent a subscription referencing a missing custID. 40. ..... is a bottom-up approach in which two lower level entities combine to form a higher level entity A) Aggregation. B) Specialization. C) Generalization. D) None of the above. Show Answer Correct Answer: A) Aggregation. 41. What is the function of the Quick Access Toolbar in a database application? A) It organizes information into columns and rows. B) It provides a simplified interface for entering, modifying, and viewing database records. C) It displays a database's name. D) It provides access to commonly used functions. Show Answer Correct Answer: D) It provides access to commonly used functions. 42. ASSERTION:-If our database name is 'schooldb' and we want to drop this database, the query will work if we will write our database name in capital letters. REASON:-SQL is a not a case sensitive. A) Both A and R are true and R is the correct explanation for A. B) Both A and R are true and R is not the correct explanation for A. C) A is True but R is False. D) A is false but R is True. Show Answer Correct Answer: A) Both A and R are true and R is the correct explanation for A. 43. Which of the following statements about relations (tables) is FALSE? A) Each relation in a schema has a unique name. B) Each attribute within a relation has a unique name. C) The order of tuples (rows) is not significant. D) Duplicate rows are always allowed by definition. Show Answer Correct Answer: D) Duplicate rows are always allowed by definition. 44. When data is stored in the form of tables (rows and columns), it is part of which model? A) Object-oriented. B) Relational. C) Hierarchical. D) Network. Show Answer Correct Answer: B) Relational. 45. Which of the following SQL clauses is used to combine rows from two or more tables based on a related column? A) SELECT. B) INTERSECT. C) UNION. D) JOIN. Show Answer Correct Answer: D) JOIN. 46. Which clause filters rows after aggregation? A) WHERE. B) FILTER. C) GROUP BY. D) HAVING. Show Answer Correct Answer: D) HAVING. 47. What is ETL in the context of data warehousing? A) ETL refers to a programming language for data analysis. B) ETL is a process in data warehousing that involves Extracting data from sources, Transforming it into a usable format, and Loading it into a data warehouse. C) ETL is a method for archiving data in cloud storage. D) ETL is a framework for real-time data streaming. Show Answer Correct Answer: B) ETL is a process in data warehousing that involves Extracting data from sources, Transforming it into a usable format, and Loading it into a data warehouse. 48. What is the purpose of a Database Management System (DBMS) in relation to a file-based approach? A) To increase data redundancy. B) To decrease data inconsistency. C) To create data dependencies. D) To improve data security. Show Answer Correct Answer: B) To decrease data inconsistency. 49. What type of database follows a table-based structure? A) NoSQL. B) Key-value. C) Relational. D) Document-based. Show Answer Correct Answer: C) Relational. 50. How do you create a database using MySQL? A) SELECT DATABASE database name;. B) DROP DATABASE database name;. C) CREATE DATABASE database name;. D) ALTER DATABASE database name;. Show Answer Correct Answer: C) CREATE DATABASE database name;. 51. Which one of th following is a type of Data Manipulation command? A) Create. B) Alter. C) Delete. D) All of the above. Show Answer Correct Answer: C) Delete. 52. Which of the following is NOT a type of database security measure? A) Access control. B) Encryption. C) Data mining. D) Backup and recovery. Show Answer Correct Answer: C) Data mining. 53. What is the primary purpose of database systems? A) To provide a platform for social networking. B) To create complex algorithms for data analysis. C) To store, manage, and retrieve data efficiently. D) To ensure data is visually appealing and colorful. Show Answer Correct Answer: C) To store, manage, and retrieve data efficiently. 54. Perintah SQL yang digunakan untuk menampilkan daftar semua database yang ada adalah ..... A) SHOW TABLES;. B) LIST DATABASES;. C) SHOW DATABASES;. D) SHOW DATABASE;. Show Answer Correct Answer: C) SHOW DATABASES;. 55. Which of the following is an example of a field in a database table? A) The relationship between two tables. B) A single row in a table. C) A collection of records. D) A single column in a table. Show Answer Correct Answer: D) A single column in a table. 56. Manakah dari berikut ini yang BUKAN contoh dari relasi one to many A) Negara dan kota. B) Hubungan suami dan istri. C) Dosen yang mengajar beberapa mata pelajaran. D) Departemen yang diisi oleh berbagai karyawan. Show Answer Correct Answer: B) Hubungan suami dan istri. 57. Which level in the ANSI-SPARC architecture represents user views? A) Internal. B) Logical. C) External. D) Conceptual. Show Answer Correct Answer: C) External. 58. When values in one or more attributes are used as foreign keys, they must exist in another set of one or more attributes in another table, we have created a: A) Referential integrity constraint. B) Insert anomaly. C) Transitive dependency. D) Normalization form. Show Answer Correct Answer: A) Referential integrity constraint. 59. How can you ensure data integrity using primary keys? A) Allow duplicate values in the primary key column for flexibility. B) Use foreign keys to link tables without defining primary keys. C) Define a primary key for each table to uniquely identify records and enforce uniqueness and non-null constraints. D) Set primary keys to nullable to accommodate missing data. Show Answer Correct Answer: C) Define a primary key for each table to uniquely identify records and enforce uniqueness and non-null constraints. 60. What does the BETWEEN keyword do in a query? A) Selects records within a given range. B) Deletes records that fall within a range. C) Formats records for display. D) Groups records together. Show Answer Correct Answer: A) Selects records within a given range. ← 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