搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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？（）

A、 INCLUDING DEPENDENCIES

B、 INCLUDING DEPENDENCIES CASCADE

C、 COMPACT

D、 CASCADE

E、 None of the above

查看正确答案
更多“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？（）”相关的问题
第1题
[单选题] 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 data in the segment will be compacted but the high water mark will not be adjusted   B、The EMPLOYEES table will be changed to read-only mode during the shrink operation   C、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over  D、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation   E、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation  

点击查看答案
第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？（）

A、 REBUILD  B、 CASCADE  C、 TRUNCATE  D、 ROW MOVEMENT  E、 SHRINK SPACE COMPACT  F、 SHRINK SPACE CASCADE  

点击查看答案
第3题
[单选题] Companycom would like the ability to shrink filesystems. They currently have JFS filesystems. Which of the following is necessary to shrink the filesystems?（）

A、Copy the existing filesystems to JFS2  B、Defragment the filesystem， then reduce its size  C、Change the file system attribute allow_shrink=yes on the existing filesystems  D、Modify the logical volume attribute allow_shrink=yes on the existing logical volumes  

点击查看答案
第4题
[] Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（） Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）

A、A. The shrink operation touches every block in the BOOKING table  B、B. The high-water mark (HWM) for the BOOKING table is shifted from its original position  C、C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table  D、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  

点击查看答案
第5题
[单选题] 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？（）

A、 You must enable the block change tracking feature.  B、 You must have enable the flashback feature.  C、 You must use the OMF in your database.  D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.  

点击查看答案
第6题
[单选题] You need to increase the size of a paging file. What should you do? （）

A、From Disk Management， shrink the boot partition.  B、From Disk Management， shrink the system partition.  C、From System， modify the Advanced system settings.  D、From System， modify the System protection settings.  

点击查看答案
第7题
[单选题] 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)  

点击查看答案
第8题
[单选题] You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）

A、 You must enable the row movement on the SCOTT.EMP table.  B、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.  C、 You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.  D、 You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.  

点击查看答案
第9题
[单选题] Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command 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  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服