This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 46 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 46 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a "primary key" in a database table? A) A unique identifier for each record in the table. B) A field that allows duplicate values. C) A field that cannot contain NULL values. D) A field used for sorting data. Show Answer Correct Answer: A) A unique identifier for each record in the table. 2. Which of the following is a characteristic of object-oriented database structures? A) Stores data only in rows and columns. B) Uses classes and objects similar to programming languages. C) Does not support inheritance. D) Does not store methods with data. Show Answer Correct Answer: B) Uses classes and objects similar to programming languages. 3. What type of data can be stored in a database? A) Images and videos. B) Unstructured data. C) Structured data. D) Audio files. Show Answer Correct Answer: C) Structured data. 4. 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. 5. Which property ensures that transactions do not interfere with each other? A) Isolation. B) Consistency. C) Atomicity. D) Durability. Show Answer Correct Answer: A) Isolation. 6. 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. 7. What does the 'A' in ACID stand for? A) Availability. B) Atomicity. C) Accuracy. D) Authorization. Show Answer Correct Answer: B) Atomicity. 8. 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) Record. B) Field. C) Table. D) Data. Show Answer Correct Answer: A) Record. 9. 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. 10. Apa fungsi dari kunci primer dalam tabel basis data? A) Menunjukkan hubungan antara tabel. B) Identifikasi unik setiap baris. C) Mempercepat pengambilan data. D) Menghubungkan tabel dengan file eksternal. E) Memvalidasi data masukan. Show Answer Correct Answer: B) Identifikasi unik setiap baris. 11. Which data manipulation command is used to combines the records from one or more tables? A) SELECT. B) PROJECT. C) JOIN. D) PRODUCT. Show Answer Correct Answer: C) JOIN. 12. 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. 13. Each column represents a ..... A) Relation. B) Attribute. C) Record. D) Field. Show Answer Correct Answer: B) Attribute. 14. 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) Student ID. C) Favorite color. D) BirthdateTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: B) Student ID. 15. What is the first step in the ETL process? A) Load. B) Transform. C) Extract. D) Analyze. Show Answer Correct Answer: C) Extract. 16. The logical level describes ..... A) User views. B) Storage details. C) Database structure. D) Hardware details. Show Answer Correct Answer: C) Database structure. 17. 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 Sharing. B) Data Redundancy. C) Data Integrity. D) Data Normalization. Show Answer Correct Answer: B) Data Redundancy. 18. What data type is used to store https://www.kdnuggets.com/2016/07/database-key-terms-explained.html to websites? A) Hyperlink. B) Calculated. C) OLE Object. D) Attachment. Show Answer Correct Answer: A) Hyperlink. 19. 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;. 20. 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. 21. 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, );. 22. 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. 23. 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. 24. Which component of SQL is used to create, alter and drop tables, views and indexes? A) Data Control Language. B) Data Definition Language. C) Data Manipulation Language. D) Embedded SQL. Show Answer Correct Answer: B) Data Definition Language. 25. 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. ← PreviousNext →Related 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 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books