单选题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.
A trigger can be created on which of the following objects?（）A、ViewB、Catalog TableC、Stored ProcedureD、Global Temporary Table
Which of the following resources can be referenced in the LOCK statement?（）A、RowB、TableC、ColumnD、Table space
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
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 trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）A、V$SESSION B、V$SYSSTAT C、DBA_SEGMENTS D、V$SORT_USAGE
Which statements are correct about temporary tables（）A、Indexes and views can be created on temporary tables.B、Both the data and the structure of temporary tables can be exported.C、Temporary tables are always created in a user’s temporary tablespace.D、The data inserted into a temporary table in a session is available to other sessions.E、Data manipulation language （DML） locks are never acquired on the data of temporary tables
Which two statements are true with respect to the maintenance window？（） .A、 A DBA can enable or disable an individual task in all maintenance windows.B、 A DBA cannot change the duration of the maintenance window after it is created.C、 In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.D、 A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window
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
Which two statements are true about simple views？（）A、Views can be created as read only.B、Views are data segments like tables.C、Views can be created on the basis of more than one table.D、Data manipulation language （DML） operations cannot be performed on views.
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） A、V$DATABASE B、DBA_TABLES C、SYSAUD$ D、EMP
Which three statements are correct about temporary tables？（）A、Indexes and views can be created on temporary tables.B、Both the data and the structure of temporary tables can be exported.C、Temporary tables are always created in a user’s temporary tablespace.D、The data inserted into a temporary table in a session is available to other sessions.E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.
多选题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 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)
多选题Which statements are correct about temporary tables（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables
单选题Which of the following commands can be used to determine if a disk drive is causing a bottleneck?（）A vmstat B fileplace C iostat D lvmstat
单选题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
单选题A trigger can be created on which of the following objects?（）AViewBCatalog TableCStored ProcedureDGlobal Temporary Table
多选题Which three statements are correct about temporary tables？（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables.
单选题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.
单选题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
单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）ASegment AdvisorBSQL Access AdvisorCUndo AdvisorDSQL Tuning Advisor
单选题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
多选题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.
单选题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?（）AThe temporary server was formatted as NTFS.BThe manager is a power user on the temporary server.CThe temporary server was formatted as FAT32.DThe manager is an administrator on the temporary server
多选题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.
单选题Which of the following resources can be referenced in the LOCK statement?（）ARowBTableCColumnDTable 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