What are two virtual tables available during database trigger execution ?

2 Answers  

---

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 primary key and unique key?

0 Answers  

---

what is pragma ?

1 Answers   Polaris,

---

Explain two easy sql optimizations.

0 Answers  

---

---

Is truncate ddl or dml?

0 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

Write a query to display the current date in sql?

0 Answers  

---

What is the use of stored procedures?

0 Answers  

---

How to fetch common records from two tables?

1 Answers  

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

Is mariadb nosql?

0 Answers  

---