Answer Posted / sowmya k
Yes we can create a primary key without creating the Unique
key. The primary key concept is same similar to the unique
key. We can set primary key to only one column, but a
unique key constraint can be set to more then one column.
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
Is primary key always clustered index?
What is string join?
What is rename in sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Can there be 2 primary keys in a table?
Can we commit inside a trigger?
What is the use of primary key?
How do I run a pl sql procedure in sql developer?
Write a unique difference between a function and a stored procedure.
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is the difference between left and left outer join?
What is pl sql code?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
How to Declare Fixed Length String Value In PL SQL
Is a secondary key the same as a foreign key?