ЁЯУв Too many exams? DonтАЩt know which one suits you best? Book Your Free Expert ЁЯСЙ call Now!
  • google app store apple app store
    • тЬЦ

      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