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,

---

What is union?

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  

---

Do foreign keys improve performance?

0 Answers  

---

what are date and time data types? : Sql dba

0 Answers  

---

Which table is left in join?

0 Answers  

---

difference between pl/sql table and normal pl/sql table

2 Answers  

---

what is a primary key? : Sql dba

0 Answers  

---

Explain the purpose of %type and %rowtype data types?

0 Answers  

---

explain advantages of innodb over myisam. : Sql dba

0 Answers  

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

What is dense_rank in sql?

0 Answers  

---