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 an indexing strategy?
Tell me what is fill factor?
What are ddl (data definition language) statements for tables in ms sql server?
What are unicode character string data types in ms sql server?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
List the different types of collation sensitivities in sql server?
Explain full-text query in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Explain system functions or built-in functions? What are different types of system functions?
Explain where clause?
Explain what is lock escalation and what is its purpose?
What happens when transaction log is full?
Can we write a distributed query and get some data which is located on other server and oracle database?
Write down the syntax and an example for create, rename and delete index?