This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 4 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 4 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Apa yang dimaksud dengan kunci asing? A) Kunci yang digunakan untuk enkripsi data. B) Kunci yang menunjukkan hubungan antara tabel. C) Kunci yang berfungsi sebagai indeks data. D) Kunci yang digunakan dalam tampilan. E) Kunci utama di setiap tabel. Show Answer Correct Answer: B) Kunci yang menunjukkan hubungan antara tabel. 2. What type of data does the 'Currency' data type store? A) Date and time data. B) Monetary data. C) Boolean data. D) Text data. Show Answer Correct Answer: B) Monetary data. 3. Which event typically *triggers* embedded SQL execution in a VB.NET or Java program? A) When the database compiles the code. B) When a user closes the application. C) When a user interacts with a GUI (e.g., clicks a button). D) When the Oracle server restarts. Show Answer Correct Answer: C) When a user interacts with a GUI (e.g., clicks a button). 4. Determine the error in the below SELECT statement SELECT ename, deptno, sal FROM emp WHERE job=CLERK; A) WHERE clause cannot refer the column JOB since it doesn't appear in the SELECT column list. B) Character literal CLERK must be enclosed within single quotes. C) Character literal CLERK must be enclosed within parentheses. D) No error in the query. Show Answer Correct Answer: B) Character literal CLERK must be enclosed within single quotes. 5. In what year was the introduction of object orientation in relational DBMS? A) 1991. B) 1990. C) 1976. D) 1997. E) 1992. Show Answer Correct Answer: B) 1990. 6. Which integrity type ensures a primary key is never NULL? A) Referential Integrity. B) Domain Integrity. C) Entity Integrity. D) Logical Integrity. Show Answer Correct Answer: C) Entity Integrity. 7. A natural business association that exists between one or more entities is a A) Relationship. B) An associative entity. C) Cardinality. D) Domain. Show Answer Correct Answer: A) Relationship. 8. In a database, what are tables used for? A) To store unrelated data. B) To store related data in rows and columns1. C) To create charts and graphs. D) To store pictures and videos. Show Answer Correct Answer: B) To store related data in rows and columns1. 9. What does it mean if a database table has 30 records and 5 fields? A) 30 columns and 5 rows. B) 30 rows and 5 columns. C) 150 separate databases. D) 5 ASCII codes per record. Show Answer Correct Answer: B) 30 rows and 5 columns. 10. Which of the following symbols is NOT used in a Chen Notation ERD? A) Rectangle. B) Oval. C) Diamond. D) Circle. Show Answer Correct Answer: D) Circle. 11. What is the purpose of a foreign key in a relational database? A) A foreign key is optional and has no impact on data relationships. B) A foreign key is used to uniquely identify a record in a table. C) A foreign key establishes a relationship between two tables by referencing the primary key of another table. D) A foreign key is used to store large binary files. Show Answer Correct Answer: C) A foreign key establishes a relationship between two tables by referencing the primary key of another table. 12. What is a database? A) A database is a physical storage device for computer files. B) A database is a programming language for data analysis. C) A database is an organized collection of data that can be easily accessed, managed, and updated. D) A database is a type of software used for web development. Show Answer Correct Answer: C) A database is an organized collection of data that can be easily accessed, managed, and updated. 13. What process is used to break a many-to-many relationship apart in a relational database? A) Aggregation. B) Optimization. C) Validation. D) Normalization. Show Answer Correct Answer: D) Normalization. 14. What is the first normal form (1NF) in database normalisation? A) A table with no repeating groups or arrays. B) A table with a single primary key. C) A table with all foreign keys removed. D) A table with all data stored in a single column. Show Answer Correct Answer: A) A table with no repeating groups or arrays. 15. Which statement about records and fields is TRUE? A) A record is a column, and a field is a row. B) A field contains one type of data, while a record contains all data about one item. C) Records are stored inside ASCII codes. D) Fields are only used in Excel, not in databases. Show Answer Correct Answer: B) A field contains one type of data, while a record contains all data about one item. 16. In the three-schema architecture, which level describes how data is actually stored in memory? A) Conceptual Level. B) Internal Level. C) External Level. D) Logical Level. Show Answer Correct Answer: B) Internal Level. 17. Which of the following is NOT a valid candidate key in a database? A) A customer's name. B) A product's name. C) A student's last name. D) An order's date. Show Answer Correct Answer: A) A customer's name. 18. Which of the following is a disadvantage of a flat file database? A) Easy to implement. B) Redundancy of data. C) No data editing issues. D) Simple structure. Show Answer Correct Answer: B) Redundancy of data. 19. What does the term 'cardinality' refer to in a relational database? A) The relationship between tables. B) The uniqueness of data values. C) The number of rows in a table. D) The number of attributes in a relation. Show Answer Correct Answer: C) The number of rows in a table. 20. Indicate whether the statement is true or false:Data scrubbing is a more intensive corrective process than data cleansing. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 21. A property of a database that does not contain any values of a foreign key that are not matched to the corresponding primary key. A) Referential integrity. B) Data integrity. C) Entity integrity. D) Domain integrity. Show Answer Correct Answer: A) Referential integrity. 22. What data type is used to store a value from another table? A) Attachment. B) Lookup. C) OLE Object. D) Calculated. Show Answer Correct Answer: B) Lookup. 23. Section A:True or False (5 marks)-Write True or False beside each statement. A record is a single piece of data such as a student's first name. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 24. WHAT IS META DATA A) DATA DESCRIBING TABLE. B) DATA DESCRIBING ABOUT DATA. C) DATA DESCRIBING ABOUT FILE. D) DATA DESCRIBING ABOUT INFORMATION. Show Answer Correct Answer: B) DATA DESCRIBING ABOUT DATA. 25. Which of the following is an example of a data update operation? A) SELECT * FROM students;. B) INSERT INTO students VALUES (1, 'Ali');. C) SELECT name FROM students WHERE grade = 10;. D) SELECT COUNT(*) FROM products;. Show Answer Correct Answer: B) INSERT INTO students VALUES (1, 'Ali');. ← 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 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 10Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books