Topic : Architecture

What are the disk components in Oracle?


Answer :

These are the physical components which gets stored in the disk.
- Data files
- Redo Log files
- Control files
- Password files
- Parameter files

Show Answer Discuss

Which Table spaces are created automatically when you create a database?


Answer :

- SYSTEM tablespace is created automatically during database creation.
- It will be always online when the database is open.
Other Tablespaces include
- SYSAUX tablespace
- UNDO tablespace
- TEMP tablespace
- UNDO & TEMP tablespace

Show Answer Discuss

List out the major installation steps of oracle software on UNIX in brief?


Answer :

- Set up disk and make sure you have Installation file (run Installer) in your dump.
- Check the swap and TEMP space .
- Export the following environment variables
1. ORACLE_BASE
2. ORACLE_HOME
3. PATH
4. LD_LIBRARY_PATH
5. TNS

Show Answer Discuss

List out some major environment variable used in installation?


Answer :

- ORACLE_BASE=/u01/app/
- ORACLE_HOME=$ORACLE_BASE/product/11.2.0(for 11g)/dbhome_1
- ORACLE_SID=
- PATH=$ORACLE_HOME/bin:$PATH
- LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
- TNS_ADMIN=$ORA

Show Answer Discuss

What is large object in oracle? Explain its purposes.


Answer :

Large objects (LOB?s) are exclusively used to hold large amounts of data. It can hold data in tetra bytes. Different types of LOBs include internal; external; persistent and temporary. Binary LOB?s are typically used to store graphics; video; or audio data.
Purpose:
- Enables you to access and manipulate the data efficiently in your application.
- Is optimized for large amounts of data.
- Provides a uniform way of accessing data stored within the database or outside the database.

Show Answer Discuss