网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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” 相关考题
考题
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?（）A
Segment Advisor B
SQL Tuning Advisor C
SQL Access Advisor D
Segment Resource Estimation E
Automatic 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? （）A
DBA_TABLESPACES B
DBA_TABLES C
DBA_SEGMENTS D
DBA_FREE_SPACE
考题
单选题A trigger can be created on which of the following objects?（）A
ViewB
Catalog TableC
Stored ProcedureD
Global 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?（）A
Segment AdvisorB
SQL Access AdvisorC
Undo AdvisorD
SQL Tuning Advisor
考题
单选题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
考题
多选题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?（）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？（）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?（）A
RowB
TableC
ColumnD
Table 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
热门标签
最新试卷
