Answer / Naveen Prasad Meena

MySQL has several potential disadvantages compared to other databases:n
1. Performance issues: MySQL can experience performance degradation when handling a large number of concurrent connections or complex queries.n
2. Limited built-in functionality: Compared to other database systems, MySQL offers fewer built-in functions and features for handling advanced data management tasks.n
3. Limited support for transactions: MySQL has limited support for multi-row transactions. This can cause issues in applications that require complex transaction management.n
4. Data consistency concerns: In some cases, MyISAM tables do not support row-level locking, which may lead to data inconsistencies during concurrent write operations.

Why do we need a foreign key?

1 Answers  

---

What is audit logout in sql profiler?

1 Answers  

---

What are hotfixes and patches?

1 Answers  

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---

Can we create index on primary key?

1 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

What is the advantage of index in sql?

1 Answers  

---

What is synchronized subquery?

1 Answers  

---

What are the parts of a sql statement?

1 Answers  

---

Differentiate between pl/sql and sql?

1 Answers  

---

what is 'trigger' in sql? : Sql dba

1 Answers  

---

Can we use update in sql function?

1 Answers  

---