This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 19 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 19 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a relationship in a database? A) A relationship in a database is a connection or association between two or more tables based on common fields. B) A relationship in a database is a connection between a table and a document. C) A relationship in a database is a connection between a table and a spreadsheet. D) A relationship in a database is a connection between a table and a graph. Show Answer Correct Answer: A) A relationship in a database is a connection or association between two or more tables based on common fields. 2. Which property ensures that transactions do not interfere with each other? A) Isolation. B) Consistency. C) Durability. D) Atomicity. Show Answer Correct Answer: A) Isolation. 3. What is the significance of a candidate key in a database? A) A candidate key uniquely identifies records in a database and ensures data integrity. B) A candidate key is a type of foreign key in a database. C) A candidate key is used to group similar records together. D) A candidate key can be duplicated across records in a database. Show Answer Correct Answer: A) A candidate key uniquely identifies records in a database and ensures data integrity. 4. What does the 'A' in ACID stand for? A) Atomicity. B) Availability. C) Authorization. D) Accuracy. Show Answer Correct Answer: A) Atomicity. 5. Section D:Fill in the Blanks (5 marks)-Write the correct word or term in each blank space. Each row in a table is called a ..... A) Data. B) Record. C) Table. D) Field. Show Answer Correct Answer: B) Record. 6. Section C:Matching (5 marks)-Match Column A with the correct description in Column B. Select the correct description for Database. A) A single category of data such as "Name" or "Gender". B) A collection of related data organized for easy access. C) A complete set of information about one person or item. D) Rows and columns where data is stored in a database. E) Raw facts or figures that have not been processed. Show Answer Correct Answer: B) A collection of related data organized for easy access. 7. Apa fungsi dari kunci primer dalam tabel basis data? A) Identifikasi unik setiap baris. B) Memvalidasi data masukan. C) Mempercepat pengambilan data. D) Menghubungkan tabel dengan file eksternal. E) Menunjukkan hubungan antara tabel. Show Answer Correct Answer: A) Identifikasi unik setiap baris. 8. Which data manipulation command is used to combines the records from one or more tables? A) JOIN. B) PROJECT. C) SELECT. D) PRODUCT. Show Answer Correct Answer: A) JOIN. 9. What does a lookup field do in a database? A) Displays a drop-down list of predefined values. B) Sorts records alphabetically. C) Deletes duplicate values. D) Converts text into numbers. Show Answer Correct Answer: A) Displays a drop-down list of predefined values. 10. Each column represents a ..... A) Attribute. B) Field. C) Relation. D) Record. Show Answer Correct Answer: A) Attribute. 11. You need to choose a key field for a database of students. Which of the following would be the best choice? A) First name. B) Favorite color. C) Student ID. D) BirthdateTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: C) Student ID. 12. The logical level describes ..... A) Storage details. B) Hardware details. C) User views. D) Database structure. Show Answer Correct Answer: D) Database structure. 13. When the same student's name appears in both the class teacher's and the office's register, it is an example of: A) Data Normalization. B) Data Redundancy. C) Data Integrity. D) Data Sharing. Show Answer Correct Answer: B) Data Redundancy. 14. What data type is used to store https://www.kdnuggets.com/2016/07/database-key-terms-explained.html to websites? A) Calculated. B) OLE Object. C) Attachment. D) Hyperlink. Show Answer Correct Answer: D) Hyperlink. 15. How do you select all columns from a table named "Employees" ? A) SELECT * FROM Employees;. B) SELECT all FROM Employees;. C) SELECT columns FROM Employees;. D) SELECT * FROM table Employees;. Show Answer Correct Answer: A) SELECT * FROM Employees;. 16. True or False:The "entity identifier" aka "key attribute" allows distinguishing between different instances of a relational database? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 17. How do you create a table in a database? A) Use the SQL command:CREATE TABLE table name (column1 datatype, column2 datatype, );. B) Use the command:ADD TABLE table name;. C) Define a table with:MAKE TABLE table name;. D) Create a table by using:INSERT INTO table name;. Show Answer Correct Answer: A) Use the SQL command:CREATE TABLE table name (column1 datatype, column2 datatype, );. 18. Which of the following uniquely identifies a row in a table? A) Primary key. B) Alternate key. C) Foreign key. D) Candidate key. Show Answer Correct Answer: A) Primary key. 19. What is the purpose of formatting data as a table in Excel? A) To make it more polished. B) To make data clear to read and analyze. C) To change data into text. D) To remove information. Show Answer Correct Answer: B) To make data clear to read and analyze. 20. Which component of SQL is used to create, alter and drop tables, views and indexes? A) Data Control Language. B) Embedded SQL. C) Data Manipulation Language. D) Data Definition Language. Show Answer Correct Answer: D) Data Definition Language. 21. What does a form in a database typically provide? A) A simplified interface for entering, modifying, and viewing database records. B) A collection of data that stores information. C) Common options placed together such as Views, Properties, and Formatting. D) A row that consists of several fields related to one item. Show Answer Correct Answer: A) A simplified interface for entering, modifying, and viewing database records. 22. An instance of an entity, represented by a row in a table. A) Column. B) Field. C) Row. D) Tuple. Show Answer Correct Answer: D) Tuple. 23. What does the term "composite key" refer to in a database? A) A key made up of multiple attributes. B) A key that uniquely identifies each record. C) A key used for encryption. D) A key used to establish relationships between tables. Show Answer Correct Answer: A) A key made up of multiple attributes. 24. What does scalability in a database mean? A) The ability to store physical items. B) The process of adding more physical hard drives for data storage. C) The ability to handle a large amount of data efficiently. D) The ability to access social media. Show Answer Correct Answer: C) The ability to handle a large amount of data efficiently. 25. What are the ACID properties in database transactions? A) Atomicity, Clarity, Isolation, Reliability. B) Atomicity, Consistency, Isolation, Accessibility. C) ACID properties:Atomicity, Consistency, Isolation, Durability. D) Accuracy, Clarity, Integrity, Timeliness. Show Answer Correct Answer: C) ACID properties:Atomicity, Consistency, Isolation, Durability. 26. A ..... is a feature of a database using which we can enter data in a table in an easy and user friendly manner. A) Field. B) Form. C) Query. D) Report. Show Answer Correct Answer: B) Form. 27. How do fields relate to records in a database? A) Fields are only used for indexing in a database. B) Fields are the same as records in a database. C) Records are collections of fields in a database. D) Fields are the attributes of a record in a database. Show Answer Correct Answer: D) Fields are the attributes of a record in a database. 28. What is the main goal of database administration? A) Managing and optimizing database systems to ensure data availability and performance. B) Hosting data-oriented applications. C) Designing database management systems to efficiently handle large datasets. D) None of the above. Show Answer Correct Answer: A) Managing and optimizing database systems to ensure data availability and performance. 29. Tuple is another name for A) Row. B) Records. C) Columns. D) Both B & C. Show Answer Correct Answer: B) Records. 30. Data mining allows users to ..... A) Quickly compare transaction data gathered over many years. B) Find hidden patterns and relationships in large databases. C) Obtain online answers to ad-hoc questions in a rapid amount of time. D) Summarize massive amounts of data into much smaller, traditional reports. Show Answer Correct Answer: B) Find hidden patterns and relationships in large databases. 31. What is the primary function of the DELETE statement in SQL? A) To retrieve data from a table. B) To update records in a table. C) To create a new table. D) To remove records from a table. Show Answer Correct Answer: D) To remove records from a table. 32. A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with ..... A) A crow's foot. B) Two short marks. C) A crow's foot topped by a short mark. D) Three short marks. Show Answer Correct Answer: A) A crow's foot. 33. Which MS Access feature is used to extract specific information from a database? A) Form. B) Query. C) Report. D) Relationship. Show Answer Correct Answer: B) Query. 34. Which DBLC phase includes performance tuning? A) Maintenance. B) Evaluation. C) Implementation. D) Design. Show Answer Correct Answer: A) Maintenance. 35. Which level of abstraction describes how data is physically stored? A) External level. B) Physical level. C) Logical level. D) Conceptual level. Show Answer Correct Answer: B) Physical level. 36. A record is represented by what in a database? A) Column. B) Cell. C) Table. D) Row. Show Answer Correct Answer: D) Row. 37. Data can be in the form of numbers, letters, symbols and sounds. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 38. How can structured query language be used to manipulate data in databases? A) By using commands such as SEARCH, APPEND, MODIFY, and CLEAR to manipulate data. B) By using commands such as PRINT, ADD, CHANGE, and ERASE to manipulate data. C) By using commands such as SELECT, INSERT, UPDATE, and DELETE to retrieve, add, modify, and remove data from the database. D) By using commands such as COPY, PASTE, CUT, and RENAME to manipulate data. Show Answer Correct Answer: C) By using commands such as SELECT, INSERT, UPDATE, and DELETE to retrieve, add, modify, and remove data from the database. 39. Which of the following is NOT a primary responsibility of a Database Administrator? A) Database design and implementation. B) Performance management. C) Security administration. D) Writing application programs. Show Answer Correct Answer: D) Writing application programs. 40. Why would you create a primary key? A) To make each record in a database unique. B) To make each field in a database unique. C) To make each query in a database unique. D) None of the above. Show Answer Correct Answer: A) To make each record in a database unique. 41. What is the purpose of data abstraction in a database system? A) To display all data to the user. B) To improve hardware speed. C) To hide complex details of data storage from the user. D) To encrypt user passwords. Show Answer Correct Answer: C) To hide complex details of data storage from the user. 42. Which of the following describes a SQL "Join" ? A) A primary key in a relational database. B) A key used to identify data in different tables. C) A rule that defines relationships between databases. D) A query that combines rows from two or more tables based on related columns. Show Answer Correct Answer: D) A query that combines rows from two or more tables based on related columns. 43. What is a relational database a collection of? A) Tables. B) Fields. C) Keys. D) Records. Show Answer Correct Answer: A) Tables. 44. What is the best definition for table A) Single type of data within the table. B) The core structure in a relational database. C) Represent a single, specific record in the table. D) None of the above. Show Answer Correct Answer: B) The core structure in a relational database. 45. What is the 'Not Null' constraint used for? A) To enforce unique values. B) To ensure a field always has a value. C) To allow duplicate values. D) None of the above. Show Answer Correct Answer: B) To ensure a field always has a value. 46. Which database approach characteristic allows the same DBMS software to work with any database? A) Multiple views. B) Data sharing. C) Self-describing nature. D) Program-data independence. Show Answer Correct Answer: C) Self-describing nature. 47. What is an example of a database management system? A) Adobe Photoshop. B) Microsoft Word. C) Windows OS. D) MySQL. Show Answer Correct Answer: D) MySQL. 48. Indicate whether the statement is true or false:The term data governance encompasses policies and procedures through which data can be managed as an organizational resource. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 49. What SQL command is used to create a new table? A) MODIFY TABLE. B) CREATE TABLE. C) ADD TABLE. D) INSERT TABLE. Show Answer Correct Answer: B) CREATE TABLE. 50. What is the difference between the "Execute Statement" and "Execute Script" icons in SQL Developer? A) Execute Statement runs multiple lines; Execute Script only one. B) Execute Script runs all statements or highlighted ones; Execute Statement runs the line with the cursor. C) Both are used to run scripts with the same functionality. D) Only Execute Script can run anonymous blocks. Show Answer Correct Answer: B) Execute Script runs all statements or highlighted ones; Execute Statement runs the line with the cursor. 51. What is a candidate key in a database? A) A field that contains a foreign key. B) A key that is used to encrypt data. C) A field that can be used as a primary key. D) A key that is used to link two tables. Show Answer Correct Answer: C) A field that can be used as a primary key. 52. Which DML command is used to add new records to a table? A) DELETE. B) SELECT. C) INSERT. D) UPDATE. Show Answer Correct Answer: C) INSERT. 53. In a table there can be many candidate keys. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 54. Which of the following is NOT one of the ACID properties? A) Atomicity. B) Simplicity. C) Isolation. D) Durability. Show Answer Correct Answer: B) Simplicity. 55. Why are databases better for concurrent use compared to spreadsheets? A) Spreadsheets are only for single users. B) Spreadsheets cannot store words. C) Databases are cheaper. D) Databases allow many users to access data simultaneously. Show Answer Correct Answer: D) Databases allow many users to access data simultaneously. 56. What is the purpose of a transaction in a database? A) To create new data. B) To read and write data. C) To store data. D) To delete data. Show Answer Correct Answer: B) To read and write data. 57. What is an aggregate function in a query? A) A function that performs calculations on a group of values. B) A function that deletes duplicate records. C) A function that creates new tables. D) A function that sorts data automatically. Show Answer Correct Answer: A) A function that performs calculations on a group of values. 58. What is the cardinality of a relationship? A) The minimum number of relationships. B) The maximum number of relationships. C) The degree of the relationship. D) None of the above. Show Answer Correct Answer: B) The maximum number of relationships. 59. Which of the following is part of a three-level database architecture? A) Logical Level. B) Physical Level. C) View Level. D) All of the above. Show Answer Correct Answer: D) All of the above. 60. What is the main challenge of data volume in database management? A) Databases must scale appropriately as data grows. B) Data must be stored in a single location. C) Data can be ignored if it is too large. D) Data quality is always guaranteed. Show Answer Correct Answer: A) Databases must scale appropriately as data grows. ← 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