This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 14 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 14 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Differentiate between a primary key and a candidate key. A) A primary key is optional, whereas a candidate key is mandatory. B) A primary key can be duplicated, while a candidate key cannot. C) A primary key is a unique identifier for a record, while a candidate key is any potential unique identifier. D) A primary key is a foreign key, while a candidate key is a local key. Show Answer Correct Answer: C) A primary key is a unique identifier for a record, while a candidate key is any potential unique identifier. 2. Which of the following operations requires the relations to be union compatible? A) UNION. B) INTERSECTION. C) DIFFERENCE. D) ALL OF THESE. Show Answer Correct Answer: D) ALL OF THESE. 3. Normalization helps make database management easier by: A) Simplifying data maintenance. B) Complicating updates. C) Increasing redundancy. D) Reducing data security. Show Answer Correct Answer: A) Simplifying data maintenance. 4. Which of the following is a DBMS for desktop computers? A) DB2. B) Microsoft SQL Server. C) Microsoft Access. D) Oracle Database. Show Answer Correct Answer: C) Microsoft Access. 5. Discuss the key features and benefits of using graph databases. A) Graph databases have no key features or benefits. B) Graph databases provide flexibility in data storage, support for hierarchical data structures, and seamless integration with object-oriented programming languages. C) Graph databases are less efficient than traditional relational databases. D) Graph databases are not suitable for complex data models. Show Answer Correct Answer: B) Graph databases provide flexibility in data storage, support for hierarchical data structures, and seamless integration with object-oriented programming languages. 6. Hubungan / relationship yang menggambarkan hubungan antara actor dengan usecase disebut ..... A) Generalization. B) Dependency. C) Extend. D) Include. E) Association. Show Answer Correct Answer: E) Association. 7. How is a composite entity identifier formed? A) By ensuring that the data does not get out of sync. B) Refers to the number of times an instance in one entity can be associated with instances in the related entity. C) Uses two or more entities to represent an interaction or association. D) The minimum number of attributes are combined to achieve this goal. Show Answer Correct Answer: D) The minimum number of attributes are combined to achieve this goal. 8. Multiple primary keys in a table A) True; a table can have multiple primary keys. B) False; a table can only have one primary key. C) A table can have primary keys if it has foreign keys. D) A table can have primary keys in different columns. Show Answer Correct Answer: B) False; a table can only have one primary key. 9. Which of the following is a function of a database? A) Efficient data storage. B) Data encryption. C) Data analysis. D) Data visualization. Show Answer Correct Answer: A) Efficient data storage. 10. What is the purpose of a Secondary Key in a database table? A) To uniquely identify each record in a table. B) To allow the database to be searched quickly. C) To store data in a hierarchical format. D) To encrypt database information. Show Answer Correct Answer: B) To allow the database to be searched quickly. 11. What type of lock allows multiple transactions to read but prevents any write operations? A) Read Lock. B) Exclusive Lock. C) Shared Lock. D) Deadlock. Show Answer Correct Answer: C) Shared Lock. 12. Which SQL keyword is used to remove a record from a table? A) SELECT. B) DELETE. C) DROP. D) UPDATE. Show Answer Correct Answer: B) DELETE. 13. Berikan contoh tag HTML untuk membuat tautan (link) ke halaman lain. A) Teks Tautan. B) Teks Tautan. C) Teks Tautan. D) Teks Tautan. Show Answer Correct Answer: A) Teks Tautan. 14. What is the main advantage of using forms in a database? A) They allow for easier data entry and viewing. B) They automatically create tables. C) They compress the database size. D) They encrypt the data. Show Answer Correct Answer: A) They allow for easier data entry and viewing. 15. What is the main advantage of using NewSQL? A) It is a type of NoSQL database. B) It does not support transactions. C) Combines reliability of SQL with speed of NoSQL. D) It is only for small datasets. Show Answer Correct Answer: C) Combines reliability of SQL with speed of NoSQL. 16. In a network model, a child can: A) Not have any parents. B) Have multiple parent records. C) Have only one parent. D) Only be linked to leaf nodes. Show Answer Correct Answer: B) Have multiple parent records. 17. A database ..... is the snapshot/state of a database at any given time. A) Relation. B) Metadata. C) Schema. D) Instance. Show Answer Correct Answer: D) Instance. 18. The "father" of MySQL is ..... A) Michael Widenius. B) Bill Joy. C) Bill Gates. D) Stephanie Wall. E) Sigmund Velin. Show Answer Correct Answer: A) Michael Widenius. 19. Which of the following is not a problem of file systems? A) Data redundancy. B) Easy multi-user access. C) Limited data sharing. D) Complex backup. Show Answer Correct Answer: B) Easy multi-user access. 20. ..... shape represents the entities in ER diagrams. A) Diamond. B) Square. C) Circle. D) Rectangle. Show Answer Correct Answer: D) Rectangle. 21. A table TEST ..... COUNT has 10 number values as 3, 32, 1, 1, null, 24, 12, null, 32, null Predict the output of the below query:SELECT COUNT(*) FROM test ..... count; A) 6. B) 7. C) Throws exception because COUNT function doesn't work with NULL values. D) 10. Show Answer Correct Answer: D) 10. 22. Why might a Composite Key be necessary in a database table? A) When the table needs to be linked to multiple foreign keys. B) When no single field contains unique values. C) When the database is normalized to the third normal form. D) When the table requires faster query processing. Show Answer Correct Answer: B) When no single field contains unique values. 23. Define the term 'tuple' in the context of a relational database. A) A tuple is a single row of data in a relational database table. B) A tuple is a type of database query. C) A tuple is a collection of tables in a database. D) A tuple is a unique identifier for a database record. Show Answer Correct Answer: A) A tuple is a single row of data in a relational database table. 24. For each attribute of a relation, there is a set of permitted values, called the ..... of that attribute. A) Set. B) Domain. C) Schema. D) Relation. Show Answer Correct Answer: B) Domain. 25. Which one of the following cannot be taken as a primary key? A) Street. B) RegistrationNo. C) DepartmentID. D) ID. Show Answer Correct Answer: A) Street. 26. What is the relationship between DOCTOR table and PATIENT table? A) M:N. B) 1:M. C) 1:1. D) M:M. Show Answer Correct Answer: B) 1:M. 27. Which of the following is an example of a physical database? A) A website that displays information. B) A collection of books in a library. C) A cloud storage service. D) A spreadsheet file saved on a computer. Show Answer Correct Answer: B) A collection of books in a library. 28. Which of these is an advantage of storing data in fields with the correct data type? A) Data looks more polished. B) The database automatically fixes spelling errors. C) Searching and sorting becomes more reliable. D) ASCII is no longer required. Show Answer Correct Answer: C) Searching and sorting becomes more reliable. 29. Which command is used to create a new table in a database? A) CREATE TABLE. B) INSERT TABLE. C) ADD TABLE. D) MAKE TABLE. Show Answer Correct Answer: A) CREATE TABLE. 30. Meera wants to store student information like name, roll number, and contact in an organized way. What should she use? A) Database. B) Drawing tool. C) Presentation. D) Spreadsheet. Show Answer Correct Answer: A) Database. 31. What does ETL stand for in data processing? A) Evaluate, Transform, Load. B) Extract, Transfer, Link. C) Evaluate, Test, Load. D) Extract, Transform, Load. Show Answer Correct Answer: D) Extract, Transform, Load. 32. The OR operator combines two relational expressions where only one must be true to provide a true result A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 33. Javell is organizing his music collection on his computer. Each song's title, artist, and album information is stored in a table. Which term refers to a single piece of data in this table? A) Record. B) File. C) Query. D) Field. Show Answer Correct Answer: D) Field. 34. Which SQL command is used to remove a table from the database? A) CLEAR table. B) DELETE table. C) DROP table. D) REMOVE table. Show Answer Correct Answer: C) DROP table. 35. Which of the following is NOT a type of database recovery technique? A) Rollback. B) Backup. C) Commit. D) Checkpoint. Show Answer Correct Answer: C) Commit. 36. What does the SELECT clause do in SQL? A) It updates data in a database. B) It inserts data into a database. C) It retrieves data from a database. D) It deletes data from a database. Show Answer Correct Answer: C) It retrieves data from a database. 37. Which of the following is not a benefit of using a relational database A) Reduces the complexity of the database. B) Removes duplicate data being stored in tables. C) Improves data integrity. D) Reduces inaccurate data being stored. Show Answer Correct Answer: A) Reduces the complexity of the database. 38. Which of the following best describes the difference between database and DBMS? A) DBMS is used for internet access. B) A DBMS is data itself. C) A database stores data, DBMS manages it. D) A database is a programming language. Show Answer Correct Answer: C) A database stores data, DBMS manages it. 39. Which of the following is an example of a table in a database? A) A list of folders. B) A list of names. C) A list of images. D) A list of records. Show Answer Correct Answer: D) A list of records. 40. Which is fundamental to any computer system? A) Attribute. B) Entity. C) Data. D) Instance. Show Answer Correct Answer: C) Data. 41. Which of the following is an advantage of using a database, except ..... A) Cost of setup and maintenance. B) Increased data redundancy. C) Improved data accessibility. D) Enhanced data security. Show Answer Correct Answer: A) Cost of setup and maintenance. 42. Which command lists all databases in PostgreSQL? A) SHOW DATABASES;. B) LIST DATABASES;. C) L. D) DISPLAY DATABASES;. Show Answer Correct Answer: C) L. 43. Which of the following is NOT a main component of a database? A) Tables. B) Pixels. C) Fields. D) Records. Show Answer Correct Answer: B) Pixels. 44. According to the example table, which of the following is a record for Johnny Mitchell? A) 12983, Ann, Hale, 102 Hwy 45, Saltillo, MS, 38866. B) 23712, Joseph, Collins, 520 Court Dr., Tupelo, MS, 38801. C) 11170, Johnny, Mitchell, 1420 Jon, Tupelo, MS, 38804. D) 25890, Albert, Jones, 2 Lakeshore Ave., Verona, MS, 38879. Show Answer Correct Answer: C) 11170, Johnny, Mitchell, 1420 Jon, Tupelo, MS, 38804. 45. A field identified in a record as holding the unique identifier for a record is called the ..... A) Identifier key. B) Primary field. C) Primary key. D) Unique ID. Show Answer Correct Answer: C) Primary key. 46. The attribute name could be structured as an attribute consisting of first name, middle name and last name. This type of attribute is called: A) Composite attribute. B) Multi-valued attribute. C) Derived attribute. D) Simple attribute. Show Answer Correct Answer: A) Composite attribute. 47. Which problem occurs when multiple users access the same file simultaneously without coordination? A) Integrity problems. B) Security problems. C) Data redundancy. D) Concurrent access anomalies. Show Answer Correct Answer: D) Concurrent access anomalies. 48. ..... are the languages used to write commands to access, insert, update and delete data stored. A) Low level language. B) High level language. C) Database access language. D) Operating system. Show Answer Correct Answer: C) Database access language. 49. What is the primary goal of database design? A) To create complex queries. B) To minimize data redundancy and ensure data integrity. C) To maximize data entry speed only. D) To replace programming. Show Answer Correct Answer: B) To minimize data redundancy and ensure data integrity. 50. Which of the following is NOT a valid MongoDB data type? A) Pointer. B) Double. C) String. D) Timestamp. Show Answer Correct Answer: A) Pointer. 51. When moving from a flat-file database to a relational database, what is the primary reason for the reduction in required external storage space? A) Data items, such as teacher names, are stored only once instead of being repeated. B) Relational databases compress all text into numeric codes. C) Student names are deleted to make room for relationship IDs. D) Relational tables do not use traditional rows or columns. Show Answer Correct Answer: A) Data items, such as teacher names, are stored only once instead of being repeated. 52. In a relational database, each tuple is divided into fields called A) Relations. B) Domains. C) Queries. D) None of the above. Show Answer Correct Answer: B) Domains. 53. What is the purpose of an input mask? A) To format data entry in a specific pattern. B) To delete records automatically. C) To prevent duplicate records. D) To create a backup of the database. Show Answer Correct Answer: A) To format data entry in a specific pattern. 54. In a relational database, what uniquely identifies a record? A) Data type. B) Column name. C) File path. D) Primary key. Show Answer Correct Answer: D) Primary key. 55. Which database type is most suitable for handling large-scale, flexible schema data? A) NoSQL. B) Hierarchical. C) Network. D) Relational. Show Answer Correct Answer: A) NoSQL. 56. Which of the following is an example of a typical DBMS functionality? A) Creating a new programming language. B) Developing hardware components. C) Defining a particular database in terms of its data types. D) Designing user interfaces. Show Answer Correct Answer: C) Defining a particular database in terms of its data types. 57. Which pane in MS Access displays the list of tables, forms, queries, and reports? A) Field Template Pane. B) Navigation Pane. C) Object Tabs. D) Status Bar. Show Answer Correct Answer: B) Navigation Pane. 58. Which of the following is TRUE about the atomicity of a database? A) All transactions are considered to be a single entity. B) Incomplete changes are also recorded. C) Multiple operations of a transaction are considered to be a single entity. D) None of the above. Show Answer Correct Answer: C) Multiple operations of a transaction are considered to be a single entity. 59. What is a composite key in a relational database? A) A key that consists of two or more attributes. B) A key that is generated automatically. C) A key that is used for indexing. D) A key that is unique to each record. Show Answer Correct Answer: A) A key that consists of two or more attributes. 60. If "Admission Number" is chosen as the primary key, the combination "Class + Section + Roll No." becomes the: A) Foreign Key. B) Alternate Key. C) Domain. D) Primary Key. Show Answer Correct Answer: B) Alternate Key. ← 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