单选题To determine the space allocated for temporary segments, the DBA can access which of the following views? （）ADBA_TABLESPACES BDBA_TABLES CDBA_SEGMENTS DDBA_FREE_SPACE
单选题
To determine the space allocated for temporary segments, the DBA can access which of the following views? （）
A
DBA_TABLESPACES
B
DBA_TABLES
C
DBA_SEGMENTS
D
DBA_FREE_SPACE
参考解析
解析：
暂无解析
相关考题：
Evaluate the following command and its output:Which two statements correctly interpret the output?() A. FREE_SPACE indicates only the space that is currently unallocated.B. ALLOCATED_SPACE indicates only the space currently allocated and in use.C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to()。 A. identify the segments that you should shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space
Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）A. Rollback segmentB. Temporary segmentC. Data segmentD. Index segment
Evaluatethefollowingcommandanditsoutput：SQLSELECT*FROMdba_temp_free_space；TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwostatementscorrectlyinterprettheoutput？（）A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused，andthespacethat isavailableforreuse.E.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse，andthespacethatiscurrentlyunallocated.
A Windows file server has run out of space. In the interim the administrator is moving several archived confidential folders that have been encrypted off the file server and onto an older server file shares. After the move, a manager reports that they are able to access and modify some of the items that have been moved. Which of the following is the MOST likely issue?（）A、The temporary server was formatted as NTFS.B、The manager is a power user on the temporary server.C、The temporary server was formatted as FAT32.D、The manager is an administrator on the temporary server
If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）A、All sorts will be done in a temporary table space. B、The shared sort memory allocation will be calculated by DB2C、No shared memory is allocated for sorting. D、All sorts will be done in shared memory.
The df command indicates that a filesystem is full， however， the du command indicates that not all space is allocated. How would the system administrator isolate the discrepancy（）A、Use the fuser command to identify deleted but open files.B、Use the ipcs command to view orphan shared memory segments.C、Use the defrag command to determine if the filesystem is fragmented.D、Use the topas command to identify processes using the most system resources.
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?（）A、The tape I/O performed is asynchronousB、The tape buffer is allocated from the System Global Area (SGA)C、The tape buffer is allocated from the Program Global Area (PGA)D、Oracle I/O uses an interrupt mechanism to determine when each I/O completes
You issued the following statement in your SQL*Plus session： SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）A、 creating a table in your schema and you exceed your allocated space quota on the tablespaceB、 executing a long query that involves a sort operation and the statement runs out of temporary spaceC、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B、 The command will not execute successfully because resumable space allocation is enabled at the session level.C、 The command will execute successfully and resumable space will be allocated at the session level.D、 The command will execute successfully and resumable space will be allocated at the instance level.
You executed the following command to create a tablespace called SALES_DATA： SQL CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）A、The database automatically determines the extent-sizing policy for the tablespace.B、The segments are automatically shrunk when the contents are removed from them.C、The allocation of extents within the tablespace is managed through the dictionary tables.D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.E、The space utilization description of the data blocks in segments is managed through free lists.
Evaluate the following command and its output： SQLSELECT * FROM dba_temp_free_space； TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（） A、 FREE_SPACE indicates only the space that is currently unallocated.B、 ALLOCATED_SPACE indicates only the space currently allocated and in use.C、 FREE_SPACE indicates only the space that is currently allocated and available for reuse.D、 ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.E、 FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.
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 tablespaceB、 space required for the bitmap index on a column of the tableC、 space remaining in the tablespace after creating the tableD、 estimated value of the PCTFREE storage parameter
单选题You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.Aadd data files to the tablespace Bidentify the segments that you should shrink Cmodify the storage parameters for the tablespace Dautomatically shrink the segments with unused space Echeck the alerts generated for the tablespace that is running low on space
单选题If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）AAll sorts will be done in a temporary table space. BThe shared sort memory allocation will be calculated by DB2CNo shared memory is allocated for sorting. DAll sorts will be done in shared memory.
单选题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 tablespaceB space required for the bitmap index on a column of the tableC space remaining in the tablespace after creating the tableD estimated value of the PCTFREE storage parameter
单选题You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）ASegment Advisor BSQL Tuning Advisor CSQL Access Advisor DSegment Resource Estimation EAutomatic Database Diagnostic Monitor (ADDM)
单选题While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）Athe CREATE TABLE .. commandBsorting of the SYSTEM tablespace’s dataCsorting of data required by recursive SQL statementsDthe CREATE TABLE .. ORGANIZATION EXTERNAL .. commandEsorting of data if the users have not been allocated temporary tablespace explicitlyFsorting of data if the users have been allocated temporary tablespace explicitly
单选题You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）AThe command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B The command will not execute successfully because resumable space allocation is enabled at the session level.C The command will execute successfully and resumable space will be allocated at the session level.D The command will execute successfully and resumable space will be allocated at the instance level.
多选题Evaluate the following command and its output: Which two statements correctly interpret the output?（）AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPACE indicates only the space that is currently allocated and available for reuse.DALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.EFREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
单选题You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。Aidentify the segments that you should shrinkBmodify the storage parameters for the tablespaceCautomatically shrink the segments with unused spaceDcheck the alerts generated for the tablespace that is running low on space
单选题You issued the following statement in your SQL*Plus session： SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）A creating a table in your schema and you exceed your allocated space quota on the tablespaceB executing a long query that involves a sort operation and the statement runs out of temporary spaceC loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
单选题You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）Arun a procedure to check the tablespace space usageBdefine the warning threshold for the tablespace at 75% in Database ControlCcreate a trigger to be executed when tablespace space usage reaches 75%Dsubmit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsEdefine the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
单选题A Windows file server has run out of space. In the interim the administrator is moving sever alarchived confidential folders that have been encrypted off the file server and onto an older servers fileshares. After the move， a manager reports that they are able to access and modify some of the items that have been moved. Which of the following is the MOST likely issue？（）A The temporary server was formatted as NTFS.B The manager is a power user on the temporary server.C The temporary server was formatted as FAT32.D The manager is an administrator on the temporary server.
多选题You executed the following command to create a tablespace called SALES_DATA： CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）AThe database automatically determines the extent-sizing policy for the tablespace.BThe segments are automatically shrunk when the contents are removed from them.CThe allocation of extents within the tablespace is managed through the dictionary tables.DThe space utilization description of the data blocks in segments is recorded inbitmapblocks.EThe space utilization description of the data blocks in segments is managed through free lists.MANUAL
单选题During inspection of the machinery space, which of the following statements points to an unsatisfactory organization of the systematic maintenance?（）Amissing valve hand wheelsBdirty tank topsCa large number of temporary repairsDAll of the above
单选题To determine the space allocated for temporary segments, the DBA can access which of the following views? （）ADBA_TABLESPACES BDBA_TABLES CDBA_SEGMENTS DDBA_FREE_SPACE
多选题Evaluate the following command and its output： SQLSELECT * FROM dba_temp_free_space； TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPACE indicates only the space that is currently allocated and available for reuse.DALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.EFREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.