Q11. Which of the following will help to maintain unique record in the table?
Q12. Which of the following field of table "Book" can act as primary key?
Q13. When primary key is made up of two or more columns then it is called ____________ primary key
Q14. Duplicate values can be entered in primary key.(T/F)
Q15. A key which is referring to the primary key of another table is called ____________
Q16. A field which is ___________ for each and every record is called Primary key.
Q17. When data is stored, maintained and retrieved from multiple tables then special database software are required called ________
Q18. Identify the Foreign Key from table "Sales"
Table Client:
ClientID (primary Key)
clientname
clientphone
Table : Sales
SalesID (Primary Key)
ClientID
Profit
Q19. Which of the following is not valid field of table "Student"
Q20. There can be multiple primary key in a table.(T/F)
When primary key is made up of two or more columns then it is called composite primary key. So why cant there be multiple primary key in a table? 20th question.
A table can only ever have a one primary key. It is not possible to create a table with two different primary keys. You can create a table with two different unique indexes (which are much like a primary key) but only one primary key can exist.
There is only one primary key
and primary key itself is unique
Normally there should be only one primary key in a table. But if u want 2 then there are options to make 2 primary keys. Both should be unique as well
You are wrong