Answer Posted / kranthi

char and varchar2 both we will use for character purpouse
only.but char take how many bytes we r specified in data
type size it will take that much of size.
eg: x char(10);
x:='nani' the remaining 6 character space will b wasted.
but in varchar2 we can use that 6 bytes for another
character also.
i hope so u under stood very well.

What is rich query?

1030

---

What are the different types of failures that occur in Oracle database?

1116

---

Explain what does a control file contain?

1159

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1395

---

How do I start tns listener?

1095

---

What is an oracle?

1063

---

What is a cursor variable?

1213

---

Can you have more than one content canvas view attached with a window ?

2369

---

What is open database communication (odbc) in oracle?

1048

---

What is analyze command used for?

1122

---

Explain the use of indexes option in imp command.

1258

---

How to check the oracle tns settings?

1087

---

What are the types of partitions in oracle?

1077

---

What is a oracle database?

1105

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1090

---