logo

CuriousTab

What is Primary Key in DBMS?

Discussion


Home Certification Oracle Certification Comments
Share: 

  • Question
  • What is Primary Key in DBMS?


  • Correct Answer
  • A primary key is a special relational database table column or combination of columns designated to uniquely identify all table records That is, A primary key is a column or set of columns in a table that uniquely identifies tuples (rows) in that table A primary key, also called a Primary Keyword Main Features Primary key are :: It must contain a unique value for each row of data It cannot contain null values 

  • Tags: Database Administrator, IT Trainer, Software Architect
    Similar Questions
  • 1. 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....

  • 2. 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....

  • 3. What is the default optimization setting for the Server service on Windows 2000 Server computers? Solve it....

  • 4. You would like to use the command line to end an application that a Terminal Services client is running. What command can you use? Solve it....

  • 5. When you run Sysprep on a Windows 2000 computer, what happens to the user-specific information on the computer? Solve it....

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

  • 7. What is the maximum number of triggers, can apply to a single table? Solve it....

  • 8. Difference between Candidate key and Primary key? Solve it....

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

  • 10. 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....


  • Comments

    There are no comments.

Enter a new Comment