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 many columns should be in an index?

0 Answers  

---

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

What is the current version of sql?

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

---

What is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---

Is primary key always clustered index?

0 Answers  

---

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

31 Answers   A1 Technology, Wipro,

---

How do I count rows in sql query?

0 Answers  

---

How do you delete a table?

0 Answers  

---

What are the different set operators available in sql?

0 Answers  

---

what are aggregate and scalar functions? : Sql dba

0 Answers  

---