This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 2 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 2 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a characteristic of 'program-data independence'? A) Data structures must remain constant. B) Data can be accessed only by one program. C) Programs must be rewritten for every data change. D) Programs can be changed without affecting data structures. Show Answer Correct Answer: D) Programs can be changed without affecting data structures. 2. What is the simplest kind of database described here? A) A relational schema with keys. B) A hierarchical tree of folders. C) A flat file storing one entity. D) A network model of relations. Show Answer Correct Answer: C) A flat file storing one entity. 3. What is the primary feature of distributed filesystems like HDFS? A) Data distribution facilitates data access speed but hinders fault tolerance. B) Data is stored in a physically distributed manner for lower latency. C) Data is partitioned and replicated across nodes for fault tolerance. D) None of the above. Show Answer Correct Answer: C) Data is partitioned and replicated across nodes for fault tolerance. 4. Which of the following wildcard characters represents 'any number of characters'? A) #. B) *. C) []. D) ?. Show Answer Correct Answer: B) *. 5. In the relational modes, cardinality is termed as: A) Number of tables. B) Number of attributes. C) Number of tuples. D) Number of constraints. Show Answer Correct Answer: C) Number of tuples. 6. What does the following SQL statement do? Delete from Customer ..... T where state = 'HI'; A) Deletes all records from customer t where the state is equal to HI. B) Removes the Customer T table from the database. C) Deletes all records from the Customer T table. D) Doesn't delete anything because of a syntax error. Show Answer Correct Answer: A) Deletes all records from customer t where the state is equal to HI. 7. Database specification A) The reliability and integrity of the data is also ensured in the database. B) It can be much faster than typing on the keyboard. C) Easier for a beginner to learn/use. D) Not very good for novice users. E) It can be much faster than typing on the keyboard. Show Answer Correct Answer: A) The reliability and integrity of the data is also ensured in the database. 8. The basic structure of data in relational model is ..... A) Row. B) Tables. C) Data. D) Column. Show Answer Correct Answer: B) Tables. 9. What is the significance of "Transactions" and "Transaction Processing" in a database? A) To enable the ability for an attribute to accept null values. B) To ensure that the data does not get out of sync. C) To represent a property, quality, or characteristic of the entity. D) To use objects that represent real-world occurrences. Show Answer Correct Answer: B) To ensure that the data does not get out of sync. 10. What is meant by 'data abstraction' in a database? A) Storing data in multiple formats. B) Creating backups of data. C) Hiding storage details and presenting a conceptual view. D) Accessing data through web applications. Show Answer Correct Answer: C) Hiding storage details and presenting a conceptual view. 11. Consider the following schema:SUPPLIERS(SupplierID, SupplierName, Address) Which SQL statement is used to REVOKE ALL privilege on the SUPPLIERS in the schema to the user 'Manager'? A) REVOKE ALL ON SUPPLIERS FROM Manager. B) GRANT ALL ON SUPPLIERS TO Manager. C) REVOKE ALL ON SUPPLIERS TO Manager. D) REVOKE ALL ON SUPPLIERS. Show Answer Correct Answer: A) REVOKE ALL ON SUPPLIERS FROM Manager. 12. In MS Access, which option allows users to create a form quickly? A) Print Preview. B) Create Tab. C) Ribbon. D) Page Layout. Show Answer Correct Answer: B) Create Tab. 13. Apa yang dimaksud dengan kunci asing? A) Kunci yang digunakan untuk enkripsi data. B) Kunci yang menunjukkan hubungan antara tabel. C) Kunci yang digunakan dalam tampilan. D) Kunci utama di setiap tabel. E) Kunci yang berfungsi sebagai indeks data. Show Answer Correct Answer: B) Kunci yang menunjukkan hubungan antara tabel. 14. 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. 15. Which event typically *triggers* embedded SQL execution in a VB.NET or Java program? A) When a user interacts with a GUI (e.g., clicks a button). B) When the Oracle server restarts. C) When a user closes the application. D) When the database compiles the code. Show Answer Correct Answer: A) When a user interacts with a GUI (e.g., clicks a button). 16. Determine the error in the below SELECT statement SELECT ename, deptno, sal FROM emp WHERE job=CLERK; A) Character literal CLERK must be enclosed within parentheses. B) WHERE clause cannot refer the column JOB since it doesn't appear in the SELECT column list. C) Character literal CLERK must be enclosed within single quotes. D) No error in the query. Show Answer Correct Answer: C) Character literal CLERK must be enclosed within single quotes. 17. 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. 18. Which integrity type ensures a primary key is never NULL? A) Logical Integrity. B) Referential Integrity. C) Domain Integrity. D) Entity Integrity. Show Answer Correct Answer: D) Entity Integrity. 19. 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. 20. 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. 21. 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. 22. Which of the following symbols is NOT used in a Chen Notation ERD? A) Rectangle. B) Diamond. C) Circle. D) Oval. Show Answer Correct Answer: C) Circle. 23. 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. 24. 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. 25. What process is used to break a many-to-many relationship apart in a relational database? A) Normalization. B) Aggregation. C) Optimization. D) Validation. Show Answer Correct Answer: A) Normalization. 26. 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. 27. 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. 28. In the three-schema architecture, which level describes how data is actually stored in memory? A) Conceptual Level. B) Logical Level. C) Internal Level. D) External Level. Show Answer Correct Answer: C) Internal Level. 29. Which of the following is NOT a valid candidate key in a database? A) An order's date. B) A product's name. C) A student's last name. D) A customer's name. Show Answer Correct Answer: D) A customer's name. 30. Which of the following is a disadvantage of a flat file database? A) Easy to implement. B) Redundancy of data. C) Simple structure. D) No data editing issues. Show Answer Correct Answer: B) Redundancy of data. 31. What does the term 'cardinality' refer to in a relational database? A) The number of attributes in a relation. B) The uniqueness of data values. C) The number of rows in a table. D) The relationship between tables. Show Answer Correct Answer: C) The number of rows in a table. 32. 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. 33. 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) Entity integrity. B) Domain integrity. C) Data integrity. D) Referential integrity. Show Answer Correct Answer: D) Referential integrity. 34. What data type is used to store a value from another table? A) Calculated. B) OLE Object. C) Attachment. D) Lookup. Show Answer Correct Answer: D) Lookup. 35. 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. 36. WHAT IS META DATA A) DATA DESCRIBING ABOUT DATA. B) DATA DESCRIBING ABOUT INFORMATION. C) DATA DESCRIBING ABOUT FILE. D) DATA DESCRIBING TABLE. Show Answer Correct Answer: A) DATA DESCRIBING ABOUT DATA. 37. Which of the following is an example of a data update operation? A) SELECT COUNT(*) FROM products;. B) INSERT INTO students VALUES (1, 'Ali');. C) SELECT * FROM students;. D) SELECT name FROM students WHERE grade = 10;. Show Answer Correct Answer: B) INSERT INTO students VALUES (1, 'Ali');. 38. Which characteristic of databases means that programs and data structure are stored separately? A) Self-describing nature. B) Data sharing capability. C) Multiple views of data. D) Program-data independence. Show Answer Correct Answer: D) Program-data independence. 39. What is the purpose of the alter keyword in SQL? A) To update existing records. B) To select all values. C) To eliminate duplicate values. D) To create a new table. Show Answer Correct Answer: A) To update existing records. 40. Singkatan DBMS berarti ..... A) Database management system. B) Database managment supply. C) Database multiple system. D) Database manage support. E) Database multitable system. Show Answer Correct Answer: A) Database management system. 41. Which of the following properties ensures that a database is in a valid state after the completion of a transaction? A) Durability. B) Consistency. C) Isolation. D) Atomicity. Show Answer Correct Answer: B) Consistency. 42. A ..... is software that manages databases, allowing users to create, read, update, and delete data. A) DBMS (Database Management System). B) Web Browser. C) Text Editor. D) Operating System. Show Answer Correct Answer: A) DBMS (Database Management System). 43. How can you find rows where the employee's last name starts with 'S' to 'Z'? A) Use the SQL query:SELECT * FROM employees WHERE last name LIKE '[S-Z]%'. B) Use the SQL query:SELECT * FROM employees WHERE last name LIKE 'S%'. C) Use the SQL query:SELECT * FROM employees WHERE last name LIKE '[s-z]%'. D) Use the SQL query:SELECT * FROM employees WHERE last name LIKE 'Z%'. Show Answer Correct Answer: A) Use the SQL query:SELECT * FROM employees WHERE last name LIKE '[S-Z]%'. 44. Define big data and its characteristics. A) Big data is defined by its volume, velocity, variety, veracity, and value. B) Big data is characterized by its simplicity and small size. C) Big data is defined by its static nature and limited variety. D) Big data refers to data that is always accurate and consistent. Show Answer Correct Answer: A) Big data is defined by its volume, velocity, variety, veracity, and value. 45. Who is responsible for authorizing access to the database, monitoring its use and managing all of the resources to support the use of the entire database system? A) Application Programmers. B) End-Users. C) Database Designers. D) Database Administrators. Show Answer Correct Answer: D) Database Administrators. 46. Which function returns the number of rows? A) COUNT(). B) TOTAL(). C) SIZE(). D) SUM(). Show Answer Correct Answer: A) COUNT(). 47. What type of data is stored in relational databases? A) Structured Data. B) Semi-structured Data. C) Unstructured Data. D) Dynamic Data. Show Answer Correct Answer: A) Structured Data. 48. Di bawah ini yang bukan termasuk jenis diagram UML adalah ..... A) Component diagram. B) Sequence diagram. C) Class diagram. D) Communication diagram. E) Use case diagram. Show Answer Correct Answer: A) Component diagram. 49. In a one-to-one relationship, how many times can a primary key exist as a foreign key? A) Once as a primary key and many times as a foreign key. B) Once as a primary key and once as a foreign key. C) Many times as a primary key and once as a foreign key. D) Many times as a primary key and many times as a foreign key. Show Answer Correct Answer: B) Once as a primary key and once as a foreign key. 50. Which of these could be a primary key? A) Surname. B) Centre number. C) Teacher name. D) Students addresses. Show Answer Correct Answer: B) Centre number. 51. Which SQL query retrieves the top 3 employees with the highest salaries? A) SELECT name, salary FROM employees LIMIT 3 ORDER BY salary DESC;. B) SELECT name, salary FROM employees ORDER BY salary DESC LIMIT 3;. C) SELECT name, salary FROM employees ORDER BY salary LIMIT 3;. D) SELECT name, salary FROM employees ORDER BY salary ASC LIMIT 3;. Show Answer Correct Answer: B) SELECT name, salary FROM employees ORDER BY salary DESC LIMIT 3;. 52. Which of the following is a responsibility of the database administrator (DBA)? A) Writing application code. B) Creating the user interface. C) Designing end-user reports. D) Managing the physical storage of data. Show Answer Correct Answer: D) Managing the physical storage of data. 53. Which database object is used for presenting data in print? A) Reports. B) Tables. C) Queries. D) Forms. Show Answer Correct Answer: A) Reports. 54. What is the significance of data types in fields? A) Data types are crucial for ensuring data integrity, optimizing storage, and enabling appropriate operations in fields. B) Data types are only relevant for programming languages. C) Data types have no impact on data analysis. D) Data types are solely for aesthetic purposes in databases. Show Answer Correct Answer: A) Data types are crucial for ensuring data integrity, optimizing storage, and enabling appropriate operations in fields. 55. A ..... relationship indicates that for each record in a table, there is only a single corresponding record in a related table. A) One-to-one. B) Many-to-many. C) Many-to-one. D) One-to-many. Show Answer Correct Answer: A) One-to-one. 56. In a database table, what is a record? A) A collection of related fields. B) A single row representing a complete set of related information. C) A single piece of data within a field. D) A key used to establish relationships between tables. Show Answer Correct Answer: B) A single row representing a complete set of related information. 57. What is the purpose of attributes in a database? A) Attributes are used to store data in a database. B) Attributes are primarily for indexing database tables. C) Attributes serve to define the properties of entities in a database. D) Attributes define the relationships between different databases. Show Answer Correct Answer: C) Attributes serve to define the properties of entities in a database. 58. In E-R Diagram, weak entity is represented by ..... A) Rectangle. B) Double Rectangle. C) Circle. D) Square. Show Answer Correct Answer: B) Double Rectangle. 59. In data mining, which of the following involves recognizing patterns that describe the group to which an item belongs by examining existing items and inferring a set of rules? A) Sequences. B) Associations. C) Classifications. D) Clustering. Show Answer Correct Answer: C) Classifications. 60. Which action should be performed first before designing a database in MS Access? A) Define relationships. B) Identify the data and structure needed. C) Create a report. D) Run a query. Show Answer Correct Answer: B) Identify the data and structure needed. ← PreviousNext →Related QuizzesScience QuizzesClass 11 QuizzesClass 11 Computer Science Chapter 7 Database Concepts Quiz 1Class 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 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books