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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the size of mysql database?
Does mysql use t sql?
How do I start mysql in mysql workbench?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
Where’s database data actually stored?
How to show all tables with 'mysql'?
How do I check mysql version?
How to Join tables on common columns.
How do I delete a mysql user?
What is 'mysqladmin' in mysql?
What is the phantom problem?
What is regex in mysql?
What is use of mysql?
What is the maximum connection pool size?
How to load data files into tables with 'mysqlimport'?