This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 5 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 5 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which characteristic of databases means that programs and data structure are stored separately? A) Self-describing nature. B) Program-data independence. C) Multiple views of data. D) Data sharing capability. Show Answer Correct Answer: B) Program-data independence. 2. 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. 3. Singkatan DBMS berarti ..... A) Database manage support. B) Database multiple system. C) Database multitable system. D) Database managment supply. E) Database management system. Show Answer Correct Answer: E) Database management system. 4. Which of the following properties ensures that a database is in a valid state after the completion of a transaction? A) Durability. B) Atomicity. C) Isolation. D) Consistency. Show Answer Correct Answer: D) Consistency. 5. A ..... is software that manages databases, allowing users to create, read, update, and delete data. A) DBMS (Database Management System). B) Operating System. C) Web Browser. D) Text Editor. Show Answer Correct Answer: A) DBMS (Database Management System). 6. 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-z]%'. C) Use the SQL query:SELECT * FROM employees WHERE last name LIKE 'S%'. 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]%'. 7. 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. 8. 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) Database Designers. B) End-Users. C) Database Administrators. D) Application Programmers. Show Answer Correct Answer: C) Database Administrators. 9. Which function returns the number of rows? A) COUNT(). B) SUM(). C) TOTAL(). D) SIZE(). Show Answer Correct Answer: A) COUNT(). 10. What type of data is stored in relational databases? A) Structured Data. B) Unstructured Data. C) Semi-structured Data. D) Dynamic Data. Show Answer Correct Answer: A) Structured Data. 11. Di bawah ini yang bukan termasuk jenis diagram UML adalah ..... A) Sequence diagram. B) Use case diagram. C) Class diagram. D) Component diagram. E) Communication diagram. Show Answer Correct Answer: D) Component diagram. 12. 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. 13. Which of these could be a primary key? A) Centre number. B) Surname. C) Teacher name. D) Students addresses. Show Answer Correct Answer: A) Centre number. 14. Which SQL query retrieves the top 3 employees with the highest salaries? A) SELECT name, salary FROM employees ORDER BY salary LIMIT 3;. B) SELECT name, salary FROM employees ORDER BY salary DESC LIMIT 3;. C) SELECT name, salary FROM employees ORDER BY salary ASC LIMIT 3;. D) SELECT name, salary FROM employees LIMIT 3 ORDER BY salary DESC;. Show Answer Correct Answer: B) SELECT name, salary FROM employees ORDER BY salary DESC LIMIT 3;. 15. Which of the following is a responsibility of the database administrator (DBA)? A) Creating the user interface. B) Managing the physical storage of data. C) Writing application code. D) Designing end-user reports. Show Answer Correct Answer: B) Managing the physical storage of data. 16. Which database object is used for presenting data in print? A) Forms. B) Reports. C) Queries. D) Tables. Show Answer Correct Answer: B) Reports. 17. 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. 18. A ..... relationship indicates that for each record in a table, there is only a single corresponding record in a related table. A) Many-to-one. B) One-to-one. C) Many-to-many. D) One-to-many. Show Answer Correct Answer: B) One-to-one. 19. In a database table, what is a record? A) A collection of related fields. B) A single piece of data within a field. C) A key used to establish relationships between tables. D) A single row representing a complete set of related information. Show Answer Correct Answer: D) A single row representing a complete set of related information. 20. What is the purpose of attributes in a database? A) Attributes are primarily for indexing database tables. B) Attributes serve to define the properties of entities in a database. C) Attributes define the relationships between different databases. D) Attributes are used to store data in a database. Show Answer Correct Answer: B) Attributes serve to define the properties of entities in a database. 21. In E-R Diagram, weak entity is represented by ..... A) Rectangle. B) Square. C) Double Rectangle. D) Circle. Show Answer Correct Answer: C) Double Rectangle. 22. 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) Associations. B) Sequences. C) Classifications. D) Clustering. Show Answer Correct Answer: C) Classifications. 23. 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. 24. What is a record in a relational database? A) A single row in a table. B) A column in a table. C) A database file. D) A relationship between tables. Show Answer Correct Answer: A) A single row in a table. 25. Which of the following items is not the advantage of a DBMS? A) Improved ability to enforce standards. B) Improved data consistency. C) Local control over the data. D) Minimal data redundancy. Show Answer Correct Answer: C) Local control over the data. ← 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 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 10Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books