Correct Answer: In the normal mode of the optimizer
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle 10g Database Administration Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle 10g Database Administration MCQ Questions
Which commands are used to copy ASM files?
What will happen if the value of the SGA_TARGET parameter is set higher than the value of the SGA_MAX_SIZE parameter at instance startup?
What does the ARBn background process do in an ASM instance?
When there is a monotonically increasing sequence number as an indexed column, which of the following is true?
Consider this SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?
Evaluate the following SQL: CREATE USER sam IDENTIFIED BY sam; GRANT CREATE ANY MATERIALIZED VIEW, CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE TO dw_manager WITH ADMIN OPTION; GRANT dw_manager TO sam WITH ADMIN OPTION; Which of the following actions is the user SAM able to perform?
Which commands are used to apply incremental backups?
The initialization parameter UNDO_RETENTION is used:
What are two main advantages of using bitmap indexes?
The utility SQL*Loader should not be used: