Answer / Navneet Shukla

"Database Keys are used to uniquely identify records within a table. There are four main types:
1. Primary Key: A column or group of columns that uniquely identifies each record in the table.
2. Foreign Key: A column or group of columns that refers to the primary key of another table, establishing a relationship between the two tables.
3. Candidate Key: A column or group of columns capable of serving as the primary key.
4. Composite Key: A combination of multiple columns used as the primary key."

What is rank in database?

1 Answers  

---

What do you understand by ‘atomicity’ and ‘aggregation’?

1 Answers  

---

Enlist the advantages of normalizing database.

1 Answers  

---

What do you understand by cursor?

1 Answers  

---

What is database development process?

1 Answers  

---

select Nth highest salary by using rownum

4 Answers   Ford, TCS, Tech Mahindra,

---

Mention some disadvantages of query?

1 Answers  

---

What are the elements of a database?

1 Answers  

---

What do you mean by deadlock dbms?

1 Answers  

---

What are the types of rdbms?

1 Answers  

---

Where the data file for system Tablespace is located? What is its name, initial size and maxsize?

1 Answers  

---

What is the best free database software?

1 Answers  

---