Answer / Akshita Mishra

Both CHAR and NCHAR are used to store strings in SQL DBA, but they differ in how they handle multi-byte characters:

- CHAR stores single-byte characters only (ASCII, ISO-8859-1, etc.). It pads spaces for fixed length.
- NCHAR stores Unicode characters and is intended to be used with national character sets. It also has a fixed length but does not pad spaces.

Which are the different case manipulation functions in sql?

1 Answers  

---

What is the primary key?

1 Answers  

---

Are stored procedures faster than queries?

1 Answers  

---

What is difference between inner join and cross join?

1 Answers  

---

What normalization means?

1 Answers  

---

What are the most important ddl statements in sql?

1 Answers  

---

Can we alter stored procedure?

1 Answers  

---

What is oracle pl sql developer?

1 Answers  

---

What are the types pl/sql code blocks?

1 Answers  

---

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  

---

What does count (*) mean?

1 Answers  

---

What is nvl function?

4 Answers   Cap Gemini,

---