SóProvas


ID
3211192
Banca
FEPESE
Órgão
CELESC
Ano
2019
Provas
Disciplina
Banco de Dados
Assuntos

Quais tipos de dados LOB são suportados pelo Oracle 10gR2?


1. BLOB

2. CLOB

3. BFILE

4. NCLOB


Assinale a alternativa que indica todas as afirmativas corretas.

Alternativas
Comentários
  • BLOB

    The BLOB data type stores binary large objects. BLOB can store up to 4 gigabytes of binary data.

    CLOB

    The CBLOB data type stores character large objects. CLOB can store up to 4 gigabytes of character data.

    NCLOB

    The NCBLOB data type stores character large objects in multibyte national character set. NCLOB can store up to 4 gigabytes of character data.

    BFILE

    The BFILE data type enables access to binary file LOBs that are stored in file systems outside the Oracle database. A BFILE column stores a locator, which serves as a pointer to a binary file on the server's file system. The maximum file size supported is 4 gigabytes.

  • A Blob Storage is an object storage solution for the cloud. It can store massive amounts of data, such as text or binary data. A Blob Storage is unstructured, meaning that there are no restrictions on the kinds of data it can hold. Blob Storage can manage thousands of simultaneous uploads, massive amounts of video data, constantly growing log files, and can be reached from anywhere with an internet connection. Blobs aren't limited to common file formats. A blob could contain gigabytes of binary data streamed from a scientific instrument, an encrypted message for another application, or data in a custom format for an app you're developing. One advantage of blob storage over disk storage is that it does not require developers to think about or manage disks; data is uploaded as blobs, and the cloud provider takes care of the physical storage needs.

    Blob Storage is ideal for:

       Serving images or documents directly to a browser.

       Storing files for distributed access.

       Streaming video and audio.

       Storing data for backup and restore, disaster recovery, and archiving.

       Storing data for analysis by an on-premises or Azure-hosted service.

       Storing up to 8 TB of data for virtual machines.