多选题For which of the following can you use Segment Shrink？（）AHeap tablesBTables with function-based indexesCIndexesDPartitions and subpartitionsENone of the above

题目
多选题
For which of the following can you use Segment Shrink？（）
A

Heap tables

B

Tables with function-based indexes

C

Indexes

D

Partitions and subpartitions

E

None of the above

相似考题

1.You use Microsoft .NET Framework 4 to create a Windows Forms client application.You write the following code segment.The application contains a form of type Form1 that contains a FormSettings object named frmSettings1.You need to maintain the user‘s form size preference each time the user executes the application.Which code segment should you use? （）A.B.C.D.

2.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 shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space

3.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?()A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.

4.You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.

更多“For which of the following can you use Segment Shrink？（）”相关问题

  • 第1题：

    The LAN needs are expanding at the Testking corporate office, which is quickly growing. You are instructed to enlarge the area covered by a single LAN segment on the TestKing network.Which of the following are layer 1 devices that you can use?（）

    A. A switch.

    B. A router.

    C. A network adapter card.

    D. A hub.

    E. A repeater.


    参考答案：D, E

  • 第2题：

    Which of the following shows the proper pronunciation of the segment "did you" inconnected speech?


    答案：A
    解析：
    考查音的同化。音的方向同化有三种情况：前音受相邻后音的影响而变化；后音受相邻前音影响而变化；前音与相邻后音互相影响，产生出既不是前者也不是后者相对应的另一音(如did本来读／did／．VOU本来读／ju：／，但齿龈爆破音/d/与硬腭近音/j/相互影响，而采用了一个位置在二者之间的齿龈后音、塞擦音／d3／，因此did you读作／did3u：／。)故选A。

  • 第3题：

    Which of the following devices can an administrator use to segment their LAN?（）

    • A、Hubs
    • B、Repeaters
    • C、Switches
    • D、Bridges
    • E、Routers
    • F、Media Converters
    • G、All of the above

    正确答案:C,D,E

  • 第4题：

    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

    正确答案:D

  • 第5题：

    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

    正确答案:E

  • 第6题：

    You develop a Web application that writes data to a file on a server. You restrict access to the file to specific Windows users. The Web application runs as CONTOSO/ASPNET. You deny anonymous access to the application in IIS. You add the following XML segment in the Web.config file.You need to ensure that the application meets the following requirements:It must impersonate the user when it writes data to the file.It must run as CONTOSO/ASPNET when a user does not access the file. Which two actions should you perform? （）

    • A、Use the following XML segment in the Web.config file. <identity impersonate="false"/>
    • B、Use the following XML segment in the Web.config file. <identity impersonate="true"/>
    • C、Use the following code segment to access the file. Dim wp As WindowsPrincipal = _CType(HttpContext.Current.User, WindowsPrincipal) Dim wi As WindowsIdentity = WindowsIdentity.GetCurrent() Dim wic As WindowsImpersonationContext = wi.Impersonate()' Access the file herewic.Undo()
    • D、Use the following code segment to access the file. Dim wi As WindowsIdentity = WindowsIdentity.GetCurrent()Dim wic As WindowsImpersonationContext = _WindowsIdentity.Impersonate(wi.Token)' Access the file herewic.Undo()

    正确答案:A,C

  • 第7题：

    多选题
    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?（）
    A

    It may advise the use of online table redefinition for tables in dictionary managed tablespace.

    B

    It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

    C

    It may advise the use of online table redefinition for tables in locally managed tablespaces

    D

    It will detect and advise about chained rows.

    E

    It may advise the use of segment shrink for free list managed tables.


    正确答案： D,C
    解析： 暂无解析

  • 第8题：

    单选题
    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）
    A

     SQL Tuning Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     Segment Advisor


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    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 the COMPACTION phase of the shrink operation.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Which of the following devices can an administrator use to segment their LAN?()

    A. Hubs

    B. Repeaters

    C. Switches

    D. Bridges

    E. Routers

    F. Media Converters

    G. All of the above


    参考答案：C, D, E

  • 第14题：

    The LAN needs are expanding at the Testking corporate office, which is quickly growing. You are instructed to enlarge the area covered by a single LAN segment on the TestKing network.Which of the following are layer 1 devices that you can use?（）

    • A、A switch.
    • B、A router.
    • C、A network adapter card.
    • D、A hub.
    • E、A repeater.

    正确答案:D,E

  • 第15题：

    Which of the following statements are true when creating NETBIOS names？ （）

    • A、 NETBIOS names can only use alphanumeric characters.
    • B、 You can use a ’.’ in a NETBIOS name.
    • C、 You can use an ’_’ （underscore） in a NETBIOS name.
    • D、 NETBIOS names must be UPPERCASE
    • E、 NETBIOS names can be a maximum of 32 characters

    正确答案:B,C

  • 第16题：

    For which of the following can you use Segment Shrink？（）

    • A、 Heap tables
    • B、 Tables with function-based indexes
    • C、 Indexes
    • D、 Partitions and subpartitions
    • E、 None of the above

    正确答案:A,C,D

  • 第17题：

    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

    • A、 SQL Tuning Advisor
    • B、 SQL Access Advisor
    • C、 Undo Advisor
    • D、 Segment Advisor

    正确答案:D

  • 第18题：

    单选题
    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

    add data files to the tablespace 

    B

    identify the segments that you should shrink 

    C

    modify the storage parameters for the tablespace 

    D

    automatically shrink the segments with unused space 

    E

    check the alerts generated for the tablespace that is running low on space


    正确答案： D
    解析： 暂无解析

  • 第19题：

    单选题
    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


    正确答案： E
    解析： 暂无解析

  • 第20题：

    多选题
    Which of the following devices can an administrator use to segment their LAN?（）
    A

    Hubs

    B

    Repeaters

    C

    Switches

    D

    Bridges

    E

    Routers

    F

    Media Converters

    G

    All of the above


    正确答案： B,E
    解析： 暂无解析

  • 第21题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第22题：

    多选题
    The LAN needs are expanding at the Testking corporate office, which is quickly growing. You are instructed to enlarge the area covered by a single LAN segment on the TestKing network.Which of the following are layer 1 devices that you can use?（）
    A

    A switch.

    B

    A router.

    C

    A network adapter card.

    D

    A hub.

    E

    A repeater.


    正确答案： E,B
    解析： 暂无解析

  • 第23题：

    多选题
    For which of the following can you use Segment Shrink？（）
    A

    Heap tables

    B

    Tables with function-based indexes

    C

    Indexes

    D

    Partitions and subpartitions

    E

    None of the above


    正确答案： A,E
    解析： 暂无解析

  • 第24题：

    单选题
    You need to create a class definition that is interoperable along with COM.You need to ensure that COM applications can create instances of the class and can call the GetAddress method. Which code segment should you use？（）
    A

    A

    B

    B

    C

    C

    D

    D


    正确答案： A
    解析： 暂无解析

相关内容