DBA Oracle Interview Questions

[kavita]

Discuss about dba oracle interview questions here. Welcome to MBA.ind.in and this page is for dba oracle interview questions discussion. If you are looking for dba oracle interview questions then ask your question is as much details as possible in the “Quick Reply” box provided below. The more detailed your question will be, the more easy will it be for our experts to answers your query. And if you have any information on dba oracle interview questions, then please share you knowledge with our viewers in the “Quick Reply” box. You knowledge can help many people. Thanks for stopping by at MBA.ind.in. Please visit again.

Hii sir, I am Appling for the DataBase Administration Post Will you Please Provide me Some Interview Question for the DataBase Administration Post ?

[shikha]

As you Asking for the Interview Question for the DataBase Administration Post the Question Paper is given below

Some of the Questions Relates for Orcale Are given below

What are different Oracle database objects?
TABLES
VIEWS
INDEXES
SYNONYMS
SEQUENCES
TABLESPACES

What is an Oracle index?
An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.


1. Oracle DBA Characteristics
Criteria Result
Main storage structures Logical and Physical
Architecture Grid architecture
ACID Compliance Fully compliant
Data stored as Data blocks, extents, segments and table spaces

What is normalization? What are the different forms of normalization?
- Normalization is a process of organizing the fields and tables of a relational database to minimize redundancy and dependency.
- It saves storage space and ensures consistency of our data.

There are six different normal forms

First Normal Form - If all underlying domains contain atomic values only.

Second Normal Form - If it is in first normal form and every non key attribute is fully functionally dependent on primary key.

Third Normal Form - If it is in 2nd normal form and every non key attribute is non transitively dependent on the primary key.

Boyce Codd Normal Form - A relation R is in BCNF if and only every determinant is a candidate key.

Fourth Normal Form

Fifth Normal Form
Differentiate between a database and Instance and explain relation between them?
- Database is a collection of three important files which include data files, control files and redo log files which physically exist on a disk

- Whereas instance is a combination of oracle background process (SMON, PMON, DBWR, LGWR) and memory structure (SGA, PGA


What are the disk components in Oracle?
These are the physical components which gets stored in the disk.

- Data files
- Redo Log files
- Control files
- Password files
- Parameter files

What is System Change Number (SCN)?
- SCN is a unique ID that Oracle generates for every committed transaction.
- It is recorded for every change in the redo entry.
- SCN is also generated for every checkpoint (CKPT) occurred.
- It is an ever increasing number which is updated for every 3 seconds
- You can get the SCN number by querying select SCN from v$database from SQLPLUS.