Answer Posted / charu gautam

primary key:- the primary key of a relational table uniquely
identifies each record in the table. it can either be a
normal attribute that is guaranteed to be unique . such as
social security number in a table with no more than record
per person or it can be generated by the D B M S .such as a
globally unique identifier ,or G U I D, in microsoft SQL
server primary key may consist of a single attribute or
multiple attribute in combination.

foreign key:- A foreign key is a field (or fields) that
points to the primary key of another table.The purpose of
the foreign key is to ensure referential integrity of the
data.In other words ,only values that are supposed to appear
in the database are permitted.

What are database connection details?

1100

---

A lowest level of security by most RDBMS is

1109

---

Explain entity type?

952

---

Explain the record term used in database.

1028

---

What are the various ways to execute a query in teradata?

2561

---

What is ole db in ssis?

1025

---

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1698

---

how can we view column head in first page but not in remaining pages?

1995

---

What is ase database?

972

---

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2507

---

What will happen non-clustered index will be created on clustered index?

998

---

How to shrink a database?

942

---

can u combine pipeline parallelism and partition parallalism? how and whan?

2284

---

What is dialect in database?

942

---

Display the employees whose salary is less than average salary.

1024

---