Mention Oracle DBA Characteristics.
| Criteria | Oracle DBA Characteristics |
| Main storage structures | Logical and physical |
| Architecture | Grid architecture |
| ACID Compliance | Fully compliant |
| Data stored as | Data blocks, extents, segments, and tablespaces |
What is an Oracle Database?
Oracle provides software to create and manage the Oracle Database. The database consists of physical and logical structures in which system, user, and control information are stored. The software that manages the database is called the Oracle Database server. Collectively, the software that runs Oracle and the physical database is called the Oracle Database system.
A database buffer cache stores the data in memory for quicker access. The redo logs track and store all the changes made to the database. A Data Guard ensures data protection and high availability of data, and a control file records the physical structure of the database.
Who is responsible to update the indexes?
Oracle is capable of maintaining and using indexes and Oracle automatically distributes the data into relevant indexes when any change is made in the table data.
What are the various databases available in the market?
There are many databases available in the market. The commonly used databases are Oracle,
IBM db2, Microsoft SQL Server, Microsoft Access, MySQL and SQLite, PostgreSQL, MariaDB.
What are the physical components of Oracle Database?
Below 5 are the physical components of Oracle Database:
- Data files
- Control files
- Redo log files
- Password files
- Parameter files
What are the different Oracle Database objects?
- Tables
- Views
- Indexes
- Synonyms
- Sequences
- Tablespaces
What are the types of backups in Oracle?
The main four types of backups in Oracle are:
(ⅰ) COLD Backup
(ⅱ) HOT Backup
(ⅲ) Import – Export Backup
(ⅳ) RMAN Backup
What are the different types of SQL statements?
The five type of SQL statements are:
- Data Definition Language
- Data Manipulation Language
- Transactional control
- Session Control
- System Control
What is a control file?
A binary file that records the physical structure of the database and is required to start and run the database.
A control file contains information such as
- Data file
- Database name
- Redo file name
- Locations of associated data files and redo files.
- Timestamp of database creation.
- Current log sequence number
- Checkpoint information
Define Parameter files?
A parameter file is a text file that includes a list of initialization parameters as well as their values. Initialization parameters are defined in a parameter file that is exclusive to your installation.
