Answer Posted / nitin bisht

PRIMARY KEY: A tabLe can aontain only one PRIMARY KEY. It
Doesn't allow null values, it is used as Foreign Key In
Another Table(like Reference Key).

UNIQUE KEY: A Table may Contain one or more UNIQUE
constraints. Its aloow only one null value . Use this key We
maintain unique vales in the table.

FOREIGN KEY: A key used in one table to represent the value
of a primary key in a related table. While primary keys must
contain unique values, foreign keys may have duplicates. For
instance, if we use student ID as the primary key in a
Students table (each student has a unique ID), we could use
student ID as a foreign key in a Courses table: as each
student may do more than one course, the student ID field in
the Courses table (often shortened to Courses.student ID)
will hold duplicate values.

1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

2192

---

What is a sequence? Explain it with one example?

1183

---

What does new grouping sets enables you to do?

1033

---

define primary key index, bitmap index, hash index,virtual indwx

3319

---

What are different types of joins used in?

1104

---

How does non-cluster index functions?

1129

---

What is the purpose of firebase?

971

---

What are different types of data models available? Explain with example?

1089

---

How does database replication work?

992

---

What do you mean by database?

1074

---

What are different types of clusters present?

1075

---

What is the difference between specialization and generalization?

1023

---

What is the DIF format and when we will use in teradata

2488

---

How many types of normalization? What is the use of it?

1132

---

What is the role of tester in discovery(in Checklist)?

1970

---