This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 1 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 1 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Alternate keys are not primary keys. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 2. Which command is used to remove entire a table? A) DROP. B) TRUNCATE. C) DELETE. D) REMOVE. Show Answer Correct Answer: A) DROP. 3. In Excel, what is the MAIN advantage of converting a list of student marks into a formatted table? A) It prevents users from editing data. B) It automatically makes data alphabetic. C) It allows easier sorting, filtering, and analysis. D) It assigns ASCII codes to the marks. Show Answer Correct Answer: C) It allows easier sorting, filtering, and analysis. 4. Swati uses Design View to build her table structure. What can she NOT do in this view? A) Assign data type. B) Set field size. C) Enter data records. D) Set primary key. Show Answer Correct Answer: C) Enter data records. 5. Repetition of data is called data ..... A) Isolation. B) Inconsistency. C) Dependance. D) Redundancy. Show Answer Correct Answer: D) Redundancy. 6. The command used to delete a particular column in a relation is ..... A) ALTER, DROP. B) UPDATE TABLE. C) TRUNCATE COLUMN. D) DELETE COLUMN. Show Answer Correct Answer: A) ALTER, DROP. 7. Data type used for age A) Date/Time. B) Text. C) Yes/No. D) Number. E) Currency. Show Answer Correct Answer: D) Number. 8. Which of the following best describes a table in a relational database? A) A single data value. B) A set of unrelated attributes. C) A programming script. D) A collection of related records. Show Answer Correct Answer: D) A collection of related records. 9. What is the difference between a compiler and an interpreter? A) A compiler translates line by line, while an interpreter translates the whole program at once. B) A compiler translates the whole program at once, while an interpreter translates line by line. C) Both are used to translate markup languages. D) Both are used to document the program. Show Answer Correct Answer: B) A compiler translates the whole program at once, while an interpreter translates line by line. 10. What does the 'Number' data type in a database allow? A) To store both letters and numbers. B) To store numbers that can be used in calculations. C) To store links to external websites. D) To store long texts. Show Answer Correct Answer: B) To store numbers that can be used in calculations. 11. Which of the following combinations correctly shows all four key database objects? A) Form, Graph, Query, Slide. B) Table, Form, Query, Report. C) Table, Data, Report, Field. D) Field, Record, Report, Cell. Show Answer Correct Answer: B) Table, Form, Query, Report. 12. Which of the following is NOT a type of schema corresponding to the three levels in the ANSI-SPARC architecture A) External. B) Physical. C) Internal. D) Conceptual. Show Answer Correct Answer: D) Conceptual. 13. Explain the concept of data modeling. A) Data modeling is the process of deleting unnecessary data. B) Data modeling involves only data storage techniques. C) Data modeling is only about creating databases. D) Data modeling is the process of creating a conceptual representation of data structures and their relationships. Show Answer Correct Answer: D) Data modeling is the process of creating a conceptual representation of data structures and their relationships. 14. Which skill is essential for a DBA? A) Knowledge of data science tools. B) Data modeling expertise. C) Creating UI layouts. D) None of the above. Show Answer Correct Answer: B) Data modeling expertise. 15. Charles Bachman created the first DBMS system? A) 1965. B) 1970. C) 1960. D) 1961. E) 1956. Show Answer Correct Answer: C) 1960. 16. What is the purpose of the CAST function in T-SQL? A) To delete records. B) To update data. C) To create new tables. D) To convert data types. Show Answer Correct Answer: D) To convert data types. 17. What is one of the basic functions of a query in a database? A) To create new tables. B) To encrypt data. C) To combine data from multiple tables. D) To delete data. Show Answer Correct Answer: C) To combine data from multiple tables. 18. Which of the following best defines a "relationship" in a relational database? A) A connection between two tables based on a common field. B) A command used to update data. C) A type of data entry form. D) A method to delete records. Show Answer Correct Answer: A) A connection between two tables based on a common field. 19. What are the 2 types of tables in Database application? A) Slave table and master table. B) Master table and student table. C) Both a and b. D) None of these. Show Answer Correct Answer: A) Slave table and master table. 20. What is a primary key? A) A unique identifier for records in a table. B) A type of relationship. C) A method of data retrieval. D) A field that links to another table. Show Answer Correct Answer: A) A unique identifier for records in a table. 21. What does the schema of a relational database consist of? A) Only tables. B) Only attributes. C) Only rows and columns. D) Tables, rows, and columns. Show Answer Correct Answer: D) Tables, rows, and columns. 22. According to the document, why is Microsoft Excel considered unsuitable for complex database tasks? A) It cannot store alphanumeric characters. B) It does not allow users to define specific data types for each field. C) It is limited to only one-to-one relationships. D) It can only handle a maximum of 255 records. Show Answer Correct Answer: B) It does not allow users to define specific data types for each field. 23. Raj wants to store a student's date of birth in his database. What data type should he choose? A) Number. B) Memo. C) Yes/No. D) Date/Time. Show Answer Correct Answer: D) Date/Time. 24. What defines a relational database model? A) A relational database model is defined by its use of hierarchical structures. B) A relational database model is defined by its use of tables to store data and relationships between them. C) A relational database model uses a single large file to store all data. D) A relational database model relies on object-oriented programming principles. Show Answer Correct Answer: B) A relational database model is defined by its use of tables to store data and relationships between them. 25. Which of the following is NOT a basic term in database concepts? A) Entity. B) Relationships. C) Function. D) Attributes. Show Answer Correct Answer: C) Function. 26. Microsoft Access's data dictionary displays all of the following information about a field except the ..... A) Description of the field. B) Size of the field. C) Ownership of the field. D) Format of the field. Show Answer Correct Answer: C) Ownership of the field. 27. A table is known as ..... A) Entity. B) Tuple. C) Attribute. D) Relation. Show Answer Correct Answer: D) Relation. 28. Why are databases important for businesses? A) They allow businesses to make smart choices and plan for the future. B) They help in organizing physical files. C) They provide a list of all installed software. D) They only work in the cloud. Show Answer Correct Answer: A) They allow businesses to make smart choices and plan for the future. 29. What is 'knowledge' in the context of data processing? A) Knowledge is the physical storage of data. B) Knowledge is the insight gained from processing information. C) Knowledge is the raw facts without context. D) Knowledge is the same as data. Show Answer Correct Answer: B) Knowledge is the insight gained from processing information. 30. What are the cardinality and modality constraints in an entity-relationship model? A) They refer to the location and weight of the entities. B) They refer to the color and size of the entities. C) They refer to the number of instances of one entity that can be associated with the number of instances of another entity and whether the relationship between entities is mandatory or optional. D) They refer to the age and gender of the entities. Show Answer Correct Answer: C) They refer to the number of instances of one entity that can be associated with the number of instances of another entity and whether the relationship between entities is mandatory or optional. 31. While entering gender in a field, Rahul selects data type as Yes/No and sets caption as "Female?" . What will this do? A) Allow only numeric input. B) Accept long text. C) Provide checkbox for Female option. D) Filter female names. Show Answer Correct Answer: C) Provide checkbox for Female option. 32. A unique identifier for a table. It is a special case of a candidate key. A) Composite key. B) Unique key. C) Foreign key. D) Primary key. Show Answer Correct Answer: D) Primary key. 33. What does 'durability' ensure in ACID properties? A) Transactions are reversible. B) Data can be easily modified. C) Completed transactions remain persistent. D) Data is always accurate. Show Answer Correct Answer: C) Completed transactions remain persistent. 34. ASSERTION:-Drop command is used to delete a database. REASON:-Drop is an example of DDL. A) Both A and R are true and R is the correct explanation for A. B) Both A and R are true and R is not the correct explanation for A. C) A is True but R is False. D) A is false but R is True. Show Answer Correct Answer: B) Both A and R are true and R is not the correct explanation for A. 35. Application form can be a paper-based or electronic. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 36. What is the purpose of the ORDER BY clause in SQL? A) To group records that have the same values. B) To sort the result set in ascending or descending order. C) To join two or more tables. D) To filter records based on a condition. Show Answer Correct Answer: B) To sort the result set in ascending or descending order. 37. What is a query in the context of databases? A) A request for data or information from a database. B) A method for updating database records. C) A type of database management system. D) A tool for designing database schemas. Show Answer Correct Answer: A) A request for data or information from a database. 38. Which of the following correctly defines a database record? A) A column in a table. B) A summary of data. C) A single piece of information in a database. D) A collection of related fields in a row. Show Answer Correct Answer: D) A collection of related fields in a row. 39. What is the main goal of data modeling? A) Definition of entities, attributes, relationships, and constraints. B) Optimizing the performance of an information system. C) Standardization of internal and external data communication protocols. D) None of the above. Show Answer Correct Answer: A) Definition of entities, attributes, relationships, and constraints. 40. Which of the following is a component of a database system? A) Hardware. B) Software. C) Data. D) All of the above. Show Answer Correct Answer: D) All of the above. 41. Which of the following activities is NOT part of the requirements gathering process for database design? A) Creating Entity-Relationship Diagrams (ERDs). B) Conducting interviews with key stakeholders. C) Analyzing existing data and systems. D) Implementing database security measures. Show Answer Correct Answer: D) Implementing database security measures. 42. Which problem occurs in file systems when the same data is stored in multiple places? A) Data isolation. B) Integrity problems. C) Data redundancy and inconsistency. D) Security problems. Show Answer Correct Answer: C) Data redundancy and inconsistency. 43. What is a "field" in a database? A) A type of data structure. B) A single piece of information within a record. C) A secondary key. D) A collection of related records. Show Answer Correct Answer: B) A single piece of information within a record. 44. What is the purpose of a database index? A) To improve the speed of data retrieval. B) To increase the size of the database. C) To store additional information about the database. D) To make the database more complex. Show Answer Correct Answer: A) To improve the speed of data retrieval. 45. What is the third normal form (3NF) in database normalisation? A) A table that is in 2NF and has no transitive dependencies. B) A table that is in 2NF and has a single primary key. C) A table that is in 2NF and has all foreign keys removed. D) A table that is in 2NF and has no partial dependencies. Show Answer Correct Answer: A) A table that is in 2NF and has no transitive dependencies. 46. What is the purpose of a database view? A) To improve the speed of data retrieval. B) To increase the size of the database. C) To make the database more complex. D) To provide a simplified view of the database. Show Answer Correct Answer: D) To provide a simplified view of the database. 47. What is a foreign key? A) A key that is used to update records. B) A key that is used to encrypt data. C) A primary key from one table that appears in another table to link the two together. D) A key that is used to delete records. Show Answer Correct Answer: C) A primary key from one table that appears in another table to link the two together. 48. How do you filter records in a SQL query? A) Using the WHERE clause. B) Using the JOIN clause. C) Using the SELECT clause. D) Using the FROM clause. Show Answer Correct Answer: A) Using the WHERE clause. 49. What is a primary source of metadata? A) Query templates. B) Printed reports and memos. C) Business rules and data models. D) None of the above. Show Answer Correct Answer: C) Business rules and data models. 50. Which of the following is NOT a valid data type in MS Access? A) Memo. B) Hyperlink. C) Currency. D) Audio. Show Answer Correct Answer: D) Audio. 51. Which SQL statement is used to grant ALL privilege on the SUPPLIERS in the schema to the user 'Manager'? A) REVOKE ALL ON SUPPLIERS TO Manager. B) GRANT ALL ON SUPPLIERS TO Manager. C) CREATE USER ON SUPPLIERS TO Manager. D) GRANT ALL ON SUPPLIERS. Show Answer Correct Answer: B) GRANT ALL ON SUPPLIERS TO Manager. 52. Berikut ini perintah yang digunakan untuk menampilkan nama dan alamat dari tabelBUKU yang di urutkan berdasarkan alamat secara urut turun ..... A) Select nama, alamat from buku order by alamat asc;. B) Select nama, alamat from buku order by alamat desc;. C) Select nama.alamat from buku order by alamat desc;. D) Select nama, alamat from buku order by alamat;. E) Select nama.alamat from buku order by alamat asc;. Show Answer Correct Answer: B) Select nama, alamat from buku order by alamat desc;. 53. Rasheed is organizing his music collection on his computer. Each song has information like title, artist, album, and duration. In the context of a database, what would each song represent? A) A set of duplicate entries. B) A single column in a table. C) A collection of related data fields. D) A backup of the database. Show Answer Correct Answer: C) A collection of related data fields. 54. Which of the following is NOT a good design practice? A) Avoid calculated fields. B) Assign appropriate data types. C) Create identical key records. D) Use a dropdown for repeated values. Show Answer Correct Answer: C) Create identical key records. 55. What is the primary objective of database security? A) To prevent unauthorized access and disclosure of data. B) To prevent packet loss while transferring data. C) To provide secure access to public data. D) None of the above. Show Answer Correct Answer: A) To prevent unauthorized access and disclosure of data. 56. What does debugging involve? A) Correcting errors in the program. B) Converting machine code into source code. C) Writing source code. D) Drawing flowcharts. Show Answer Correct Answer: A) Correcting errors in the program. 57. Where does the DBMS store the definitions of data elements and their relationships? A) Index. B) Data dictionary. C) Data file. D) Data map. Show Answer Correct Answer: B) Data dictionary. 58. Which of the following is a benefit of using a DBMS? A) They provide seamless Internet access to database data. B) They help create an environment for centralized control. C) They provide full security to data using private/public key encryption. D) They create automatic queries. Show Answer Correct Answer: B) They help create an environment for centralized control. 59. When a school's database is password protected and only the principal can change marks, it shows: A) Data Normalization. B) Data Sharing. C) Data Security. D) Data Redundancy. Show Answer Correct Answer: C) Data Security. 60. Setelah membuat database 'siswa', perintah apa yang harus digunakan untuk memilih database tersebut agar dapat bekerja di dalamnya? A) SELECT siswa;. B) OPEN siswa;. C) ACTIVATE siswa;. D) USE siswa;. Show Answer Correct Answer: D) USE siswa;. Next →Related QuizzesScience QuizzesClass 11 QuizzesClass 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 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books