DBSkool Header Image Background

Category: DBA_Expressive

DBA Fundamental II(1)

1. What is incremental backup? Incremental backup makes a copy of all data blocks that have changed since a previous backup. 2. What are types of incremental backup?…

DBA Fundamental II

1. WHAT IS SQL* LOADER? SQL * LOADER loads data from external files into tables of an oracle database. It has a powerful data parsing engine that puts…

Maintaining Online Redo Log Files

1. Write down the name of table space? The name of table space are as follows: ♦ SYSTEM ♦ SYSAUX ♦ TEMP ♦ UNDOTBS1 ♦ USERS ♦ EXAMPLE…

Managing Tablespaces and Data Files

1. What is user? A database user account is a way to organize the ownership of and access to database objects. 2. What is privileges? A privileges is…

Managing Undo Data

1. What is Undo Data? The Oracle database saves the old value (undo data) when a process changes data in a database. It stores the data as it…

Storage Structure and Relationships

1. What are locks? Locks prevent multiple sessions from changing the same data at the same time. A lock gives the session exclusive control over the data so…

Creating Database

1. What is server parameter file or SPFILE? This is the preferred type of initialization parameter file. It is a binary file that can be written to and…

Oracle Architectural Components

1. What is SGA? System Global Area (SGA) is a key component of the relational database management system (RDMS). The SGA is a memory area that contains data…