Answer / naz

A Candidate Key can be any column or a combination of
columns that can qualify as unique key in database. There
can be multiple Candidate Keys in one table. Each Candidate
Key can qualify as Primary Key.

A primary key is the column that uniquely identifies a
record. A primary key should be UNIQUE and never be NULL.

Answer / uday shankar dokku

candidate key: when we reduce unnecessary columns from a
super key it is called as candidate key
primary key: primary key is a constraint, in a table
there is only one primary key,a primary key is simple or
composite, a simple primary key is based on one column which
can be specified either inline outline of the constraint,a
composite primary key is based on (2-32)columns which can
be specified only out line of the constraint,a primary dose
not allows duplicates.

Answer / parijatha

there is no difference between the candidate and primary key
as both derives all other attributes in the relation.The
concept of primary key came into account to make the search
easy the is whenever a candidate key is declared as primary
key the primary key attribute gets sorted which reduces the
response time

What is denormalization and why would someone consider doing so?

0 Answers  

---

Explain the term entity in dbms?

0 Answers  

---

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

0 Answers   eBay,

---

What are the features of openedge features?

0 Answers  

---

Explain meant by 3-tier architecture?

0 Answers  

---

---

Define join types.

0 Answers  

---

Can Full Backup be performed when the database is open ?

1 Answers  

---

What is a SQL * NET?

2 Answers  

---

What is hashing in dbms?

0 Answers  

---

Differentiate nested loop, hash join and merge join.

0 Answers  

---

What are the SQL clauses supported in the link property sheet ?

1 Answers  

---

What is write ahead logging in DBMS?

0 Answers   HAL,

---