Delete comment from: Javarevisited
I was looking for some short Oracle database questions for telephonic round of interview, but didn't find any good list, so end up creating my own.
what is explain plan in oracle?
Explain plan describe the execution plan choosen to execute a SQL query by Query Engine.
What is $ORACLE_BASE and where it is defined? $ORACLE_BASE is similar to $JAVA_HOME, it's an environment variable points to the
location of Oracle installation folder in disk. In Windows, you can defined it under user defined environment variable.
What is index in Oracle Database?
An index is a database object which is applied to a column to make searching easy in database. Index is normally used to improve SQL query performance.
How does a Query executes in Oracle? Can you list steps involved?
Following steps are involved in parsing SQL query :
1) parsing
2) binding
3) execute
4) fetch
What is init.ora file, where does it used, when it is read?
what is TOAD?
Difference beween segment, schema and table in Oracle database?
Dec 17, 2014, 11:15:34 PM
Posted to Top 10 Oracle Interview Question and Answer - Database and SQL