This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 22 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 22 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Gina needs to create a database of all her friends. Where will all the information be kept? A) Record. B) Entry. C) Field. D) Table. Show Answer Correct Answer: A) Record. 2. Number of columns in a relation is called ..... A) Degree. B) Cardinality. C) Attribute. D) None of these. Show Answer Correct Answer: A) Degree. 3. What is the default size of a text data type? A) 240 characters. B) 270 characters. C) 260 characters. D) 255 characters. Show Answer Correct Answer: D) 255 characters. 4. Which of the following is an example of an entity-attribute relationship? A) The entity PRODUCT with the attribute CUSTOMER. B) The entity CUSTOMER with the attribute PRODUCT. C) The entity CUSTOMER with the attribute ADDRESS. D) The entity PRODUCT with the attribute PURCHASE. Show Answer Correct Answer: C) The entity CUSTOMER with the attribute ADDRESS. 5. What type of commands are GRANT and REVOKE? A) DML. B) DCL. C) TCL. D) DDL. Show Answer Correct Answer: B) DCL. 6. Which of these is not a basic building block of a data model? A) Relationship. B) Table. C) Attribute. D) Entity. Show Answer Correct Answer: B) Table. 7. Sebuah program komputer yang disalin untuk mengelola basis data sebagai kumpulan data yang disimpan secara terstruktur dan melakukan operasi pada data atas permintaan pengguna didefinisikan sebagai ..... A) DBMS. B) DDL. C) ORACLE. D) DB2. E) SQL. Show Answer Correct Answer: A) DBMS. 8. What is an alternate key in a database? A) An alternate key is a primary key that allows duplicate values. B) An alternate key is a unique identifier for a record that is not the primary key. C) An alternate key is a foreign key that links two tables together. D) An alternate key is a temporary identifier used during data entry. Show Answer Correct Answer: B) An alternate key is a unique identifier for a record that is not the primary key. 9. How would you retrieve the total number of distinct job roles in the 'employees' table? A) SELECT COUNT(job role) FROM employees WHERE DISTINCT;. B) SELECT DISTINCT job role FROM employees;. C) SELECT COUNT(DISTINCT job role) FROM employees;. D) SELECT job role FROM employees WHERE DISTINCT;. Show Answer Correct Answer: C) SELECT COUNT(DISTINCT job role) FROM employees;. 10. Database is a collection of related data. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 11. In the context of multiple views, why do different user groups need different perspectives of the same data? A) To confuse users. B) To increase storage costs. C) Different information needs, security requirements, and simplified interaction. D) To slow down the system. Show Answer Correct Answer: C) Different information needs, security requirements, and simplified interaction. 12. A student claims productID should be stored in the Customer table instead of Subscription. What is the best response? A) It prevents duplicate customer records entirely. B) It would incorrectly tie one customer to one product. C) It allows faster joins across three tables. D) It enforces stronger primary key uniqueness. Show Answer Correct Answer: B) It would incorrectly tie one customer to one product. 13. Why is it important to define data types when creating a table? A) It is important to define data types to ensure data consistency, optimize storage, and enforce data integrity. B) Data types should be defined to improve the speed of data retrieval and display. C) Defining data types helps in creating visually appealing tables and layouts. D) It is crucial to define data types to enhance user experience and interface design. Show Answer Correct Answer: A) It is important to define data types to ensure data consistency, optimize storage, and enforce data integrity. 14. What is a Student Table in MS Access used for? A) Entering and storing student-related data. B) Creating a new software program. C) Formatting images. D) Deleting databases. Show Answer Correct Answer: A) Entering and storing student-related data. 15. What is the purpose of a database trigger? A) To automatically execute a procedure when a certain event occurs. B) To improve the speed of data retrieval. C) To increase the size of the database. D) To make the database more complex. Show Answer Correct Answer: A) To automatically execute a procedure when a certain event occurs. 16. Which of these best explains why records must be accurate in a database? A) Inaccurate records make ASCII unreadable. B) Inaccurate records make reports unreliable. C) Inaccurate records delete tables automatically. D) Inaccurate records prevent formatting into Excel. Show Answer Correct Answer: B) Inaccurate records make reports unreliable. 17. Which object is best suited to extract specific data based on criteria in MS Access? A) Report. B) Field. C) Query. D) Table. Show Answer Correct Answer: C) Query. 18. Which of the following is an advantage of using forms instead of directly entering data in a table? A) Forms can be printed. B) Forms allow for a more user-friendly data entry process. C) Forms store data more securely. D) Forms can only display one record at a time. Show Answer Correct Answer: B) Forms allow for a more user-friendly data entry process. 19. ..... is a bottom up process in EERD. It combines lower level entities into one that is a higher level. Example:Apple, Banana, Grapes when generalized can be called as "FRUITS" . A) Generalization. B) Association. C) Specialization. D) Aggregation. Show Answer Correct Answer: A) Generalization. 20. When printing forms in MS Access, what option is available? A) Print with animation effects. B) Print only selected records. C) Print to multiple printers simultaneously. D) Print in 3D format. Show Answer Correct Answer: B) Print only selected records. 21. What is a junction table used for? A) Eliminating relationships between tables. B) Deleting redundant records. C) Connecting two tables in a many-to-many relationship. D) Storing unrelated data. Show Answer Correct Answer: C) Connecting two tables in a many-to-many relationship. 22. Which component of a DBMS is responsible for managing physical storage? A) Query Processor. B) Transaction Manager. C) Data Dictionary. D) Storage Manager. Show Answer Correct Answer: D) Storage Manager. 23. .... is a way of combining two relations. A) Intersection. B) Cross product. C) Union. D) None of these. Show Answer Correct Answer: B) Cross product. 24. What are columns in a database table? A) Columns represent the rows in a database table. B) Columns are the horizontal sections that contain the data. C) Columns in a database table are the vertical sections that define the attributes of the data. D) Columns are the unique identifiers for each record in a table. Show Answer Correct Answer: C) Columns in a database table are the vertical sections that define the attributes of the data. 25. Which of the following statements is FALSE about keys in a relational database? A) Any candidate key is eligible to become a primary key. B) A primary key uniquely identifies the tuples in a relation. C) A candidate key that is not a primary key is a foreign key. D) A foreign key is an attribute whose value is derived from the primary key of another relation. Show Answer Correct Answer: C) A candidate key that is not a primary key is a foreign key. 26. What are the 2 types of tools used in Database application? A) Left-end tool and Right-end tool. B) Front-end tool and back-end tool. C) Front-end tool and Right-end tool. D) Bottom-end tool and top-end tool. Show Answer Correct Answer: B) Front-end tool and back-end tool. 27. How can you enter data into a table in Access? A) Use SQL queries to add data to the table. B) Enter data by importing from an Excel file. C) Create a new table and copy data from another database. D) Open the table in Datasheet View and enter data directly into the cells. Show Answer Correct Answer: D) Open the table in Datasheet View and enter data directly into the cells. 28. In a database table, each row stores complete information about one student. What is this row called? A) Field. B) Record. C) Header. D) Column. Show Answer Correct Answer: B) Record. 29. Berikut ini yang bukan merupakan siklus penggembangan perangkat lunak (SDLC)adalah ..... A) Perencanaan system. B) Analisis system. C) Perancangan system. D) System Documentation. E) Implementasi system. Show Answer Correct Answer: D) System Documentation. 30. Which is NOT a type of DBMS? A) Hierarchical. B) Network. C) Sequential. D) Distributed. Show Answer Correct Answer: C) Sequential. 31. A table is in 3NF if it is in 2NF and ..... A) It has duplicate records. B) It has no transitive dependencies. C) It has no foreign keys. D) It has only one table. Show Answer Correct Answer: B) It has no transitive dependencies. 32. Find all the cities whose humidity is 89 A) SELECT city WHERE humidity = 89;. B) SELECT city FROM weather WHERE humidity = 89;. C) SELECT humidity = 89 FROM weather;. D) SELECT city FROM weather;. Show Answer Correct Answer: B) SELECT city FROM weather WHERE humidity = 89;. 33. Apa itu normalisasi dalam basis data? A) Proses menghapus duplikasi data. B) Proses membuat basis data offline. C) Proses mengekspor data ke format lain. D) Proses otomatis mencadangkan data. E) Proses menyimpan semua data dalam satu tabel. Show Answer Correct Answer: A) Proses menghapus duplikasi data. 34. What is the purpose of a query in a database? A) To prepare data to be used in another program. B) To ask a database to find specific data from one or more tables. C) To organize information into columns and rows. D) To create printouts for presentation and sharing. Show Answer Correct Answer: B) To ask a database to find specific data from one or more tables. 35. Which of the following could be considered a potential secondary key in a Customer table? A) Customer email address. B) Customer username. C) Customer postcode. D) Customer date of birth. Show Answer Correct Answer: B) Customer username. 36. How can you create a report in Access? A) Open Access, go to 'File' tab, select 'New Document'. B) Select 'Design' tab and click on 'Create Report' button. C) Use 'Data' tab to create a new report. D) Open Access, go to 'Create' tab, select 'Report' or use 'Report Wizard'. Show Answer Correct Answer: D) Open Access, go to 'Create' tab, select 'Report' or use 'Report Wizard'. 37. Who is called Father of relational Database from the following? A) Edgar Frank Codd. B) Chris Date. C) Edgar Frank Cadd. D) Hugh Darween. Show Answer Correct Answer: A) Edgar Frank Codd. 38. What is the purpose of the Form Wizard? A) To create and customize forms. B) To delete unwanted data. C) To change the default file name. D) To organize spreadsheets. Show Answer Correct Answer: A) To create and customize forms. 39. MySQL runs on which operating systems? A) Unix and Linux only. B) Linux and Mac OS-X only. C) Unix, Linux, Windows and others. D) Any operating system at all. Show Answer Correct Answer: C) Unix, Linux, Windows and others. 40. What is the purpose of DDL commands in a database? A) The purpose of DDL commands in a database is to retrieve data from the database. B) The purpose of DDL commands in a database is to perform calculations and computations on the data. C) The purpose of DDL commands in a database is to secure and protect the data in the database. D) The purpose of DDL commands in a database is to define and manage the structure of the database. Show Answer Correct Answer: D) The purpose of DDL commands in a database is to define and manage the structure of the database. 41. What happens when you delete a record in MS Access? A) It can be automatically recovered. B) It moves to a backup table. C) It is permanently removed. D) It becomes hidden but remains in the database. Show Answer Correct Answer: C) It is permanently removed. 42. What is the primary goal of data management? A) To automate data-related processes without human input. B) To ensure data accuracy, consistency, security, and accessibility. C) To improve the presentation of data across platforms. D) None of the above. Show Answer Correct Answer: B) To ensure data accuracy, consistency, security, and accessibility. 43. What advanced skills can you develop after learning the basics of Access? A) Creating complex reports and automating tasks with macros. B) Learning to play a musical instrument. C) Practicing basic yoga poses. D) Understanding elementary mathematics. Show Answer Correct Answer: A) Creating complex reports and automating tasks with macros. 44. Indicate whether the statement is true or false:A logical view shows data as it is actually organized and structured on the data storage media. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 45. What is the role of a database administrator? A) To develop software applications. B) To create network protocols. C) To manage and maintain database systems. D) To design user interfaces. Show Answer Correct Answer: C) To manage and maintain database systems. 46. In the ER model, a relationship between 'Teacher' and 'Class' would be represented as: A) Primary key. B) Attribute. C) Field. D) Connection line with diamond. Show Answer Correct Answer: D) Connection line with diamond. 47. What are primary and foreign keys used for in a database? A) Primary keys are used to uniquely identify records in a table, while foreign keys are used to establish relationships between tables by referencing primary keys. B) Primary keys can be duplicated across different tables. C) Primary keys are used to group similar records together. D) Foreign keys are used to delete records from a table. Show Answer Correct Answer: A) Primary keys are used to uniquely identify records in a table, while foreign keys are used to establish relationships between tables by referencing primary keys. 48. What are the components of a single-table database? A) Fields. B) Records. C) Validation rules. D) All of the aboveTagsLO1. Show Answer Correct Answer: D) All of the aboveTagsLO1. 49. An organized collection of structured information, or data, typically stored electronically in a computer system. A) Database Management System. B) Database. C) Database Application. D) Database Integration. Show Answer Correct Answer: B) Database. 50. What is the purpose of a database schema? A) The purpose of a database schema is to define the organization and structure of data within a database. B) To create user interfaces for applications. C) To manage network security protocols. D) To store data in a cloud environment. Show Answer Correct Answer: A) The purpose of a database schema is to define the organization and structure of data within a database. 51. A bank database has different tables for "Customers, " "Loans, " and "Transactions." This organization ensures: A) Redundancy. B) Integrity and Simplicity. C) Data Duplication. D) Manual Handling. Show Answer Correct Answer: B) Integrity and Simplicity. 52. Which data model supports many-to-many relationships? A) Network. B) Hierarchical. C) Relational. D) File system. Show Answer Correct Answer: A) Network. 53. What type of relationship exists when a single record in Table A is linked to many records in Table B? A) Many-to-One. B) One-to-One. C) One-to-Many. D) Many-to-Many. Show Answer Correct Answer: C) One-to-Many. 54. How would you select all employees with either a 'Manager' or 'Analyst' title? A) SELECT * FROM employees WHERE title IN ('Manager', 'Analyst');. B) SELECT * FROM employees WHERE title = 'Manager' OR title = 'Analyst';. C) SELECT * FROM employees WHERE title = 'Manager' AND title = 'Analyst';. D) SELECT * FROM employees WHERE title LIKE 'Manager' OR title LIKE 'Analyst';. Show Answer Correct Answer: B) SELECT * FROM employees WHERE title = 'Manager' OR title = 'Analyst';. 55. Each row is known as ..... A) Field. B) Attribute. C) Tuple. D) Relation. Show Answer Correct Answer: B) Attribute. 56. What is the correct SQL statement to add a new record into a table? A) INSERT INTO table (column1, column2) VALUES (value1, value2);. B) SELECT column FROM table;. C) DELETE FROM table WHERE condition;. D) UPDATE table SET column=value;. Show Answer Correct Answer: A) INSERT INTO table (column1, column2) VALUES (value1, value2);. 57. What does a many-to-many relationship in a relational database describe? A) A single record in one table linking to multiple records in another table. B) Each record in one table linking to only one record in another table. C) Multiple records in one table linking to the same single record in another table. D) One record in table A links to many records in table B and vice versa. Show Answer Correct Answer: D) One record in table A links to many records in table B and vice versa. 58. ..... establishes an organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information. A) Data definition. B) Data scrubbing. C) Data quality assurance. D) Data governance. Show Answer Correct Answer: D) Data governance. 59. How is data perceived in a logical view compared to a physical view? A) Physical view emphasizes data relationships over structure. B) Data in a logical view focuses on structure and relationships, while in a physical view, it focuses on storage and access methods. C) Logical view deals with how data is stored on disk. D) Data in a logical view is only concerned with data types. Show Answer Correct Answer: B) Data in a logical view focuses on structure and relationships, while in a physical view, it focuses on storage and access methods. 60. Which data type is used in SQL to store true or false values? A) BOOLEAN. B) INT. C) FLOAT. D) VARCHAR. Show Answer Correct Answer: A) BOOLEAN. ← 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