你可能感興趣的試題

You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session：
ALTER SESSION ENABLE RESUMABLE；
Which command could you issue to enable the resumable space allocation feature at the session level？（）

A. ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；
B. ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；
C. ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；
D. ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；

單項(xiàng)選擇題

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

A. space allocated in the tablespace
B. space required for the bitmap index on a column of the table
C. space remaining in the tablespace after creating the table
D. estimated value of the PCTFREE storage parameter

You issued the following statement to monitor the usage of the index： SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）

你可能感興趣的試題

You issued the following statement to monitor the usage of the index：
SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE；
Which view will you query to ensure that the index is being monitored？（）