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?

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?

Accepted Answer

B. because the TEMP_L tablespace was shrunk

Answer

A. because checkpoint occurred

Answer

C. because the database instance was restarted

Answer

D. because no sort operations are running currently

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…

Question

Options

How the community answered

Community Discussion