oracle 11g r2题库.docx

Oracle 11G R2题库类别数量说明
此是我根据053的676道分类的,并删除了重复部份,我已考完,仅供大家学****参考. QQ:994165
TYPE SHRINK
ALTER TABLE booking SHRINK SPACE -- 收高水位
COMPACT -- 只有他不会收高水位
Casecde -- 收高水位并且把相关index等一起收缩
Examine the mand:
SQL> ALTER TABLE booking SHRINK PACT;
Which activity is performed when the mand is executed?
A. The shrink operation touches every block in the BOOKING table
B. The high-water mark (HWM) for the BOOKING table is shifted from its original position
C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
Answer: C
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?
A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.
B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table
during PACTION phase of the shrink operation.
Answer: C
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 _____.
A. identify the segments that you should shrink
B. modify the storage parameters for the tablespace
C. automatically shrink the segments with unused space
D. check the alerts generated for the tablespace that is running low on space
Answer: A
Which two statements regarding the Flashback Table feature are correct? (Choose two.)
A. Flashback Table can be performed on system tables.
B. Flashback Table operation does not shrink the segments.
C. Flashback