Correct Answer: Oracle performs a checkpoint for all online datafiles in the tablespace
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
What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?
Which conditions should be met before a RENAME DATAFILE with the alter tablespace command is used?
A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?
How can the SQL Access Advisor be managed?
If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?
What are the functions of an ASM instance?
What is the default value for the OPTIMIZER_MODE initialization parameter?
Which command revokes the ROLE_DATA role from all the users?
You want to find the following information about a user: - The expiry date of the user's account - The user's default tablespace name - The user's profile name Which data dictionary view should be queried for the purpose?
Consider the following 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?