单选题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

题目内容(请给出正确答案)

单选题

To determine the space allocated for temporary segments, the DBA can access which of the following views? （）

DBA_TABLESPACES

DBA_TABLES

DBA_SEGMENTS

DBA_FREE_SPACE

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）A Segment AdvisorB SQL Access AdvisorC Undo AdvisorD SQL Tuning Advisor

点击查看答案
第2题

单选题During inspection of the machinery space, which of the following statements points to an unsatisfactory organization of the systematic maintenance?（）A missing valve hand wheelsB dirty tank topsC a large number of temporary repairsD All of the above

点击查看答案
第3题

多选题Which two statements are true about simple views？（）AViews can be created as read only.BViews are data segments like tables.CViews can be created on the basis of more than one table.DData manipulation language （DML） operations cannot be performed on views.

点击查看答案
第4题

单选题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

点击查看答案
第5题

多选题Evaluate the following command and its output： SQL>SELECT * 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.

点击查看答案
第6题

单选题Which of the following resources can be referenced in the LOCK statement?（）A RowB TableC ColumnD Table space

点击查看答案
第7题

单选题You issued the following statement in your SQL*Plus session： SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）Acreating a table in your schema and you exceed your allocated space quota on the tablespaceBexecuting a long query that involves a sort operation and the statement runs out of temporary spaceCloading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitDcreating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

点击查看答案

单选题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

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容