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

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

第2题:

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

第3题:

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.


参考答案:A

第4题:

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

第5题:

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

第6题:

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.


参考答案:B

第7题:

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

第8题:

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.


参考答案:B, C

第9题:

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

第10题:

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

更多相关问题