Database Concept Class 11 MCQ
Q1. ___________________ maintains data about its students, along with their attendance record and guardian details.
a. Hostel
b. Hospital
c. Bank
d. School
Q2. The class teacher marks daily attendance of the students in the attendance register. The teacher records ‘P’ for present or ‘A’ for absent. If class strength is 50 and total working days in a month are 26, the teacher needs to write _________ records manually in the register every month.
a. 50 + 26
b. 50 – 26
c. 50 * 26
d. 50 / 26
Q3. “Loss of data, in case if attendance register is lost or damaged” This is limitation of _______
a. Manual Data Entry
b. Electronic Data Entry
c. Both of the above
d. None of the above
Q4. Finding information from a huge volume of papers or deleting/modifying an entry is a difficult task in ____
a. Manual Data Entry
b. Electronic Data Entry
c. Both of the above
d. None of the above
Q5. Which of the following is an advantage of storing data in computerized systems?
a. Easy to find any data.
b. Adding more records to existing data
c. Deleting any record from existing data.
d. All of the above
Q6. A ___________ can be understood as a container to store data in a computer.
a. Operating System
b. Database
c. File
d. Software
Q7. Files are stored on the ______ of a computer system.
a. Hard Disk
b. Software
c. Desktop
d. Freeware
Q8. Contents of a file can be ____________
a. Text
b. Computer Program Code
c. Comma Separated Value
d. All of the above
Q9. ______ becomes difficult to handle when number of files increases and volume of data also grows.
a. File system
b. Folder System
c. Database
d. Data
Q10. Data in a file system are accessed through ___________.
a. Antivirus
b. System Programs
c. Application Programs
d. Microsoft Word
Database Concept Class 11 MCQ
Click here to test yourself on Database Concept Class 11 MCQ Questions
Database Concept Class 11 MCQ
Q11. _______ means same data are duplicated in different places (files).
a. Redundancy
b. Consistency
c. Inconsistency
d. Foreign Key
Q12. Redundancy leads to excess storage use and may cause _____.
a. Data Consistency
b. Data Inconsistency
c. Data Filter
d. None of the above
Q13. When same data is maintained in different places and do not match. This is called ________
a. Data Consistency
b. Data Inconsistency
c. Data Filter
d. Data Isolation
Q14. If the structure of a file is changed, all the existing application programs accessing that file also need to be change. Otherwise, the programs may not work correctly. This is called __________
a. Data Consistency
b. Data Inconsistency
c. Data Dependency
d. Data Isolation
Q15. Which of the following is limitation of a File System?
a. Difficulty in Access
b. Data Redundancy
c. Data Inconsistency
d. All of the above
Q16. Limitations faced in file system can be overcome by storing the data in a ______ where data are logically related.
a. Microsoft Word
b. Microsoft Excel
c. DBMS
d. Microsoft PowerPoint
Q17. DBMS stands for _____________
a. Database Management System
b. Database Manager System
c. Database Management Software
d. Data Management System
Q18. Name a software that can be used to create and manage databases.
a. DSBM
b. DMBS
c. DBMS
d. DBSM
Q19. Example of open source DBMS is __________
a. Oracle
b. MySQL
c. Microsoft Access
d. MongoDB
Q20. Real life application of DBMS is __________
a. Banking
b. Inventory Management
c. Online Shopping
d. All of the above
Database Concept Class 11 MCQ
Click here to test yourself on Database Concept Class 11 MCQ Questions
Database Concept Class 11 MCQ
Q21. We know that tables in a database are linked or related through one or more common columns or fields. This common field is called _______
a. Primary Key
b. Foreign Key
c. Alternate Key
d. Candidate Key
Q22. _________ maintains a single repository of data at a centralised location that can be used by multiple users at the same time.
a. DBMS
b. Microsoft Word
c. Microsoft Excel
d. Open Office Calc
Q23. ______ represents the design or structure of a database.
a. Data Constraint
b. Data Dictionary
c. Database Schema
d. Database Instance
Q24. _______ is also called the visual or logical architecture as it tells us how the data are organised in a database.
a. Data Constraint
b. Data Dictionary
c. Database Schema
d. Database Instance
Q25. Sometimes we put certain restrictions or limitations on the type of data that can be inserted in one or more columns of a table. These restriction is called ____________
a. Data Constraint
b. Data Dictionary
c. Database Schema
d. Database Instance
Q26. _______ are used to ensure accuracy and reliability of data in the database.
a. Data Constraint
b. Data Dictionary
c. Database Schema
d. Database Instance
Q27. A _____ is data about the data.
a. Data Constraint
b. Data Dictionary
c. Meta Data
d. Database Instance
Q28. Meta data is also known as ___________
a. Data Constraint
b. Data Dictionary
c. Database Schema
d. Database Instance
Q29. Which of the following is not the data constraint in DBMS?
a. Not Null
b. Unique
c. Distinct
d. Primary Key
Q30. After loading data, the state or snapshot of the database at any given time is the ___________.
a. Database Instance
b. Meta Data
c. Data Constraint
d. Database Schema
Database Concept Class 11 MCQ
Click here to test yourself on Database Concept Class 11 MCQ Questions
Database Concept Class 11 MCQ
Q31. A database schema can have different instances at different times.(T/F)
a. True
b. False
Q32. A _____ is a request to a database for obtaining information in a desired way.
a. Form
b. Query
c. Report
d. Table
Q33. Query is used to fetch data from __________
a. One table only
b. Two tables only
c. Three tables only
d. One or more tables
Q34. Which of the following operation is not the part of Manipulation of Database?
a. Insert new record
b. Delete an existing record
c. Modify/Update an existing record
d. Display specific records
Q35. Suppose Atharv’s Guardian has changed his mobile number, his Guardian Phone number needs to be modified in GUARDIAN file. This is called _____ operation
a. Delete
b. Update
c. Insert
d. Display
Q36. ________ is the set of programs used by a DBMS to create database and handle various queries for data retrieval and manipulation.
a. Database constraint
b. Meta data
c. Database engine
d. Data dictionary
Q37. Identify the limitations of DBMS.
a. Increased Complexity
b. Increased data vulnerability
c. Both of the above
d. None of the above
Q38. The most commonly used data model is _______.
a. Relational Data Model
b. Object-Oriented Data Model
c. Entity-Relationship Data Model
d. Document Model
Q39. Identify the odd one out.
a. Relational Data Model
b. Object-Oriented Data Model
c. Tree Data Model
d. Hierarchical Data Model
Q40. In DBMS, we can retrieve and manipulate data through _______
a. Form
b. Query
c. Report
d. Table
Database Concept Class 11 MCQ
Click here to test yourself on Database Concept Class 11 MCQ Questions
Database Concept Class 11 MCQ
Q41. In relational data model, tables are called _______________
a. Relations
b. Related Data
c. Relational
d. Relation Model
Q42. Each column name in a table should be unique. (T/F)
a. True
b. False
Q43. A row in a table is also known as _________
a. Record
b. Tuple
c. Both of the above
d. None of the above
Q44. A column in a table is also known as ___________
a. Attributes
b. Field
c. Both of the above
d. None of the above
Q45. Number of columns in a table is known as ______
a. Cardinality
b. Degree
c. Attributes
d. Tuples
Q46. Number of rows in a table is known as ______
a. Cardinality
b. Degree
c. Attributes
d. Tuples
Q47. ______ is a set of values from which an attribute can take a value in each row.
a. Degree
b. Cardinality
c. Domain
d. Attribute
Q48. A relation has 3 rows and 5 columns. What is the degree and cardinality of this relation?
a. Degree – 5 and Cardinality – 3
b. Degree – 5 and Cardinality – 5
c. Degree – 3 and Cardinality – 3
d. Degree – 3 and Cardinality – 5
Q49. Which of the following statement is wrong?
a. Each attribute in a relation has a unique name.
b. Sequence of attributes in a relation is immaterial
c. All data values in an attribute is not of same data type.
d. Sequence of tuples in a relation is immaterial.
Q50. A special value ________ is used to represent values that are unknown to certain attributes.
a. None
b. Null
c. Unknown
d. No
Database Concept Class 11 MCQ
Click here to test yourself on Database Concept Class 11 MCQ Questions
Database Concept Class 11 MCQ
Q51. Those field which can act as a primary key is called _____
a. Foreign Key
b. Alternate Key
c. Candidate Key
d. Composite Primary Key.
Q52. The relation EMPLOYEE has four attributes out of which EMPID and EMP_PHONE always take unique values. No two employees will have same phone number or same employee id. Hence, these two attributes are the ________________ keys as they both are candidates for ____________ key
a. Composite, Primary
b. Primary, Candidate
c. Candidate, Primary
d. Foreign, Primary
Q53. Out of one or more candidate keys, the attribute chosen by the database designer to uniquely identify the tuples in a relation is called the _____ of that relation.
a. Primary Key
b. Foreign Key
c. Composite Primary Key
d. Alternate Key
Q54. The relation EMPLOYEE has four attributes out of which EMPID and EMP_PHONE are the candidates for Primary Key. The database designer choose EMP_ID as primary key then the remaining candidate key (EMP_PHONE) is called _________
a. Foreign Key
b. Candidate Key
c. Primary Key
d. Alternate Key
Q55. Primary key consisting of more than one attribute is called _________.
a. Composite Primary key
b. Compost Primary key
c. Combined Primary key
d. Campsite Primary key
Q56. Which of the following is most suitable primary key in table “STUDENT”?
a. Roll_number
b. Admission_number
c. Name
d. Class
Q57. A _______________ is used to represent the relationship between two relations.
a. Primary Key
b. Alternate Key
c. Foreign Key
d. Candidate Key
Q58. A Foreign Key is an attribute whose value is derived from the _________ of another relation
a. Primary Key
b. Alternate Key
c. Foreign Key
d. Candidate Key
Q59. A Foreign Key can take NULL values. (T/F)
a. False
b. True
Q60. A Primary Key can take NULL values. (T/F)
a. False
b. True
Database Concept Class 11 MCQ
Click here to test yourself on Database Concept Class 11 MCQ Questions
Database Concept Class 11 MCQ
Database Concept Class 11 MCQ
Chapter Wise MCQ
2. Flow of Control (Loop and Conditional statement)
3. 140+ MCQ on Introduction to Python
4. 120 MCQ on String in Python
7. 100+ MCQ on Flow of Control in Python
8. 60+ MCQ on Dictionary in Python
Important Links
100 Practice Questions on Python Fundamentals
120+ MySQL Practice Questions
90+ Practice Questions on List
50+ Output based Practice Questions
100 Practice Questions on String
70 Practice Questions on Loops
70 Practice Questions on if-else
Disclaimer : I tried to give you the correct MCQ of ” Database Concept Class 11” , but if you feel that there is/are mistakes in the MCQ of “Database Concept Class 11 “ given above, you can directly contact me at csiplearninghub@gmail.com.