Answer Posted / saravanan

there are two type of triggers
1.application trigger

2.Database trigger

What are sql queries used for?

756

---

Does view contain data?

783

---

How much does sql cost?

730

---

What are transaction and its controls?

731

---

differentiate between float and double. : Sql dba

748

---

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

769

---

How many scalar data types are supported in pl/sql?

709

---

What is the difference between microsoft sql and mysql?

705

---

What is sqlcommand?

746

---

Which are the different case manipulation functions in sql?

728

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6576

---

What can you do with pl sql?

762

---

How do we accept inputs from user during runtime?

725

---

How do I count rows in sql?

734

---

How to rename a table?

751

---