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.

Which tcp/ip port does sql server run on? How can it be changed?

1044

---

How to link tables in sql server?

938

---

What is the use of floor function in sql server?

1084

---

How to perform backup for certificates in sql server? : sql server security

1096

---

where the connection string store in the database

2074

---

Does server sql treat char as a variable-length or fixed-length column?

1044

---

What does it mean if @@cursor_row returns a negative number?

995

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1594

---

Is sql server free?

921

---

Do you know exporting and importing utility?

1046

---

how you can deploy an ssrs report?

178

---

What are the differences between local and global temporary tables?

1087

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

992

---

How many databases instances are there in sql server 2000?

1102

---

What is the difference between getdate and sysdatetime?

1014

---