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
What is a trigger? Why we need it?
Define left outer join?
What are functions in the sql server?
Explain Capacity planning to create a database? and how to monitor it?
How you can minimize the deadlock situation?
How to query multiple tables jointly?
What is the process of normalization?
Name the different type of indexes in sql?
How to enter date and time literals in ms sql server?
Can you explain what are various ways to enhance the ssrs report?
What is database architecture? : SQL Server Architecture
What is partition index in sql server?
Is it ok to shrink transaction log?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Explain the rules for designing files and file groups in sql server?