Oracle Interview questions

Total available count: 35
Subject - Databases
Subsubject - Oracle

How does Oracle work?

  • When Oracle starts an instance has started on the database server
  • An Oracle client established a connection to the server, using the proper Oracle Net Services driver
  • The server creates a dedicated server process on behalf of the user process
  • The user executes the SQL statement and commits the transaction statements
  • The server process receives the statement and checks for any shared SQL area that contains a similar SQL
  • The server process retrieves data from a datafile (SQL table) or SGA(System Global Area )
  • The server process modifies data in the System Global Area(SGA). The DBWn process writes modified blocks permanently to disk. The LGWR process records the transaction in the redo log file
  • The server process sends a message to the application

Next 4 interview question(s)

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 ?