This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 62 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 62 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the most detailed type of data model? A) Logical Data Model. B) Physical Data Model. C) Conceptual Data Model. D) Abstract Data Model. Show Answer Correct Answer: B) Physical Data Model. 2. A relational operator that allows for the combination of information from two or more tables is known as the ..... operator. A) SELECT. B) PROJECT. C) JOIN. D) DIFFERENCE. Show Answer Correct Answer: C) JOIN. 3. In a table storing student data, the "Roll Number" column represents an: A) Attribute. B) Relation. C) Tuple. D) Schema. Show Answer Correct Answer: A) Attribute. 4. What is a stored procedure and how does it differ from a function? A) A stored procedure is a set of SQL statements executed as a unit, while a function returns a value and is used for calculations. B) A stored procedure is a type of database that stores data permanently. C) A function is a set of SQL statements that cannot return a value. D) A stored procedure is only used for data retrieval, while a function is for data manipulation. Show Answer Correct Answer: A) A stored procedure is a set of SQL statements executed as a unit, while a function returns a value and is used for calculations. 5. Which command is used to remove all records from a table? A) DELETE. B) DROP. C) TRUNCATE. D) REMOVE. Show Answer Correct Answer: C) TRUNCATE. 6. Suggest a free software for managing the database A) Oracle. B) MySQL. C) Sybase. D) Microsoft SQL Server. Show Answer Correct Answer: B) MySQL. 7. External level provides ..... A) Complete database view. B) Storage paths. C) User-specific views. D) File formats. Show Answer Correct Answer: C) User-specific views. 8. Why should a 'Telephone Number' be stored as an alphanumeric (text) field rather than a numeric field in a database like Microsoft Access? A) Numeric fields cannot store more than three digits. B) Telephone numbers are not used for mathematical calculations. C) Alphanumeric fields automatically format numbers with dashes. D) Numeric fields use significantly more storage space than text fields. Show Answer Correct Answer: B) Telephone numbers are not used for mathematical calculations. 9. Which of these is NOT a common use of databases in business? A) Managing customer information. B) Tracking inventory. C) Keeping financial records. D) Writing marketing slogans. Show Answer Correct Answer: D) Writing marketing slogans. 10. Apa yang dimaksud dengan atribut dalam ERD? A) Nama entitas. B) Properti atau karakteristik dari sebuah entitas. C) Hubungan antara entitas. D) Kunci utama dari sebuah entitas. E) Tabel dalam sebuah database. Show Answer Correct Answer: B) Properti atau karakteristik dari sebuah entitas. 11. What is a stored procedure in a database and how is it used? A) A stored procedure is a type of computer virus used to corrupt databases. B) A stored procedure is a method for organizing files in a computer system. C) A stored procedure is a tool for creating animations in database design. D) A stored procedure is a set of SQL statements that can be stored and executed on the database server, providing better performance and security. Show Answer Correct Answer: D) A stored procedure is a set of SQL statements that can be stored and executed on the database server, providing better performance and security. 12. Which of the following is an advantage of a relational database over a file-based system? A) Reduced data duplication through normalization. B) More data redundancy. C) Slower data retrieval. D) No relationships between data. Show Answer Correct Answer: A) Reduced data duplication through normalization. 13. What language does the Relational Model use? A) Java. B) Python. C) SQL. D) C++. Show Answer Correct Answer: C) SQL. 14. The attribute AGE is calculated from DATE ..... OF ..... BIRTH. The attribute AGE is: A) Single valued. B) Multi valued. C) Composite. D) Derived. Show Answer Correct Answer: D) Derived. 15. Which deadlock prevention scheme is based on transaction age? A) Wait-die. B) Wound-wait. C) Both a & b. D) Timeout. Show Answer Correct Answer: C) Both a & b. 16. What is the primary purpose of the COMMIT command in SQL? A) To display transaction results. B) To save changes made during a transaction. C) To undo changes made during a transaction. D) To create a new transaction. Show Answer Correct Answer: B) To save changes made during a transaction. 17. What data type is used to store large amounts of alphanumeric data, such as detailed product descriptions? A) Long Text. B) Text. C) Date/Time. D) Number. Show Answer Correct Answer: A) Long Text. 18. What are fields in a database also known as? A) Rows. B) Records. C) Columns. D) Tuples. Show Answer Correct Answer: C) Columns. 19. OLAP enables ..... A) Users to quickly obtain online answers to ad-hoc questions even when the data are stored in very large databases. B) Users to view both logical and physical views of data. C) Programmers to quickly diagram data relationships. D) Programmers to normalize data. Show Answer Correct Answer: A) Users to quickly obtain online answers to ad-hoc questions even when the data are stored in very large databases. 20. Which feature in MS Access helps you create a form automatically? A) Query Wizard. B) Table Wizard. C) Form Wizard. D) Report Wizard. Show Answer Correct Answer: C) Form Wizard. 21. .... is formatted data, which allows being utilized in a significant way. A) Data. B) Information. C) Database. D) None of these. Show Answer Correct Answer: B) Information. 22. If a table is in 1NF and every non-key attribute is fully functionally dependent on the primary key, but some attributes are transitively dependent on the primary key, which normal form is the table in? A) 1NF. B) 2NF. C) 3NF. D) BCNF. Show Answer Correct Answer: C) 3NF. 23. The SQL operator that is used where an exact match is not necessary is A) %. B) LIKE. C) BETWEEN. D) ANY. Show Answer Correct Answer: B) LIKE. 24. What is a primary key in a relational database? A) An attribute that is optional in a table. B) An attribute that refers to another table. C) An attribute that can have duplicate values. D) An attribute that uniquely identifies each tuple. Show Answer Correct Answer: D) An attribute that uniquely identifies each tuple. 25. It can be structured as a collection of records, where each record is made up of fields containing data about the same 'thing'. A) File. B) Database. C) Table. D) Spreadsheet. Show Answer Correct Answer: A) File. ← 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