Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

---

Explain about various levels of constraint.

0 Answers  

---

What is sap sql anywhere?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

---

how to enter numeric values as hex numbers? : Sql dba

0 Answers  

---

How many levels can subqueries be nested in a FROM clause?

7 Answers  

---

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

What is difference between pls_integer and integer?

0 Answers  

---