Answer Posted / madhavi

1)varchar2()
2)date
3)TIMESTAMP[(precision)] default precision is 6 we can
mention from 0...9
4)long
5)integer
6)number
7)char
8)clob
9)raw()
10)pls_integer
11)binary_integer
12)nvarchar2()
13)bfile

What is Histogram?

1549

---

Is left join and outer join same?

1045

---

What is a crud api?

940

---

What does bitemporal mean?

1048

---

what are rollup and cube in t-sql? : Transact sql

1072

---

What are the types of views in sql?

1082

---

What is cursor and why it is required?

1165

---

How sql query is executed?

1112

---

Can we perform dml in function?

1050

---

What is the use of sqlerrd 3?

927

---

What are the two types of periodical indexes?

925

---

Do ddl statements need commit?

958

---

What is a dirty read sql?

1109

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

987

---

What is sql query limit?

960

---