|
Related Questions |
View Answer |
|
What are the basic element of Base configuration of an oracle Database?
|
View Answer
|
|
What is Distributed database?
|
View Answer
|
|
What is a SNAPSHOT LOG?
|
View Answer
|
|
What are the options available to refresh snapshots?
|
View Answer
|
|
What is a database schema?
|
View Answer
|
|
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
|
View Answer
|
|
What does coalescing a tablespace do?
|
View Answer
|
|
Describe what redo logs are.
|
View Answer
|
|
What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
|
View Answer
|
|
What is difference between UNIQUE constraint and PRIMARY KEY constraint?
|
View Answer
|
|
What does a Control file Contain?
|
View Answer
|
|
Explain materialized views and how they are used?
|
View Answer
|
|
Explain the use of table functions.
|
View Answer
|
|
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
|
View Answer
|
|
Explain the use of setting GLOBAL_NAMES equal to TRUE.
|
View Answer
|
|
How would you determine the time zone under which a database was operating?
|
View Answer
|
|
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
|
View Answer
|
|
How would you go about increasing the buffer cache hit ratio?
|
View Answer
|
|
How would you go about generating an EXPLAIN plan?
|
View Answer
|
|
What is a Sequence?
|
View Answer
|