Answer / Princy Verma

In MySQL, there are several types of tables available. Here are some commonly used ones:n
1. InnoDB tables:nThese are the default tables in MySQL and support ACID properties.n
2. MyISAM tables:nMyISAM is an older storage engine that doesn't support transactions, but offers faster read performance than InnoDB.n
3. MEMORY (HEAP) tables:nThese are stored entirely in memory for faster performance and are ideal for small tables or temporary data.n
4. Archive tables:nArchive tables are optimized for storing large amounts of data, but with slower write performance.

How many sql statements are used?

1 Answers  

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

1 Answers  

---

Why trigger is used in sql?

1 Answers  

---

What is difference between function and trigger?

1 Answers  

---

What are sql constraints?

1 Answers  

---

What are functions in sql?

1 Answers  

---

how to return query output in html format? : Sql dba

1 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

Do you understand the meaning of exception handling?

3 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

Can we write dml inside a function in sql server?

1 Answers  

---