Answer Posted / nilam

SQL aggregate functions return a single value, calculated from values in a column.




Useful aggregate functions:




AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() - Returns the sum

Briefly explain what is literal? Give an example where it can be used?

546

---

How to define an anonymous block?

623

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1609

---

Explain the dml?

602

---

Can we save images in a database and if yes, how?

594

---

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1660

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

653

---

Can we create database in oracle using command line ?

584

---

Explain the difference between sql and oracle?

582

---

How will you identify oracle database software release?

527

---

How many types of auditing in Oracle?

571

---

How to export your connection information to a file?

599

---

What are the restrictions on external table columns?

552

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

595

---

How can windows applications connect to oracle servers?

524

---