Correct Answer: DBA_FREE_SPACE
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
User Smith created indexes on some tables owned by user John. The following has to be displayed: 1.Index names 2.Index types Which data dictionary view(s) should be queried?
Which conditions among the following must be met, if the tablespace is to be made read only?
When is SGA created in an Oracle database environment?
What do ASM disk groups provide?
When a deadlock shutdown is detected by Oracle, where is the trace file generated?
Which three among the following dynamic performance views obtain information from the control file?
Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?
What is the priority level for a job in a job class?
Which statement about the LOG_BUFFER initialization parameter is true?
Examine the SQL statement: CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1MB?