This quiz works best with JavaScript enabled. Home > Class 11 > 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 (25 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. Disadvantages of the database A) > Everything is correct. B) Easier for a beginner to learn/use. C) Not very good for novice users. D) It can be much faster than typing on the keyboard. E) Damage to database affects virtually all applications programs. Show Answer Correct Answer: E) Damage to database affects virtually all applications programs. 3. Which command is used to remove entire a table? A) DROP. B) DELETE. C) TRUNCATE. D) REMOVE. Show Answer Correct Answer: A) DROP. 4. 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. 5. Swati uses Design View to build her table structure. What can she NOT do in this view? A) Set field size. B) Assign data type. C) Enter data records. D) Set primary key. Show Answer Correct Answer: C) Enter data records. 6. Repetition of data is called data ..... A) Dependance. B) Redundancy. C) Inconsistency. D) Isolation. Show Answer Correct Answer: B) Redundancy. 7. The command used to delete a particular column in a relation is ..... A) UPDATE TABLE. B) TRUNCATE COLUMN. C) ALTER, DROP. D) DELETE COLUMN. Show Answer Correct Answer: C) ALTER, DROP. 8. Data type used for age A) Text. B) Number. C) Date/Time. D) Yes/No. E) Currency. Show Answer Correct Answer: B) Number. 9. Which of the following best describes a table in a relational database? A) A collection of related records. B) A single data value. C) A set of unrelated attributes. D) A programming script. Show Answer Correct Answer: A) A collection of related records. 10. 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. 11. 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. 12. Which of the following combinations correctly shows all four key database objects? A) Field, Record, Report, Cell. B) Table, Form, Query, Report. C) Form, Graph, Query, Slide. D) Table, Data, Report, Field. Show Answer Correct Answer: B) Table, Form, Query, Report. 13. Which of the following is NOT a type of schema corresponding to the three levels in the ANSI-SPARC architecture A) Internal. B) Conceptual. C) Physical. D) External. Show Answer Correct Answer: B) Conceptual. 14. 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. 15. 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. 16. Charles Bachman created the first DBMS system? A) 1956. B) 1970. C) 1965. D) 1960. E) 1961. Show Answer Correct Answer: D) 1960. 17. What is the purpose of the CAST function in T-SQL? A) To convert data types. B) To create new tables. C) To delete records. D) To update data. Show Answer Correct Answer: A) To convert data types. 18. What is one of the basic functions of a query in a database? A) To delete data. B) To combine data from multiple tables. C) To encrypt data. D) To create new tables. Show Answer Correct Answer: B) To combine data from multiple tables. 19. 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. 20. 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. 21. What is a primary key? A) A method of data retrieval. B) A unique identifier for records in a table. C) A field that links to another table. D) A type of relationship. Show Answer Correct Answer: B) A unique identifier for records in a table. 22. 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. 23. 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. 24. Raj wants to store a student's date of birth in his database. What data type should he choose? A) Number. B) Date/Time. C) Memo. D) Yes/No. Show Answer Correct Answer: B) Date/Time. 25. 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. Next →Related 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 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