This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 28 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 28 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A database where the data items are linked by internal pointers. A) Hierarchical database. B) Relational database. C) Flat file database. D) Object-oriented database. Show Answer Correct Answer: B) Relational database. 2. What is the purpose of a NOT NULL constraint in a database? A) To allow fields to be left blank. B) To ensure a value must be entered into a field. C) To prevent duplicate records. D) To format data automatically. Show Answer Correct Answer: B) To ensure a value must be entered into a field. 3. A data structure built from one or more columns in a database table to speed up searching for data. A) View (database). B) Schema (database). C) Table (database). D) Index (database). Show Answer Correct Answer: D) Index (database). 4. Which operator is used for pattern matching in PostgreSQL? A) MATCHES. B) PATTERN. C) CONTAINS. D) LIKE. Show Answer Correct Answer: D) LIKE. 5. Which statement about tables in MS Access is correct? A) Tables are the fundamental building blocks of a database. B) Tables cannot be related to each other. C) Tables can only contain text data. D) Tables can only have 10 fields maximum. Show Answer Correct Answer: A) Tables are the fundamental building blocks of a database. 6. An ad hoc query is a ..... A) Pre-planned question. B) Question that will not return any results. C) Spur-of-the-moment question. D) Pre-scheduled question. Show Answer Correct Answer: C) Spur-of-the-moment question. 7. A database table has a field called "Grade" set as Number. Which of these values would cause an error? A) 95. B) 67. C) A+. D) 100. Show Answer Correct Answer: C) A+. 8. Which of the following is not a step in creating a file in MS Access? A) Formatting text in bold. B) Clicking the "Create" button. C) Opening the software. D) Entering data into fields. Show Answer Correct Answer: A) Formatting text in bold. 9. What are the three design levels of data modeling? A) Conceptual, Logical, Physical. B) Design, Implementation, Delivery. C) Input, Processing, Output. D) None of the above. Show Answer Correct Answer: A) Conceptual, Logical, Physical. 10. Which of the following operation is used if we are interested in only certain columns of a table? A) JOIN. B) PROJECTION. C) UNION. D) SELECTION. Show Answer Correct Answer: B) PROJECTION. 11. What is the purpose of data integrity in databases? A) To ensure accuracy and consistency of data. B) To simplify data storage. C) To increase data redundancy. D) To eliminate the need for keys. Show Answer Correct Answer: A) To ensure accuracy and consistency of data. 12. What is the default port number for PostgreSQL? A) 3306. B) 1433. C) 5432. D) 1521. Show Answer Correct Answer: C) 5432. 13. What is the purpose of a business database? A) To store and manage customer and product information. B) To create video games. C) To perform calculations. D) To write stories. Show Answer Correct Answer: A) To store and manage customer and product information. 14. List the four main types of SQL commands. A) SQL, DQL, DML, DCL. B) DQL, DDL, RML, DCL. C) DQL, DDL, DML, DCL. D) DML, DCL, DDL, RCL. Show Answer Correct Answer: C) DQL, DDL, DML, DCL. 15. With reduced redundancy ..... automatically increases. A) Duplication. B) Consistency. C) AutoNumber. D) Characters. Show Answer Correct Answer: B) Consistency. 16. Which of the following is NOT a type of database model? A) Graphical Model. B) Relational Model. C) Hierarchical Model. D) Network Model. Show Answer Correct Answer: A) Graphical Model. 17. All candidate keys are primary keys. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 18. To check for a value outside of a range, you can use A) NOT RANGE operator. B) NOT LIKE operator. C) NOT BETWEEN operator. D) None of these. Show Answer Correct Answer: C) NOT BETWEEN operator. 19. Which of the following is a grouping of characters into a word, a group of words, or a complete number? A) File. B) Entity. C) Table. D) Field. Show Answer Correct Answer: D) Field. 20. What is data integrity in the context of databases? A) Data integrity refers to the speed of data retrieval. B) Data integrity is the amount of data stored in a database. C) Data integrity is the accuracy and consistency of data in a database. D) Data integrity is the process of backing up data regularly. Show Answer Correct Answer: C) Data integrity is the accuracy and consistency of data in a database. 21. Which entity has a unique identifier? A) Weak Entity. B) Strong Entity. C) Both. D) None. Show Answer Correct Answer: B) Strong Entity. 22. Which of the following is a valid example of a relation? A) A table named Employees with columns ID, Name, and Salary. B) A single row from a table. C) The allowed range of values for the Salary column. D) The ID field in a form. Show Answer Correct Answer: A) A table named Employees with columns ID, Name, and Salary. 23. Which of the following is NOT a purpose of a DBMS? A) To store information about teachers. B) To store information about social media users. C) To store information about classes. D) To store information about students. Show Answer Correct Answer: B) To store information about social media users. 24. What is the main purpose of creating an index in a database? A) To store data. B) To link two database files. C) To help find specific records and sort them faster. D) To convert text to machine code. Show Answer Correct Answer: C) To help find specific records and sort them faster. 25. In Datasheet View, to insert a new field, what action should be taken? A) Press Ctrl + N. B) Type in any cell directly. C) Double-click on "Add New Field". D) Use Insert Row in Form View. Show Answer Correct Answer: C) Double-click on "Add New Field". 26. What is the purpose of a primary key in a relational database? A) To establish relationships between tables. B) To ensure data uniqueness within a table. C) To index data for faster retrieval. D) To enforce data integrity constraints. Show Answer Correct Answer: B) To ensure data uniqueness within a table. 27. Which model is used in MySQL? A) Network Model. B) Hierarchical Model. C) Relational Model. D) None of the above. Show Answer Correct Answer: C) Relational Model. 28. Which DBMS is best for structured data with relations? A) Relational DBMS. B) Object-oriented DBMS. C) NoSQL DBMS. D) Graph DBMS. Show Answer Correct Answer: A) Relational DBMS. 29. The external level of data abstraction provides: A) Details on file structures. B) Programming code. C) System architecture information. D) A simplified user view of the data. Show Answer Correct Answer: D) A simplified user view of the data. 30. Which data model is most commonly used in current database systems? A) Relational. B) Network. C) Object-oriented. D) Hierarchical. Show Answer Correct Answer: A) Relational. 31. What can a query instantly generate if a database has people stored on one table and phone numbers on another? A) A list of emails. B) A directory of each person's phone number. C) A list of addresses. D) A list of job titles. Show Answer Correct Answer: B) A directory of each person's phone number. 32. What is the purpose of validation in a computerised system? A) To ensure the data entered is accurate. B) To ensure the data entered is sensible and reasonable. C) To correct any errors in the data entered. D) To check the speed of data entry. Show Answer Correct Answer: B) To ensure the data entered is sensible and reasonable. 33. Indicate whether the statement is true or false:Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 34. Data type used for telephone numbers A) Number. B) Text. C) Currency. D) Date/Time. E) Yes/No. Show Answer Correct Answer: B) Text. 35. What is a major limitation of a file-based approach to data storage? A) Data redundancy and inconsistency. B) Faster data retrieval. C) Improved data security. D) Easier relationship management. Show Answer Correct Answer: A) Data redundancy and inconsistency. 36. A candidate key that is an alternative to the primary key. A) Composite key. B) Secondary key. C) Foreign key. D) Primary key. Show Answer Correct Answer: B) Secondary key. 37. Identify the types of Data Anomalies: A) Add, Delete and Save anomalies. B) Insert, Add and Save anomalies. C) Update, Save and Insert anomalies. D) Insert, Delete and Update anomalies. Show Answer Correct Answer: D) Insert, Delete and Update anomalies. 38. A file in a database consists of: A) A single field. B) A collection of databases. C) A collection of records. D) A single record. Show Answer Correct Answer: C) A collection of records. 39. What does the BEGIN/END block do in T-SQL? A) Executes a set of SQL statements together. B) Creates a new database. C) Defines a variable. D) Ends a database connection. Show Answer Correct Answer: A) Executes a set of SQL statements together. 40. Which option in MS Access is used to open an already created database? A) Exit. B) Create New. C) Open Recent Database. D) Blank Database. Show Answer Correct Answer: C) Open Recent Database. 41. When would you use the "Boolean" data type in a database? A) To calculate total salesTagsLO2. B) To store customer addresses. C) To indicate whether an item is in stock (Yes/No). D) To store employee names. Show Answer Correct Answer: C) To indicate whether an item is in stock (Yes/No). 42. What is another term for a database record? A) Tuple. B) Index. C) Attribute. D) Key. Show Answer Correct Answer: A) Tuple. 43. What is a major disadvantage of the file system? A) Low data redundancy. B) High performance. C) Centralized management. D) Data inconsistency. Show Answer Correct Answer: D) Data inconsistency. 44. Which of the following provides centralized control of data? A) DBMS. B) Compiler. C) File system. D) Operating system. Show Answer Correct Answer: A) DBMS. 45. True or False:The "Value" of a relational database represents the entity for which it has value for each attribute? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 46. Network Structure A) A database structure where records can have multiple relationships. B) A hierarchical model with a single parent for each record. C) A linear arrangement of data records. D) A flat file system with no relationships between records. Show Answer Correct Answer: A) A database structure where records can have multiple relationships. 47. In the context of database systems, what does 'CRUD' stand for? A) Copy, Restore, Upgrade, Downgrade. B) Create, Read, Update, Delete. C) Compile, Run, Undo, Debug. D) Classify, Retrieve, Utilize, Discard. Show Answer Correct Answer: B) Create, Read, Update, Delete. 48. What is a tablespace in an RDBMS? A) A caching layer for temporary queries. B) A virtual partition of operating system memory. C) Logical structure that maps objects to physical files. D) None of the above. Show Answer Correct Answer: C) Logical structure that maps objects to physical files. 49. Which schema level describes how data is stored, including file organizations and indexes? A) Conceptual schema. B) External schema. C) Internal schema. D) View schema. Show Answer Correct Answer: C) Internal schema. 50. In a relational database, what is a foreign key? A) A key that refers to the primary key in another table. B) A key that is automatically generated. C) A key that is unique to each table. D) A key that is used for indexing. Show Answer Correct Answer: A) A key that refers to the primary key in another table. 51. How can you retrieve unique values from a column? A) Use the DISTINCT keyword. B) Use the GROUP BY clause. C) Use the UNIQUE function. D) Use the SELECT ALL statement. Show Answer Correct Answer: A) Use the DISTINCT keyword. 52. The database schema is written in A) DDL. B) DML. C) DCL. D) SQL. Show Answer Correct Answer: A) DDL. 53. During which SDLC phase is the conceptual model designed? A) Design. B) Analysis. C) Planning. D) None of the above. Show Answer Correct Answer: B) Analysis. 54. Which SQL keyword is used to remove existing records from a table? A) INSERT. B) ADD. C) DELETE. D) VIEW. Show Answer Correct Answer: C) DELETE. 55. Perintah pada MySQL selalu diakhiri dengan tanda ..... A) ;. B) ,. C) ". D) ). E) );. Show Answer Correct Answer: A) ;. 56. Why are databases important in healthcare? A) They diagnose diseases. B) They manufacture medicines. C) They store patient records. D) They perform surgeries. Show Answer Correct Answer: C) They store patient records. 57. Section A:True or False (5 marks)-Write True or False beside each statement. A field refers to a complete set of data about one person or item. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 58. What does normalization help to achieve? A) Data duplication. B) Unstructured storage. C) Reduced redundancy and improved integrity. D) File compression. Show Answer Correct Answer: C) Reduced redundancy and improved integrity. 59. Which of the following is a valid SQL type? A) CHARACTER. B) NUMERIC. C) FLOAT. D) All of the above. Show Answer Correct Answer: D) All of the above. 60. Which of the following is a sign that a table is not in 3NF? A) It contains non-key attributes that depend on other non-key attributes. B) It has no primary key. C) It has a foreign key. D) It uses an index. Show Answer Correct Answer: A) It contains non-key attributes that depend on other non-key attributes. ← 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