How primary key is implemented in Oracle?



How primary key is implemented in Oracle?..

Answer / Mukesh Kumar Sinha

A primary key in Oracle is a column or set of columns that uniquely identifies each record in a table. It enforces the rule that no two records can have the same value for the primary key columns. To create a primary key, the CREATE TABLE statement includes the PRIMARY KEY keyword followed by the column name(s). For example: "CREATE TABLE Employees ( Employee_ID PRIMARY KEY, First_Name VARCHAR2(20), Last_Name VARCHAR2(25));"

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Advanced Java Interview Questions

What is the O/P of the below Code Snippet ? And how does it imply the concept of call-by-value/call-by-reference. (Note : Pls ignore syntx errors) public class One { sop ("Into One--"); } public class Two extends One{ sop ("Into Two--"); } public class Home { One a; Two t; public static void main(argv[]) { sop ("In Home--"); sop(One.a); sop(Two.a); sop(One.t); sop(Two.t); } }

2 Answers   Wipro,


What is meant by method chaining?

1 Answers  


A user of a web application sees a jsessionid argument in the URL whenever a resource is accessed. What does this mean? a. The form must have the field jsessionid b. URL rewriting is used as the session method c. Cookies are used for managing sessions

1 Answers  


What is the difference between static and non-static with examples?

1 Answers   HCL,


How would you create a button with rounded edges?

1 Answers  


What is multithread synchronizing ?

4 Answers   Sun Microsystems,


What is RRL?

1 Answers  


What is the purpose of the notifyall() method?

1 Answers  


can a static method be overridden

41 Answers   IBM, SolutionNET,


How would you reatach detached objects to a session when the same object has already been loaded into the session?

1 Answers  


What is the return type of interrupt method?

2 Answers  


can any one tell me how to learn good coding techniques

3 Answers  


Categories