Sobre Oracle datatypes em bancos de dados Oracle 11g, consid...
1. Dentre os tipos de dados LOB, o Oracle trabalha com os datatypes BLOB, CLOB e NCLOB, dentre outros. 2. O datatype BFILE armazena dados não estruturados em formato binário em arquivos do sistema operacional, fora do banco de dados. 3. Uma tabela pode conter somente um campo LOB, mas pode conter N campos do dataype LONG.
Assinale a alternativa que indica todas as afirmativas corretas.
Comentários
Veja os comentários dos nossos alunos
LOBs store a variety of data such as audio, video, documents, and so on. Based on the type of data stored in the LOB or memory management mechanism used, there are different classifications.
BLOB
Binary Large Object
Stores any kinds of data in binary format. Used for images, audio, and video.
CLOB
Character Large Object
Stores string data in the database character set format. Used for large strings or documents that use the database character set exclusively. Characters in the database character set are in a fixed width format.
NCLOB
National Character Set Large Object
Stores string data in National Character Set format, typically large strings or documents. Supports characters of varying width format.
BFILE
External Binary File
A binary file stored outside of the database in the host operating system file system, but accessible from database tables. BFILEs can be accessed from your application on a read-only basis. Use BFILEs to store static data, such as image data, that is not manipulated in applications.
Any kind of data, that is, any operating system file, can be stored in a BFILE. For example, you can store character data in a BFILE and then load the BFILE data into a CLOB, specifying the character set upon loading.
https://docs.oracle.com/en/database/oracle/oracle-database/23/adlob/LOB-classifications.html#GUID-A1258F7E-A100-423C-B0BC-960AD9A00510
Clique para visualizar este comentário
Visualize os comentários desta questão clicando no botão abaixo
Conheça nossos planos