how do you know the version of your mysql server? : Sql dba

0 Answers  

---

is it possible to pass an object or table to a procedure as an argument?

0 Answers  

---

What are the different schemas objects that can be created using pl/sql?

0 Answers  

---

What are character functions?

0 Answers  

---

Explain the methods used to protect source code of pl/sql.

0 Answers  

---

what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

---

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,

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

Which is better varchar or nvarchar?

0 Answers  

---

How does a covering index work?

0 Answers  

---