1Z0-023 考试回忆 11.20

ack segments.
　　C. User data segments.
　　D. Temporary segments.
　　E. Data dictionary segments.
　　
　　14. Which data dictionary view shows the xdyailable free space in a certain tablespace?
　　
　　A. DBA_EXTENTS
　　B. V$FREESPACE
　　C. DBA_FREE_SPACE
　　D. DBA_TABLESPACE
　　E. DBA_FREE_EXTENTS
　　
　　15. Which statement about using PCTFREE and PCTUSED is true?
　　
　　A. Block space utilization can be specified only at the segment level.
　　B. Block space utilization can be specified only in the data dictionary.
　　C. Block space utilization parameters can only be specified at the tablespace.
　　D. Block space utilization can be specified both at the tablespace level and segment level.
　　
　　16. Which type of index should be created to spread the distribution of an index across the index tree?
　　
　　A. B-tree indexes.
　　B. Bitmap indexes.
　　C. Reverse-key indexes.
　　D. Function-based indexes.
　　
　　17. Which statement about rebuilding indexes is true?
　　
　　A. The NOSORT option must be used.
　　B. The new index is built using the table as the data source
　　C. A reverse b-tree index can be converted to a normal index.
　　D. Query performance may be affected because the index is not.
　　
　　18. When granting the system privilege, which clause enables the grantee to further grant the privilege to other users or roles?
　　
　　A. PUBLIC
　　B. WITH PRIVILEGE
　　C. WITH ADMIN OPTION
　　D. WITH GRANT OPTION
　　
　　19. Which view will show a list of privileges th

上一页  [1] [2] [3] [4] [5] 下一页