This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 16 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 16 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Perintah SQL yang digunakan untuk memperbarui data pada kolom 'nama' di tabel 'pelanggan' adalah ..... A) CHANGE pelanggan SET nama = 'John' WHERE id = 1;. B) MODIFY pelanggan SET nama = 'John' WHERE id = 1;. C) UPDATE pelanggan SET nama = 'John' WHERE id = 1;. D) ALTER pelanggan SET nama = 'John' WHERE id = 1;. Show Answer Correct Answer: C) UPDATE pelanggan SET nama = 'John' WHERE id = 1;. 2. What are the benefits of using views in database management? A) Views are used to increase data redundancy. B) Views help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. C) Views are only used for data deletion in a database. D) Views have no impact on database performance. Show Answer Correct Answer: B) Views help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. 3. What is the main function of tables in a database? A) To send emails. B) To create graphics. C) To store information. D) To browse the internet. Show Answer Correct Answer: C) To store information. 4. Information is obtained after ..... of data. A) Collection. B) Processing. C) Storage. D) Duplication. Show Answer Correct Answer: B) Processing. 5. The database language that allows us to access data in a database is called: A) DCL. B) DML. C) DDL. D) None Of Above. Show Answer Correct Answer: A) DCL. 6. What is a DBMS and its primary function? A) A DBMS is a cloud service for file sharing. B) A DBMS is a type of hardware used for data storage. C) A DBMS is software that manages databases, allowing for data creation, retrieval, updating, and management. D) A DBMS is a programming language for data analysis. Show Answer Correct Answer: C) A DBMS is software that manages databases, allowing for data creation, retrieval, updating, and management. 7. What challenges are associated with distributed databases? A) Uniform data storage across all nodes. B) High availability and redundancy. C) Simple query execution. D) Challenges include data consistency, network latency, partition tolerance, and complex query processing. Show Answer Correct Answer: D) Challenges include data consistency, network latency, partition tolerance, and complex query processing. 8. Mismatched redundant copies of data is known as data ..... A) Redundancy. B) Inconsistency. C) Isolation. D) Dependance. Show Answer Correct Answer: B) Inconsistency. 9. A ..... database allows access from any location with an internet connection. A) Local. B) Offline. C) Desktop. D) Cloud. Show Answer Correct Answer: D) Cloud. 10. Which of the followings are correct in relational databases? A) A relational database has one table only. B) Each attribute is shown in row in a table. C) Each record is shown in column in a table. D) Tables in relational database are referred to as relations. Show Answer Correct Answer: D) Tables in relational database are referred to as relations. 11. Suppose a change is made in the storage structure of the database files (e.g., changing from magnetic disks to SSDs). Which level of the ANSI-SPARC architecture does this affect directly? A) Internal level. B) Conceptual level. C) External level. D) Logical level. Show Answer Correct Answer: A) Internal level. 12. The default ..... id field in MongoDB is of type: A) String. B) UUID. C) Integer. D) ObjectId. Show Answer Correct Answer: D) ObjectId. 13. Which schedule allows commit only after all dependent transactions commit? A) Cascading abort schedule. B) Recoverable schedule. C) Non-recoverable schedule. D) Strict schedule. Show Answer Correct Answer: B) Recoverable schedule. 14. Which type of data includes measurable facts like test scores or visitor numbers? A) Symbolic. B) Numerical. C) Alphanumeric. D) Alphabetic. Show Answer Correct Answer: B) Numerical. 15. Which of the following can be stored in a database? A) Text and numbers. B) Images and audio. C) Videos and documents. D) All of the above. Show Answer Correct Answer: D) All of the above. 16. DML is used for: A) Defining schemas. B) Granting permissions. C) Creating constraints. D) Manipulating data. Show Answer Correct Answer: D) Manipulating data. 17. In an ER model, what does an "entity" typically represent? A) A computer program. B) A file system. C) A field in a record. D) A real-world object like a student or course. Show Answer Correct Answer: D) A real-world object like a student or course. 18. Which of the following correctly defines a field? A) A request for data from the database. B) A single piece of information in a database. C) A summary of data. D) A collection of related fields in a row. Show Answer Correct Answer: B) A single piece of information in a database. 19. Which of the following best describes a flat file system? A) Stores data in a relational manner. B) Uses tables with foreign keys. C) Simple text-based storage without relations. D) Hierarchical data storage. Show Answer Correct Answer: C) Simple text-based storage without relations. 20. In a table of employees, "Department" field can take only values "HR, " "Finance, " "IT." This set of allowed values is called a: A) Domain. B) Tuple. C) Attribute. D) Relation. Show Answer Correct Answer: A) Domain. 21. What does a column in a database table represent? A) A group of related fields. B) A single record. C) A collection of tables. D) A specific piece of data. Show Answer Correct Answer: D) A specific piece of data. 22. Raw facts which people gather is referred to as ..... A) Data. B) Knowledge. C) Information. D) Wisdom. Show Answer Correct Answer: A) Data. 23. ..... allows multiple users to work on it. A) Normalization. B) Security. C) DBMS. D) None of the above. Show Answer Correct Answer: C) DBMS. 24. Which of the following best describes an entity in an Entity Relationship Diagram (ERD)? A) A relationship between two tables. B) A unique attribute of a table. C) A field that contains a foreign key. D) An object or concept about which data is stored. Show Answer Correct Answer: D) An object or concept about which data is stored. 25. What is the primary function of a DBMS (Database Management System)? A) To perform data analysis. B) To manage the interaction between users and databases. C) To display web content. D) To optimize system hardware. Show Answer Correct Answer: B) To manage the interaction between users and databases. 26. A structured collection of data items that can be accessed by different application programs. A) Data warehouse. B) Spreadsheet. C) Text file. D) Database. Show Answer Correct Answer: D) Database. 27. Fill in the blank: ..... is a non-key attribute, whose values are derived from the primary key of some other table. A) Primary Key. B) Foreign Key. C) Candidate Key. D) Alternate Key. Show Answer Correct Answer: B) Foreign Key. 28. What does atomicity mean in database transactions? A) Breaking transactions into small parts. B) Using atomic data types. C) A transaction should be completed entirely or not at all. D) Processing one transaction at a time. Show Answer Correct Answer: C) A transaction should be completed entirely or not at all. 29. What are the benefits of using forms for data entry? A) Forms eliminate the need for any data validation. B) Forms are only useful for collecting payments. C) Using forms slows down the data entry process. D) Benefits of using forms for data entry include improved data accuracy, consistency, user guidance, and efficiency. Show Answer Correct Answer: D) Benefits of using forms for data entry include improved data accuracy, consistency, user guidance, and efficiency. 30. What does ACID stand for in the context of databases? A) Access, Change, Integration, Data. B) Atomicity, Consistency, Isolation, Durability. C) Aggregation, Consistency, Indexing, Data. D) Analysis, Control, Input, Data. Show Answer Correct Answer: B) Atomicity, Consistency, Isolation, Durability. 31. Why is storage method selection critical in database systems? A) Facilitates the database design process. B) Ensures compatibility with presentation layers. C) Impacts performance, reliability, and cost. D) None of the above. Show Answer Correct Answer: C) Impacts performance, reliability, and cost. 32. What does a one-to-many relationship in a relational database describe? A) A single record in one table is linked to multiple records in another table. B) Multiple records in one table are linked to a single record in another table. C) All records in one table are linked to all records in another table. D) No records are linked between tables. Show Answer Correct Answer: A) A single record in one table is linked to multiple records in another table. 33. What are the four core functions of a DBMS? A) Creating, Deleting, Updating, Viewing. B) Input, Output, Storage, Control. C) Reading, Writing, Storing, Processing. D) Defining, Constructing, Manipulating, Sharing. Show Answer Correct Answer: D) Defining, Constructing, Manipulating, Sharing. 34. ..... is the presence of duplicate data in multiple data files so that the same data are stored in more than one place or location. A) Batch processing. B) Data redundancy. C) Data independence. D) Online processing. Show Answer Correct Answer: B) Data redundancy. 35. What is the meaning of LIKE '%0%0%' A) Feature ends with two 0's. B) Feature has more than two 0's. C) Feature has two 0's in it, at any position. D) Feature begins with two 0's. Show Answer Correct Answer: C) Feature has two 0's in it, at any position. 36. Explain the significance of database indexing in improving query performance. A) Indexes are used to store data in a database. B) Indexes help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. C) Indexes are only used for data deletion in a database. D) Indexes have no impact on database performance. Show Answer Correct Answer: B) Indexes help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. 37. Which level hides hardware details from the user? A) External. B) Conceptual. C) System. D) Physical. Show Answer Correct Answer: B) Conceptual. 38. A schematic of the entire database that describes the relationships in a database is called a(n) ..... A) Intersection relationship diagram. B) Data definition diagram. C) Entity-relationship diagram. D) Data dictionary. Show Answer Correct Answer: C) Entity-relationship diagram. 39. What is the purpose of a primary key in a table? A) To allow null values. B) To uniquely identify records. C) To store foreign keys. D) None of the above. Show Answer Correct Answer: B) To uniquely identify records. 40. Perintah yang memudahkan admin dalam memberikan hak akses adalah ..... A) REVOKE. B) ALTER. C) GRANT. D) SELECT. E) DELETE. Show Answer Correct Answer: C) GRANT. 41. The output relation which has sum of column and product of rows is called ..... A) Selection Operation. B) Cartesian product. C) Union operation. D) Project Operation. Show Answer Correct Answer: B) Cartesian product. 42. Which data type can store a calculated value based on other fields in the table? A) Calculated. B) Attachment. C) Lookup. D) OLE Object. Show Answer Correct Answer: A) Calculated. 43. What is the function of a form in database management? A) To store data in a structured format. B) To perform complex calculations on data. C) To generate reports automatically. D) To provide a user-friendly interface for data entry and management. Show Answer Correct Answer: D) To provide a user-friendly interface for data entry and management. 44. Which of the following is NOT a type of database user? A) Hardware Engineer. B) Database Administrator. C) End-user. D) Database Designer. Show Answer Correct Answer: A) Hardware Engineer. 45. Why is a DBMS necessary for managing data? A) A DBMS complicates data access and reduces efficiency. B) A DBMS is unnecessary for small-scale data management. C) A DBMS is only useful for large organizations with massive data. D) A DBMS is essential for efficient data management, ensuring integrity, security, and concurrent access. Show Answer Correct Answer: D) A DBMS is essential for efficient data management, ensuring integrity, security, and concurrent access. 46. How do markup languages like HTML differ from programming languages? A) Markup languages are used for formatting and linking text, not for programming instructions. B) Markup languages require a compiler to run. C) Markup languages are low-level languages like assembly code. D) Markup languages cannot be used for creating web pages. Show Answer Correct Answer: A) Markup languages are used for formatting and linking text, not for programming instructions. 47. Indicate whether the statement is true or false:Encryption is a key feature of a blockchain database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 48. At which level of data abstraction is the database schema defined? A) Physical level. B) External level. C) Logical level. D) Conceptual level. Show Answer Correct Answer: D) Conceptual level. 49. SQL statements can be classified into A) Data definition language(DDL). B) Data manipulation language(DML). C) Transaction control language(TCL). D) All of these. Show Answer Correct Answer: D) All of these. 50. In the context of databases, what does the term 'concurrency control' refer to? A) Backing up data regularly. B) Ensuring that multiple transactions can occur without conflict. C) Managing multiple database connections. D) Controlling user access to the database. Show Answer Correct Answer: B) Ensuring that multiple transactions can occur without conflict. 51. Another name for a production database is a ..... database. A) Development. B) Warehousing. C) Data-mining. D) Transactional. Show Answer Correct Answer: D) Transactional. 52. Which type of end user makes up the largest category and uses predefined transactions? A) Naive or Parametric End Users. B) Casual End Users. C) Sophisticated End Users. D) Stand-alone Users. Show Answer Correct Answer: A) Naive or Parametric End Users. 53. What is the primary key for the world table? A) Continent. B) Population. C) Name. D) Area. Show Answer Correct Answer: C) Name. 54. The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; A) 6789. B) 1234. C) 456789. D) 2345. Show Answer Correct Answer: D) 2345. 55. Which of the following SQL queries is used to retrieve rows from the "customers" table where the "email" column contains NULL values? A) SELECT * FROM customers WHERE ISNULL(email);. B) SELECT * FROM customers WHERE email = NULL;. C) SELECT * FROM customers WHERE email IS NOT NULL;. D) SELECT * FROM customers WHERE email IS NULL. Show Answer Correct Answer: D) SELECT * FROM customers WHERE email IS NULL. 56. Which of the following is NOT a foreign key in a database? A) Product category. B) Student ID number. C) Order date. D) Customer name. Show Answer Correct Answer: A) Product category. 57. Which of the following is an RDBMS? A) FoxPro. B) Dbase. C) Microsoft Access. D) SQLite. Show Answer Correct Answer: D) SQLite. 58. Which of the following is NOT an expectation we have for a database management system, whether it is relational or not A) More complicated handling of requests for information. B) Backup and recovery. C) Efficient storage handling. D) Concurrency. Show Answer Correct Answer: B) Backup and recovery. 59. What is the main advantage of a distributed database? A) Easier to manage. B) Lower costs. C) Faster access times. D) Redundancy and reliability. Show Answer Correct Answer: D) Redundancy and reliability. 60. What is a transposition error? A) When data is omitted or excluded. B) When two characters are accidentally swapped. C) When data is lost or damaged. D) When data is encrypted incorrectly. Show Answer Correct Answer: B) When two characters are accidentally swapped. ← 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