Answer Posted / nevual
Primary keys are the unique identifiers for each row. They
must contain unique values and cannot be null. Due to their
importance in relational databases, Primary keys are the
most fundamental of all keys and constraints. A table can
have only one Primary key.
Foreign keys are both a method of ensuring data integrity
and a manifestation of the relationship between tables.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Define candidate key, alternate key, and composite key.
What is the difference between rank and dense_rank?
What are the differences between local and global temporary tables?
How do you migrate data from mssql server to azure?
What is the command used to check locks in microsoft sql server?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
Explain filtered indexes?
Explain the architecture of ms sql reporting service?
what's the information that can be stored inside a bit column? : Sql server database administration
How will you hide an attribute? : sql server analysis services, ssas
What is a fill factor?
What are the advantages of sql stored procedure?
How to create a local temporary stored procedure?
What is difference between group by and having?
How to change the ownership of a schema in ms sql server?