|
Related Questions |
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
|
|
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
|
View Answer
|
|
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
|
View Answer
|
|
Give the two types of tables involved in producing a star schema and the type of data they hold?
|
View Answer
|
|
Compare and contrast TRUNCATE and DELETE for a table.
|
View Answer
|
|
Where would you look for errors from the database engine?
|
View Answer
|
|
Where would you look for errors from the database engine?
|
View Answer
|
|
What are the Referential actions supported by FOREIGN KEY integrity constraint?
|
View Answer
|