Correct Answer:
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
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?
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?
Which command revokes the ROLE_DATA role from all the users?
What is the default value for the OPTIMIZER_MODE initialization parameter?
What are the functions of an ASM instance?
If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?
How can the SQL Access Advisor be managed?
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?
Which conditions should be met before a RENAME DATAFILE with the alter tablespace command is used?
What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?