DBA_TABLESPACES
DBA_TABLES
DBA_SEGMENTS
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?()
第2题:
Which statements are correct about temporary tables()
第3题:
Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()
第4题:
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()
第5题:
FREE_SPACE indicates only the space that is currently unallocated.
ALLOCATED_SPACE indicates only the space currently allocated and in use.
FREE_SPACE indicates only the space that is currently allocated and available for reuse.
ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
第6题:
Indexes and views can be created on temporary tables.
Both the data and the structure of temporary tables can be exported.
Temporary tables are always created in a user’s temporary tablespace.
The data inserted into a temporary table in a session is available to other sessions.
Data manipulation language (DML) locks are never acquired on the data of temporary tables
第7题:
View
Catalog Table
Stored Procedure
Global Temporary Table
第8题:
The temporary server was formatted as NTFS.
The manager is a power user on the temporary server.
The temporary server was formatted as FAT32.
The manager is an administrator on the temporary server.
第9题:
Segment Advisor
SQL Access Advisor
Undo Advisor
SQL Tuning Advisor
第10题:
Views can be created as read only.
Views are data segments like tables.
Views can be created on the basis of more than one table.
Data manipulation language (DML) operations cannot be performed on views.
第11题:
FREE_SPACE indicates only the space that is currently unallocated.
ALLOCATED_SPACE indicates only the space currently allocated and in use.
FREE_SPACE indicates only the space that is currently allocated and available for reuse.
ALLOCATED_SPACE indicates both the space currently allocated and used,and the space that is available for reuse.
FREE_SPACE indicates both the space that is currently allocated and available for reuse,and the space that is currently unallocated.
第12题:
creating a table in your schema and you exceed your allocated space quota on the tablespace
executing a long query that involves a sort operation and the statement runs out of temporary space
loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
第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?()
第14题:
Which two statements are true with respect to the maintenance window?() .
第15题:
Which two statements are true about simple views?()
第16题:
Which three statements are correct about temporary tables?()
第17题:
Segment Advisor
SQL Tuning Advisor
SQL Access Advisor
Segment Resource Estimation
Automatic Database Diagnostic Monitor (ADDM)
第18题:
vmstat
fileplace
iostat
lvmstat
第19题:
Indexes and views can be created on temporary tables.
Both the data and the structure of temporary tables can be exported.
Temporary tables are always created in a user’s temporary tablespace.
The data inserted into a temporary table in a session is available to other sessions.
Data manipulation language (DML) locks are never acquired on the data of temporary tables.
第20题:
Segment Advisor
SQL Access Advisor
Undo Advisor
SQL Tuning Advisor
第21题:
missing valve hand wheels
dirty tank tops
a large number of temporary repairs
All of the above
第22题:
The temporary server was formatted as NTFS.
The manager is a power user on the temporary server.
The temporary server was formatted as FAT32.
The manager is an administrator on the temporary server
第23题:
Row
Table
Column
Table space