Oracle Interview questions


Total available count: 35
Subject - Databases
Subsubject - Oracle

What is a Tablespace?

For logical data Storage, Oracle uses Tablespace. Physically, data will get stored in Datafiles. Datafiles will be connected to the tablespace. A tablespace can have multiple data files. A tablespace can have objects from different schema's and a schema can have multiple tablespace's. The database creates "SYSTEM tablespace" by default during database creation. It contains read-only data dictionary tables that contain information about the database.




Next 5 interview question(s)

1
What contains oracle physical database structure?
2
How does Oracle work?
3
What are the several tools for interacting with the oracle database using sql?
4
What is storage virtualization?
5
Explain oracle grid architecture?