单选题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 （）Aidentify the segments that you should shrinkBmodify the storage parameters for the tablespaceCautomatically

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

相似考题

1.You are writing an application that uses isolated storage to store user preferences.The application uses multiple assemblies.Multiple users will use this application on the same computer.You need to create a directory named Preferences in the isolated storage area that is scoped to the current Microsoft Windows identity and assembly.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 create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this?（）A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task.

4.You create a Web application for your company‘s intranet. You want to enable users to customize their versions of the intranet home page. You create sections of content as Web Parts. You need to ensure that users can customize content at any time.Which two code segments should you use?（）A.B.C.D.

更多“单选题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  automat”相关问题

  • 第1题：

    Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%.  To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）

    • A、disable SQL tracing for theAPPS tablespace
    • B、disable logging attribute for the APPS tablespace
    • C、modify the tablespace to be a dictionary­managed tablespace
    • D、increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace
    • E、increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

    正确答案:E

  • 第2题：

    Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

    • A、the retention period to support flashback
    • B、the expected length of the longest-running query
    • C、the number of undo tablespaces in the database
    • D、the size of the Flash Recovery Area for the database instance

    正确答案:A,B

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    You have a computer that runs Windows Vista. You need to identify whether the computer can be upgradedto Windows 7.  Which tool should you use?（）

    • A、Windows Anytime Upgrade for Windows 7.
    • B、Windows Anytime Upgrade for Windows Vista.
    • C、Windows 7 Upgrade Advisor.
    • D、Windows Vista Upgrade Advisor.

    正确答案:C

  • 第6题：

    You have an Exchange Server 2010 organization.Users report that they can share free/busy information with users at a federated partner， but they cannot share contacts with those users. You need to ensure that your users can share contacts with users at the federated partner.  What should you modify？（）

    • A、the Federation Trust
    • B、the EWS virtual directory
    • C、the default sharing policy
    • D、the Organizational Relationship

    正确答案:C

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

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


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

  • 第9题：

    单选题
    You have an Exchange Server 2010 organization.Users report that they can share free/busy information with users at a federated partner， but they cannot share contacts with those users. You need to ensure that your users can share contacts with users at the federated partner.  What should you modify？（）
    A

    the Federation Trust

    B

    the EWS virtual directory

    C

    the default sharing policy

    D

    the Organizational Relationship


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

  • 第10题：

    单选题
    You have a computer that runs Windows Vista. You need to identify whether the computer can be upgradedto Windows 7.  Which tool should you use?（）
    A

    Windows Anytime Upgrade for Windows 7.

    B

    Windows Anytime Upgrade for Windows Vista.

    C

    Windows 7 Upgrade Advisor.

    D

    Windows Vista Upgrade Advisor.


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
    A

    the DBNEWID utility

    B

    the ANALYZE command

    C

    the RMAN LIST command

    D

    the RMAN REPORT command

    E

    the RMAN CROSSCHECK command

    F

    the RMAN BLOCKRECOVER command


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

  • 第13题：

    You deploy your companys Internet Web site. You need to deny anonymous access to the Web site, allowing only authenticated users. Which code segment should you use?（）

    • A、<authorization> <allow users="?"/> </authorization>
    • B、<authorization> <deny users="?"/> </authorization>
    • C、<authorization> <deny users="*"/></authorization>
    • D、<authorization> <allow users="*"/> </authorization>

    正确答案:B

  • 第14题：

    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

    • A、The retention period to support flashback
    • B、The expected length of the longest-running query
    • C、The number of undo tablespaces in the database
    • D、The size of the Flash Recovery Area for the database instance

    正确答案:A,B

  • 第15题：

    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

    • A、 the RMAN LIST command
    • B、 the DBNEWID utility
    • C、 the RMAN REPORT command
    • D、 the RMAN BLOCKRECOVER command
    • E、 the RMAN CROSSCHECK command
    • F、 the ANALYZE command

    正确答案:F

  • 第16题：

    You have an Exchange Server 2010 organization.You create a distribution group for all users in your company.You need to ensure that new users can add their mailboxes to the distribution group.What should you do？（）

    • A、Modify the group scope of the distribution group.
    • B、Modify the approval mode of the distribution group.
    • C、Modify the security settings of the distribution group.
    • D、Modify the authentication settings of the ECP virtual directory.

    正确答案:B

  • 第17题：

    You have an Exchange Server 2010 organization.You need to ensure that all users in the organization can automatically schedule the use of a projector.What should you do？（）

    • A、Create a new sharing policy
    • B、Create a mailbox
    • C、Modify the properties of the Calendar managed default folder
    • D、Modify the schedule for the Managed Folder Assistant

    正确答案:B

  • 第18题：

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


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

  • 第19题：

    多选题
    Identify three situations in which you would NOT be able to drop a tablespace. （）
    A

    when the tablespace is online

    B

    when the tablespace has segments with data in it

    C

    when the tablespace is a default permanent tablespace for the database

    D

    when the tablespace contains a table that is currently being used by transactions

    E

    when the tablespace contains undo data that is needed to rollback an uncommitted transaction


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

  • 第20题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    The retention period to support flashback

    B

    The expected length of the longest-running query

    C

    The number of undo tablespaces in the database

    D

    The size of the Flash Recovery Area for the database instance


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

  • 第21题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    the retention period to support flashback

    B

    the expected length of the longest-running query

    C

    the number of undo tablespaces in the database

    D

    the size of the Flash Recovery Area for the database instance


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

  • 第22题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    The retention period to support flashback

    B

    The expected length of the longest-running query

    C

    The number of undo tablespaces in the database

    D

    The size of the Flash Recovery Area for the database instance


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

  • 第23题：

    单选题
    You deploy your companys Internet Web site. You need to deny anonymous access to the Web site, allowing only authenticated users. Which code segment should you use? （）
    A

    <authorization> <allow users=?/> </authorization>

    B

    <authorization> <deny users=?/> </authorization>

    C

    <authorization> <deny users=*/></authorization>

    D

    <authorization> <allow users=*/> </authorization>


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

  • 第24题：

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


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

相关内容