This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 7 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 7 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is NOT a characteristic of a database system? A) Data Integrity. B) Multiple Views. C) Self-Describing Nature. D) Data Redundancy. Show Answer Correct Answer: D) Data Redundancy. 2. Which statement about schema evolution is true? A) Schema changes affect data structure. B) Data remains unchanged during schema evolution. C) Schema evolution is not supported in DBMS. D) Schema cannot be changed after creation. Show Answer Correct Answer: A) Schema changes affect data structure. 3. What is normalization in database design? A) A way to combine multiple databases into one. B) A method to increase data redundancy in databases. C) A technique for encrypting database information. D) Normalization in database design is the process of structuring a database to minimize redundancy and dependency by organizing fields and tables. Show Answer Correct Answer: D) Normalization in database design is the process of structuring a database to minimize redundancy and dependency by organizing fields and tables. 4. What is the first step in an ETL process? A) Extraction. B) Validation. C) Transformation. D) Loading. Show Answer Correct Answer: A) Extraction. 5. Which SQL statement is used to update data in a database? A) SAVE AS. B) MODIFY. C) SAVE. D) UPDATE. Show Answer Correct Answer: D) UPDATE. 6. What is the disadvantage of using a DBMS? A) Data security. B) Data performance. C) Data complexity. D) Data sharing. Show Answer Correct Answer: C) Data complexity. 7. To change the structure of a table, you use: A) ALTER TABLE. B) CHANGE TABLE. C) UPDATE TABLE. D) MODIFY TABLE. Show Answer Correct Answer: A) ALTER TABLE. 8. Which structure is most commonly used in modern systems for storing and querying data? A) Relational structure. B) Network structure. C) Tree-based structure. D) Sequential file structure. Show Answer Correct Answer: A) Relational structure. 9. What are some common database security practices? A) Access controls, encryption, regular updates, security audits, monitoring and logging. B) Physical security, software installation, data archiving. C) Backup strategies, network segmentation, password sharing. D) Data replication, user training, firewall configuration. Show Answer Correct Answer: A) Access controls, encryption, regular updates, security audits, monitoring and logging. 10. Bagaimana cara membuat database baru dalam SQL? A) INSERT INTO nama database;. B) CREATE DATABASE nama database;. C) ADD DATABASE nama database;. D) UPDATE DATABASE nama database;. Show Answer Correct Answer: B) CREATE DATABASE nama database;. 11. A ..... is a collection of organized data that can be easily accessed, managed, and updated. A) Document. B) Database. C) Presentation. D) Spreadsheet. Show Answer Correct Answer: B) Database. 12. An ER diagram that shows the concepts of Specialization & Generalization are known as: A) Extended E-R diagram. B) Effective E-R diagram. C) Expanded E-R diagram. D) Enhanced E-R diagram. Show Answer Correct Answer: D) Enhanced E-R diagram. 13. What is the role of APIs in databases? A) To delete data. B) To create new databases. C) To allow different software systems to communicate. D) To secure data. Show Answer Correct Answer: C) To allow different software systems to communicate. 14. The value 'Computer Science' in the above example belongs to which concept? A) Entity. B) Domain. C) Tuple. D) Schema. Show Answer Correct Answer: B) Domain. 15. Which of the following is NOT a type of database management system (DBMS)? A) Object-Oriented DBMS. B) Relational DBMS. C) Network DBMS. D) Hierarchical DBMS. Show Answer Correct Answer: A) Object-Oriented DBMS. 16. How do data dictionaries help ensure data integrity and consistency? A) By deleting old data. B) By defining data types, constraints, and relationships. C) By storing data in multiple locations. D) By encrypting data. Show Answer Correct Answer: B) By defining data types, constraints, and relationships. 17. What does durability mean in the context of transactions? A) Changes are permanent even after a failure. B) Changes are temporary. C) Changes must be verified. D) Changes can be rolled back. Show Answer Correct Answer: A) Changes are permanent even after a failure. 18. What is the purpose of the 'where' clause in an SQL query? A) To specify conditions for filtering results. B) To define the structure of a table. C) To join multiple tables. D) To select all attributes. Show Answer Correct Answer: A) To specify conditions for filtering results. 19. When using the SQL INSERT statement: A) Rows cannot be copied in mass from one table to another only. B) Rows can either be inserted into a table one at a time or in groups. C) Rows can be modified according to criteria only. D) Rows can be inserted into a table only one at a time. Show Answer Correct Answer: B) Rows can either be inserted into a table one at a time or in groups. 20. What is a feature of reports in Access? A) They are dynamic. B) They are temporary. C) They are encrypted. D) They are static. Show Answer Correct Answer: A) They are dynamic. 21. Advantage of 3NF? A) It eliminates redundant data which in turn saves space and reduces manipulation anomalies. B) It gives the data status. C) It allows the tables to be queried in SQL. D) It prevents any new updates. Show Answer Correct Answer: A) It eliminates redundant data which in turn saves space and reduces manipulation anomalies. 22. Apa perbedaan antara tipe data CHAR dan VARCHAR dalam database? A) CHAR is fixed-length, while VARCHAR is variable-length. B) CHAR is case-sensitive, while VARCHAR is case-insensitive. C) CHAR stores only numbers, while VARCHAR stores only letters. D) CHAR can store unlimited characters, while VARCHAR has a character limit. Show Answer Correct Answer: A) CHAR is fixed-length, while VARCHAR is variable-length. 23. .... manages the complete database management system. A) End-User. B) Application Programmers. C) Database Administrators. D) Database designers. Show Answer Correct Answer: C) Database Administrators. 24. To ..... data means to add new information to the database. A) Delete. B) Retrieve. C) Insert. D) Update. Show Answer Correct Answer: C) Insert. 25. Which of the following is NOT a type of information system? A) Transaction Processing Systems (TPS). B) Management Information Systems (MIS). C) Data Analysis Systems (DAS). D) Decision Support Systems (DSS). Show Answer Correct Answer: C) Data Analysis Systems (DAS). 26. Which of the following best describes data mining? A) The process of deleting unnecessary data. B) The process of storing data. C) The process of discovering patterns in data. D) The process of cleaning data. Show Answer Correct Answer: C) The process of discovering patterns in data. 27. The number of tuples in a relation is termed as A) Cardinality. B) Entity. C) Column. D) None of the above. Show Answer Correct Answer: A) Cardinality. 28. Apa itu atribut 'src' pada tag dalam HTML? A) Atribut 'src' pada tag dalam HTML adalah URL dari gambar yang akan ditampilkan. B) Atribut 'src' harus berupa angka dalam tag . C) Atribut 'src' menentukan ukuran gambar dalam tag . D) Atribut 'src' digunakan untuk menambahkan teks alternatif pada gambar. Show Answer Correct Answer: A) Atribut 'src' pada tag dalam HTML adalah URL dari gambar yang akan ditampilkan. 29. How are relationships established in a relational database? A) By creating a new table that combines elements of two tables. B) By merging two tables into one. C) By linking the secondary key of one table to a primary key in another table. D) By linking the primary key of one table to an appropriate foreign key in another table. Show Answer Correct Answer: D) By linking the primary key of one table to an appropriate foreign key in another table. 30. The ability to query data as well as insert, delete, and alter tuples is offered by ..... A) TCL(Transaction Control Language). B) DCL(Data Control Language). C) DDL(Data Definition Language). D) DML(Data Manipulation Language). Show Answer Correct Answer: D) DML(Data Manipulation Language). 31. Which of these is not a characteristic of a relational database? A) Two tables or records are related. B) Each record has a unique identifier. C) It contains random unorganized data. D) Tables can share common fields. Show Answer Correct Answer: C) It contains random unorganized data. 32. How do you define primary keys in a table? A) Primary keys are optional for every table. B) A primary key is a column that can contain duplicate values. C) A primary key can be any column in a table. D) A primary key is a column or set of columns that uniquely identifies each row in a table. Show Answer Correct Answer: D) A primary key is a column or set of columns that uniquely identifies each row in a table. 33. Which of the following is NOT a limitation of a file-based approach? A) Enhanced data security. B) Difficulty in simultaneous access. C) Inefficient querying of large data sets. D) Data duplication. Show Answer Correct Answer: A) Enhanced data security. 34. The Relational Database model was first proposed by E.F. Codd in ..... A) 1980. B) 1972. C) 1970. D) 1975. Show Answer Correct Answer: C) 1970. 35. What data types are commonly used in Microsoft Access? A) Short Text, Long Text, Float, Time. B) Boolean, Date, Image, File. C) String, Textbox, Integer, Decimal. D) Text, Memo, Number, Currency, Date/Time, Yes/No, OLE Object, Hyperlink. Show Answer Correct Answer: D) Text, Memo, Number, Currency, Date/Time, Yes/No, OLE Object, Hyperlink. 36. Which of the following best describes 'data'? A) Raw, unorganized facts. B) A collection of database tables. C) The output of a computer program. D) Processed information. Show Answer Correct Answer: A) Raw, unorganized facts. 37. A primary key that consists of more than one field is called a ..... key. A) Group. B) Composite. C) Foreign. D) Secondary. Show Answer Correct Answer: B) Composite. 38. Which transaction command permanently saves changes? A) SAVEPOINT. B) COMMIT. C) ROLLBACK. D) DELETE. Show Answer Correct Answer: B) COMMIT. 39. If a database designer accidentally stores "Phone Number" as Number instead of Text, what problem could occur? A) It may remove leading zeros from phone numbers. B) It will prevent saving any numbers at all. C) It will turn numbers into ASCII codes. D) It will make the field act like a Boolean. Show Answer Correct Answer: A) It may remove leading zeros from phone numbers. 40. One key benefit of DBMS over file systems is: A) Less secure storage. B) More redundancy. C) Data integrity and consistency. D) Higher cost. Show Answer Correct Answer: C) Data integrity and consistency. 41. Which command removes all documents from a collection but keeps the collection? A) Db.collection.drop(). B) Db.collection.deleteMany({}). C) Db.collection.removeAll(). D) Db.collection.truncate(). Show Answer Correct Answer: B) Db.collection.deleteMany({}). 42. Which join returns all rows from both tables, with NULL where no match exists? A) CROSS JOIN. B) FULL JOIN. C) INNER JOIN. D) LEFT JOIN. Show Answer Correct Answer: B) FULL JOIN. 43. Which keys are required to create relationships between entities? A) Primary key and foreign key. B) Primary key and secondary key. C) Foreign key and domestic key. D) Secondary key and foreign key. Show Answer Correct Answer: A) Primary key and foreign key. 44. . Perintah yang memudahkan admin dalam mencabut hak akses yang sebelumnyadiberikan adalah ..... A) REVOKE. B) ALTER. C) SELECT. D) GRANT. E) DELETE. Show Answer Correct Answer: A) REVOKE. 45. What are the benefits of using a DBMS for data management? A) Benefits of using a DBMS include data integrity, security, concurrent access, backup and recovery, and simplified data management. B) Complex data retrieval processes. C) Increased data redundancy. D) Limited user access. Show Answer Correct Answer: A) Benefits of using a DBMS include data integrity, security, concurrent access, backup and recovery, and simplified data management. 46. The DBMS language component which can be embedded in a program is A) The data manipulation language (DML). B) The data definition language (DDL). C) A query language. D) The database administrator (DBA). Show Answer Correct Answer: A) The data manipulation language (DML). 47. What are the advantages of using stored procedures in a database? A) Stored procedures improve performance by reducing network traffic and encapsulating business logic. B) Stored procedures are only useful for data entry tasks. C) Stored procedures are less efficient than executing individual SQL statements. D) Stored procedures do not provide any security benefits. Show Answer Correct Answer: A) Stored procedures improve performance by reducing network traffic and encapsulating business logic. 48. Which command is used to query the table in a database? A) MODIFY. B) SELECT. C) UPDATE. D) CHANGE. Show Answer Correct Answer: B) SELECT. 49. What does the GROUP BY clause do in a query? A) Deletes duplicate records. B) Formats query results. C) Groups records with similar values together. D) Creates new tables. Show Answer Correct Answer: C) Groups records with similar values together. 50. Bahasa pemodelan berbasis berupa grafis/gambar (Notasi grafis) yang sering digunakan dalam sistem disebut ..... A) Unit Model Lang. B) Unified Modeling Language. C) United Modeling Language. D) Unit Modeling Language. E) Unified Modeling League. Show Answer Correct Answer: B) Unified Modeling Language. 51. Which tab on the Ribbon should be used to create a new table? A) View. B) Create. C) Insert. D) File. Show Answer Correct Answer: B) Create. 52. Which of these is NOT a type of database interface? A) Query language interface. B) File system interface. C) Graphical user interface. D) Speech-based interface. Show Answer Correct Answer: B) File system interface. 53. Untuk mengaktifkan database, dapat menggunakan perintah ..... A) USE. B) SHOW. C) ACTIVE. D) DESC. E) START. Show Answer Correct Answer: A) USE. 54. Which of the following is a conceptual model of a database? A) Relational Model. B) Hierarchical Model. C) Physical Storage Model. D) Entity-Relationship (ER) Model. Show Answer Correct Answer: D) Entity-Relationship (ER) Model. 55. Apa tujuan utama dari database? A) Mempercepat akses internet. B) Menyimpan data tanpa hubungan. C) Mengorganisir dan mengelola data terkait secara efektif. D) Mengelola dokumen. Show Answer Correct Answer: C) Mengorganisir dan mengelola data terkait secara efektif. 56. Apa yang dimaksud dengan redundansi dalam basis data? A) Menggunakan data yang sama untuk tujuan yang berbeda. B) Menyimpan data secara berulang dalam basis data. C) Menyimpan data hanya sekali tanpa duplikat. D) Menggabungkan beberapa basis data menjadi satu sistem. Show Answer Correct Answer: B) Menyimpan data secara berulang dalam basis data. 57. What is a field in a database table that is used to establish a link between two tables? A) Foreign Key. B) Unique Key. C) Index. D) Primary Key. Show Answer Correct Answer: A) Foreign Key. 58. What are integrity rules in a database? A) Integrity rules are methods for data encryption. B) Integrity rules are guidelines for database design. C) Integrity rules are only applicable to user permissions. D) Integrity rules in a database are constraints that maintain data accuracy and consistency. Show Answer Correct Answer: D) Integrity rules in a database are constraints that maintain data accuracy and consistency. 59. How can you retrieve specific data from a database using a query? A) Using the DELETE statement with appropriate conditions in SQL. B) Using the INSERT statement with appropriate conditions in SQL. C) Using the UPDATE statement with appropriate conditions in SQL. D) Using the SELECT statement with appropriate conditions in SQL. Show Answer Correct Answer: D) Using the SELECT statement with appropriate conditions in SQL. 60. What is data independence in database systems? A) The ability to store data separately from metadata. B) The ability to recover data in case of failure. C) The ability to manage data without a DBMS. D) The ability to easily change the structure of the database without affecting the application. Show Answer Correct Answer: D) The ability to easily change the structure of the database without affecting the application. ← 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 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books