This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 29 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 29 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. One specific piece of information about a person or thing is called a: A) Record. B) File. C) Field. D) Table. Show Answer Correct Answer: C) Field. 2. Perintah SQL yang digunakan untuk masuk ke MySQL sebagai pengguna 'root' dengan kata sandi adalah ..... A) Mysql-u root-p. B) Mysql-p root. C) Mysql-u root. D) Mysql root-p. Show Answer Correct Answer: A) Mysql-u root-p. 3. What does ETL stand for? A) Extract, Transfer, Load. B) Extract, Transform, Load. C) Execute, Transfer, Load. D) Execute, Transform, Load. Show Answer Correct Answer: B) Extract, Transform, Load. 4. The AND 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: B) False. 5. What type of relationship exists when a single record in one table is related to multiple records in another table? A) One-to-Many. B) One-to-One. C) Many-to-One. D) Many-to-Many. Show Answer Correct Answer: A) One-to-Many. 6. What is a functional dependency? A) When an non-key attribute is determined by a whole part of a COMPOSITE primary key. B) When a key field is changed and it conflicts with another key. C) When a database function is dependant of the operation of another function to work correctly. D) When data is a database is repeated for different entities. Show Answer Correct Answer: A) When an non-key attribute is determined by a whole part of a COMPOSITE primary key. 7. Which model represents more complex applications? A) Relational model. B) Object model. C) ER Database model. D) None of the above. Show Answer Correct Answer: D) None of the above. 8. Ananya wants to make sure that each student's roll number is unique. What should she use? A) Primary Key. B) Filter. C) Field Template. D) Caption. Show Answer Correct Answer: A) Primary Key. 9. Involves database design and construction on how the databases will operate and f unction within exisiting structures and location. A) Database System Platform. B) Database System Architecture. C) Database System Developer. D) Database System Schedma. Show Answer Correct Answer: B) Database System Architecture. 10. What is the software used to manage databases called? A) Information Retrieval System. B) Database Management System (DBMS). C) Data Storage System. D) File Management System. Show Answer Correct Answer: B) Database Management System (DBMS). 11. What is the role of constraints in a database? A) To allow fields to be left blank. B) To define rules about what can or cannot be entered. C) To format data automatically. D) To create relationships between tables. Show Answer Correct Answer: B) To define rules about what can or cannot be entered. 12. What is the purpose of a social media database? A) To store information about products. B) To store information about social media users. C) To store information about finances. D) To store information about customers. Show Answer Correct Answer: B) To store information about social media users. 13. Write a SQL query to retrieve all the records from a table named 'students'. A) SELECT * FROM students;. B) GET FROM students. C) RETRIEVE * FROM students. D) SELECT ALL students. Show Answer Correct Answer: A) SELECT * FROM students;. 14. In order to retrieve data from two or more tables through query, we must establish a ..... between tables. A) Criteri. B) Relationship. C) Field. D) Primary key. Show Answer Correct Answer: B) Relationship. 15. Apa singkatan dari HTML? A) Hypertext Markup Language. B) Hyperspace Markup Language. C) Hyperlink Markup Language. D) High Tech Markup Language. Show Answer Correct Answer: A) Hypertext Markup Language. 16. A DBMS makes the ..... A) Relational database available for different analytic views. B) Physical database available for different logical views. C) Relational database available for different logical views. D) Physical database available for different analytic views. Show Answer Correct Answer: B) Physical database available for different logical views. 17. Data is the collection of raw facts. A) TRUE. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 18. Why is it important to have unique records in a database? A) To allow for easier data entry by having multiple records for the same entity. B) To increase the complexity of data retrieval processes. C) It is important to have unique records in a database to ensure data integrity, prevent duplication, and facilitate efficient data management. D) To ensure that all records are identical for consistency. Show Answer Correct Answer: C) It is important to have unique records in a database to ensure data integrity, prevent duplication, and facilitate efficient data management. 19. In which stage is user training typically conducted? A) Implementation. B) Design. C) Initial study. D) Maintenance. Show Answer Correct Answer: A) Implementation. 20. What is a columnar format in MS Access? A) A layout for tables and forms. B) A tool for exporting data. C) A way to delete data. D) A password protection feature. Show Answer Correct Answer: A) A layout for tables and forms. 21. Which SQL standard was introduced in 1999? A) SQL-89. B) SQL-86. C) SQL:1999. D) SQL-2003. Show Answer Correct Answer: C) SQL:1999. 22. DBMSs typically include report generation tools in order to ..... A) Retrieve and display data. B) Display data in a more structured and polished format than would be possible just by querying. C) Display data in graphs. D) Perform predictive analysis. Show Answer Correct Answer: B) Display data in a more structured and polished format than would be possible just by querying. 23. In SQL, which of the following can be used to limit the number of rows returned by a query? A) GROUP BY. B) HAVING. C) LIMIT. D) DISTINCT. Show Answer Correct Answer: C) LIMIT. 24. In SQL, what is the difference between CHAR and VARCHAR data types? A) No difference. B) CHAR is variable length, VARCHAR is fixed length. C) CHAR is fixed length, VARCHAR is variable length. D) VARCHAR is used only for numeric data. Show Answer Correct Answer: C) CHAR is fixed length, VARCHAR is variable length. 25. The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; A) Prints 045.926. B) Is illegal. C) Prints garbage. D) Prints 50. Show Answer Correct Answer: D) Prints 50. 26. What is SQL injection and how can it be prevented? A) SQL injection is a method to enhance database performance. B) SQL injection is a code injection technique that exploits vulnerabilities in applications. It can be prevented by using prepared statements, parameterized queries, and input validation. C) It can be avoided by using regular expressions and data encryption. D) SQL injection is a technique for optimizing SQL queries. Show Answer Correct Answer: B) SQL injection is a code injection technique that exploits vulnerabilities in applications. It can be prevented by using prepared statements, parameterized queries, and input validation. 27. What is concurrency in the context of databases? A) The simultaneous execution of multiple transactions. B) The speed at which database operations are performed. C) The process of creating backup copies of the database. D) The ability to store large amounts of data. Show Answer Correct Answer: A) The simultaneous execution of multiple transactions. 28. Which of the following is not a characteristic of a good database design? A) Efficiency. B) Data redundancy. C) Data integrity. D) Scalability. Show Answer Correct Answer: B) Data redundancy. 29. Mana yang BUKAN merupakan atribut? A) Hubungan dengan pemasok. B) Nomor telepon. C) Nama. D) Email. Show Answer Correct Answer: A) Hubungan dengan pemasok. 30. Where is the foreign key used in a one-to-many relationship? A) In the table on the 'one' side of the relationship. B) In the table on the 'many' side of the relationship. C) In both tables involved in the relationship. D) Foreign keys are not used in one-to-many relationships. Show Answer Correct Answer: B) In the table on the 'many' side of the relationship. 31. A transaction is a unit of work performed within a database management system against a database. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: B) True. 32. The vertical section (column) in a table is known as: A) Record. B) View. C) Form. D) Field. Show Answer Correct Answer: D) Field. 33. When a database is used for a web application to display high-resolution product images, which data type is specifically intended to hold these files? A) Boolean. B) Long Integer. C) Alphanumeric (Short Text). D) Attachment or OLE object. Show Answer Correct Answer: D) Attachment or OLE object. 34. .... includes all tuples that are in tables A or in B. A) Union. B) Product. C) Set difference. D) Intersection. Show Answer Correct Answer: A) Union. 35. Depending on the type of data organization, the following basic models of data representation are distinguished in the database? A) Hierarchical; network;relationships. B) To each other; relationshipone-many and many-one;many relationships. C) Individual and group. D) Everything is correct. E) Operational and non-operational. Show Answer Correct Answer: A) Hierarchical; network;relationships. 36. Apa itu foreign key dalam database? A) Foreign key digunakan untuk menghapus data dari tabel induk. B) Foreign key adalah kolom yang tidak memiliki hubungan dengan tabel lain. C) Foreign key adalah kolom atau serangkaian kolom dalam sebuah tabel yang mengacu pada kunci utama kolom atau serangkaian kolom lain dalam tabel lain, yang digunakan untuk membangun hubungan antar tabel. D) Foreign key hanya dapat mengacu pada kunci utama dalam tabel yang sama. Show Answer Correct Answer: C) Foreign key adalah kolom atau serangkaian kolom dalam sebuah tabel yang mengacu pada kunci utama kolom atau serangkaian kolom lain dalam tabel lain, yang digunakan untuk membangun hubungan antar tabel. 37. Why is credential management important? A) It ensures secure authentication and user identity. B) It logs password reuse. C) It enables storing passwords in plaintext for easy recovery. D) None of the above. Show Answer Correct Answer: A) It ensures secure authentication and user identity. 38. What are the steps to design a form in Access? A) Choose 'Design View' for a report instead. B) 1. Open Access and select the database. 2. Go to 'Create' tab. 3. Click 'Form Design'. 4. Add controls. 5. Set properties. 6. Save the form. 7. Test in 'Form View'. C) Select 'File' and create a new table. D) Go to 'Home' tab and click 'Import'. Show Answer Correct Answer: B) 1. Open Access and select the database. 2. Go to 'Create' tab. 3. Click 'Form Design'. 4. Add controls. 5. Set properties. 6. Save the form. 7. Test in 'Form View'. 39. Indicate whether the statement is true or false:Multiple data marts are combined and streamlined to create a data warehouse. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 40. What is the relationship where one entry in one table has a single entry in the other table and vice versa? A) One-to-one. B) One-to-many. C) Many-to-many. D) None of the above. Show Answer Correct Answer: A) One-to-one. 41. Which of the following is an example of a non-relational database? A) Oracle. B) MongoDB. C) PostgreSQL. D) MySQL. Show Answer Correct Answer: B) MongoDB. 42. A ..... is a stored program that is attached to a table or a view. A) Pseudofile. B) Embedded SELECT statement. C) Trigger. D) None of the above is correct. Show Answer Correct Answer: C) Trigger. 43. Why are database systems important for businesses? A) They improve office layout. B) They enhance business intelligence. C) They prevent electricity loss. D) They are required by law. Show Answer Correct Answer: B) They enhance business intelligence. 44. What is referential integrity? A) A way to delete old records. B) A method for sorting data. C) A rule that ensures data consistency between related tables. D) A formatting tool for reports. Show Answer Correct Answer: C) A rule that ensures data consistency between related tables. 45. Which method is NOT a data validation method? A) Double Entry. B) Lookup Check. C) Length Check. D) Format Check. Show Answer Correct Answer: A) Double Entry. 46. Paul is organizing a database for his travel agency. Which of the following is an example of a primary key he might use to uniquely identify each client's record? A) Country name. B) Phone number. C) Passport number. D) Address. Show Answer Correct Answer: C) Passport number. 47. What skills are important for a career in database administration? A) Proficiency in knitting. B) Knowledge of database management systems, SQL, data modeling, data security, troubleshooting, and communication skills. C) Expertise in skydiving. D) Knowledge of cooking techniques. Show Answer Correct Answer: B) Knowledge of database management systems, SQL, data modeling, data security, troubleshooting, and communication skills. 48. Which of the following is NOT a basic building block of a database system? A) Hardware. B) Data. C) Users. D) Compiler. Show Answer Correct Answer: D) Compiler. 49. Define the relational data model. A) A method for storing data in a single flat file without relationships. B) A framework for organizing data in a non-tabular format. C) The relational data model is a way to structure data using tables (relations) with rows and columns, where each table represents an entity and relationships are defined through foreign keys. D) A model that uses only hierarchical structures for data storage. Show Answer Correct Answer: C) The relational data model is a way to structure data using tables (relations) with rows and columns, where each table represents an entity and relationships are defined through foreign keys. 50. What is typically produced during the analysis phase of SDLC? A) ER models. B) System blueprints. C) Code for the test system. D) None of the above. Show Answer Correct Answer: A) ER models. 51. Discuss the concept of data redundancy and how it can be minimized in database design. A) Normalizing the database. B) Denormalizing the database. C) Adding more redundant data. D) Ignoring data redundancy. Show Answer Correct Answer: A) Normalizing the database. 52. Why is assigning the correct data type to a field important? A) It makes the form colorful. B) It determines how data can be stored and processed. C) It shortens the query length. D) It prints the report faster. Show Answer Correct Answer: B) It determines how data can be stored and processed. 53. What is the significance of normalisation in databases? A) It increases redundancy. B) It complicates data retrieval. C) It is not necessary. D) It improves data integrity. Show Answer Correct Answer: D) It improves data integrity. 54. What type of database model organizes data in tables with rows and columns? A) Network. B) Relational. C) Object-Oriented. D) Hierarchical. Show Answer Correct Answer: B) Relational. 55. How do you use the BETWEEN keyword in SQL? Example:SELECT * FROM Orders WHERE OrderDate BETWEEN '2021-01-01' AND '2021-12-31'; A) To delete records from a table. B) To sort records in ascending order. C) To join two tables. D) To filter records within a range of values. Show Answer Correct Answer: D) To filter records within a range of values. 56. A graphical representation of a database and the relationships between the entities. A) Object-oriented model. B) Relational model. C) Entity-relationship (E-R) model. D) Hierarchical model. Show Answer Correct Answer: C) Entity-relationship (E-R) model. 57. In a client-server architecture, where is the DBMS typically located? A) Client-side. B) Server-side. C) Middle layer. D) Cloud platform. Show Answer Correct Answer: B) Server-side. 58. How do you create a new table in Access? A) Select 'File', then 'New', and choose 'Table'. B) Open Access, go to 'Home' tab, click 'New Document'. C) Open Access, go to 'Create' tab, click 'Table'. D) Right-click on the database and select 'Add Table'. Show Answer Correct Answer: C) Open Access, go to 'Create' tab, click 'Table'. 59. Tabel 'detail ..... jual' memiliki 'id ..... nota' dan 'id ..... barang' sebagai kunci utama. Ini menunjukkan bahwa tabel ini menggunakan konsep ..... A) Unique Index. B) Single Primary Key. C) Foreign Key. D) Composite Primary Key. Show Answer Correct Answer: D) Composite Primary Key. 60. What is data mining and how is it related to databases? A) Data mining is solely about data storage techniques. B) Data mining is the process of discovering patterns from large datasets, and it relies on databases to store and retrieve the data for analysis. C) Data mining is a method for creating databases from scratch. D) Data mining focuses only on data visualization tools. Show Answer Correct Answer: B) Data mining is the process of discovering patterns from large datasets, and it relies on databases to store and retrieve the data for analysis. ← 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