What is Primary key and foreign key? Give an example
Answer Posted / alquama rizvi
MS-Access requires a special way of recognising every record of a table. For this you have to set or make a primary key. If you do not do so, MS-Access does this itself by adding a new field , serving as the primary key. A table may have only one primary key, although it may have more than one fields.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What you can do to delete a table without the delete trigger firing?
How to write character string constants or literals in ms sql server?
what is the different types of backups available in sql server? : Sql server database administration
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What happens if null values are involved in bitwise operations?
what is datawarehouse?
Define clusters?
What are “lost updates”?
Write a SQL query to delete a table?
What are examples of triggers?
How check triggers in sql server?
What is the command used to recompile the stored procedure at run time?
What is the distinction amongst delete and truncate?
What is correlated subquery in sql server?