Oracle
1Z0-054 · Question #94
1Z0-054 Question #94: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #94. The question stem and answer options stay visible for context.
Question
Examine the output of the following query: SQL> SELECT tablespace_name, tablespace_size, allocated_space, free_space 2 FROM DBA_TEMP_FREE_SPACE; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE ------------ ------------------ --------------- --------------- ---------- TEMP_L 157286400 144048128 157220864 TEMP 105906176 105906176 0 After some time you executed the same command and observed a different output, as shown below: SQL> SELECT tablespace_name, tablespace_size, allocated_space, free_space 2 FROM DBA_TEMP_FREE_SPACE; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE ------------ ------------------ --------------- --------------- ---------- TEMP_L 131072 65536 65536 TEMP 105906176 105906176 0 Why has the output changed?
Options
- Abecause checkpoint occurred
- Bbecause the TEMP_L tablespace was shrunk
- Cbecause the database instance was restarted
- Dbecause no sort operations are running currently
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.