📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    Question

    Which of the following statements accurately describes

    the characteristics of a primary key in a relational database?
    A A primary key can accept duplicate values as long as it is unique within the table. Correct Answer Incorrect Answer
    B A primary key is used to establish a link between two tables by referencing the foreign key in another table. Correct Answer Incorrect Answer
    C A primary key can be composed of multiple columns, and each combination of these columns must be unique across the table. Correct Answer Incorrect Answer
    D A primary key can be null if the table has other unique constraints. Correct Answer Incorrect Answer
    E A primary key is used solely for indexing purposes and does not enforce any uniqueness or integrity constraints. Correct Answer Incorrect Answer

    Solution

    A primary key is a critical concept in relational databases, ensuring that each record within a table can be uniquely identified. The primary key has the following key characteristics: • Uniqueness: Each value of a primary key must be unique across the entire table. No two rows can have the same primary key value. • Non-nullable: A primary key must always have a value; it cannot be null. This is essential for maintaining the integrity of the database as it ensures that every record can be uniquely identified.

    Practice Next
    More IT Operating System Questions
    ask-question