This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 66 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 66 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the full form of ACID in databases? A) Atomicity, Consistency, Isolation, Durability. B) Atomicity, Confidentiality, Integrity, Durability. C) Access, Control, Integrity, Data. D) Application, Configuration, Isolation, Database. Show Answer Correct Answer: A) Atomicity, Consistency, Isolation, Durability. 2. Perintah ini digunakan untuk menampilkan seluruh isi table adalah ..... A) Desc table;. B) Show tables;. C) Select tables;. D) Select * from table name;. E) Select isi tables;. Show Answer Correct Answer: D) Select * from table name;. 3. Which join returns all rows when there is a match in either table? A) INNER JOIN. B) LEFT JOIN. C) FULL OUTER JOIN. D) CROSS JOIN. Show Answer Correct Answer: C) FULL OUTER JOIN. 4. What term is used to describe the process of organizing data into tables to minimize redundancy and dependency? A) Normalization. B) Denormalization. C) Abstraction. D) Concatenation. Show Answer Correct Answer: A) Normalization. 5. DBMS IS A ..... A) HARDWARE. B) SOFTWARE. C) FREEWARE. D) FIRMWARE. Show Answer Correct Answer: B) SOFTWARE. 6. What is the file extension for databases created in MS Access 2007? A) .mdb. B) .accdb. C) .xlsx. D) .docx. Show Answer Correct Answer: B) .accdb. 7. Which data type can store date and time values with precision up to milliseconds and microseconds? A) AutoNumber. B) Currency. C) Date/Time Extended. D) Date/Time. Show Answer Correct Answer: C) Date/Time Extended. 8. Why is it incorrect to have two identical records when a key field is used? A) It increases file size. B) It can cause printing errors. C) It violates the rule of uniqueness. D) It helps in sorting data. Show Answer Correct Answer: C) It violates the rule of uniqueness. 9. If you were to organize a large collection of documents, which database component would be most similar to the file folders that group related documents together? A) Tables. B) Records. C) Fields. D) Database. Show Answer Correct Answer: B) Records. 10. Flat-file Structure A) A database structure that stores data in a single table or file. B) A complex database structure with multiple tables. C) A type of database that uses hierarchical data models. D) A database structure that stores data in a cloud environment. Show Answer Correct Answer: A) A database structure that stores data in a single table or file. 11. Which of the following is an example of a secondary key in a database? A) A customer's name. B) An order's date. C) A product's name. D) A student's last name. Show Answer Correct Answer: D) A student's last name. 12. Which data structure holds all information relevant to a specific entity in a database? A) Table. B) Field. C) Record. D) Form. Show Answer Correct Answer: C) Record. 13. What is an entity in a database context? A) An entity is a type of database query. B) An entity is a programming language used in databases. C) An entity is a real-world object or concept in a database. D) An entity is a collection of database records. Show Answer Correct Answer: C) An entity is a real-world object or concept in a database. 14. How do databases improve healthcare? A) By performing surgeries. B) By diagnosing diseases. C) By allowing quick access to patient information. D) By cleaning hospital rooms. Show Answer Correct Answer: C) By allowing quick access to patient information. 15. Which structure is best suited for real-time GPS navigation systems using unstructured data? A) Hierarchical. B) Relational. C) NoSQL. D) Flat file. Show Answer Correct Answer: C) NoSQL. 16. What is the purpose of indexing in a database? A) To speed up data retrieval. B) To normalize tables. C) To delete duplicate records. D) To encrypt database contents. Show Answer Correct Answer: A) To speed up data retrieval. 17. A row is a collection of data under different column headings, also called as A) Relation. B) Tuple. C) Record. D) Both record and tuple. Show Answer Correct Answer: D) Both record and tuple. 18. In a database context, what is a table most similar to? A) A book. B) A spreadsheet. C) A photo album. D) A video. Show Answer Correct Answer: B) A spreadsheet. 19. What type of end users maintain personal databases using ready-made software packages? A) Casual End Users. B) Sophisticated End Users. C) Naive End Users. D) Stand-alone Users. Show Answer Correct Answer: D) Stand-alone Users. 20. In MS Access, which view allows you to modify the structure and layout of a form? A) Datasheet View. B) Query View. C) Design View. D) Print View. Show Answer Correct Answer: C) Design View. 21. Which query type can prompt for criteria each time it is run? A) Parameter Queries. B) Delete Queries. C) Make Table Queries. D) Appended Queries. Show Answer Correct Answer: A) Parameter Queries. 22. Evolution of data models aims to improve ..... A) Data redundancy. B) Data independence. C) File size. D) Hardware cost. Show Answer Correct Answer: B) Data independence. 23. Dalam diagram use case, include digunakan untuk: A) Menunjukkan hubungan antara aktor. B) Menjelaskan proses utama. C) Menunjukkan bahwa sebuah use case selalu memanggil use case lain. D) Menunjukkan opsi tambahan. E) Menunjukkan entitas yang terlibat dalam use case. Show Answer Correct Answer: C) Menunjukkan bahwa sebuah use case selalu memanggil use case lain. 24. Which of these best describes a schema? A) A specific data entry in a column. B) The current data inside a table. C) The design of a table like (ID INT, Name VARCHAR(50)). D) A domain of names. Show Answer Correct Answer: C) The design of a table like (ID INT, Name VARCHAR(50)). 25. Course(course ..... id, sec ..... id, semester)Here the course ..... id, sec ..... id and semester are ..... and course is a ..... A) Relations, Attribute. B) Attributes, Relation. C) Tuple, Relation. D) Tuple, Relation. Show Answer Correct Answer: B) Attributes, Relation. ← 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