logo

CuriousTab

Difference between Candidate key and Primary key?

Discussion


Home Certification Oracle Certification Comments
Share: 

  • Question
  • Difference between Candidate key and Primary key?


  • Correct Answer
  • Candidate Key ? A Candidate Key can be any column or a combination of columns that can qualify as unique key in database There can be multiple Candidate Keys in one table Each Candidate Key can qualify as Primary Key Primary Key ? A Primary Key is a column or a combination of columns that uniquely identify a record Only one Candidate Key can be Primary Key One needs to be very careful in selecting the Primary Key as an incorrect selection can adversely impact the database architect and future normalization For a Candidate Key to qualify as a Primary Key, it should be Non-NULL and unique in any domain 

  • Tags: Software Architect, Project Manager, Network Engineer, IT Trainer, Database Administrator, Analyst
    Similar Questions
  • 1. What is the maximum number of triggers, can apply to a single table? Solve it....

  • 2. Which dml command is used in conjunction with @@identity? Solve it....

  • 3. What is Primary Key in DBMS? Solve it....

  • 4. You are choosing a Windows 2000 operating system to use on a new computer at your company. This new computer will be a heavily used SQL server in your enterprise network environment. which operating system should you choose? Solve it....

  • 5. You use two sites on your Windows 2000 network. You decide you want to manually specify a particular domain controller in each site that will be used for intersite replication. What should you do? Solve it....

  • 6. Why do you need common fields in a Database? Solve it....

  • 7. What is the output after compile and run the following code ? int Output = 10; boolean b = false; if((b == true) && ((Output += 10) == 20)) { System.out.println("We are equal " + Output); } else { System.out.println("Not equal! " + Output); } Solve it....

  • 8. In the following pieces of code, B and D will compile without any error. True or false ? A: StringBuffer sb1 = "abcd"; B: Boolean b = new Boolean("abcd"); C: byte b = 255; D: int x = 0x1234; E: float fl = 1.2; Solve it....

  • 9. Define Executive Plan in Database SQL ? Solve it....

  • 10. Insert command falls in which sub-language of SQL ? Solve it....


  • Comments

    There are no comments.

Enter a new Comment