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?()
第1题:
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
第2题:
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.
第3题:
You need to write a code segment that transfers the contents of a byte array named dataToSendby using a NetworkStream object named netStream.You need to use a cache of size 8,192 bytes.Which code segment should you use?()
A.
B.
C.
D.
第4题:
You create a table in your database that contains 50,000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes?()
第5题:
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()
第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.
第7题:
You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor?()
第8题:
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.
第9题:
While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()
第10题:
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?()