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

Which of the following resources can be referenced in the LOCK statement?（）

• A、Row
• B、Table
• C、Column
• D、Table space

第2题：

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.

第3题：

第4题：

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

第5题：

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

第6题：

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

第7题：

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

第8题：

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

• A、View
• B、Catalog Table
• C、Stored Procedure
• D、Global Temporary Table

第9题：

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

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