This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 25 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 25 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The SERIAL keyword in PostgreSQL is used for: A) Auto-increment integer values. B) Creating foreign keys. C) String concatenation. D) Setting default values. Show Answer Correct Answer: A) Auto-increment integer values. 2. DBMS is mainly used to ..... A) Manage databases. B) Compile programs. C) Control operating systems. D) Design hardware. Show Answer Correct Answer: A) Manage databases. 3. What is the main purpose of a Transaction Processing System (TPS)? A) To analyze data. B) To provide information for managing organizations. C) To support decision-making. D) To handle daily transactions of an organization. Show Answer Correct Answer: D) To handle daily transactions of an organization. 4. The status of a relational database in which entities do not contain repeated groups of attributes. A) Second normal form (2NF). B) Third normal form (3NF). C) Boyce-Codd normal form (BCNF). D) First normal form (1NF). Show Answer Correct Answer: D) First normal form (1NF). 5. Given a table "students" with columns "id", "name", and "age", which is the correct syntax to insert a new record? A) INSERT students (1, 'Alice', 20);. B) INSERT students (id, name, age) VALUES (1, 'Alice', 20);. C) INSERT INTO students VALUES (1, 'Alice', 20);. D) ADD INTO students (id, name, age) VALUES (1, 'Alice', 20);. Show Answer Correct Answer: C) INSERT INTO students VALUES (1, 'Alice', 20);. 6. What is the main advantage of using a relational database over a flat file database? A) Easier to create. B) Simplicity in data management. C) Support for complex relationships. D) Lower cost of implementation. Show Answer Correct Answer: C) Support for complex relationships. 7. What is the purpose of a query processor in a DBMS? A) To design data models. B) To process and execute queries. C) To manage data dictionary entries. D) To create databases. Show Answer Correct Answer: B) To process and execute queries. 8. The underlying software that implement DBMS function is called data ..... A) Base. B) Type. C) Engine. D) Constraint. Show Answer Correct Answer: C) Engine. 9. In a three-tier architecture, which tier is responsible for business logic? A) Data Tier. B) Client Tier. C) Presentation Tier. D) Application Tier. Show Answer Correct Answer: D) Application Tier. 10. The Chen Notation ER model uses this symbol to represent weak entity set? A) Dotted rectangle. B) Diamond. C) Doubly outlined rectangle. D) None of these. Show Answer Correct Answer: C) Doubly outlined rectangle. 11. What is used if a postcode needs to have particular format, such as LL09 0LL? A) Input mask. B) Presence check. C) Range check. D) Value lookup. Show Answer Correct Answer: A) Input mask. 12. Ankit is designing a table in MS Access. Each column in his table is referred to as a: A) Report. B) Field. C) Query. D) Record. Show Answer Correct Answer: B) Field. 13. When data is sorted in ascending order, which value would appear first for age? A) 50TagsDOK Level 2:Skill/Concept. B) 35. C) 65. D) 20. Show Answer Correct Answer: D) 20. 14. How does a database management system (DBMS) improve data integrity? A) By allowing anyone to modify the data. B) By using complex algorithms to store data. C) By enforcing rules and constraints on the data entered. D) By storing data in a single locationTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: C) By enforcing rules and constraints on the data entered. 15. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier? A) O ID-dependent entity X. B) Strong entity X. C) ID-independent entity. D) Weak entity X. Show Answer Correct Answer: D) Weak entity X. 16. Which aggregate function calculates average values? A) COUNT(). B) SUM(). C) AVG(). D) MAX(). Show Answer Correct Answer: C) AVG(). 17. Which model is faster to access data? A) Object. B) Relational model. C) Network database model. D) ER model. Show Answer Correct Answer: C) Network database model. 18. Define the term 'primary key' in a database. A) A primary key is a unique identifier for a record in a database table. B) A primary key can contain duplicate values in a table. C) A primary key is used to store large binary data in a database. D) A primary key is a type of foreign key in a database. Show Answer Correct Answer: A) A primary key is a unique identifier for a record in a database table. 19. Referring to the ER diagram, what is a "relationship" ? A) A relationship involves two or more entities and is used to represent an interaction or association. B) A unique identity for each instance of the entity. C) The minimum number of attributes combined to achieve this goal. D) The rules and restrictions that apply to the data. Show Answer Correct Answer: A) A relationship involves two or more entities and is used to represent an interaction or association. 20. What is the most detailed type of data model? A) Physical Data Model. B) Abstract Data Model. C) Conceptual Data Model. D) Logical Data Model. Show Answer Correct Answer: A) Physical Data Model. 21. A relational operator that allows for the combination of information from two or more tables is known as the ..... operator. A) PROJECT. B) SELECT. C) DIFFERENCE. D) JOIN. Show Answer Correct Answer: D) JOIN. 22. In a table storing student data, the "Roll Number" column represents an: A) Relation. B) Schema. C) Attribute. D) Tuple. Show Answer Correct Answer: C) Attribute. 23. 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. 24. Which command is used to remove all records from a table? A) TRUNCATE. B) DELETE. C) DROP. D) REMOVE. Show Answer Correct Answer: A) TRUNCATE. 25. Suggest a free software for managing the database A) Sybase. B) Microsoft SQL Server. C) MySQL. D) Oracle. Show Answer Correct Answer: C) MySQL. 26. External level provides ..... A) User-specific views. B) Storage paths. C) File formats. D) Complete database view. Show Answer Correct Answer: A) User-specific views. 27. 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. 28. Which of these is NOT a common use of databases in business? A) Writing marketing slogans. B) Keeping financial records. C) Tracking inventory. D) Managing customer information. Show Answer Correct Answer: A) Writing marketing slogans. 29. Apa yang dimaksud dengan atribut dalam ERD? A) Properti atau karakteristik dari sebuah entitas. B) Kunci utama dari sebuah entitas. C) Tabel dalam sebuah database. D) Nama entitas. E) Hubungan antara entitas. Show Answer Correct Answer: A) Properti atau karakteristik dari sebuah entitas. 30. 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. 31. 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) No relationships between data. D) Slower data retrieval. Show Answer Correct Answer: A) Reduced data duplication through normalization. 32. What language does the Relational Model use? A) Python. B) Java. C) SQL. D) C++. Show Answer Correct Answer: C) SQL. 33. 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. 34. 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. 35. What is the primary purpose of the COMMIT command in SQL? A) To create a new transaction. B) To save changes made during a transaction. C) To undo changes made during a transaction. D) To display transaction results. Show Answer Correct Answer: B) To save changes made during a transaction. 36. What data type is used to store large amounts of alphanumeric data, such as detailed product descriptions? A) Number. B) Long Text. C) Text. D) Date/Time. Show Answer Correct Answer: B) Long Text. 37. What are fields in a database also known as? A) Rows. B) Columns. C) Records. D) Tuples. Show Answer Correct Answer: B) Columns. 38. 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. 39. Which feature in MS Access helps you create a form automatically? A) Form Wizard. B) Query Wizard. C) Table Wizard. D) Report Wizard. Show Answer Correct Answer: A) Form Wizard. 40. .... 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. 41. 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) BCNF. D) 3NF. Show Answer Correct Answer: D) 3NF. 42. The SQL operator that is used where an exact match is not necessary is A) %. B) ANY. C) BETWEEN. D) LIKE. Show Answer Correct Answer: D) LIKE. 43. What is a primary key in a relational database? A) An attribute that uniquely identifies each tuple. B) An attribute that refers to another table. C) An attribute that is optional in a table. D) An attribute that can have duplicate values. Show Answer Correct Answer: A) An attribute that uniquely identifies each tuple. 44. It can be structured as a collection of records, where each record is made up of fields containing data about the same 'thing'. A) Spreadsheet. B) File. C) Table. D) Database. Show Answer Correct Answer: B) File. 45. What does the term "cardinality" refer to in an ERD? A) The numerical relationship between two entities. B) The number of relationships between entities. C) The number of entities in a database. D) The number of attributes in an entity. Show Answer Correct Answer: A) The numerical relationship between two entities. 46. Which of the following is NOT a candidate key in a database? A) Customer name. B) Product category. C) Student ID number. D) Order date. Show Answer Correct Answer: D) Order date. 47. Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security? A) Entity-relationship diagram. B) Data dictionary. C) Relationship dictionary. D) Data definition diagram. Show Answer Correct Answer: B) Data dictionary. 48. Which of the following is an example of a database used in a business? A) A list of customers and their orders. B) A storybook. C) A calculator. D) A video game. Show Answer Correct Answer: A) A list of customers and their orders. 49. One of the following is not a valid data type name for a field ..... A) Date. B) Number. C) Entity. D) Text or string. Show Answer Correct Answer: C) Entity. 50. The status of a relational database in which entities are in 1NF and any non-key attributes depend on the primary key. A) First normal form (1NF). B) Third normal form (3NF). C) Second normal form (2NF). D) Boyce-Codd normal form (BCNF). Show Answer Correct Answer: C) Second normal form (2NF). 51. What problem might arise if incorrect fields are inserted into a database? A) Students can log in faster. B) Reports may be inaccurate or misleading. C) The ASCII code won't work. D) The database becomes more efficient. Show Answer Correct Answer: B) Reports may be inaccurate or misleading. 52. What is data validation in a database? A) Ensuring data is accurate and meets certain criteria. B) Sorting data alphabetically. C) Deleting duplicate records. D) Storing images in a table. Show Answer Correct Answer: A) Ensuring data is accurate and meets certain criteria. 53. How do databases help businesses? A) By hiring employees. B) By creating advertisements. C) By designing products. D) By managing customer information. Show Answer Correct Answer: D) By managing customer information. 54. Which of the following is an example of a SQL extension? A) XML. B) JSON. C) HTML. D) PL-SQL. Show Answer Correct Answer: D) PL-SQL. 55. What is an example of a record in a database? A) A movie script. B) A painting description. C) Information about a unique employee. D) A song playlist. Show Answer Correct Answer: C) Information about a unique employee. 56. DBMS EXTRACT DATA FROM A) META DATA. B) INFORMATION. C) DATA. D) DATABASE. Show Answer Correct Answer: D) DATABASE. 57. What does ETL stand for in data integration? A) Extract, Transform, Load. B) Encode, Translate, Load. C) Evaluate, Transmit, G. D) None of the above. Show Answer Correct Answer: A) Extract, Transform, Load. 58. Facilitates oversight and control of databases, enabling a variety of administrative operations such as performance monitoring, tuning, and backup and recovery. A) RDMS. B) NoSQL. C) DBMS. D) MySQL. Show Answer Correct Answer: C) DBMS. 59. Which database language is used for defining data structures? A) DCL. B) TCL. C) DML. D) DDL. Show Answer Correct Answer: D) DDL. 60. A ..... is a question asked from a database. A) Field. B) Query. C) Form. D) Report. Show Answer Correct Answer: B) Query. ← 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