Interested to Buy Any Domain ? << Click Here >> for more details...
What are different types of Keys? Please explain all the
keys with a suitable example.
- 4 Answers
- 27215 Views
- I also Faced
- E-Mail Answers
Answer Posted / abdul malik(new college)
keys-A key allows us to identify a set of attributes and
thus distinguishes entities from each other.keys also help
uniquely identify relationships,and thus distinguishes
relation with each other.
different types of keys:
(i)super key
(ii)candidate key
(iii)primary key
(iv)unique key
(v)foreign key
sk-it is a set of one or more attributes that allows us to
identify uniquely an entity set.
ck-a super key for which no subset is a superkey is called
a candidate key.
pk-In a table pk does not take no repetation and does not
allow null values.
fk-it acts as a referential order.it refers one table from
the another one.
| Is This Answer Correct ? | 53 Yes | 9 No |
Post New Answer View All Answers
What command must you use to include the not null constraint after a table has already been created?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Suggest a method of joining two tables.
Please differentiate between a local and a global temporary table?
what is a self join? : Sql server database administration
You want to implement the one-to-one relationship while designing tables. How would you do it?
How can I get data from a database on another server?
What is transaction server distributed transaction?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is 1nf 2nf?
What does the update command do?
Which are the third-party tools used in sql server and why would you use them?
Explain Normalization and DE normalization
How can you insert values in multiple rows using one Insert statement?
What new changes are being made in SQL Server?
