Answer Posted / b.chandan kumar patra

this function returns a single row,based on group of rows.
this function an apperars in select list and having clause
only,
the aggregate functions are
sum(),avg(),min(),max(),count()etc.

What are a collation and state the different types of collation sensitivity?

1170

---

How to define and use table alias names in oracle?

943

---

What are the data types in oracle?

1040

---

What are the system predefined user roles?

1041

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2902

---

What are the different oracle database objects?

1091

---

What is a system tablespace?

1072

---

How to start a specific oracle instance?

1037

---

What to do if dba lost the system password?

1172

---

What is a tns file?

996

---

How to calculate date and time differences in oracle?

1042

---

What is the usage of control file in oracle?

1088

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

---

How to add a new column to an existing table with a default value?

1016

---

What is transaction control statement and how many types of transaction control statement in Oracle?

1156

---