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
What are the different subsets of sql?
How many non clustered indexes there can be on table ?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is normalization process?
Explain what is log shipping?
How to select all columns of all rows from a table with a select statement in ms sql server?
State a few properties of relational databases?
What do you mean by an execution plan? How would you view it?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What can be used instead of trigger?
Is mysql the same as sql server?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Write a program using SQL queries to find a unique entry in a table.
What is a data source file?
Does windows server 2016 come with sql server?