Answer / Vivek Vikas Rai

The INFORMATION_SCHEMA is a virtual catalog view provided by SQL to enable portable SQL applications. It provides a common, standardized way of accessing metadata about the database objects and their relationships across different databases.

What is character functions?

1 Answers  

---

Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,

---

What is difference between cursor and ref cursor?

1 Answers  

---

find the third highest salary?

23 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

What are the two types of exceptions.

1 Answers  

---

How to Declare Fixed Length String Value In PL SQL

1 Answers  

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1 Answers  

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

Why do you partition data?

1 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

What is dba in sql? : SQL DBA

1 Answers  

---