How many aggregate functions are available there in sql?

0 Answers  

---

How do you optimize a stored procedure in sql?

0 Answers  

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

Define commit?

0 Answers  

---

How do you concatenate in sql?

0 Answers  

---

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

---

What are sql procedures?

0 Answers  

---

How do I add a primary key to a table?

0 Answers  

---

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

---

What is the difference between row level and statement level trigger?

0 Answers  

---

What is mutating table error?

0 Answers  

---