This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 17 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 17 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. .... manages the complete database management system. A) Application Programmers. B) End-User. C) Database Administrators. D) Database designers. Show Answer Correct Answer: C) Database Administrators. 2. To ..... data means to add new information to the database. A) Insert. B) Delete. C) Update. D) Retrieve. Show Answer Correct Answer: A) Insert. 3. Which of the following is NOT a type of information system? A) Data Analysis Systems (DAS). B) Transaction Processing Systems (TPS). C) Management Information Systems (MIS). D) Decision Support Systems (DSS). Show Answer Correct Answer: A) Data Analysis Systems (DAS). 4. Which of the following best describes data mining? A) The process of deleting unnecessary data. B) The process of storing data. C) The process of discovering patterns in data. D) The process of cleaning data. Show Answer Correct Answer: C) The process of discovering patterns in data. 5. The number of tuples in a relation is termed as A) Cardinality. B) Entity. C) Column. D) None of the above. Show Answer Correct Answer: A) Cardinality. 6. Apa itu atribut 'src' pada tag dalam HTML? A) Atribut 'src' harus berupa angka dalam tag . B) Atribut 'src' digunakan untuk menambahkan teks alternatif pada gambar. C) Atribut 'src' menentukan ukuran gambar dalam tag . D) Atribut 'src' pada tag dalam HTML adalah URL dari gambar yang akan ditampilkan. Show Answer Correct Answer: D) Atribut 'src' pada tag dalam HTML adalah URL dari gambar yang akan ditampilkan. 7. How are relationships established in a relational database? A) By linking the secondary key of one table to a primary key in another table. B) By merging two tables into one. C) By linking the primary key of one table to an appropriate foreign key in another table. D) By creating a new table that combines elements of two tables. Show Answer Correct Answer: C) By linking the primary key of one table to an appropriate foreign key in another table. 8. The ability to query data as well as insert, delete, and alter tuples is offered by ..... A) DML(Data Manipulation Language). B) TCL(Transaction Control Language). C) DDL(Data Definition Language). D) DCL(Data Control Language). Show Answer Correct Answer: A) DML(Data Manipulation Language). 9. Which of these is not a characteristic of a relational database? A) Two tables or records are related. B) Each record has a unique identifier. C) It contains random unorganized data. D) Tables can share common fields. Show Answer Correct Answer: C) It contains random unorganized data. 10. How do you define primary keys in a table? A) Primary keys are optional for every table. B) A primary key is a column that can contain duplicate values. C) A primary key can be any column in a table. D) A primary key is a column or set of columns that uniquely identifies each row in a table. Show Answer Correct Answer: D) A primary key is a column or set of columns that uniquely identifies each row in a table. 11. Which of the following is NOT a limitation of a file-based approach? A) Inefficient querying of large data sets. B) Difficulty in simultaneous access. C) Enhanced data security. D) Data duplication. Show Answer Correct Answer: C) Enhanced data security. 12. The Relational Database model was first proposed by E.F. Codd in ..... A) 1980. B) 1972. C) 1970. D) 1975. Show Answer Correct Answer: C) 1970. 13. What data types are commonly used in Microsoft Access? A) String, Textbox, Integer, Decimal. B) Text, Memo, Number, Currency, Date/Time, Yes/No, OLE Object, Hyperlink. C) Boolean, Date, Image, File. D) Short Text, Long Text, Float, Time. Show Answer Correct Answer: B) Text, Memo, Number, Currency, Date/Time, Yes/No, OLE Object, Hyperlink. 14. Which of the following best describes 'data'? A) Processed information. B) Raw, unorganized facts. C) A collection of database tables. D) The output of a computer program. Show Answer Correct Answer: B) Raw, unorganized facts. 15. A primary key that consists of more than one field is called a ..... key. A) Composite. B) Secondary. C) Group. D) Foreign. Show Answer Correct Answer: A) Composite. 16. Which transaction command permanently saves changes? A) ROLLBACK. B) COMMIT. C) SAVEPOINT. D) DELETE. Show Answer Correct Answer: B) COMMIT. 17. If a database designer accidentally stores "Phone Number" as Number instead of Text, what problem could occur? A) It may remove leading zeros from phone numbers. B) It will prevent saving any numbers at all. C) It will turn numbers into ASCII codes. D) It will make the field act like a Boolean. Show Answer Correct Answer: A) It may remove leading zeros from phone numbers. 18. One key benefit of DBMS over file systems is: A) Less secure storage. B) More redundancy. C) Data integrity and consistency. D) Higher cost. Show Answer Correct Answer: C) Data integrity and consistency. 19. Which command removes all documents from a collection but keeps the collection? A) Db.collection.drop(). B) Db.collection.deleteMany(\{\}). C) Db.collection.removeAll(). D) Db.collection.truncate(). Show Answer Correct Answer: B) Db.collection.deleteMany(\{\}). 20. Which join returns all rows from both tables, with NULL where no match exists? A) INNER JOIN. B) LEFT JOIN. C) FULL JOIN. D) CROSS JOIN. Show Answer Correct Answer: C) FULL JOIN. 21. Which keys are required to create relationships between entities? A) Primary key and foreign key. B) Primary key and secondary key. C) Foreign key and domestic key. D) Secondary key and foreign key. Show Answer Correct Answer: A) Primary key and foreign key. 22. . Perintah yang memudahkan admin dalam mencabut hak akses yang sebelumnyadiberikan adalah ..... A) ALTER. B) DELETE. C) REVOKE. D) GRANT. E) SELECT. Show Answer Correct Answer: C) REVOKE. 23. What are the benefits of using a DBMS for data management? A) Benefits of using a DBMS include data integrity, security, concurrent access, backup and recovery, and simplified data management. B) Complex data retrieval processes. C) Increased data redundancy. D) Limited user access. Show Answer Correct Answer: A) Benefits of using a DBMS include data integrity, security, concurrent access, backup and recovery, and simplified data management. 24. The DBMS language component which can be embedded in a program is A) The data definition language (DDL). B) The data manipulation language (DML). C) The database administrator (DBA). D) A query language. Show Answer Correct Answer: B) The data manipulation language (DML). 25. What are the advantages of using stored procedures in a database? A) Stored procedures improve performance by reducing network traffic and encapsulating business logic. B) Stored procedures are only useful for data entry tasks. C) Stored procedures are less efficient than executing individual SQL statements. D) Stored procedures do not provide any security benefits. Show Answer Correct Answer: A) Stored procedures improve performance by reducing network traffic and encapsulating business logic. ← 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 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 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books