Home » MCQs » SQL MCQs » SQL Data Types MCQs

What is the similarity between CLOB and NCLOB Oracle Large Object Data Types?

19. What is the similarity between CLOB and NCLOB Oracle Large Object Data Types?

1. Both CLOB and NCLOB are used for multibyte national character set data.
2. Both CLOB and NCLOB can range upto 2^32-1 bytes or 4 GB.
3. Both CLOB and NCLOB can range upto 2^32-1 bytes or 8GB.
4. Both CLOB and NCLOB are used for singlebyte and multibyte national character set data.

Answer: B) Both CLOB and NCLOB can range upto 2^32-1 bytes or 4 GB

Explanation:

Both CLOB and NCLOB can range upto 2^32-1 bytes or 4 GB.