Oracle Interview questions

Total available count: 35
Subject - Databases
Subsubject - Oracle

What contains oracle physical database structure?

One characteristic of an RDBMS is the independence of logical data structures such as tables, views, and indexes from physical storage structures. Because physical and logical structures are separate, you can manage the physical storage of data without affecting access to logical structures.

Oracle physical database structure contains the following:

  • Datafiles
  • Control Files
  • Redo Log Files
  • Archive Log Files
  • Parameter Files
  • Alert and Trace Log Files
  • Backup Files

Next 5 interview question(s)

How does Oracle work?
What are the several tools for interacting with the oracle database using sql?
What is storage virtualization?
Explain oracle grid architecture?
What is oracle database ?