What is difference b/w composit key n primary key and
forigion key?
Answer Posted / saraswathi muthuraman
Compost key :
More than one column will be used to create compst key
SQL> create table ts_250 (a number,b number,c number,
primary key(a,c));
Table created.
here column A and column C is used to create compst key.
U can't insert null value in both columns.
Only unique combination of column A and column B value can
be inserted.
Primary key :
Key will be created on a single column in table.
SQL> create table ts_251 (a number,b number,c number,
primary key(a));
Table created.
null value cann't be inserted into column a.
oracle will create a index
only unique value can be inserted into column a.
only one primary key can be created on a table
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Why is mysql used?
How does mysql store dates?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
How do I rename a table in mysql workbench?
Is mysqli deprecated?
How do I find the size of a mysql database?
How to show table structure mysql?
What is trigger in mysql?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
Where is mysql data stored linux?
What are the advantages and disadvantages of using mysql?
How show all tables in mysql query?
What is blob and text in mysql?
How do I use mysql?
How do you create a primary key?