INCLUDING DEPENDENCIES
INCLUDING DEPENDENCIES CASCADE
COMPACT
CASCADE
None of the above
第1题:
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to()。
第2题:
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()
第3题:
View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?()
A. An error is produced.
B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
第4题:
You work as a database administrator for Certkiller .com. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows: ERROR at Line 1: ORA-10635: Invalid segment ortablespacetype What could be the reason?()
第5题:
For which of the following can you use Segment Shrink?()
第6题:
You created the DEPT table by using the following command: CREATE TABLE scott.dept (deptno NUMBER(3), dname VARCHAR2(15), loc VARCHAR2(15) ) STORAGE (INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4);You are required to shrink the DEPT table. While performing the shrink operation, you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table?()
第7题:
When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()
第8题:
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()
第9题:
You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?()
第10题:
Which of the following options describes Segment Shrink?()