a
askaideAI
Log in
— CHAPTER MASTERY · CLASS 12

Database Concepts Important Questions.

Master Database Concepts with AI-powered practice. Our adaptive tutor identifies your gaps and provides step-by-step explanations for every topic in this chapter.

Exam-Ready Questions

Practice questions specifically designed for CBSE Class 12 Computer Science board exams. Covers all difficulty levels from basic to advanced.

Instant AI Doubts

Stuck on a tricky concept in Database Concepts? Our AI tutor provides immediate, step-by-step explanations 24/7.

Adaptive Practice

The difficulty adjusts as you learn. Master foundations first, then move to challenging board-level problems.

Database Concepts — Important Questions with Answers

Practice these Database Concepts questions for Class 12 Computer Science, each with the correct answer and a step-by-step explanation. Sign up free to practice all 25+ questions with adaptive difficulty.

  1. Q1Medium

    Which of the following is NOT a property of a relation in the relational data model?

    • A.Sequence of attributes is immaterial
    • B.Each tuple must be unique
    • C.Sequence of tuples is material
    • D.Each attribute has a unique name
    Answer: Sequence of tuples is material

    Explanation: In the relational data model, the sequence of tuples is immaterial, meaning the order of tuples does not affect the integrity or meaning of the data. Other properties include uniqueness of tuples, attribute uniqueness, and immaterial sequence of attributes.

  2. Q2Medium

    What is the cardinality of a relation with 7 tuples?

    • A.Number of attributes
    • B.Number of domains
    • C.7
    • D.Degree of the relation
    Answer: 7

    Explanation: Cardinality refers to the number of tuples in a relation. If a relation has 7 tuples, its cardinality is 7. This is a fundamental concept in relational databases.

  3. Q3Medium

    Which of the following is an example of a composite primary key?

    • A.GUID alone
    • B.{RollNumber, AttendanceDate}
    • C.AttendanceDate alone
    • D.StudentName
    Answer: {RollNumber, AttendanceDate}

    Explanation: A composite primary key consists of multiple attributes combined to uniquely identify tuples. In the ATTENDANCE relation, {RollNumber, AttendanceDate} is used as a composite primary key because neither attribute alone can uniquely identify a tuple.

  4. Q4Medium

    What is the primary purpose of a foreign key in a relational database?

    • A.To uniquely identify tuples within a table
    • B.To enforce data types
    • C.To establish relationships between tables
    • D.To ensure data consistency within a single table
    Answer: To establish relationships between tables

    Explanation: A foreign key is used to create a link between two tables by referencing the primary key of another table. This helps maintain referential integrity and establish relationships between related data.

  5. Q5Medium

    Which of the following is NOT a limitation of file systems?

    • A.Data redundancy
    • B.Data inconsistency
    • C.Centralized data sharing
    • D.Difficulty in accessing data
    Answer: Centralized data sharing

    Explanation: File systems suffer from issues like data redundancy, inconsistency, and lack of controlled data sharing. Centralized data sharing is a feature of Database Management Systems (DBMS), not file systems.

  6. Q6Medium

    What is the degree of a relation with the attributes: StudentID, StudentName, Age, and Address?

    • A.2
    • B.3
    • C.4
    • D.5
    Answer: 4

    Explanation: The degree of a relation is the number of attributes it contains. Here, the relation has four attributes: StudentID, StudentName, Age, and Address.

  7. Q7Medium

    Which of the following is an example of an alternate key?

    • A.GUID
    • B.GName
    • C.GPhone, if GUID is the primary key
    • D.GAddress
    Answer: GPhone, if GUID is the primary key

    Explanation: An alternate key is any candidate key that is not chosen as the primary key. In the GUARDIAN relation, if GUID is the primary key, GPhone would be an alternate key.

  8. Q8Medium

    What does the NULL value in a database represent?

    • A.Missing data
    • B.Zero value
    • C.Unknown or non-applicable data
    • D.Default value
    Answer: Unknown or non-applicable data

    Explanation: The NULL value is used in databases to indicate that the data for a particular attribute is either unknown or not applicable for a specific tuple.

  9. Q9Medium

    Which of the following is NOT a characteristic of a relational database?

    • A.Data is organized into tables
    • B.Data is stored in a hierarchical structure
    • C.Relationships are established using keys
    • D.Data integrity is maintained through constraints
    Answer: Data is stored in a hierarchical structure

    Explanation: Relational databases organize data into tables (relations) with rows and columns, not hierarchical structures. Hierarchical data structures are more typical of tree-based systems.

  10. Q10Medium

    What is the primary advantage of using a database over a file system?

    • A.Easier data retrieval
    • B.Reduced redundancy
    • C.No need for data constraints
    • D.Hierarchical data structure
    Answer: Reduced redundancy

    Explanation: Databases reduce redundancy by storing data in a structured format and linking related data through keys, thereby minimizing duplication and inconsistencies.

  11. Q11Medium

    Which of the following is an example of a database constraint?

    • A.Hierarchical structure
    • B.NOT NULL
    • C.Data redundancy
    • D.Data isolation
    Answer: NOT NULL

    Explanation: Database constraints ensure data integrity. NOT NULL is a constraint that enforces the presence of a value in a specified column.

  12. Q12Medium

    Why is the sequence of tuples in a relation immaterial?

    • A.It affects data retrieval speed
    • B.It is required for primary key identification
    • C.The order of tuples does not affect data integrity
    • D.It is necessary for data normalization
    Answer: The order of tuples does not affect data integrity

    Explanation: In relational databases, the order of tuples does not influence the correctness or meaning of the data. Tuples are considered unordered sets of data.

Practice all 25+ Database Concepts questions — free

Start Free Practice

Why practice Database Concepts on AskAide?

Preparing for board exams requires more than just reading Database Concepts from the textbook. You need to apply concepts to different types of problems. AskAide's AI-powered platform makes this process seamless for Class 12 students.

Our question bank for Database Concepts is generated from the NCERT chapter text itself, so every question stays inside the syllabus. Whether it's complex numericals or conceptual theory, our AI tutor helps you break down every problem.

  • Unlimited practice questions for Database Concepts
  • Personalized feedback on your weak areas
  • NCERT-aligned curriculum for Computer Science
  • Free access for students across India

Ready to ace your exams?

Students across India are already practising their chapters on AskAide — free during early access.

Try for free now
Menu