单选题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? （）
A

DBA_TABLESPACES 

B

DBA_TABLES 

C

DBA_SEGMENTS 

D

DBA_FREE_SPACE

相似考题

1.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.

2.Which of the following resources can be referenced in the LOCK statement?（）A、RowB、TableC、ColumnD、Table space

3. 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

4.A trigger can be created on which of the following objects?（）A、ViewB、Catalog TableC、Stored ProcedureD、Global Temporary Table

更多“单选题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题：

    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？（）

    • 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.

    正确答案:D,E

  • 第2题：

    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

    正确答案:A,C,E

  • 第3题：

    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）  

    • A、 Segment Advisor
    • B、 SQL Access Advisor
    • C、 Undo Advisor
    • D、 SQL Tuning Advisor

    正确答案:B

  • 第4题：

    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

    正确答案:B

  • 第5题：

    多选题
    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.


    正确答案： C,D
    解析： 暂无解析

  • 第6题：

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


    正确答案： D,E
    解析： 暂无解析

  • 第7题：

    单选题
    A trigger can be created on which of the following objects?（）
    A

    View

    B

    Catalog Table

    C

    Stored Procedure

    D

    Global Temporary Table


    正确答案： B
    解析： 暂无解析

  • 第8题：

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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）
    A

    Segment Advisor

    B

    SQL Access Advisor

    C

    Undo Advisor

    D

    SQL Tuning Advisor


    正确答案： B
    解析： 暂无解析

  • 第10题：

    多选题
    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.


    正确答案： D,B
    解析： 暂无解析

  • 第11题：

    多选题
    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？（）
    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.


    正确答案： B,D
    解析： 暂无解析

  • 第12题：

    单选题
    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？（）
    A

     creating a table in your schema and you exceed your allocated space quota on the tablespace

    B

     executing a long query that involves a sort operation and the statement runs out of temporary space

    C

     loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

    D

     creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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

    正确答案:D

  • 第14题：

    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

    正确答案:A,D

  • 第15题：

    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.

    正确答案:A,C

  • 第16题：

    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.

    正确答案:A,C,E

  • 第17题：

    单选题
    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?（）
    A

    Segment Advisor 

    B

    SQL Tuning Advisor 

    C

    SQL Access Advisor 

    D

    Segment Resource Estimation 

    E

    Automatic Database Diagnostic Monitor (ADDM)


    正确答案： A
    解析： 暂无解析

  • 第18题：

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


    正确答案： C
    解析： 暂无解析

  • 第19题：

    多选题
    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.


    正确答案： E,C
    解析： 暂无解析

  • 第20题：

    单选题
    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）
    A

     Segment Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     SQL Tuning Advisor


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    During inspection of the machinery space, which of the following statements points to an unsatisfactory organization of the systematic maintenance?（）
    A

    missing valve hand wheels

    B

    dirty tank tops

    C

    a large number of temporary repairs

    D

    All of the above


    正确答案： D
    解析： 暂无解析

  • 第22题：

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


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following resources can be referenced in the LOCK statement?（）
    A

    Row

    B

    Table

    C

    Column

    D

    Table space


    正确答案： C
    解析： 暂无解析

相关内容