Database-Oracle [3i Infotech Placement]: Sample Questions 19 - 20 of 132

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 19

Oracle
Edit

Describe in Detail

Essay▾

What are the Large object types supported by Oracle?

Explanation

Table Shows the Large Object Types
TypeDescription
CLOBCharacter large object. Stores up to 8 terabytes of character data inside the database.
NCLOBNational character large object. Stores up to 8 terabytes of national character data inside the database.
BLOBBinary large object. Stores up to 8 terabytes of binary data inside the database.
BFILEBinary file. Stores a pointer to a large binary file stored outside the database in the file system of the host computer.
RAWStores up to 2000 bytes of binary data that is not intended to be converted by Oracle when moving data between different systems.
LONGStores up to 2 gigabytes of character data.
LONG RAWStores up to 2 gigabytes of row binary data that is not intended to be converted.

Question 20

Oracle
Edit

Describe in Detail

Essay▾

What is an Oracle Instance?

Explanation

Given Figure is Oracle Instance and Oracle Database
  • All running Oracle database is related with an Oracle instance.
  • Oracle allocates a memory area called the System Global when a database is started on a database server Area and starts one or more Oracle processes.
  • Oracle instance is the combination of the SGA and the Oracle processes.
  • An Oracle instance can access only one database at a time, while an Oracle database can be accessed by multiple instances.
  • Oracle database-wide system memory is known as the SGA, the system global area or shared global area.
  • The data and control structures in the SGA are shareable, and all the Oracle background processes and user processes can use them.

Developed by: